Orders commit and the message vanishes? Save both in one transaction, then let a worker claim, send and retry with a lease. Duplicates are still possible.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
Storing Images in varbinary(max): Size, Reads and Backups
Store images in varbinary(max), read file bytes with OPENROWSET, inspect LOB allocation, and evaluate backup and retrieval costs.
SQL SERVER – Listing Primary Key of Table with Stored Procedure sp_pkeys
Here is how to list the primary key of a table with the stored procedure sp_pkeys, a follow up to my earlier post on sp_fkeys.
SQL SERVER – Listing Foreign Key Relationships of Table with Stored Procedure sp_fkeys
A quick trick to list all the foreign key relationships of a table with the stored procedure sp_fkeys, with a sample script on AdventureWorks2012.
Learning SQL Wait Stats: The Complete Series Guide
Learning SQL Wait Stats is the fastest way I know to find out why a SQL Server is slow. This guide lists every post in my wait stats series, told as one story about an all-night diner, and answers the questions readers ask before they start.
SQL SERVER – Dude, Where is the SQL Agent Job History? – Notes from the Field #017
A job failed but you cannot find the SQL Agent Job History? John Sterrett explains this common problem he sees in the field and what to do about it.
SQL SERVER – Find Anything in Object Explorer in SSMS
It is easy to find anything in Object Explorer, but how do you find every object where a string exists? Here is my chat with Vinod Kumar about it.
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.