Month: August 2016

By Posted on Posted in Podcast No Comments Tagged with , , , , , , ,

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 »

By Posted on Posted in Performance, Podcast No Comments Tagged with ,

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 …

The Use of WITH NOLOCK Query Hint Read more »

By Posted on Posted in Podcast No Comments Tagged with , ,

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 »

By Posted on Posted in Podcast No Comments Tagged with , , , , , ,

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 »

By Posted on Posted in Podcast No Comments Tagged with , , , , ,

This weeks SQL Data Partners podcast, Episode 55,  is on (SSRS) Reporting Services Changes in SQL 2016. This episode features Jessica Moss, and the discussion is on some of the great new features in SSRS 2016. One of the key take-aways from the session is how Microsoft has broken the report groups into 4 categories. Paginated – Like what we are used …

This weeks podcast featuring Jessica Moss Read more »