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 and Steve on the SQL trail compañeros--you won't regret it.
RSS Feed Subscribe in iTunes
SQL Data Partners Podcast
2017
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: April, 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.

Apr 26, 2017

We all make them and sometimes it can be painful.  Making and sharing mistakes is one of the most powerful tools for learning; However, most of us do all they can to avoid and hide those mistakes.  In this episode, Steve and I talk about making mistakes and share some thoughts around how we might improve how to respond when we don't do something quite right.

The shownotes for today’s episode is found at http://sqldatapartners.com/2017/04/25/episode-93-making-mistakes/ and have fun on the SQL trail.

Apr 19, 2017

At one time there were two different products named SSDT and that was confusing for lots of folks. and we’re pleased to have Kevin Cunnane, the program manager for SSDT, as our guest.  We wanted to ask him about some of the new database features in Visual Studio and what kind of problems they are looking to solve.

SSDT

We think it is awesome the Microsoft folks will take some time our there their schedules to talk with us and we think you will this episode an interesting discussion on the future of database tooling.

The shownotes for today’s episode is found at http://sqldatapartners.com/2017/04/18/episode-92-ssdt/ and have fun on the SQL trail.

Apr 12, 2017

We all want an easy button.  It is human nature.  We heard quite a bit about how easy PowerShell will make everything, but for those of us who aren't programmers, it can be a bit intimidating to get started.  Luckily for us, we have what is shaping up to be the closest thing to an easy button for DBAs I have found for PowerShell tools from the folks at dbatools.io.  We invite some of the team to chat with us about their tool, how they got started and the types of problems they are looking to solve.

In this episode, Chrissy will be talking about how DBA Tools started from just being a simple migration tool until it became a useful tool solving various SQL related issues.  The team will discuss the other various situations where DBA Tools can really be helpful and how they manage contributions from over 30 people which leads us to talk about GitHub, the open source community, and their experiences in updating versions of DBA Tools and how they encourage contributors in the project.

Chrissy, Rob, Constantine, and Aaron were super excited to talk with us and we loved their energy and think you will enjoy this episode.

The shownotes for today’s episode is found at http://sqldatapartners.com/2017/04/12/episode-91-dba-tools/ and have fun on the SQL trail.

Apr 5, 2017

DBCC CheckDB.  It is a simple command, but one that can cause database contention, dba stress, confusing results, dba elation, and everything in between.  At one time we will all have to face the results of having a corruption issue and we’re delighted to have Sean McCown with us again to discuss the ins and outs of the issues of this command. If you can remember, Sean was our guest in Episode 41. He is an SQL Server MVP with more than 15 years experience.

We talk with Sean about how frequent issues we have with maintenance like we often we should run CheckDB on our databases or what happens when I can only check one database during my window. While we don't end up discussing the command as much, we definitely review all aspects of making sure it can run in ALL environments.

The shownotes for today’s episode is found at http://sqldatapartners.com/2017/04/05/dbcc-checkdb/ and have fun on the SQL trail.

1