What is the performance difference between SELECT and SET? SELECT can assign many variables at once, but how each handles rows matters more.
SQL SERVER – How to Suppress SQL Server messages in Application Event Log
A brute force attack on sa flooded the Application Event Log with login failures and alerts. Here is how to suppress SQL Server messages from going there.
SQL SERVER – How to Change SQL Server Product Key or License Key?
How do you change the SQL Server product key or license key on an installed instance? Here is what I learned from senior DBAs who manage 1000s of servers.
MySQL – Different Methods to Know MySQL Version
Three simple ways to find your MySQL version with SQL: @@version, the version() function and SHOW VARIABLES, plus why the server version matters.
Say No at Work Without Burning Bridges When You’re Over-Committed
To say no at work without burning bridges, queue the request instead of refusing it. This post borrows a busy server’s habit of holding requests in line with a clear wait time. You’ll get a short reply format, ways to offer options and a limit for the queue.
SQL SERVER – How to take InMemory – OLTP FileGroup Offline?
Can you take an InMemory OLTP filegroup offline, and what happens to the table data? I test it step by step using the database from my earlier post.
SQL SERVER – Basics ColumnStore FAQ – Part II
Part II of my ColumnStore FAQ: what to check when a ColumnStore index causes a performance regression, starting with whether the optimizer used it.