The solution to my Puzzle of SET ANSI_NULL: why IN returns a row but NOT IN returns nothing when the list has a NULL, and how SET ANSI_NULLS ON explains it.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
SQL SERVER – How to INSERT data from Stored Procedure to Table – 2 Different Methods
How do you INSERT data from stored procedure results into a table? I show 2 methods: one when the table exists and one when it is created at run time.
Blog Launch Checklist: What to Set Up Before Your First Post
A blog launch checklist saves you from mistakes that are hard to fix later. This post walks through domain and HTTPS, a phone-friendly theme, the About page, search, categories, ways to follow, analytics, tested backups and the first three posts.
Snapshot Isolation Update Conflicts: Handling Error 3960
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.
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.