A Microsoft deck on security for web applications and infrastructure from the Windows Live team, plus simple database checks you can use today.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
SQLAuthority News – SQL SERVER Database Administrator Job Description
An updated SQL Server Database Administrator Job Description: support for the database environment, new technology, reliability and long-term planning.
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.
SQL SERVER – Find Table in Every Database of SQL Server – Part 3
Part 3 of Find Table in Every Database: Greg Steinkuhler shares a stored procedure that also searches servers across the network, where sp_msforeachdb could not.
SQL SERVER – SQL Joke, SQL Humor, SQL Laugh – Silly Mistake
A developer lost a backup, and the forum replies turned into dark SQL humor: write a resignation letter, or make vendors block DELETE without a WHERE clause.
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 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.