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
SQL
Azure Databases – Restore Local Database To Azure
Execute Script Error Resolved In SQL Server Management Studio
Query Stack Overflow With T-SQL – Give Your Queries A Workout
Shrink Bloated Development Databases – Save Precious Space
Prevent Accidental Table Data Deletion In SQL Server Management Studio
Automate Standard Comment Blocks For New SQL Queries
Customizing SQL Server Status Bar – Know Your Connection
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
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