Reproduce snapshot isolation update conflict error 3960, compare read committed snapshot, and retry the whole transaction safely.
Blog Ideas: What to Do When You Run Out of Things to Write
Every blogger hits the day when the list of blog ideas is empty. This post shows where new topics come from: your own questions, reader comments, mistakes you fixed and old posts that deserve a better answer, plus a simple way to keep an idea list.
Blogging Ethics: Credit, Copyright and Images
Blogging ethics comes down to saying where things came from. This post covers quoting versus copying, crediting and linking sources, the images you can use, including AI-generated ones, sponsor disclosure, public corrections and comments.
Writing an Interesting Blog Post People Finish Reading
Writing an interesting blog post is mostly a matter of habits. This post covers starting with the reader’s problem, keeping one idea per post, using a real example, writing a title that promises something and ending when the point is made.
Starting a Blog: Own the Domain From Day One
Starting a blog takes an afternoon, but where it lives is the hardest choice to undo. This post compares hosted platforms with self-hosted WordPress, explains why your own domain keeps your links and readers safe, and lists what to set up first and what to skip.
Blog vs Website: Which One Do You Actually Need?
The blog vs website question comes down to how much your words change. This post explains who needs which, how to combine them on one address, what a blog costs in time, and why original writing still matters when AI tools answer questions.
Sharing Query Results From SSMS: Copy With Headers, Grids and CSV
Share SSMS results with copy with headers, text and file output, deliberate CSV quoting, and command-line exports for larger sets.
SQL Server slow? Let's fix it together in about four hours.
In my Comprehensive Database Performance Health Check, you share your screen, I guide you, and we fix your biggest performance troublemakers. No passwords. No remote access.
You keep every script, and the know-how to fix it yourself next time.
Want your whole team to learn it?
My Practical Workshop has no PowerPoint, just live demos. My AI Enablement Workshop shows your team where AI saves hours, and where it quietly costs them.
Over 400 customers have worked with me this way, and not one shared a password. See all consulting options.
Who We Are
Pinal Dave is an SQL Server Performance Tuning Expert and independent consultant with over 24 years of hands-on experience. He holds a Masters of Science degree and numerous database certifications.
Pinal has authored 19 books and 125 Pluralsight courses. To freely share his knowledge and help others build their expertise, Pinal has also written more than 5,800 database tech articles on his blog at https://blog.sqlauthority.com.
Pinal is also a CrossFit Level 1 Trainer (CF-L1) and CrossFit Level 2 Trainer (CF-L2).
Nupur Dave is a social media enthusiast and an independent consultant. She primarily focuses on the database domain, helping clients build short and long-term multi-channel campaigns to drive leads for their sales pipeline.
Shaivi Pinalkumar Dave is a book author and a women’s artistic gymnast.

