When should you use IDENT_CURRENT instead of SCOPE_IDENTITY()? A question I heard at the Group By conference, answered with the key difference.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
SQL SERVER – Backup to URL error: Operating system error 50(The request is not supported.)
Backing up a database to Azure gave me a backup to URL error: Operating system error 50, the request is not supported. Here is the cause and the fix.
SQL SERVER – Execution Failed. See the Maintenance Plan and SQL Server Agent Job History Logs for Details
My client ran a new Maintenance plan for full and log backups and it failed at once. The reason was two subplans in one plan. Here is how to run them.
SQL SERVER – AlwaysOn Availability Groups: Script to Sync Logins Between Replicas?
A script to sync logins between availability group replicas, keeping the SID so users do not orphan on failover. What to copy and what to check after.
Collapsing Repeated Spaces and Line Breaks With REGEXP_REPLACE
Tabs, line breaks and a sneaky character 160 can all hide in a name that looks fine. Here is how to clean them on purpose.
SQL SERVER – Msg 1105 – Could Not Allocate Space for Object Name in Database ‘DB’ Because the ‘PRIMARY’ Filegroup is Full
Msg 1105 says SQL Server could not allocate space for an object because the PRIMARY filegroup is full, even with free disk. Here is how to reproduce and fix it.
SQL SERVER – AlwaysOn Availability Group Backup fn_hadr_backup_is_preferred_replica Not Working Correctly
A client’s backups to the secondary never ran because fn_hadr_backup_is_preferred_replica returned 0 on every node. Here is what I found in its code.
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.