Live classes start in 1d 07h 19m — Save your seat

SQL Server Administration and Maintenance

Installation, configuration, automation, health checks, and governance controls.

301 associated posts140 primary posts

[Video] Office Hours at Iceland’s Most Famous Waterfall

Iceland has some pretty famous waterfalls, from Þórufoss and Skógafoss in Game of Thrones, to Háifoss in Stranger Things, to Dettifoss in Prometheus, and more. However, probably the most-photographed one is Seljalandsfoss, partially because of its easy access from the Ring Road, and partially because of, uh, Justin Bieber's video for I'll Show You. That video is also a pretty good intro to the greatest hits of Iceland's south coast.

Read more about [Video] Office Hours at Iceland’s Most Famous Waterfall Be the first to comment

Using Claude Code with SQL Server and Azure SQL DB

Your queries won’t tune themselves. My 2027 Live Class Season Pass is $995 (normally $4,395), with live Fundamentals and Mastering classes plus recordings. Register by October 31 to join Fundamentals Week, November 2–6. See the pass. Let's start with a 7-minute demo video - I didn't edit this down because I want you to be…

Read more about Using Claude Code with SQL Server and Azure SQL DB 22 comments — Join the discussion

[Video] Office Hours in Osaka, Japan

The Dotonbori area of Osaka is like a video game version of Japan: wild, over-the-top neon signs, awesome street food, cool street markets, Kabuki theater on a revolving stage, and more. It's very touristy, but as touristy places go, it's fantastic. Last year when I was here, I filmed Office Hours at the river, but this time around let's go into one of the side streets where the food vendors gather.

Read more about [Video] Office Hours in Osaka, Japan Be the first to comment
Production DBA

Let’s Build a Better KILL. What Do We Need to Consider?

When there's a performance emergency, a lot of us perform the same manual tasks over and over. We run sp_BlitzWho or sp_WhoIsActive, look for blocking, long-running or out-of-control queries, and kill them. I'm going to build a new sp_kill for the First Responder Kit to make that easier, faster, and safer, and I want your…

Read more about Let’s Build a Better KILL. What Do We Need to Consider? 62 comments — Join the discussion

Microsoft Now Recommends You Set Max Memory to 75% and Min Memory to 0%.

Your queries won’t tune themselves. My 2027 Live Class Season Pass is $995 (normally $4,395), with live Fundamentals and Mastering classes plus recordings. Register by October 31 to join Fundamentals Week, November 2–6. See the pass.

Somehow I missed this a few years ago, and I bet a lot of y'all did too. Note the new "Recommended" column in the memory settings documentation:

Read more about Microsoft Now Recommends You Set Max Memory to 75% and Min Memory to 0%. 20 comments — Join the discussion