SQL Saturday Baton Rouge 2025
SQL Saturday Baton Rouge is a great event hosted on LSU’s campus that has some of the best food, presenters, and attendees in the country! Had some incredible questions...
2025-07-26
53 reads
Responsible AI: Why Leaders Need More Than Just Guardrails
In the rush to adopt artificial intelligence, many organizations have quickly built ethical frameworks, compliance protocols, and technical safeguards. These “guardrails” are necessary, but not sufficient. Because AI isn’t...
2025-07-25
42 reads
TempDB Performance Tuning in SQL Server 2022 vs 2016 vs 2019
📘 What Is TempDB and Why It Matters TempDB is a shared system database in SQL Server used for: Because it’s used by every session and process, TempDB is often a performance bottleneck—especially...
2025-07-24
1,444 reads
Optimize Azure Fabric Pipelines with This Key Spark Setting
Boost Your Azure Fabric Pipelines: Don’t Overlook This Crucial Spark Setting Are your Azure Fabric pipelines with multiple notebooks running slower than you’d like? Are you paying for more...
2025-07-23
198 reads
Microsoft Fabric shortcut-based AI transformations
A new feature has just been released in Microsoft Fabric that I was so impressed with that I decided to blog about it. Available in public preview is the...
2025-07-23
7 reads
Microsoft Fabric shortcut‑based AI transformations
A new feature has just been released in Microsoft Fabric that I was so impressed with that I decided to blog about it. Available in public preview is the...
2025-07-23
28 reads
SQL Server Post-Install Configurations
The SQL Server installer has gotten better: tempdb configuration, MAXDOP, and even max memory can now be configured during setup. But don’t be fooled: there’s still a post-install checklist...
2025-07-23
72 reads
How Vastu Principles Can Inspire Smarter Database Administration: A Holistic Approach to Data Architecture
In the fast-paced world of IT, Database Administrators (DBAs) are the unsung heroes who ensure that data flows securely, efficiently, and reliably. But what if we viewed database environments not just...
2025-07-23
19 reads
9 questions to ask before adding generative AI to your data project
Will adding generative AI to your data project improve the outcomes? It might, but it’s not guaranteed. It can be harmful and costly to add generative AI in the...
2025-07-23
1,085 reads
Accelerating Database Modernization Through DevOps & Cloud Integration
In today’s enterprise landscape, agility and reliability go hand-in-hand. As organizations modernize legacy infrastructure and scale operations across borders, the challenge is no longer just about moving fast –...
2025-07-22
87 reads
Blogs
Programmatic Tool Calling with the Claude SDK
Programmatic Tool Calling with the Claude SDK Every morning somebody on the team runs the...
A New Word: Mauerbauertraurigkeit
By Steve Jones
mauerbauertraurigkeit – n. inexplicable urge to push people away, even close friends whose company...
Methodology for dealing with bad data in production
By Brian Kelley
Pinal Dave wrote up his methodology for what to do when you discover bad...
Forums
Why SQL Server Database Attach fails and how to repair it
Comments posted to this topic are about the item Why SQL Server Database Attach...
Fixing P1 Queries
Comments posted to this topic are about the item Fixing P1 Queries
Question of the Day
BIT_COUNT() IV
In SQL Server 2025, I run this code:
select bit_count('A')
What is returned? See possible answers