I am scheduled on July 6th for a special session on Rockin’ the Code World with dotNetDave. I was on a session a couple of years ago of the show with Dave, and now I am coming back for another episode. During this episode we plan to talk about more of a non-technical item but something that we hopefully all …
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 »
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 »
Here is a quick update on the last 3 podcast episodes that we have published, ending up 2016, and starting out 2017 with some great information from Paul Turley, Jimmy May and Argenis Fernandez. Episode 77: New Reporting Options with Paul Turley We invited Paul Turley on the show to chat with us about some of the new features in …
This weeks latest podcast is an interview with Melissa Coates, on the topic of Cortana Intelligence Suite. From this weeks podcast: The Cortana Intelligence Suite is actually a huge collection of services in Azure for the purposes of providing big data and analytical solutions. So the suite consists of: Azure data factory, data catalog, Azure SQL data warehouse, Azure data …
Cortana Intelligence Suite – Podcast Episode #62. 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 »
There is a great deal of confusion about the WITH NOLOCK query hint. The following is a transcription of a conversation that I had on the SQL Data Partners Podcast #57 about the WITH NOLOCK hint, and some of the misconceptions about it. WITH NOLOCK Hint Carlos: So the next on is the WITH NOLOCK hint and I think this …
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 »
For this weeks SQL Data Partners podcast, we followed up on one of the #sqlfamily questions that we usually ask at the end of the podcast. If you could change one thing about SQL Server, what would it be? The list that we came up with was: Default file autogrowth settings Default maintenance plans Shrink database or Auto Shrink NOLOCK Hints …
Podcast Episode 57: the SQL Server Hit List – Our Least Favorite Features Read more »