Azure Databases – Restore Local Database To Azure

Azure Databases - What do you need to do if you have a local database and you want to deploy it to Azure? I saw while researching for this article that there were a few ways to do this, but the method I'm going to show you is a nice

Shrink Bloated Development Databases – Save Precious Space

Shrink Bloated Development Databases - Last night I noticed that the space on my C drive was running slightly low. When this happens, I usually go and look in the temp folder to see what unnecessary space hogs are hiding there. After clearing this folder I realised that the amount

Automate Standard Comment Blocks For New SQL Queries

Automate Standard Comment Blocks - If you write a lot of SQL stored procedures or functions in SQL Server Management Studio, you might like this tip. Many companies require a standard comment format at the beginning of a stored procedure or function. What would be the easiest way to always have

The Daily Six Pack: January 29, 2014

Fallback Image

A COLLECTION OF LINKS FOR LOVERS OF I.T. Dirk Strauss . . . . Feature link: SSMSBoost SSMSBoost - a free Add-in for SQL Server Management Studio Other Free ebooks: Now on the Microsoft Virtual Academy site, Kim Spilker Using Windows 8 to build Windows 8 apps, Lee Stott Microsoft "Project Siena" SPARROW II: NSA Exploit of the Day, Bruce Schneier LeakSource Even More Microsoft rechristens

Easily Generate Table Change Scripts In SQL Server Management Studio

Something I found frustrating when designing databases, were the frequent changes made to tables. Managing the scripts can become quite tricky, especially if you are still in the design phase. This is made worse by code changes or change requests to existing data structures. Sometimes a person gets so caught

Script Table Data In SQL Server Management Studio

Script Table Data

How Do I Script Table Data In SQL Server Script Table Data - I have used other tools to do this for ages. I can't believe that I never knew that it existed in SQL Server Management Studio. Well ok, in my defence it isn't quite the most 'In-your-face' setting. Nevertheless, it