Vanishing objects; hello ORA-08103
In the previous post we saw that even though we had done an exchange partition mid-flights through a query execution, the query kept on running to successful completion. The...
2026-05-13
72 reads
Blog Posts
A very robust query
Some times I’m blown away by how the database will try very hard to save you from yourself :-). Consider the following example: I’ve got a table called T....
2026-05-12
48 reads
T-SQL Tuesday #198–Change Detection
This month we have a new host, Meagan Longoria, who graciously agreed to help me this month. I’ve known Meagan for a number of years and she’s been a...
2026-05-12
29 reads
Designing a Storage Load Test for SQL Server
I’ve been doing storage load tests for SQL Server for a long time, both as a consultant and now in my work at Everpure, and I see the same...
2026-05-11 (first published: 2026-04-27)
237 reads
Quick Tip: Check Most DTU Expensive Queries in Azure SQL Database
Optimizing Azure SQL Database performance often begins with identifying the most resource-intensive queries. Understanding which queries consume the most DTU (Database Transaction Unit) helps prioritize tuning efforts and improve...
2026-05-11
59 reads
Redgate and Rome
I’m at the UK Redgate office today, meeting with senior leaders in all areas of the business. I was honored to be awarded a spot in our President’s Club....
2026-05-11
26 reads
Upgrading SQL Server Containers on the Laptop
I don’t have SQL Server installed on my laptop. In an effort to keep things clean and smooth in case I need to rebuild things, I’ve gone with containers....
2026-05-11 (first published: 2026-04-29)
323 reads
A New Word: the Kinder Surprise
the kinder surprise – . the point in your early adolescence when you realize that your parents are muddling through their lives the same as you; that many respectable...
2026-05-08
43 reads
Get a Range of Sequence Values: #SQLNewBlogger
I discovered a procedure recently that I wasn’t aware of: sp_sequence_get_range. This post looks at how the proc works. Another post for me that is simple and hopefully serves...
2026-05-08 (first published: 2026-04-22)
250 reads
Overcoming Imposter Syndrome: A Plan
My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework (DTEF) foundation exam. I’m blogging about it because I know a lot of people struggle...
2026-05-08 (first published: 2026-05-01)
345 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
Alamat Kantor BCA KCU BOGOR Tlp:08217555651
WA CS 628217555651 Jl. Ir. H. Juanda No.28, RT.03/RW.02, Paledang, Kecamatan Bogor Tengah, Kota...
Alamat Kantor BCA KCU Sukabumi Tlp:08217555651
WA CS 628217555651 Jl. A. Yani No.33-35, Gunungparang, Kec. Cikole, Kota Sukabumi, Jawa Barat...
Alamat Kantor BCA KCU Karawang Tlp:08217555651
WA CS 628217555651 Jl. Interchange Karawang Barat, Purwadana, Karawang, 41361, Purwadana, Telukjambe Timur, Karawang,...
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