An updated SQL Server Database Administrator Job Description: support for the database environment, new technology, reliability and long-term planning.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
SQL SERVER – Ideal TempDB FileGrowth Value
What is a good TempDB FileGrowth value? Here are simple size-based guidelines, from 10 MB growth for small files to 10 percent for large ones.
Bit Shifts: Move Bits Without Rotating Them
Bit shifts fill vacant positions with zero and discard bits past the type width. Compare tinyint with int and a negative shift direction.
Untested Backup: The Joke That Ends With a Resignation Letter
An untested backup is the darkest joke in the DBA world. Here’s how the story usually ends, and the simple restore drill that keeps you out of it.
SQL SERVER – Orphaned MS DTC Transaction Information
An orphaned MS DTC transaction kept crashing our IIS application pool. A quick script on sys.syslockinfo shows if you have one, and a Microsoft hotfix solved it.
SQL SERVER – Four Basic SQL Statements – SQL Operations
The four basic SQL statements are SELECT, UPDATE, INSERT and DELETE. A short note on what each one does, with a link to my one page FAQ sheet for full syntax.
SQL SERVER – SQL SERVER – Comparison : Similarity and Difference #TempTable vs @TempVariable – Part 2
Can a temp table have indexes? Yes. In Part 2 of #TempTable vs @TempVariable, I explain how temporary table indexes live in TempDB and when they help.
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.