Error 2596 stops a DBCC repair because the database is read only. Here is the safe order: back up, single user, read write, repair and check again.
SQL SERVER – Stop SQL Server Immediately Using T-SQL
Need to stop SQL Server immediately? Run SHUTDOWN, or SHUTDOWN WITH NOWAIT to skip checkpoints. I also note which roles have permission to run it.
SQL SERVER – One Thing All DBA Must Know
The one thing all DBA must know is to backup database fully. I also answer reader questions on the best time for a backup and how often to take one.
Which Sample Database to Use for Which Demo
Which sample database fits your lesson? Compare AdventureWorks, WideWorldImporters, and Stack Overflow data before choosing a demo.
SQLAuthority News – Author Visit – Database Architecture and Implementation Discussion – New York, New Jersey
I am traveling to New York and New Jersey for a Database Architecture and Implementation discussion, so replies to comments and emails will wait two days.
Fast Bulk Inserts From Python
Bulk inserts from Python work best with parameterized executemany, measured batch sizes, a tested fast_executemany path, and clear restart rules.
SQL SERVER – Two Different Ways to Comment Code – Explanation and Example
SQL Server has two different ways to comment code. Let us learn all of them here in this blog post. Various the options in the blog posts.
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.