SQL Data Partners Podcast-logo

SQL Data Partners Podcast

26 Favorites

More Information


United States




Episode 109: To certify or not to certify?

In episode 64 we interviewed Patrick Thomas, the program manager for the MCP program which includes certifications. There continues to be quite a bit of discussion around certifications, so it only makes sense that we give our take on the matter. Both Steve and I are certified, so this may give away some of our thoughts. Certification is a tricky thing. Much of the value you get out of a certification is dependent on where you on in your career and what your next step is going to be. This...

Duration: 01:01:06

Episode 108: The Future of the Relational Database

After a brief hiatus, we are back on the air to continue the conversation and let me tell you--we have a great conversation lined up for this episode. The discussion around what will happen to the relational database, and by extension us as administrators continues to get quite a bit of traction. Even within SQL Server, we are starting to see more features that don't fit the traditional relational mode and a podcast listener inquired about getting our thoughts. As I thought about a guest...

Duration: 01:34:24

Episode 107 BI for the Little Guy

Data analytics is all anyone seems to talk about anymore. We've even caught the bug at SQL Data Partners and have started working with data platform MVP César Oviedo from Costa Rica. César has been helping us on some projects and we thought it was time we introduced him to everyone. On the Spanish front, he has been very busy putting out YouTube videos and publishing content for BI LATAM (Latin America). We invite him on the show to introduce himself and our conversation turns to the idea...

Duration: 00:59:22

Episode 106 Temporal Tables

User: What was that record before it was updated? Me: I don't know. Maybe I could restore a backup? User: Really? You have to do all that? It is just one record. Me: (under my breath) Yes, a record YOU updated. If you have ever had a conversation like this you know how difficult it can be to implement auditing of records as they change. With temporal tables, a new feature, we have the ability to track point in time information about a record without the huge expense of setting up...

Duration: 01:45:31

Episode 75 When is enough, enough?

How can you tell when a change is enough of a change? How do you know you didn’t make too big of a change? Steve and I discuss some thoughts around what you might look for when you make certain changes. Some of the components we cover include Max degree of parallelism, cxpackets, virtual log files, the number of log files for a database, backup retention and memory. The shownotes for today’s episode is found at http://sqldatapartners.com/2017/07/18/enough/ and have fun on the SQL trail.

Duration: 01:32:51

Episode 104: Keeping up with technology

Do you have any experience with [Insert random technology]? Your heart starts to race and your palms get a little sweaty. You don’t want to say no–we’re tech folks–we know stuff, but there are so many new things to learn! How are you supposed to keep up with it all? In this episode, we chat with Eugene Meidinger about his thoughts on keeping up and his ideas on the most important learning components. The show notes for today's episode can be found at ...

Duration: 01:59:59

Episode 103 Plan Reuse

When we write our queries to the database, SQL Server has to go and figure out the best way to go and bring back the data you asked for. A query plan is created to help SQL Server remember how to get the data for this query. It takes time to make these queries, so the database wants to limit the number of times it has to create the plans so it will try to reuse the plan as much as possible. Our topic for today's episode is query plan reuse and the pros and cons with this concept. We...

Duration: 01:32:07

Episode 102 Monitoring Availability Groups

One of the newer features in SQL Server is availability groups, which can help solve a number of business problems. As administrators, availability groups introduce some complexity as we are tasked to make sure the Recovery Point Objective (RPO) and Recovery Time Objective (RTO) can be meet for these servers. The complexity comes because we have different instances that must work together, but they don't always see eye to eye. In this episode, we chat with Tracy Boggiano of channeladvisor...

Duration: 01:07:26

Episode 101 Inspecting a new Database

Listener Cody Ford wrote in and asked if we could share some thoughts on getting familiar with an unfamiliar database. While we have done episodes in the past on best practices, this episode takes the approach of what we should look for on a server that is new to us--the components we should document and then review for potential updates. Do you agree with our list? Let us know on by leaving a comment on the show notes page. The shownotes for today’s episode is found at...

Duration: 01:22:17

Episode 100 Role Reversal

Something a bit strange happened in episode 100--almost like something out of the twilight zone, but don't take our word for it. Check out our latest episode as tell some of the stories that led up today. The shownotes for today’s episode is found at http://sqldatapartners.com/2017/06/14/episode-100-listener-qa-c144/ ‎and have fun on the SQL trail

Duration: 01:20:54

Episode 99 Imposter Syndrome

Impostor syndrome (also known as impostor phenomenon or fraud syndrome) is a term coined in 1978 by clinical psychologists Dr. Pauline R. Clance and Suzanne A. Imes referring to high-achieving individuals marked by an inability to internalize their accomplishments and a persistent fear of being exposed as a "fraud". In this episode of the SQL Data Partners podcast, we take on a topic that is not technical; however, might play a very important role in some of the opportunities we take--or...

Duration: 01:47:58

Episode 98: The first change you make

In a recent SQLSaturday conference, I walked into the speakers room and asked the question--What is the first thing you change after you install SQL Server? It was interesting to get their take on the server setup and I think you will enjoy the conversation. There are various answers on this one but some of the speakers have mentioned stuffs like set auto grow files, SQL Prompt, SQL parameter class and max memory among others. I would like to thank Kevin Feasel, Jonathan Stewart, Eugene...

Duration: 01:27:33

Getting Ready for Episode 100

As Steve and I prepare for episode 100, we want to hear from you! Have a question for us or some story you want us share? Drop us a line on our website or any social media platform. We will take submissions until June 9th.

Duration: 00:02:44

Epsiode 96 Building Community Tools

Have you ever created something and wanted to share it with others with the hope they will contribute and make it better? Sites like the new defunct codeplex and GitHub are full of functionality people want to share and work with others on; however, many projects remain dormant. What are the characteristics that create an environment where people want to contribute to your project? Steve and I discuss a few ideas and we interview two very successful community project leaders in Brent Ozar...

Duration: 01:42:21

Episode 95 Polybase

Big data is term we have been hearing frequently as of late and this might cause some concern for us in the SQL Server space. Micrsoft has introduced some new functionality to help connect different data stores with PolyBase. We are happy to have Kevin Feasel from ChannelAdvisor back with us and Kevin will discuss some of the basics around what PolyBase does. We’ll be discussing a lot about integrations using PolyBase specifically on Hadoop and Azure SQL Blob Storage. We also touch on some...

Duration: 02:06:30

Episode 94 Qlik Technologies

There are lots of reporting options and I watch SQL Server move up the Gartner magic quantrant, I saw another reporting tool moving up as well--Qlik. In this episode we will start by sharing information about Qlik, what it is and some background in the event it gets adopted at your company. Today we are delighted to have Michael Armentrout as our guest. Michael is a Microsoft SQL Server DBA as well as the developer of QlikView and we discuss the fundamentals of QlikView such as the...

Duration: 00:46:22

Episode 93 Making Mistakes

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

Duration: 00:37:17

Episode 92 SSDT

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

Duration: 00:51:15

Episode 91 DBA Tools

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

Duration: 00:49:04

Episode 90 Check DBCC

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

Duration: 01:09:34

See More