Office Hours Podcast

Listen in as we answer SQL Server questions.

Every Wednesday, we used to get together to answer your SQL Server questions. They’re on hold for 2019, but you can listen to past episodes in your podcast player or below.

Subscribe to the Podcast

itunes

Or subscribe via Stitcher or RSS.

Subscribe

  • This field is for validation purposes and should be left unchanged.

Past Episode Videos and Transcriptions

[Video] What’s New in SQL Server 2019

We must be getting pretty close to the official release of Microsoft SQL Server 2019. There are less than 80 days left in the year. (Interestingly, it’s been almost 60 days since Release Candidate 1 shipped – that’s unusually long for a delay between builds. Hmm.)

With the clock ticking down, now’s a good time to take a 40-minute look at some of my favorite new features: deferred compilation for table variables, adaptive memory grants, adaptive joins, and air_quote_actual plans:

To learn more about this stuff:

[Video] Help! SQL Server 2008 is Still Here!

Your company is ignoring the news: SQL Server 2008 and 2008R2 are officially out of support as of today, but nothing’s changing at your company. You still have SQL Server 2008 in production, and you’re a little nervous. How should you approach the conversations with management? Brent Ozar will help: he’s been there too, fighting managers who want to leave an old server hiding in the corner. We’ll role play: you be the manager, and Brent will show his techniques for convincing management to take the plunge and move to a newer SQL Server version.

Slide deck:

Using Implicit Transactions? You *Really* Need RCSI.

Implicit transactions are a hell of a bad idea in SQL Server: they require you to micromanage your transactions, staying on top of every single thing in code. If you miss just one little DELETE/UPDATE/INSERT operation and don’t commit it quickly enough, you can have a blocking firestorm.

The ideal answer is to stop using implicit transactions, and only ask for transactions when you truly need ’em. (Odds are, you don’t really need ’em.)

But if you can’t change the code, you need the delicious goodness of Read Committed Snapshot Isolation. Here’s a video demo showing why:

You can learn more about RCSI, its gotchas, and how to implement it here.

[Video] An Introduction to GitHub for DBAs

Distributed source control is really intimidating: branches, pull requests, merges – will somebody just take my code, for crying out loud? Why does it have to be so complicated and involved?

I’m with you: I hated GitHub. For years, I struggled with it, but I’ve come to a gradual truce. I’m not a GitHub pro by any means, but in about an hour, I can explain the most important terms to you in a way that’ll make sense for non-developers. I’ll show you how to contribute to someone else’s open source project, and how to get started putting your own scripts under source control.

The resource links:

[Video] Getting Started with the Consultant Toolkit

You’re a consultant who needs to figure out why your clients’ SQL Servers are slow and unreliable.

You’ve collected a bunch of diagnostic queries over the years, but they have a lot of holes, and you don’t really have the time to maintain them – let alone make ’em better. You waste time connecting to the server, running one query at a time, copy/pasting the results into Excel or taking screenshots. You’re burning the client’s money doing manual labor, and neither of you are happy with the results.

That’s where our Consultant Toolkit comes in, and today I did a live webcast talking about how it works:

Get a free trial and a big discount during our launch sale – ends Saturday.

Menu
{"cart_token":"","hash":"","cart_data":""}