Even though there are many useful and exciting SQL Server tools out there, I find it extremely interesting, in some cases, to develop my own tools for SQL Server. Explore this part of my world via via my initiative “SQLArtBits“.
DBA Security Advisor
DBA Security Advisor is a powerful security tool which assesses SQL Server instances against a rich set of security checks and detects potential security risks. Moreover, in the Enterprise Edition, you can get recommendations as well as remediation methods and scripts for the detected security risks. Furthermore, there is a history mechanism which allows you to track the progress of your SQL Server instances security by accessing older reports. Secure your SQL Server instances today and protect your data more efficiently!
In-Memory OLTP Simulator
With In-Memory OLTP Simulator you can easily test and benchmark the powerful In-Memory OLTP Engine of SQL Server with different simulations/benchmarks and against different workloads. In the Ultimate Edition of the tool, among other, you can load data from different sources (i.e. from Production DBMS instances using Linked Servers) into the Simulator’s database and simulate real-life scenarios with the use of custom scenarios. Moreover, you can get in-depth analytics on performance when utilizing Memory-Optimized Tables and Natively-Compiled Stored Procedures in SQL Server. Furthermore, with “Benchmark Mode” which is available in all editions, you can run three basic benchmarks (update, insert and aggregation) using different parameters.
Dynamic T-SQL Generator
Dynamic T-SQL Generator is a cool free tool which makes it easy for database developers to generate dynamic T-SQL scripts by converting a given static T-SQL script and vice versa. Moreover, it provides a wide range of editing options which enable the developer be more productive with less effort.