Use a DBA on call checklist to establish impact, inspect blocking and disk space, review failed jobs, and choose a safe next step during incidents.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
SQLAuthority News – Meeting SQL Friends – SQLPASS 2011 Event Log
The best part of SQLPASS 2011 was meeting SQL friends I usually only talk to on Facebook and Twitter. Here are a few of our photos together.
SQLAuthority News – Story of Seattle – SQLPASS 2011 Event Log
My SQLPASS 2011 event log in photos from Seattle: the skyline, the convention center, the gum wall, the first Starbucks and people on the street.
SQL SERVER – Dedicated Access Control for SQL Server Express Edition – An error occurred while obtaining the dedicated administrator connection (DAC) port.
Connecting to SQL Server Express failed while obtaining the dedicated administrator connection (DAC) port. Here is why it happens and how to fix it.
Personal Notes – Random Thoughts and Random Ideas
There are days when I keep on wondering about SQL, and even my life overall. Let us see some random thoughts and random ideas.
SQL SERVER – DATEDIFF – Accuracy of Various Dateparts
Why does DATEDIFF say 1 minute between two times only 3 seconds apart? It is not a bug. Here is how DATEDIFF counts datepart boundaries.
SQL SERVER – TRACEWRITE – Wait Type – Wait Related to Buffer and Resolution
What does the TRACEWRITE wait type mean, and how do you resolve it? A DBA saw it as the top wait on his system, so here is a quick explanation.
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.