What are the five best third-party, T-SQL-based solutions for SQL Server?
- The product is not included with SQL Server itself.
- The product must be built around T-SQL and ‘internal’ to SQL Server, not external scripts which hit a SQL Server. That is why, for example, the excellent dbatools is not on this list.
- There must be a freely-available version of this product.
LINKS AND ADDITIONAL INFORMATION
All of these videos are on behalf of Catallaxy Services, LLC, my consulting company where I help customers on problems all across the data platform space.
- QDS Toolbox
- Building a calendar table: part 1 and part 2
- A calendar table script
- Derik Hammer has 5 Extended Events sessions for your SQL Server instance
- Brent Ozar’s First Responder Kit
- The Minionware Suite
- Ola Hallengren’s maintenance solution didn’t make the list but is also excellent
- sp_WhoIsActive documentation
- sp_WhoIsActive shortcuts I use