a developer's notebook
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…
A couple of days ago Facebook released Yarn, a new package manager for Javascript, with a focus on speed and consistent package dependency management across machines. With Yarn, engineers still have access to the npm registry, so I thought it worth the try to test the claimed speed improvements between package installation using yarn and npm default installation process. For my tests I used ng-lightning, a project for…
In this post we are going to explore what we need in order to setup a local environment for our Azure Functions implementation, and how we can easily update our Azure Functions App through GitHub, using continuous integrations. Let’s start with some details about Azure Functions. What is Azure Functions? Azure Functions is a serverless event-driven experience that extends the existing Azure App Service platform; serverless…
In this post we are going to explore a feature provided by Azure App Service called “Testing in production” that allows you to direct a portion of live user traffic to one or more deployment slots of your web app before swapping this deployment slot to production. You can, thus, analyze your app, check for exceptions or errors, and make certain everything works properly, before your app…
