Six ALTER statements look equally small, but their log cost is not. Here is how to measure each one before the change window.
The SQL Server Permission Hierarchy
Understand the SQL Server permission hierarchy from server to database, schema, and object, including GRANT, DENY, and role paths.
SQL SERVER – SSMS: Configuration Changes History
My friend Joe’s new job needed standard server settings. The SSMS Configuration Changes History report shows when settings changed. Here is how it helps.
SQL SERVER – Automate Database Operations for Success – Notes from the Field #035
It is not about how busy you are, but how valuable you are. Brian Kelley explains how to automate database operations and get more important work done.
SQL SERVER – SSMS: Server Dashboard Report
Like a car’s dashboard, the SSMS Server Dashboard Report shows the health of your SQL Server at a glance. Here is what this basic report tells you.
SQL SERVER – Introduction to SQL Server Management Studio Reports
Who dropped my table? Who is using my memory? SQL Server Management Studio Reports answer many such questions. Here is an introduction to them.
SQL SERVER – Find Blocking Using Blocked Process Threshold
My friend Jim came back with more blocking questions. Here is how the blocked process threshold option, a feature hidden in plain sight, helps find blocking.
Missing Index Query Text: Linking Suggestions to Their Queries
A missing index suggestion means more when you can see its query. Here is how to link them, trim the text and test the index.
MySQL – Add a Column at Particular Ordinal Position in Table
SQL Server needs the designer to add a column at a particular ordinal position, but MySQL does it with ALTER TABLE and AFTER. Here is a quick example.
SQL SERVER – Activity Monitor to Identify Blocking – Find Expensive Queries
My friend Jim needed an easy way to find blocking on a live system. Here is how to use Activity Monitor to identify blocking and find expensive queries.










