SQL Data Partners Podcast

Clustering is a now tried and true technology to help increase the availability of your SQL Server environment.  I talk with Paul Popovich about his experiences with clustering and how his approach has changed as the technology has evolved.  If you are looking for a good introduction to some concepts of clustering, this episode is for you!  It should be noted this episode does not include the new feature of Availability Groups. You can view the show notes for this episode at http://sqldatapartners.com/2015/10/03/clustering/

21 Okt 201523min

I attended Kevin Feasel's SQLSaturday session entitled Apply Yourself and thought it was pretty funny.  While not close friends, I have know Kevin for a while and knew he had good stuff.  He there shared this quote in his session.  “If you don't understand the APPLY operator, your skills are somewhere around the 50th percentile at best.” -- Adam Machanic.  I knew immediately I wanted to have him on the show. This episode will introduce some concepts, but you will have to do a bit a leg work if you want to start 'Applying' this into your code--I'm sorry, I couldn't resist. As always, you can check out http://sqldatapartners.com/2015/10/13/the-apply-operator/ for the show notes.  Have fun on the SQL trail!

14 Okt 201530min

Database corruption is something that will eventually come to all data professionals.  While I have been fortunate to only come across is a handful of times, I was glad that I was able to get back the corrupted data and get everyone back on track. In May of 2015, Steve Stedman set the data community ablaze with his database corruption challenge.  Some of the biggest names in the community jumped in with solutions to his challenge and I knew I wanted to have Steve on the show. If you are interested in hearing more about his experience and his suggestions for dealing with database corruption, this episode is for you!

7 Okt 201531min

So it turns out an old dog can learn new tricks--or at least that is what happened to me when I chatted with Grant Fritchey from Red Gate software about SQL Server Statistics.  Always taking an opportunity to teach, Grant talks about why statistics are important and we go over some fundamental items you may just want to know about.  As always compañeros, have fun on the SQL trail.   Be sure to check out the show notes at http://sqldatapartners.com/2015/09/29/statistics for information we chat about during the program.

30 Sep 201534min

We mix things up a bit as I chat with Thomas Frank from collegeinfogeek.com about test anxiety and test preparation.  Taking a test can be a big deal and it is always interesting to get other options on preparation.  As data professionals, of course we want a way to be able to advance our careers and a certification can play a role in that, but we might have a bit of anxiety around it.  The biggest take away for me from this session was Thomas's tool recommendation and how he was able to start better habits.  I took his advice and have seen some results I may share in a latter episode.  Have fun on the SQL trail compañeros! As always, you can check out links for the show on the website http://sqldatapartners.com/2015/09/23/episode-10-test-anxiety-and-test-preparation.

23 Sep 201532min

Joey D’Antoni has been doing quite a bit with database automation and I caught with him to discuss his experiences about how database automation has helped him be more efficient and have fewer support problems.  We discuss strategies for starting your automation techniques and he gives a few pie in the sky examples if you are running a large environment.  Compañeros, I hope you enjoy the program. Be sure to check out the show notes at http://sqldatapartners.com/2015/09/17/episode-09-database-automation

16 Sep 201529min

I chat will Louis Davidson about database design and get his thoughts on some strategies about how to go about making your design and what tools are available to help you.  It may surprise you that, according to Louis, the data type is not the most important component of database design.  I hope you enjoy the show. Be sure to check out http://sqldatapartners.com/2015/09/08/episode-08-database-design/for the show notes.

9 Sep 201533min

I chat with Microsoft MVP Chris Bell about database security and some seemingly cavelier attitudes some organziations have about keeping data safe.  We hit some of the methods SQL Server has to protect your data.  Chris also unveils his security analzyer you can use in your environment to see what areas might need to be addressed. You can check the full show notes at http://sqldatapartners.com/2015/09/01/episode-07-sql-server

2 Sep 201541min