Service Broker supports transactional asynchronous messaging within SQL Server. I separate queued work from the application that processes it.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
Organising Notes You Have Already Written
Learn to organise notes around problems, useful search terms, and review dates so earlier SQL Server work becomes easy to find and trust.
Checking Which Accounts the SQL Server Services Run As
Inventory SQL Server services and their accounts, compare virtual and managed identities, and verify permissions after a change.
SQL SERVER – Readers Contribution to Site – Simple Example of Cursor
A reader wanted to join values from several rows into one record. Imran Mohammed answered with a simple example of cursor code in SQL Server 2005.
SQL SERVER – Deferred Name Resolution
Why can a stored procedure with a wrong table name be created, but not one with a wrong column name? Deferred Name Resolution explains it.
SQL SERVER – 2008 – Introduction to SPARSE Columns – Part 2
Part 2 on SPARSE Columns in SQL Server 2008: how they are stored as one XML column, plus the main advantages and the limits you should know about.
SQL SERVER – SP_CONFIGURE – Displays or Changes Global Configuration Settings
The global configuration list shows configured and effective SQL Server settings. I compare both before deciding that a change has taken effect.
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.