T-SQL Tuesday 184 - Mentorship
T-SQL Tuesday is a monthly blog party hosted by a different community member each month. This month, Deborah Melkin
(blog) asks us to talk about our relationship with mentoring and...
2025-03-11
25 reads
March 2025 SQL Challenge: Test Your Skills with Advanced SQL Scenarios
If you’re an experienced SQL user eager to sharpen your expertise with real-world challenges, the March SQL Practice is the perfect opportunity. This month’s challenge is designed for advanced...
2025-03-11
6,581 reads
SQL Saturday Atlanta BI Recap
https://sqlsaturday.com/2025-03-08-sqlsaturday1102/#schedule SQL Saturday Atlanta BI is one of my favorite SQL Saturdays of the year. This year was especially sweet to see a lot of the SML (Saturday Morning...
2025-03-10
33 reads
Answering Questions On Dropped Columns
Howdy folks! Long time no write.
In this post, I will be answering a couple of questions from the previous posts about dropping columns.
A quick refresh
If you haven’t read the...
2025-03-10
10 reads
Mistakes IT Shops Without a DBA Make
We get it. There’s no budget for a DBA on staff, or even a contract support firm like Dallas DBAs. You are not alone! There are thousands of firms...
2025-03-19 (first published: 2025-03-07)
612 reads
A New Word: Waldosia
waldosia– n. a condition in which you keep scanning faces in a crowd looking for a specific person who would have no reason to be there, as if your...
2025-03-07
33 reads
Deploy at Low Priority
Learn how to deploy schema changes in an always-online SQL Server environment without a maintenance window. This utility reduces blocking and improves deployment success.
The problem
I attempted to deploy a...
2025-03-19 (first published: 2025-03-07)
212 reads
A Couple Quick GENERATE_SERIES Tests
I had someone reach out about generate_series() recently, saying they hadn’t realized this was a new feature in SQL Server 2022. They were wondering if it was better than...
2025-03-17 (first published: 2025-03-05)
382 reads
How I passed the DP-700 Exam
I recently took and passed the DP-700 exam, which is required for the Microsoft Certified: Fabric Data Engineer Associate certification. It’s the second Fabric certification, and it focuses more...
2025-03-17 (first published: 2025-03-05)
1,067 reads
Which approach to take: Build it, buy it, cloud it?
As a Consultant, I would typically answer with – it depends! Then a typical conversation starts with an expression of personal preferences based on experience, the organization’s history, and...
2025-03-14 (first published: 2025-03-05)
304 reads
Blogs
Take Time to Gain Perspective
By Brian Kelley
Probably the best piece of advice I ever received is to take time to...
The Fringe Festival
By Steve Jones
I was lucky enough to take a vacation a decade ago in Edinburgh with...
Demo for Parameter Sniffing and Memory Grant Feedback
Disclaimer: The following is built with Claude Code. Just need to justify my $100/mo...
Forums
Learn From History
Comments posted to this topic are about the item Learn From History
The SQL Server MCP Server
Comments posted to this topic are about the item The SQL Server MCP Server
The Hidden Danger of Wildcard Operators In Join Operations
Comments posted to this topic are about the item The Hidden Danger of Wildcard...
Question of the Day
The SQL Server MCP Server
How do I get an MCP server for my SQL Server 2025 database from Microsoft?
See possible answers