SQL Server Maintenance Solution
I know that some of you are using this T-SQL based toolkit to perform maintenance on your servers, but is this a toolkit we should need to use? Why not use a fancy PowerShell script, create a basic Maintenance Plan in SSMS/SSDT or by CMD perhaps?
Well let me drop the link, let me know who’s using it or what you think?
The SQL Server Maintenance Solution comprises scripts for running backups, integrity checks, and index and statistics maintenance on all editions of Microsoft SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, and SQL Server 2012. The solution is based on stored procedures, functions, the sqlcmd utility, and SQL Server Agent jobs. I designed the solution for the most mission-critical enterprise environments, and it is used in manyorganizations around the world. Numerous SQL Server community experts recommend the SQL Server Maintenance Solution, which has been a Gold and Silver winner in the 2011 and 2010 SQL Server Magazine Awards. The SQL Server Maintenance Solution is free.
The best starting point for building your own maintenance plan is the comprehensive and free script from Ola Hallengren. That’s what I recommend to my clients.