Error 945 means the database cannot be opened due to inaccessible files or low disk space. My four checks: disk space, autogrow, permissions and read only files.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
MSSQL or MySQL? Clearing Up the Name Mix-Up
MSSQL or MySQL? The names are one letter apart and the products are not. Here’s who makes each, and the syntax differences that trip people up.
Why SQL Server Has Cumulative Updates, Not Service Packs
Understand why SQL Server uses Cumulative Updates instead of service packs, what each CU contains, and how to plan a reliable patch cycle.
Index Maintenance on Modern Storage
Index maintenance on modern storage needs query evidence, page density, and statistics checks before you choose a rebuild or lighter action.
SQLAuthority News – Birthday of SQL Authority Author
Today is the birthday of the SQL Authority Author, and my thought of the day is a simple one that I truly believe: family is everything.
SET_BIT: Return a Changed Value Without Updating Data
SET_BIT returns a value with one bit set or cleared. Compare the default one with explicit zero, and keep scalar calculation separate from updates.
SQL SERVER – Data Warehousing Interview Questions and Answers – Part 3
Data Warehousing Interview Questions and Answers Part 3 explains slowly changing dimensions: SCD1, SCD2, SCD3 and hybrid SCD, and what each one keeps.
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.