Today Episode 91 released and it is our pleasure to present this episode on DBA Tools.  DBA Tools is an open source project (http://DBATools.io) that provides a number of powershell scripts to better help the DBA perform common SQL Server tasks. This was a fun episode with the panel of Chrissy, Rob, Constantine, and Aaron who were super excited to talk …

Podcast Episode 91: DBA Tools – Listen and find out what you are missing. Read more »

This weeks episode of the is Episode 90 released today.  Episode Quote “I would say that the bigger issue is probably going to be something like snapshot space for your disk” “When the rubber hits the road I’m still running CheckDB and CheckTable but it’s all about the process behind it”  Overview DBCC CheckDB.  It is a simple command, but …

Podcast Episode 90: DBCC CheckDB Read more »

For a couple of months we have had requests on the SQL Data Partners Podcast to do an episode on indexing. It is my pleasure to announce that the Indexing episode was released today, well at lease half of it. After we finished the recording, we realized that there was too much content to fit it in to our normal …

Podcast Episode – The Long Awaited Index Episode Read more »

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 behave like other databases.  Our conversation in this episode revolves around the catalog, SSIS packages, and some of the complexities of migrating …

Podcast Episode 79: SSIS Catalog with Andy Leonard Read more »