Podcast Episode 79: SSIS Catalog with Andy Leonard

This weeks episode we are pleased to host Andy Leonard to discuss his thoughts on the catalog and how this feature provides some really interesting benefits for ETL architecture. Although the SSIS Catalog DB is created with management studio, it does not

Tagged with: , , , , ,

Max Server Memory – SQL Server

Max Server Memory Setting Explained If you have more memory than your database and applications on the SQL Server will ever use than this is not a problem, but when you run into memory constraints this setting is much more

Tagged with: , , , , , , ,

New Raving Fan for Database Health Reports

I received this rave today about the Database Health Reports.  It has been posted on the Raving Fans page. 7/17/2013 – Beta 6 Rave The software is really good, I am using very regularly to audit and performance tune the

Tagged with: , ,