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
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
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 - 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 - 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 - 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 - 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 - 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.
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
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