Video: Top 5 Add-Ins for SQL Server

THE VIDEO

THE SYNOPSIS

What are the five best third-party, T-SQL-based solutions for SQL Server?

Ground Rules

1. The product is not included with SQL Server itself.
2. 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.
3. 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.

Links

• dbatools
• QDS Toolbox
• SQL#
• 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
• sp_WhoIsActive documentation
• sp_WhoIsActive shortcuts I use

Attributions

• Mayan calendar image
• 2012 movie poster
• What is the Worst Technology Trend of 2012?

Advertisement