Writing three books in 2011 grew from years of answering questions and writing every day. This personal account looks back at emails, research, blogging and workbooks at home.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
SQL SERVER – Year End Brain Teaser – Disabled Login and Associated User Without Disabled User Red Arrow
My year end brain teaser in two parts: find the hidden tiger in a picture, and explain why a disabled login’s user shows no red arrow.
SQL SERVER – Effect of Compressed Backup Setting at Server Level on Database Backup
A reader’s database backup got much smaller with no code change. The reason was the compressed backup setting at the server level. Here is the story.
SQL SERVER – Target Recovery Time of a Database – Advance Option in SQL Server 2012
Target Recovery Time is a new database option in SQL Server 2012. Set it above 0 and SQL Server uses indirect checkpoints to limit recovery time.
SQL SERVER – Fix: Error: 15138 – The database principal owns a schema in the database, and cannot be dropped
Error 15138: the database principal owns a schema in the database and cannot be dropped. Move the schema to another user first, then drop the user.
Counting Users, Roles and Orphans in Every Database
Audit counting users across databases, include roles and schema ownership, and distinguish orphaned SQL users from contained identities.
SQL SERVER – A Simple Puzzle and Simple Solution of Datatype and Computed Column
An interview riddle: create two columns but give a datatype only once, and copy data without UPDATE. A computed column solves it simply.
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.