At the PASS Data Community Summit in Seattle on November 12th, I'm teaching a one-day pre-conference workshop. This year, the Summit is a hybrid event: you can either attend in-person in Seattle, or online via live streaming. If you attend online, PASS is recording the live stream, and you'll be able to re-watch it during the…
The newest Cumulative Update for SQL Server 2019 has this gem in the release notes:
This is a massive problem if:
These days, BrentOzar.com mostly focuses on the Microsoft data platform. However, you and I have a relationship, dear reader, so I just need to talk about some personal stuff today.
Lemme get two things out of the way first:
You love learning from me. You've attended some of my free online streams, read my blog posts, and you use the First Responder Kit. You enjoy my laid-back, humorous approach to sharing what I've learned over the years. You love live classes. You've tried watching recordings or stepping through demos yourself, but...you just can't block…
Post your questions at https://pollgab.com/room/brento and upvote the questions you'd like to see me discuss.
The light balance on this video is all over the place, getting brighter and darker constantly, so you might wanna leave this one playing in the background and just listen to it rather than watch.
You posted SQL Server questions and upvoted the ones you'd like to see at https://pollgab.com/room/brento, and before the Cabo Clasico finals start for the day, I sat by the pool to talk through 'em:
https://www.youtube.com/watch?v=--nU3K47Eyc
For years, the biggest conference in the Microsoft data platform community has been the PASS Summit.
This November 15-18, it's coming back to the Seattle Convention Center. You can attend in person, or virtually.
You've been working with Microsoft SQL Server for yeeears, and you're pretty confident that you know how to write a query.
So when I tell you about a book called T-SQL Fundamentals, you're all, "nah, man, I got this covered."
I recorded an Office Hours stream answering a bunch of your questions quickly, but...I forgot to turn on my microphone, so the video only had the sound effects:
https://www.youtube.com/watch?v=Iyd6JRAyGog
In a programming language like C# or Java, you tell the computer what to do, in order. Get the customers from California, then get their invoices, then sum the total. SQL, on the other hand, is a declarative language where you declare the shape of your result set: Get the total sales from Californian customers.…
If you want to get a look at where Microsoft SQL Server is heading in the future, it helps to get an idea of what users are repeatedly asking for. Here's a quick rundown of the top requests from feedback.azure.com as voted by the people who cared enough to log in and upvote 'em:
When you see "index seek" on an execution plan, that doesn't mean SQL Server is jumping to exactly the row you're looking for. It only means that SQL Server is seeking on the first column of the index.
This is especially misleading on indexes where the first column isn't very selective.
Is your company hiring for a database position as of May 2022? Do you wanna work with the kinds of people who read this blog? Let's set up some rapid networking here. If your company is hiring, leave a comment.
The rules:
For my Office Hours streams on my Twitch channel, y'all post questions at PollGab and upvote the ones you'd like to see me discuss on the stream. However, not all questions require a video answer. Here are some simple no-brainer ones:
Q: BehindTheScenesDBA: With all its limitations, what do you think about memory-optimized tables? Have you recommended to a client to use it?
It's the first webcast I've done from my new Vegas pad. You posted questions at https://pollgab.com/room/brento/ and I discussed the highest-upvoted ones:
https://www.youtube.com/watch?v=3wV64rqwxSk
You're a DBA responsible for making sure SQL Server databases are online, backed up, corruption-free, and fast. Your databases have gradually grown in size over time, and you're starting to hit new size issues you haven't encountered before.
Nightly maintenance windows are getting smaller, you're not able to refresh your development environments quickly enough, and you're not able to run DBCC CHECKDB as often as you'd like.
It's the last San Diego balcony edition of Office Hours! You posted your questions at https://pollgab.com/room/brento and upvoted the ones you'd like to see.
https://www.youtube.com/watch?v=YLA2O4m99lE
You're investigating your SQL Server's top wait stats, and you're noticing a lot of LCK% waits. Normally, that indicates blocking and deadlocks, but you're just not getting complaints from your end users, and you're wondering what's causing it.
It might be overzealous index rebuilds.
Wow, talk about stable! The last 3 months have only introduced a series of small bug fixes. I held this release back as long as I could, waiting to see if anything major might get added or if we might get a SQL Server 2022 CTP, but no dice. If there was ever a First Responder Kit release you could skip, it's probably this one. If the specific issues listed here don't affect you, take the morning off.
You posted questions at https://pollgab.com/room/brento and I picked the fastest ones to answer:
https://www.youtube.com/watch?v=AmBMThuMoxw
