SQL

ApexSQL Provides Excellent SQL Tools For Free

by Dirk Strauss - 123032
ApexSQL

ApexSQL has a few free tools on their site. Before I carry on, I was in no way compensated for this blog post at all. Now that is out of the way, check out ApexSQL tools. I was amazed by the feature richness of these tools. Looking for something else? Try

Execute Script Error Resolved In SQL Server Management Studio

by Dirk Strauss - 917145
Execute Script Error

Execute Script Error - Imagine my surprise when I tried executing a rather large SQL script (255 Mb) and received an error telling me that there was 'Insufficient memory to continue the execution of the program. (mscorlib)'. You might be wondering why I would even have such a large script to

Query Stack Overflow With T-SQL – Give Your Queries A Workout

by Dirk Strauss - 78094
Query Stack Overflow

Query Stack Overflow - Do you wish that you could run a few queries against a truly huge database? Do you want to tune your queries and see how they match up against some big data? Sometimes we need a big database for research reasons (here's looking at the educators

Shrink Bloated Development Databases – Save Precious Space

by Dirk Strauss - 67632
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

Prevent Accidental Table Data Deletion In SQL Server Management Studio

by Dirk Strauss - 742831
Prevent Accidental Table Data Deletion

Prevent Accidental Table Data Deletion - How do we secure our production database against simple errors that could cause quite a problem. As a developer, I mainly work on my database while being in a development environment. It is only after the development is one that some of the work

Automate Standard Comment Blocks For New SQL Queries

by Dirk Strauss - 57520
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

Customizing SQL Server Status Bar – Know Your Connection

by Dirk Strauss - 48400
Customizing SQL Server Status Bar

Customizing SQL Server Status Bar - Sometimes I work on a server that has live databases mixed in with test databases. You can obviously see the problem here. Let's delete some test data. Oops, wrong database. Well there is a solution. SQL Server Management Studio allows us to identify the connection.

Easily Generate Table Change Scripts In SQL Server Management Studio

by Dirk Strauss - 436406
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

by Dirk Strauss - 2160324
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