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 »

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 »

This week on the SQL Data Partners Podcast Episode #59 we discussed Mirroring, Availability Groups, Replication and Log Shipping. There were 4 of us on the podcast, two guests Mariano Kovo and Andy Mallon, along with Carlos Chacon and I. Each of us discussed one of the 4 options for having your data in multiple locations which are Mirroring, Availability Groups, …

Episode 59: Mirroring, Availability Groups, Replication, and Log shipping Read more »

This week on the SQL Data Partners podcast, Podcast Episode #58, we focused on Four Ways to Stay Sharp with Technical Learning.  I can’t believe this is the 8th in a row of the SQL Data Partners podcast that I have had the opportunity to co-host. This week we didn’t have a scheduled guest so it was just Carlos Chacon and I …

Podcast Episode 58: Four Ways to Stay Sharp with Technical Learning Read more »