Set Theory vs. Batch Mode in SQL Server
Not long ago, a colleague of mine was completely shocked when he first heard about SQL Server’s Batch Mode feature. His immediate...
2025-10-15 (first published: 2025-09-23)
586 reads
A customer wanted a report they could email to their boss about jobs, something that showed failures. This isn’t hard to get in Redgate Monitor, though it is manual...
2025-10-06 (first published: 2025-09-22)
242 reads
In the world of modern data infrastructure, SQL databases remain the backbone of enterprise applications. They power everything from e-commerce platforms to financial systems, and their reliability is non-negotiable....
2025-09-22
73 reads
Do you know if your SQL Server is really running at its best? To help you answer that question, I’ve recently launched a free 30-minute SQL Server Health Check. In...
2025-09-21
19 reads
You can find the slides of my session on the €100 DWH in Azure on Github.
The post Retro Data 2025 – Slidedeck first appeared on Under the kover of...
2025-09-20
15 reads
This value is something that I still hear today: our best work is done in teams. On the facing page, there is a short description of what this means....
2025-10-10 (first published: 2025-09-19)
181 reads
Have you ever received the dreaded error from SQL Server that the TempDB log file is full? Only to open SSMS and be greeted with a message that prevents...
2025-10-13 (first published: 2025-09-18)
679 reads
Artificial intelligence is no longer a distant concept. It is here, embedded in the way we work, create, and make decisions. From generative assistants to predictive analytics, AI is...
2025-10-13 (first published: 2025-09-18)
367 reads
Every Scooby-Doo mystery starts with a haunted house, a strange villain, and a trail of clues. With SQL Server 2025 now reaching its first Release Candidate (RC0), it feels...
2025-10-10 (first published: 2025-09-17)
380 reads
Prompt AI released recently and I decided to try a few things with the tool that might help me in database work. I’ve had to do this task, but...
2025-09-17
104 reads
Every PostgreSQL migration eventually hits the same fork in the road. The database is...
By Steve Jones
I’m off on vacation today. Which is a little weird as I just got...
By Arun Sirpal
Every DBA has a box like this. Sitting untouched for months. Nobody’s proud of...
WA:08218154393 Jl. KH. Wahid Hasyim No.20, Jombang, Kec. Jombang, Kabupaten Jombang, Jawa Timur 61415
WA:08218154393 Jl. Kauman No.25, Magersari, Krian, Kec. Krian, Kabupaten Sidoarjo, Jawa Timur 61262
Comments posted to this topic are about the item Calculating Geometric Mean in Power...
Can I set Accelerated Database Recovery on tempdb?
See possible answers