Better Trigger Design: #SQLNewBlogger
I had someone ask me about using triggers to detect changes in their tables. This is the third post in the series. The first one Another post for me...
2025-06-18
31 reads
Blog Posts
Comparing Microsoft Fabric Alternatives in AWS, GCP, and OCI in 2025
Microsoft's unified analytics platform, Fabric, simplifies integration across various tools in Azure by offering seamless authentication and a comprehensive set of features. Although alternatives exist in AWS, GCP, and...
2025-06-18 (first published: 2025-06-05)
742 reads
How To Test SQL Server Disk IO Throughput
When managing large databases or high-transactional databases, the performance of your underlying storage system is crucial, whether it...
2025-06-18
5 reads
SQL Server error 18456
Working with thousands of instances of Microsoft SQL Server, I often encounter users having issues. A common error is 18456 which indicates a login failure.
The post SQL Server error...
2025-06-18
109 reads
SQL Server in the Cloud – Are DBAs Still Needed?
Things your cloud vendor may not tell you Here’s a common theme I hear from small IT teams: “Our SQL Server is in the cloud now. We don’t...
2025-06-18
38 reads
Are Your Disks Lagging?
Recently, one of my clients was experiencing performance issues with their SQL Server. Although the server was not underpowered from a...
2025-06-17
2 reads
AZ-900: Microsoft Azure Fundamentals – The Ultimate Beginner’s Guide to Cloud Mastery
In an era where cloud computing drives innovation, understanding its fundamentals is no longer optional—it’s essential. The AZ-900: Microsoft Azure Fundamentals certification is the perfect starting point for anyone...
2025-06-17
29 reads
Becoming a Presenter: My Journey and Tips
I still remember my very first presentation many years ago. Someone in my team asked me to demo a project I’d been working on, and I was absolutely terrified....
2025-06-17
14 reads
Getting Started with Vector Search in SQL Server 2025 Using Ollama
Ollama SQL FastStart streamlines the deployment of SQL Server 2025 with integrated AI capabilities through a comprehensive Docker-based solution. This project delivers a production-ready environment combining SQL Server 2025,...
2025-06-16 (first published: 2025-05-19)
815 reads
Invoking Another Pipeline in Microsoft Fabric
At the moment there are two activities in Fabric pipelines that allow you to execute a “child” pipeline. They are both named “Invoke Pipeline” but are differentiated by the...
2025-06-16 (first published: 2025-06-04)
759 reads
Blogs
Rethinking Index Maintenance: Why avg_fragmentation_in_percent Is Outdated and What You Should Do Instead
By Tim Radney
As a SQL Server DBA with years of experience tuning production environments, I’ve seen...
Microsoft Build 2026 announcements
By James Serra
Once again there were a number of Microsoft Build announcements related to data and...
T-SQL Tuesday #199: Roundup
A good week ago I hosted the monthly T-SQL Tuesday blog party. I invited...
Forums
Changes, Happiness, and a Few Tears
Comments posted to this topic are about the item Changes, Happiness, and a Few...
BCP on Linux
Comments posted to this topic are about the item BCP on Linux
You Probably Don't Need a Vector Database
Comments posted to this topic are about the item You Probably Don't Need a...
Question of the Day
BCP on Linux
When running bcp on Linux, what is the field terminator?
See possible answers