a developer's notebook
Some really easy ways to improve performance in your asp.net core web application are: response caching, which adds cache-related headers to responses, to reduce the number of requests a client makes to your web server; compressing response using gzip to reduce its size. You may start with the default asp.net core web application, apply the above steps and check the result. Setup…
Application Insights is an extensible Application Performance Management (APM) service for web developers. It provides rich performance monitoring, powerful alerting, and easy-to-consume dashboards to help ensure your applications are available and performing as you expect. One of the powerful characteristics of Application Insights is that it provides an extensible API where you can customize the behavior of the standard telemetry modules the way…
Azure App Service can be integrated with a plethora of services like BitBucket, GitHub, Dropbox, OneDrive, Visual Studio Team Services, local or any external git repository, while it enables a continuous deployment workflow, where Azure pulls in the most recent updates from a project published to one of these services. One of the most common options is to configure continuous deployment…
Microsoft Azure platform is evolving at a very fast pace and keeping up with all the changes may be challenging. Many products and services are released every week, while new ones are announced as being in public preview or under development. For that reason, Microsoft has built the Microsoft Cloud Platform Roadmap, which provides a snapshot of what Microsoft is working on in its Cloud Platform business….
Azure App Service Editor, formerly known as Visual Studio Online (Monaco), is a web-based editor for App Service, that looks a lot like VS Code and allows you to modify files already deployed to Azure Web Apps. App Service Editor is based on monaco-editor, an open-source project which is generated straight from VS Code’s sources, with some shims to make it work…
Wouldn’t it be great if you could have a function which generates resized images from every new image that gets uploaded in your Azure blob storage, without having to create a new app and manage the infrastructure to run it? Welcome to the era of Serverless Computing where, through a few lines of code, you can have this function up and running in a few minutes. To…
If you have multiple files having an extension like jpeg and you want to batch rename them to jpg as extension you can do that with a single line of code:
1 | FOR /R %f IN (*.jpeg) DO REN "%f" *.jpg |
In my case I wanted to batch rename all my template files from .jade to .pug, as there was an issue with trademarks, so the command would change to:
1 | FOR /R %f IN (*.jade) DO REN "%f" *.pug |
A time may come when you will need to alter your database to use a different collation. You can do this by using the following snippet:
1 2 3 4 5 6 7 8 9 10 11 | USE master; GO ALTER DATABASE [DatabaseName] COLLATE SQL_Latin1_General_CP1_CI_AS ; GO --Verify the collation setting. SELECT name, collation_name FROM sys.databases WHERE name = N'[DatabaseName]'; GO |
When you execute the above snippet you may come across the following error: This error occurs when your database is in Multi-User mode or when there are objects referring to your database. To overcome this error, you…
To get a rough view of how many rows, total, used and unused space each table has, in a sql server database you can run the following query:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 | USE {Database_Name}; GO SELECT t.Name AS TableName, s.Name AS SchemaName, p.Rows AS RowCounts, SUM(a.total_pages) * 8 AS TotalSpaceKB, SUM(a.used_pages) * 8 AS UsedSpaceKB, (SUM(a.total_pages) - SUM(a.used_pages)) * 8 AS UnusedSpaceKB FROM sys.tables t INNER JOIN sys.indexes i ON t.object_id = i.object_id INNER JOIN sys.partitions p ON i.object_id = p.object_id AND i.index_id = p.index_id INNER JOIN sys.allocation_units a ON p.partition_id = a.container_id LEFT OUTER JOIN sys.schemas s ON t.schema_id = s.schema_id WHERE t.Name NOT LIKE 'dt%' AND t.is_ms_shipped = 0 AND i.object_id > 255 GROUP BY t.Name, s.Name, p.Rows ORDER BY t.Name; GO |
Another way is using the stored procedure sp_spaceused which displays the number of rows, disk space reserved, and disk space used by a table, indexed view, or Service Broker queue in…
It’s a common thing for websites to serve some kind of static content, like images, sounds, fonts or videos. When deploying a new website, the most common way to serve the aforementioned content is to include these files in the app structure and allow the web server to serve the static content. In Azure, there are additional ways to serve static content, either through Azure Blob…
