sql server management studio Archives ⋆ Programming and Tech Blog

Azure Databases – Restore Local Database To Azure

Post author:Dirk Strauss
Post published:July 23, 2014
Post category:SQL
Post comments:4 Comments

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:

The method I’m going to show you now, is a nice quick and easy method. (more…)

Shrink Bloated Development Databases – Save Precious Space

Post author:Dirk Strauss
Post published:February 12, 2014
Post category:SQL
Post comments:6 Comments

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 of data removed from this folder didn’t make much of a difference. I then went hunting. Using a very nifty tool called WinDirStat, I found the problem files. It turns out that some of my development databases were absolutely huge. The LDF files were several gigs in size. Here is what I did to save a little bit of space. (more…)

Automate Standard Comment Blocks For New SQL Queries

Post author:Dirk Strauss
Post published:February 3, 2014
Post category:SQL
Post comments:5 Comments

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 this text available?

Looking for something else? Try these links instead:

Some might think to have it in a text file and just copy and paste every time you create a new script. Here is a little trick for those lazy developers (in other words, everyone). (more…)

The Daily Six Pack: January 29, 2014

Post author:Dirk Strauss
Post published:January 29, 2014
Post category:The Daily Six Pack
Post comments:0 Comments

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…

Easily Generate Table Change Scripts In SQL Server Management Studio

Post author:Dirk Strauss
Post published:January 29, 2014
Post category:How To SQL
Post comments:4 Comments

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 up in the changes you need to make, that you forget about scripting these table changes.

Looking for something else? Try these links instead:

Here is a nice trick in SQL Server Management Studio to easily generate table change scripts. Never forget to script your changes again. (more…)

Script Table Data In SQL Server Management Studio

Post author:Dirk Strauss
Post published:January 27, 2014
Post category:How To SQL
Post comments:21 Comments

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 is very convenient and best of all, you don’t need to leave the IDE to script table data. So where is this function? Why, under Tasks of course. (more…)