Build SSMS code snippets with editable literals, register your own snippet folder, and use Template Explorer for repeatable SQL scripts.
SQL SERVER – What is Biml and How Can it Help Me with SQL Server BI? – Notes from the Field #036
What is Biml, and how can it help with SQL Server BI? Reeves Smith explains Business Intelligence Markup Language and how it adds automation to BI work.
Reading the Top Five Wait Types on Your Server
Top five wait types become useful when you filter background waits, measure changes over time, and connect them to active work.
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 – SSIS Component Error Outputs – Notes from the Field #034
Notes from the Field #034: Tim Mitchell explains SSIS component error outputs, how to use them in practice, and the caveats to watch for.
Finding Rows That Differ Between Two Tables With EXCEPT
Use EXCEPT to find differing rows in both directions, compare selected columns, handle NULLs, and distinguish changed keys from additions.
GDR or CU: Choosing Your Update Branch
Choose GDR or CU for SQL Server by understanding security and cumulative branches, checking the exact build, and testing a branch change.