a developer's notebook
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…
Sometimes, the response from a request is required first in order to continue with all the other API requests currently stored in your Postman folders. Think of a request that, in order to return results, it requires from you to be authenticated, so a typical workflow would be: authenticate yourself with a proper username and password; get an authentication token; update…
In Entity Framework code-first, if you have a domain model like the following:
|
1 2 3 4 5 6 7 |
public class Country { public int Id { get; set; } [Index] public string IsoCode { get; set; } } |
and want to create an index for a string property, when you execute update-database for your migration, you may end up with the following error: This usually happens when you use VARCHAR(max), which is the default column type when creating a string property in EF. To make…
