Native procedures check every statement when you create them. Build a tiny one and see which habits it will not accept.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
SQL SERVER – Backup to Azure Blob using SQL Server 2014 Management Studio
SQL Server 2014 Management Studio has a new URL option on the backup screen. Here is how to use backup to URL to take a database backup to Azure Blob storage.
Finding Rows That Differ Between Two Tables With EXCEPT
Use EXCEPT to find differing rows in both directions, compare selected columns, handle NULLs, and distinguish changed keys from additions.
Unicode Lost: Finding Question Marks Left by varchar Conversion
Customer names turn into question marks, and an nvarchar column does not bring them back. Here is how it happens and how to repair it.
SQL SERVER – Fix Error – Package ‘Microsoft SQL Management Studio Package’ failed to load in SQL Server Management Studio
SSMS says Package ‘Microsoft SQL Management Studio Package’ failed to load? I list a few ways to fix it, from reinstalling .NET Framework to running as admin.
MySQL – Dynamic SQL with EXECUTE and PREPARE Statements
MySQL supports dynamic SQL with EXECUTE and PREPARE statements. Here is how to pass a table name as a parameter and return all rows from it.
SQL SERVER – Keeping MSDB System Database Lean and Fit – Notes from the Field #033
The MSDB database is one of the most ignored on any server. Tim shares his tricks to keep the MSDB system database lean, fit and at its best settings.
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.