The Asynchronous Ledger Trick for Lightning-Fast SQL Server OLTP
Are you facing slow database performance and frequent lock chains caused by the high concurrency of DML statements on a central table in...
top of page
Eitan Blumin
- Apr 23, 2023
- 2 min
Should your DB and App projects be in the same Source Control Repository?
As someone who works with databases and often collaborates with software development teams, I've noticed a rise in the popularity of...
Eitan Blumin
- Apr 3, 2023
- 2 min
Resolved: Database Stuck in Single-User Mode
Today we had an interesting use case where a customer reported that one of the databases they just restored from a backup got stuck in...
Guy Glantser
- Mar 16, 2023
- 1 min
My Session in SQLBits 2023
Today I had the honor to present my session in SQLBits 2023. I promised to make all the session materials available for download...
Eitan Blumin
- Mar 14, 2023
- 6 min
The Pitfalls of Using System-Named Constraints in SQL Server
This article was published by Aaron Bertrand a few years ago, talking about system-named constraints in SQL Server. The article mostly...
bottom of page