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.
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.
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.
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.
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.