ApexSQL Complete is a free add-in for auto-completing SQL code which integrates with SQL Server Management Studio and Visual Studio. Let us learn about free tools for the month.
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
Note: This review is based on the performance monitoring and tuning free product Spotlight on SQL Server Freemium. If you think of a DBA’s life, it has one very simple goal – their server should never go down and all the queries should always perform excellently. However, just like any…
Read More
SQL SERVER – How to Compare the Schema of Two Databases with Schema Compare
Earlier I wrote about An Efficiency Tool to Compare and Synchronize SQL Server Databases and it was very much well received. Since the blog post I have received quite a many question that just like data how we can also compare schema and synchronize it. If you think about comparing the schema manually, it is almost impossible to do so. Table Schema has been just one of the concept but if you really want the all the schema of the database (triggers, views, stored procedure and everything else) it is just impossible task. Let us learn about Schema Compare.
SQL SERVER – Auditing and Profiling Database Made Easy with ApexSQL Trigger and ApexSQL Audit
Do you like auditing your database, or can you think of about a million other things you’d rather do? Unfortunately, auditing is incredibly important. As with tax audits, it is important to audit databases to ensure they are following all the rules, but they are also important for troubleshooting and security. Let us learn about Profiling Database.
SQL SERVER – An Efficiency Tool to Compare and Synchronize SQL Server Databases
There is no need to reinvent the wheel if it is already invented and if the wheel is already available at ease, there is no need to wait to grab it. Here is the similar situation. I came across a very interesting situation and I had to look for efficiency tool which can make my life easier and solve my business problem.
SQL SERVER – Three Efficiency Tools for SQL Server From Devart
I just returned from successful road trip of TechEd India. The trip was extremely successful and I have got big chance to engage with community and friends. One of the most frequently asked question during the trip was what kind of efficiency tools do I use while working with SQL Server. I use many different tools and here is the list of my most favorite tools from Devart. If you are using them, do let me know as I would like to get your feedback about the tools.