A secondary server sitting idle as a backup feels like a waste. In Notes from the Field #107, Kenneth Urena shows how to make it readable in Standard Edition.
SQL SERVER – Getting Started with Project Versions in the SSIS Catalog – Notes from the Field #106
Tim Mitchell shows a handy but overlooked feature: project versions in the SSIS catalog, which keep earlier deployments you can browse in SSMS.
SQL SERVER – Could Not Register Service Principal Name Persists – Notes from the Field #105
Seeing ‘Could not register the Service Principal Name’ in your SQL Server log at startup? In Notes from the Field #105, Ryan Adams explains why and what to do.
SQL SERVER – Availability Group and the Six Critical Steps for DBAs to Follow – Notes from the Field #104
Mike Lawell shares six critical steps every DBA should follow when asked to implement an AlwaysOn Availability Group. Notes from the Field #104.
SQL SERVER – T-SQL Window Function Framing and Performance – Notes from the Field #103
Kathi Kellenberger shows how window function framing and performance are linked, and why relying on the default frame can hurt. Notes from the Field #103.
SQL SERVER – What is T-SQL Window Function Framing? – Notes from the Field #102
Kathi Kellenberger explains T-SQL window function framing, added in SQL Server 2012, and how frames help with running totals. Notes from the Field #102.
SQL SERVER – What is the OVER Clause? – Notes from the Field #101
The OVER Clause arrived in SQL Server 2005, yet few know all its uses. In Notes from the Field #101, Kathi Kellenberger explains it with window functions.