I inspect Service Broker Queue Count through queue and internal-table catalogs. A customer requested a quick inventory.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
SQL SERVER – Enabling or Disabling Triggers with the Correct Scope
To disable all triggers correctly, I first identify the required scope. My original customer case concerned expensive table-trigger work.
Simple Interest in SQL Server: A Function That Keeps Cents
Simple interest in SQL Server is principal times rate times years divided by 100, and a T-SQL function returns it in one line. This post shows how an int return type drops the cents and what SCHEMABINDING changes. It measures the cost of a scalar function on 500,000 rows and ends with compound interest.
SQL SERVER – Difference Between Count and Count_Big
The difference between Count and COUNT_BIG includes result range and indexed-view requirements. Their row-counting rules are the same.
Logon Storms: Protecting SQL Server From Connection Floods
Diagnose SQL Server logon storms, control connection growth, test a limited logon trigger, and preserve administrator recovery access.
Searching the Error Log by Date and Text With xp_readerrorlog
Search the SQL Server error log by date and text, select archives, capture matching rows, and cycle logs without losing context.
Bitwise Puzzle – SQL in Sixty Seconds 160
Many did not believe in the real world and based on the request, I have made the recent video on the same topic of the bitwise puzzle.
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.