One of the neat benefits of putting the podcast together is talking to a wide spectrum of folks with varied backgrounds. As we get more feedback from listeners, the idea of the Lone DBA emerged. The Lone DBA is someone who is the only person responsible for database administration at their company. These tasks may have been assigned or they may have simply been required to help support an application. Steve and I thought we should explore this a bit and to help give us some context, we invited Monica Rathbun to chat with us about some of the challenges she’s faced.
Besides the challenges, Monica shares tactics and techniques to juggle many tasks while being a lone DBA. This includes using social media as a way of building connections with different experts, getting the right tools for the organization’s needs and making your boss your supporter. Have your own perspective on this? Let us know in the show notes for the episode.
The shownotes for today’s episode is found at http://sqldatapartners.com/2017/03/28/episode-89-lone-dba/ and have fun on the SQL trail.
Why can't we just get along? There can be a real love/hate relationship between those of us with data responsibilities and those who are responsible for SharePoint environments. We want to provide good service to those environments, but there are SO MANY things we can't do on a SharePoint database. To see how the other half lives, we invited Todd Klindt onto the program to give us his thoughts on how we can all get along a bit better.
Because Todd suggests the “SQL and SharePoint communities should understand each other a little better”, we will try to tackle some of the obstacles the teams face so you can be better armed to support your SharePoint team.
The shownotes for today’s episode is found at http://sqldatapartners.com/2017/02/08/episode-88-sharepoint/ and have fun on the SQL trail.
Why do some features get all the fun? I would like to be a fly on the wall at some of the Microsoft feature development meetings. There are many very cool features that didn't get quite enough love to get the adoption they deserve. In this episode we are talking about Resource Governor and before you roll your eyes, you may be interested to know some of the side benefits of using the feature. We are joined by Mark Wilkinson from channeladvisor to give us an overview of the feature and how they use it to manage SQL resources and workloads.
One interesting story is how their team won the query challenge last PASS summit using Resource Governor so it is pretty powerful. Mark will also share his experiences using Resource Governor in different working environments. He will also be discussing the basics and tips about building the classifier function of Resource Governor. Furthermore, we will go through setting up I/O caps, resource pools and workloads, and the NUMA node affinity.
The shownotes for today’s episode is found at http://sqldatapartners.com/2017/02/08/episode-87-resource-governor/ and have fun on the SQL trail.
Based on listener feedback we got from episode 72, a request was made to have a conversation about testing frameworks and in this episode we are going to focus on tSQLt. We are pleased to have Sebastian Meine, the creator of the tSQLt unit testing framework, on the podcast with us. We talk about the basic principles of tSQLt Framework when it comes to unit testing. Sebastian will also be discussing about the do’s and don’ts as well as the different aspects to be considered when using the framework. Sebastian makes the case for why you should take the time to create unit tests and we discuss the challenges culture might play into the use of the framework.
The shownotes for today’s episode is found at http://sqldatapartners.com/2017/03/03/episode-86-tsqlt/ and have fun on the SQL trail.
Have you done your migration to SQL Server 2016 yet? Don’t worry—you aren’t alone. With all the glory of new features and improved performance, not all upgrades are equal. In this episode we talk with Javier Villegas who returns from episode 2 to talk about some of the issues he ran into on the upgrade to 2016. He stumbled on a process that normally runs for 7 minutes prior to the upgrade and then 26 hours after the upgrade. While it all worked out, he shares the issues he had and gives us a reminder that testing has not been deprecated.
The shownotes for today’s episode is found at http://sqldatapartners.com/2017/01/25/speedbumps/ and have fun on the SQL trail.