I recently asked on Twitter an exciting question about OR vs IN. While I got lots of good answers, there were an equal amount of wrong answers.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
SQL SERVER – The Comprehensive Guide to STATISTICS_NORECOMPUTE
One such feature that plays a pivotal role in managing your SQL Server databases’ performance is the STATISTICS_NORECOMPUTE option.
PS1 Cannot Be Loaded Because Running Scripts Is Disabled
PS1 cannot be loaded because PowerShell’s execution policy blocks scripts by default. You can set RemoteSigned, bypass the policy for one session, or choose Unrestricted as a last resort. Here is each option, and the scope to check.
Blocking Alert: A T-SQL Check for Sessions Blocked Too Long
Short blocking is normal. This check flags lock waits past a threshold and walks each chain to the session at the front of the line.
SQL SERVER – Understanding MAX_DURATION in Index Creation
One particular option that can be specified during the index creation is MAX_DURATION. This blog post will explore this option.
SQL SERVER – How to Move a Table into a Schema in T-SQL
If you’ve ever wondered how to move a table into a schema in T-SQL, this post is for you. One ALTER SCHEMA TRANSFER command does the job.
SQL SERVER – Fix – Error – The certificate chain was issued by an authority that is not trusted
ASP.NET Core applications can sometimes result in the error “The certificate chain was issued by an authority that is not trusted.”
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.