SQL Server cluster Installation Fails with ‘A constraint violation occurred’ as the network name won’t come online. I’ve fixed it for 10 clients.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
SQL SERVER – Creating a Copy of Database in Azure SQL DB
A client wanted to tune a slow query on a copy, not on production. Here is how to create a copy of a database in Azure SQL DB and work on it safely.
Upsert Patterns in SQL Server Without Race Conditions
Compare upsert patterns under concurrent calls, protect missing-key ranges, test MERGE with HOLDLOCK, and keep unique keys as a guard.
Install the WideWorldImporters Sample Database
To install the WideWorldImporters sample database, restore its backup file in SSMS and check the files and the row counts. This post explains the Full and Standard versions, the disk space you need, the permission trap, and three queries that prove the install worked.
Deleting Millions of Rows in Batches Without Filling the Log
Plan deleting millions of rows with bounded commits, an indexed cutoff, log reuse checks, and a clear choice of retention method.
Install SSMS: Setup and First Connection
To install SSMS, download the installer, run it, and connect to your server. This post explains why SSMS is separate from the SQL Server engine, how to fill in the first connection, what to do about the certificate error, and how to check the connection with one query.
Does Dropping Clustered Index Drop Primary Key on the Same Column? – Interview Question of the Week #083
Does dropping clustered index also drop the primary key on the same column? Here is the short answer, a follow-up to last week’s question on the reverse case.
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.