Try Premium for 30 days

Live games for all NFL, MLB, NBA, & NHL teams
Commercial-Free Music
No Display Ads
SQL Data Partners Podcast-logo

SQL Data Partners Podcast

38 Favorites

More Information

Location:

United States

Language:

English


Episodes

Episode 121: What makes a good manager?

12/14/2017
More
I have heard it said "People don't quit jobs--they quit managers". At a recent event, I decided to ask people what they thought the qualities of a good manager are. Perhaps you aren't thinking of getting into management; however, at some point in your career you will have the opportunity to lead. We share your thoughts and comment on the challenges of having the qualities of a good manager. The show notes from today's episode can be found at...

Duration: 01:19:57


Episode 120: SQL Injection

12/6/2017
More
Shouldn't they have fixed that instead of putting out all these new features? That might be what you are thought when you saw the title for today's episode. SQL Injection is still a big deal in today's databases and we are pleased to have Bert Wagner on the program to talk with us about how it can affect you and the applications you protect. One of the most difficult aspects to deal with SQL Injection is to decide who is responsible for dealing with it? Bert does a great job giving us some...

Duration: 02:14:39


Episode 119: Getting started with Github

11/29/2017
More
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...

Duration: 01:22:52


Episode 118: How has index maintenance changed?

11/24/2017
More
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...

Duration: 02:17:26


Episode 117: PASS Summit Retrospective

11/15/2017
More
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...

Duration: 01:24:06


Episode 116: Are people still using PSSDiag?

11/8/2017
More
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...

Duration: 01:14:26


Episode 115: The Companero Conference Retrospective

11/1/2017
More
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...

Duration: 01:34:06


Episode 114: How do you start consulting?

10/25/2017
More
One of the advantages to a small conference is the ability to take attendee feedback and put it in place during the conference. We actually made time for the attendees to pick topics they wanted to discuss and this episodes comes from one of our attendees Aaron Hayes. It can be very tempting to think of the good life of consulting. I almost liken it to playing the lottery--what am I going to do with all that time and money? While the odds on successful consulting are a bit higher than the...

Duration: 00:24:08


Episode 113: How do you start consulting?

10/11/2017
More
"If I have seen further, it is by standing on the shoulders of giants." Those words are attributed to Issac Newton and they are fitting for the way I was feeling recently as I thought back to those who have helped me in my career. While we might always want things to be better, as technologies we have it pretty good. There are unnumbered people who have dedicated untold amounts of time so we can have the tech available to us. We take a moment to think about those who have paved the way for...

Duration: 00:46:02


Episode 112: Keeping up with patching

10/4/2017
More
When listener Mel Vargas first suggested the topic of patching, I was not sure this would work as a topic; however, the Equifax story had just developed and there are many other security related issues that could be prevented with patching. Match that with our guest, Robert Davis, who just happened to publish some articles on patching and I decided we needed to do this episode. I should never have doubted this as topic. While we are a bit more protected in SQL Server than others, the...

Duration: 01:21:32


Episode 111: How do you prepare for a conference?

9/27/2017
More
Sometimes just getting approval to attend a conference is a challenge, but getting the green light isn't the only thing you should plan for. Sure, you want to learn some things--but a google search can teach you too. In fact this week we are hearing about new features and functionality from the Ignite event--and I am catching all of it in my bunny slippers. Why attend a conference then? Conference season is upon us and Steve and I share some thoughts on why we attend conferences and some...

Duration: 01:07:22


Episode 110 How do I build trust with my team

9/20/2017
More
As you work with other people, you will experience resistance when you suggest changes and want to implement something new. Why is this? One podcast listener shared an experience where a problem was occurring. The suggested a solution. The idea was rejected. No solution presented itself and the idea was submitted various times. When nothing else was working, the idea was finally implemented. The suggested change successfully helped the situation. Victory! Later, another issue arose and...

Duration: 01:38:00


Episode 109: To certify or not to certify?

9/13/2017
More
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

9/6/2017
More
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

8/3/2017
More
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

7/26/2017
More
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?

7/19/2017
More
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

7/12/2017
More
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

7/5/2017
More
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

6/29/2017
More
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

See More