SQL Server 2016 Service Pack 1 introduced CREATE OR ALTER. I use it for repeatable deployments of supported object types.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
How to Use OR Condition in CASE WHEN Statement? – Interview Question of the Week #102
How do you use an OR condition in a CASE WHEN statement? A tricky interview question, and how to write it so the logic works.
Linked Servers and What Goes Wrong With Them
Investigate linked server performance and failures by checking remote work, provider settings, security mappings, and the alternatives available.
SQL SERVER – Unable to bring resource online – Error DoREPLSharedDataUpgrade : Failed to create working directory
SQL Server would not come online in the cluster: DoREPLSharedDataUpgrade, Failed to create working directory. The cluster log showed why. Here is the fix.
SQL SERVER – Discovery Report – How to Find Information About Installed Features?
No DBA needed: the Installed SQL Server Features Discovery Report in Installation Center lists every SQL Server feature and version on a machine in one place.
SQL SERVER – Performance Analysis of Backup to Azure
Compression saves backup space, but does it save time too? My Performance Analysis of backup to Azure compares timings with and without compression.
SQL SERVER – Error After Cluster Patching – Error: 5184, Severity: 16, State: 2
SQL Server would not come online after a service pack on a cluster. Here is how ERRORLOG helped me fix this error after cluster patching (error 5184).
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.