Press F7, select a group of tables and script them in one go. Then check the grid’s row counts with two short queries.
SQL SERVER – SSMS: Schema Change History Report
Who created, dropped or altered a database or object? Young DBAs in Delhi gave me many answers, but the SSMS Schema Change History report answers it quickly.
Metadata-Only Column Changes: Which ALTER COLUMN Is Instant
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.