Azure Databases – Restore Local Database To Azure

azure databases

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. Looking for something else? Try these links instead: Customizing SQL Server Status

Shrink Bloated Development Databases – Save Precious Space

Shrink Bloated Development Databases

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

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

Easily Generate Table Change Scripts In SQL Server Management Studio

Easily Generate Table Change Scripts

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