This is the first post in our new Case of the Week series — short write-ups from the real SQL Server issues our team of 17 SQL Server experts helps clients solve every day. Case of the Week: SQL Server Partition Job Failure after Migration from AWS FCI to AWS AG. Quick Summary A client … Read more
Recently, I announced that after almost 20 years at Microsoft, I was moving to a new company and role. I’ve been in the Information Technology industry for over 40 years, and I believe that experience, combined with the various companies, organizations, and roles I have held, has led me to this place. Why Straight Path … Read more
I watched Bob Ward demo vector search in SQL Server at the NYC PASS road show in late August, and I have a confession that I’m not proud of. I felt that little knot in my stomach that every DBA knows too well. His pre-recorded PowerPoint videos typed a few commands, asked questions in natural … Read more
“Oh, hi, don’t mind us – we’re just having a little conversation about SQL Server. I’m so glad you can join us. There are seats up front here…” That was the first time I ever heard words from Buck Woody directed at me. It was my first time attending one of his sessions at the … Read more
Have you ever written a PowerShell command so long that it stretched across the screen? Or had to update a script and hunt through a long parameter list to change a single value? Splatting solves that problem by letting you pass multiple parameters to a command using a single variable. What Is Splatting? Splatting allows … Read more
In this and the next two blog posts I will be bringing diverse dbatools commands into scripts that can handle a complete deployment, do a checkup of major health and configuration metrics, and do a true up of a pre-existing instance. This post will cover the complete deployment, which if you have been reading the … Read more
I’ll be speaking on Tuesday, 8/19, at the PASS Summit on tour in New York City. I’ll be giving a talk in the “professional development” world this time.. And I’ll be doing the same session at the PASS Summit in Seattle this fall. This time, rather than talk about SQL Server DBA tips, upgrades, migrations, … Read more