T-SQL for restoring a database
Helper script for myself
Oct 14, 20152 min read40
Command Palette
Search for a command to run...
#sql
Articles tagged with #sql
GUID or Varchar(36)?
While working on an application which had a foreign key GUID reference, we had to change the implementation for that field to accept a string. Then we came across the question as to whether GUIDs or a Varchar(36) field would perform better? First o...
Aug 27, 20152 min read1.6K
Using DbUp - The first go...
So a release was coming up with multiple SQL scripts to be executed in a sequence. The best bet was to use a tool such as DbUp to automate the process. DbUp is a .NET library that helps you to deploy changes to SQL Server databases. It tracks which...
Mar 19, 20151 min read163