a developer's notebook
In this tutorial we are going to move a quite big database (~160GB) to an Azure SQL Database using BACPAC and Azure Storage. We are going to describe below the process of exporting a database from your local SQL Server instance and importing it to an Azure SQL Database. First things first, in order to proceed with the above action we are going to use the…
In Azure it is very easy to upgrade from one pricing/performance tier to another in a matter of clicks, but some processes are not instant. Upgrading your SQL Database may take some time and through the portal the only info you can get at the moment is that an update is in process. Azure SQL Database provides progress information on management operations (like CREATE,…
SQL Server management studio allows you to have Database Diagrams to graphically show the structure of the database. In addition, you can create and modify tables, columns, relationships, and keys. Plus, you can modify indexes and constraints. While trying to Create a New Database Diagram you might come across to the following error:
ServiceStack has recently announced that will go commercial from version 4 and on. Although it is a very useful library that worth paying for you might not want to go straight ahead to acquire a license. One option is to downgrade to version 3.9.71 which is free to use and decide later if you want to buy a license or find a better alternative. In…
In Entity Framework when you want to insert multiple items in your database you usually add your objects in your DbSet and then call context.SaveChanges at the end. This action, you may think, performs bulk inserts in your db but in reality things are a bit different. In the following example, we are going to generate multiple objects from our model Products and try to…
Chrome developer tools is a suite of tools that helps every web developer to develop, test and debug web sites and applications directly from the Google Chrome browser. Some might argue that it comes only in “White”, however there is a hidden feature that can change the color so as to personalize it based on your preferences. ZeroDarkMatrix is a very nice option for developers who prefer dark…
What is AutoMapper? AutoMapper is a simple little library built to solve a deceptively complex problem – getting rid of code that mapped one object to another. This can be very useful when you want to map your Model to ViewModel and vice versa, without writing and maintaining property mapping between those objects. How to Install it AutoMapper is available through Nuget, so…
In cases you want to display a more personalized avatar for a user that hasn’t uploaded any image to his profile, Canvas might help you through its toDataURI() function. So, let’s see what this method is all about. The HTMLCanvasElement.toDataURL() method returns a data URIs containing a representation of the image in the format specified by the type parameter (defaults to…
Jay Parikh, vice president of Engineering at Facebook, gives an interesting talk at Scale conference about challenges their network engineers face due to the increased user generated content and their approach to improve end-user experience through planning, iteration and performance principles. The most interesting part appears to be their approach on making uploaded video content instantly available through distributed encoding and how they…
