This page mentions a few of the most well-known free SQL Server tools for which SQLFacts offers overlapping functionality.
Glenn Berry created SQL Server Diagnostic Queries (DQ) to provide a variety of information.
The SQLFacts toolkit provides very similar functionality with SQLFacts, BACKUP, MetricsNow, SQLAgent, Bufferin,
Databases, Sessions, Resources, AGLatency, Statistics, QueryHistory, IndexHistory, IndexActivity, and IndexNeeds.
DQ is the most comprehensive of all the tools listed here, but it's not nearly as comprehensive as the SQLFacts toolkit.
The SQLFacts toolkit neatly organizes all the functionality into tools for specific tasks. The tools provide all the necessary contextual information for the tasks. The functionality and the information are much more disjointed in DQ.
Adam Machanic created sp_WhoIsActive to investigate what SQL code is running.
The SQLFacts toolkit provides very similar functionality with Sessions.
Brent Ozar created sp_BlitzFirst, sp_BlitzIndex, sp_BlitzCache, and sp_Blitz, to investigate performance issues.
The SQLFacts toolkit provides very similar functionality with Sessions, IndexHistory, QueryHistory, and MetricsNow.
Greg Low created SDU Tools to provide many general-purpose functions and utilities.
The SQLFacts toolkit provides much of the same utility functionality with SQLFacts, Sessions, and IndexHistory.
Phil Factor (and others) have done a lot of work on identifying SQL Code Smells and Table Smells.
The SQLFacts toolkit implements checking for many code smells and database smells with SQLFacts.
All the tools listed here are wonderful. The SQLFacts toolkit is wonderful as well.
The SQLFacts toolkit provides a lot of the same functionality, and a lot of other unique functionality, but without all the variability in style. All the tools in the toolkit use the same T-SQL code conventions and formatting.
If you choose to dig deep into the SQLFacts tools, which is not required for using them, you can begin with one tool and automatically have a great start on understanding several other tools.
Copyright 2021 Wingenious