A Mess of Nested Transactions
Transactions are an area that I often find are used badly, or not used at all. Transactions without any error...
2015-11-03
841 reads
Gail Shaw
- Interests: Computer Graphics, Aikido, Roleplaying
Of clustered indexes and ordering
There is a particularly irritating and persistent belief that indexes (usually it’s the clustered that gets picked on) are always...
2015-10-26 (first published: 2015-10-20)
2,828 reads
Index selectivity and index scans
There was a question raised some time back ‘If an index is not selective, will the query operators that use...
2015-10-14 (first published: 2015-10-06)
4,395 reads
Repairing a replication subscriber
It’s a question which has come up a couple of times. If a subscriber of a transactional replication publication becomes...
2015-09-22
1,137 reads
Unusual errors with Distributed Replay
I’ve come to really like Distributed Replay in the last couple of years. I’ve used it to do a scale...
2015-09-08
1,169 reads
How not to do a Masters degree
There are many, many guides to successfully completing a post grad degree, so I am not going to add to...
2015-08-11
599 reads
Premature Optimisation
Learning how to tune a system is a bit of science and a bit of an art. Gail Shaw gives some guidelines on when you might want to tune and how to go about it so as not to unnecessarily undertake the effort.
2014-09-22
5,911 reads
On the importance of a complete break
If you’re the type who habitually checks work email and thinks about work while on holiday, here’s Gail Shaw's challenge for next time: don’t.
2014-09-01
181 reads
But, but, but, my data is clean!
Gail Shaw on the challenges of trying to extract meaningful data from a database containing customers who have the name 'Dummy **DO NOT USE**''.
2014-06-23
339 reads
How to Post Performance Problems
How do you get help? You can post a question on SQLServerCentral, but to get the most help you can, read this article from MVP Gail Shaw.
2014-01-17 (first published: 2009-06-12)
65,287 reads
Blogs
Think Twice Before Enabling Fabric’s Inbound Network Protection
Fabric inbound network protection involves two tenant-level controls: Private Link and Block Public Internet...
Match the Model to the Task, Not the App: An Orchestrator-Worker Pattern in Python
Most apps that call an LLM send every request to the same model. That...
Advice I Like: Responsibility
By Steve Jones
“The foundation of maturity: Just because it’s not your fault doesn’t mean it’s not...
Forums
ALAMAT KANTOR BCA KCP Pondok Bambu Telp:083831618008
WhatsApp:0838-3161-8008 Pondok Bambu Center, Jl. Pahlawan Revolusi No.30 Blk A/5-6, RT.2/RW.2, Wil, Kec. Duren...
Alamat Kontak Bank BCA KCP Sabang Telp:08218154392
WA CS (08218154392) Jl. H. Agus Salim No.57 B, RT.3/RW.1, Kb. Sirih, Kec. Menteng,...
AI Observability Challenges in FinOps as a DBA
Comments posted to this topic are about the item AI Observability Challenges in FinOps...
Question of the Day
Finding a Database Master Key
Where do I check for the existence of a Database Master Key (DMK) in SQL Server 2025?
See possible answers