How to write conditions with CASE statement in a computed column, using a simple AdventureWorks script you can adapt for any complicated logic.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
SQL SERVER – Identify Table Where Clustered Index is Not a Primary Key – DMV
Let us first see script which will return us tablename with schema where clustered index is not a primary key.
SQL SERVER – What is WRK file in Log Shipping?
Even if you have used log shipping for years, you may never have noticed the WRK file in log shipping. Here is what I learned about it.
What is Difference Between HAVING and WHERE – Interview Question of the Week #068
Clients sometimes interview me, and my answers from experience do not always match the textbook. Last week’s Interview Question: HAVING versus WHERE.
PowerShell Script – Backup Every Database In SQL Server
A client wanted to automate backups with a script instead of a GUI. Here is the PowerShell and SMO script I have used for years to backup every database.
The Tale of the Cunning Dev, Encrypted Procedures, DAC and God Mode = ON – Experts Opinion
My friend Syrovatchenko Sergey from Devart tells a detective story about a free tool, Encrypted Procedures, DAC and God Mode. A creative read you will enjoy.
SQL SERVER 2016 – Enhancements with AlwaysOn Availability Groups – Notes from the Field #121
In Notes from the Field #121, Mike Lawell covers the SQL Server 2016 enhancements to AlwaysOn Availability Groups and why this feature keeps getting better.
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.