Can you survive a month on free tools? First up is ApexSQL Complete, a free add-in for SSMS and Visual Studio that auto-completes SQL code as you type.
SQL Contest – USD 100 Gift Card and Attractive Discount from Devart
Win a USD 100 gift card and get a festive discount on Devart tools I use and like. Here is how to enter this SQL contest before it ends.
SQL SERVER – Monitor Database via a Heatmap, Alarms List and Realtime Diagnostics for FREE
DBAs keep checking screens and phones for alerts. Spotlight on SQL Server Freemium lets you monitor database health with a heatmap and alarms, for free.
SQL SERVER – How to Compare the Schema of Two Databases with Schema Compare
Comparing the schema of two databases by hand, with every table, view, trigger and procedure, is close to impossible. Here is how a Schema Compare tool does it.
SQL SERVER – Auditing and Profiling Database Made Easy with ApexSQL Trigger and ApexSQL Audit
Auditing matters for rules, troubleshooting and security, but by hand it takes forever. A look at ApexSQL Trigger and ApexSQL Audit for auditing SQL Server.
SQL SERVER – An Efficiency Tool to Compare and Synchronize SQL Server Databases
A developer deleted rows from a key mapping table and the whole dev team stopped. Here is the efficiency tool I used to compare and sync the databases.
SQL SERVER – Three Efficiency Tools for SQL Server From Devart
At TechEd India many people asked which efficiency tools I use with SQL Server. Here are my three favorites from Devart, starting with SQL Complete.