Info

SQL Data Partners Podcast

In this podcast, I discuss a variety of SQL Server related topics mixed with a sprinkling of professional development and I talk with some of the biggest names in the industry. I want to introduce new and familiar topics and talk about them in a way you may have not considered. We are all on different stages as data professionals. I hope you will join me on the SQL Trail, compañeros--you won't regret it.
RSS Feed Subscribe in Apple Podcasts
SQL Data Partners Podcast
2019
October
September
July
June
May
April
March
February
January


2018
December
November
October
September
August
July
June
May
April
March
February


2017
December
November
October
September
August
July
June
May
April
March
February
January


2016
December
November
October
September
August
July
June
May
April
March
February
January


2015
December
November
October
September
August


Categories

All Episodes
Archives
Categories
Now displaying: November, 2017

Companeros, welcome to the SQL Data Partners Podcast, a podcast dedicated to SQL Server related topics which is designed to help you become familiar with what’s out there, how you might use features or ideas and how you might apply them in your environments.

Nov 30, 2017

At first glance you might think our podcast topic is from way out in left field; however, as you think about it there are a number of reasons we should be talking about GitHub.  Even if you don't need a public source control repository for creating code, GitHub is becoming the preferred place for creators to publish their content and the ability to interact with other is extremely value.  In this episode we give some of our thoughts around getting started with GitHub and how it might differ from some of the other options out there.

Don't forget to leave your 'Tips and Tricks' on the podcast page.  If we get enough submissions, we will start that new segment in January.

The show notes from today's episode can be found at http://sqldatapartners.com/2017/11/29/episode-119-should-i-get-involved-with-github. Have fun on the SQL Trail!

Nov 24, 2017

After having attended PASS Summit and seeing all the new features coming it out, it can be very easy to overlook the basics--they are boring.  These features have been around forever.  This may be true, but they still play an important role and ignoring them won't help get you those fancy new features any time soon.

In this episode, our topic is index maintenance, with an emphasis on what has changed or what might change.  Is the query store feature going to impact the way we maintain our indexes?  We invite one our favorite guests, Sean McCown back to talk with us and give some of his thoughts.

The show notes from today's episode can be found at http://sqldatapartners.com/2017/11/24/index-maintenance. Have fun on the SQL Trail!

Nov 15, 2017

Have you ever had a week without a Wednesday?  Me neither, so for this episode, we recap our experience at PASS Summit and talk about all the amazing compañeros we met and give some thoughts around our very first meetup.  It was so much fun to meet everyone and both Steve and I gave sessions, which was a great experience--and a first for me.

One, we both realized after the fact is, we are not good at social media or taking pictures!  We apologize we don't have a bit more to share on that front, but hey--we do have faces for radio.

The show notes from today's episode can be found at http://sqldatapartners.com/2017/11/15/episode-117-pass-summit-retrospective/. Have fun on the SQL Trail!

Nov 8, 2017

If you have ever worked with Microsoft support, you probably came across the PssDiag tool they use to collect information about your environment.  My experience with the tool is it always seemed, well--a bit clunky.  Now, it does collect lots of information and seemed to be a bit overwhelming when I was first a DBA.  Fast forward a few years and PssDiag was not a tool I use anymore and was not sure if anyone outside of Microsoft was using it.  I run into Jared Poche in Raleigh and he mentions he really likes the tool and mentions some of the improvements they have made over the years.  Well, you can guess where this is heading.

We talk with Jared about his experience with the tool and cover some of the basics about how you might go about using this tool in your environment.  There are two pieces to this tool, the first is the utility that collects the data and the second is the reporting piece SQL Nexus.

Are you using PssDiag?  Let us know if the comments below.

The show notes for today's episode can be found at  http://sqldatapartners.com/2017/11/07/episode-116-are-people-still-using-pssdiag. Have fun on the SQL trail!

Nov 1, 2017

It was a beautiful idea.  Gather together with a group of our podcast listeners in a conference type format and find ways for us to connect and help each grow.  I had seen it down in other events; however, I wanted to add my own flavor.  I wanted this to be different.  While the event turned out great and we got good marks from the attendees, we didn't have the response we were hoping for.  In this episode of the podcast, we have our companero conference retrospective.

We try to give our honest feedback about what we did well, what could have been improved, and what the attendees reported.  I can't say enough about the help I got from our speakers--Jonathan Stewart, Kevin Feasel, Randolph West, Tracy Boggiano, and Doug Purnell.  They were awesome and the event was much simpler because of them and their commitment.  They are truly my companeros on the SQL trail.

The show notes for today's episode can be found at  http://sqldatapartners.com/2017/10/31/episode-115-the-companero-conference-retrospective. Have fun on the SQL trail!

1