Version: 20230808

SQLFacts - A powerful suite of FREE tools for SQL Server database professionals.

SQLFacts is a comprehensive suite of 44 tools with awesome features. The toolkit includes plenty to love for everybody, with tools for SQL Server database development, database administration, and performance tuning.

All of them consist of T-SQL code, so nothing is hidden from users.
All the code can be reviewed to see how things are done.
All the code can be customized to suit various needs and situations.
All the tools, except for two, are strictly read-only. The two exceptions create new objects for monitoring and logging.

The SQLFacts suite of tools requires the user to have VIEW SERVER STATE permission.

The SQLFacts suite of tools was created using the practical experience of more than 20 years of work as a SQL Server database developer and administrator. This collection of tools is new, but routines like these have proven extremely useful for SQL Server database engineering and performance tuning for a very long time. The suite of tools is also a great way to learn more about how SQL Server operates by observing how different actions affect various result sets.

If you would like to engage the creator of SQLFacts to improve your database(s)...
Click here for a list of the SQL Server database services we offer.
The functionality of these tools is not entirely unique. Some of the same functionality can be obtained from various articles written by very smart people with deep SQL Server experience. This new collection of tools has the advantage of obtaining everything all at once, from one source, with consistency in T-SQL coding style and format. These tools also have many unique and beneficial features. They are much more than slapped together, piecemeal, blog post scripts.

The SQLFacts suite of tools is intended for SQL Server 2012 or newer. However, most of them work fine with some prior versions. A few of the tools have a disabled block of SQL code to exchange with an active block for use with prior versions.

Click here to view the README file (documentation) and learn more!

Click here to download the SQLFacts suite of tools and enjoy the features! It’s absolutely FREE!

© Copyright 2021 Wingenious SQLFacts         DBGizmo         Articles         Wingenious         About Us         Contact Us         Brian Walker