Our agenda is live! 📅 Saturday, September 26, 2026 📅 🕜 8:00 am ⭐️ SUPERCHARGE YOUR DASHBOARDS WITH POWER BI We’ll explore advanced techniques for optimizing data models

Welcome to another T-SQL Tuesday! This month is hosted by Marlon Ribunal (b). You can find the full invitation here. This month, Marlon asks us to recall our worst SQL Server disaster. I have spent most of my time on the development side of the house so while I’ve had some fun troubleshooting issues, most of the time I was shielded from the true outages.

Whether you're always running the latest version of SSMS or are a few releases behind, there's never been a more exciting time to be an SSMS user. The SQL Server Management

ALT: Infokomposter Spongebob: Old Age Transformation

It's another T-SQL Tuesday! Thanks to Jeff Taylor for hosting this month. You can find his full invitation here. Jeff wants to know where we stand: Are temp tables our "friend" or our "foe", even while we acknowledge that the likely answer is "it depends". My stance is that temp tables are a useful tool when properly used, but they're very easy to misuse to the point of creating problems.

Hello, Data WIT, and Happy August! If you remember, we’ve said we’ve been busy with things. So let’s jump into it. 🔁July Recap: Last month, our July meetup was with Mou Rakshit, presenting “Transformi...

It's the final video of the 3 part series. Hopefully you have watched (or read) Parts 1 & 2. This third video is about DMVs and Query Store. We'll bring everything back together at the end. The (slightly edited for garbled words) transcript is at the end for those who prefer to read, with references to where in the video you can find the demos I'm talking about.

In today’s technical world, traditional career paths often fail to align with the unique skills and ambitions of professionals. This session empowers technical audiences to

This is the second part of the series. Hopefully you are all caught up on Part 1. If not, you can see that here. Part 2 is about Actual Execution Plans. I have the (slightly edited for garbled words) transcript below for those who prefer to read, with references to places in the video. Otherwise, watch the video and let me know what you think.

I'm very excited for this because I've wanted to put something together about this topic for a long time. What inspired me is that I've really come to appreciate that there's different pieces of information collected with the execution plan itself depending on where I get the plan from. Understanding what's collected, where, and why can help make a difference when trying to troubleshoot and performance tune.

Happy T-SQL Tuesday! It's hard to believe, but it's number #200! That's quite an accomplishment. Thanks to everyone who has kept this tradition alive by contributing to it in some way, shape, or form. Especially to Adam Machanic for starting this blog party and Steve Jones for making sure that we have a host each month. It's not an easy feat!

New Video Drop! Leaving the transcript here (with light editing to make things a little clearer in case I mumbled the words) for those who prefer to read. I have also added times in the video for those who want to jump to those parts and watch the demo.

A virtual MS Data Platform conference focusing on SQL Server internals.

Happy T-SQL Tuesday! Our host this month is Koen Verbeeck (see his T-SQL Tuesday invitation here) Koen asks an interesting question: So, dear reader, I want you to think about what would happen if suddenly your company or your client asks to build everything on-prem again (or maybe a hybrid architecture). My first reaction to this sentence was: Oh look, he assumes that everyone is in the cloud…

Hello, Data WIT! Happy June, everyone! This year keeps flying by. We had a great May meetup. Our speaker was Kendra Little, who had a great presentation called “The Anti-Hustle Guide to Technical Blog...

Photo by Alina Komarevska on Pexels.com This month had a couple of milestones that seem significant enough to talk here. There is a 6 year mark to highlight as well as an important 10 year mark to celebrate.

This link will take you to a page that’s not on LinkedIn

Thank you to everyone who participated in T-SQL Tuesday #198! When I wrote the invitation post, I intentionally kept the prompt broad because change detection looks different depending on your source system, your infrastructure, your data volumes, and what you need to do with the changes once you have them. The responses covered SQL Server

Note: Currently I am using this button so you the reader know the level of AI used in my articles. For more information – go here: What’s with the AI button? Data Wrangler has been avai…

It's another T-SQL Tuesday! This month, our host is Meagan Longoria (blog). She is inviting us to share a tip, technique or lesson learned about how we've handled detecting data changes in our tech of choice. This has definitely been something that is I've had some experience with recently. It inspired my "Change Tracking in SQL Server 2025: Exploring Change Event Streaming vs CDC…

I didn’t start blogging to build a personal brand. I started because I was tired of losing my scripts to solve the same SQL Server problems over and over again. Over the ye

Hello WIT! It’s hard to believe that 2026 is already a third over! This year is just flying by. We’ve got some plans in the works for sprucing things up over the next couple of months, so keep your ey...

It's time for T-SQL Tuesday #198! This month's topic is change detection.

Burnout is complex, and as it is unique to every person, it can be difficult to define and identify. Let me help you with that. Over the past few years burnout has become

Burnout is complex, and as it is unique to every person, it can be difficult to define and identify. Let me help you with that. Over the past few years burnout has become

Hello Data Platform WIT & Allies – Nothing inspires us more than being able to celebrate all of the women who inspire us. That’s why highlighting these women was so important to us over the past month...