Bad IT People
What happens when you have bad IT people working in your company? Steve Jones says that they always will be around, but we might not want to enable them to continue in this business when we find them.
Calculating Geometric Mean in Power BI
Learn how to add the geometric mean in Power BI to your calculations.
SQL Server Contained Availability Groups Configuration
In a previous tip on Orphaned User Detection for SQL Server High Availability Databases, we have seen how to identify when there are orphaned database users in an Availability Group database. Is there a way where we no longer need to worry about missing database users or different SID values between primary and secondary databases in an Availability Group?
Have you done a Mid year check in?
This Editorial is coming to you during an exciting birthday for the United States. If you are in the US, you are most likely celebrating the 4th of July. This is the 250th anniversary for the US, quite a milestone. I hope that all my US friends are celebrating safely and responsibly. While it is […]
From SQL Server On-Premises to Claude Desktop: How I built a Full MCP Pipeline
Learn how to get started with an MCP server that can query your SQL Server database.
SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About
Another fun article for America's Independence Day using SQL Server's spatial features.
How to stop AI hallucinations in enterprise RAG systems (a complete guide)
From the Air Canada chatbot lawsuit to the infamous Chevy dealership pricing fiasco, this article breaks down the six real reasons RAG systems fail in production – and the five architectural patterns high-performing AI teams use to make them trustworthy, grounded, and production-ready.
Cognitive Coverage
Understanding the scope of what AI and humans are changing in your code going to be an important part of your future as a tech professional.
How We Handled a Vendor Retry That Loaded Twice in Snowflake
The vendor file arrived twice overnight, Snowflake loaded both copies without complaining, and finance found the problem before the pipeline did.
Blogs
Red Flags in Your Query (T-SQL Tuesday #200)
By Zikato
When I'm looking at a query, I bet it's bad if I see... a...
T-SQL Tuesday #200: When I Look at a Query …
By Steve Jones
This month is a milestone for T-SQL Tuesday. It’s number 200, which doesn’t sound...
Reflections on the Life of a DBA
The DBA life is fraught with pain. Those battles that we endure are mostly...
Forums
cons for a dev machine in a different version of sql from our prod server
hi, im not a dba. For a couple of years our dev sql server...
ALAMAT KONTAK BCA KCP Sesetan Telp:08218154393
WA:08218154393 Jl. Raya Sesetan No.301, Sesetan, Denpasar Selatan, Kota Denpasar, Bali 80223
Inquiry – Enforcing ApplicationIntent=ReadOnly via GPO
Hello, I would like to ask whether it is technically possible to redirect a...
Question of the Day
TempDB Facts I
Can I set Accelerated Database Recovery on tempdb?
See possible answers