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.
The Milestone – Notes from the Field #100
The 100th episode of Notes from the Field is a true milestone. A thank you to the experts who shared real-world lessons with all of us.
SQL SERVER – Database Testing and Waitfor Delay – Notes from the Field #099
Kevin Hazzard shows how WAITFOR DELAY helps with database testing, like mocking procedures that simulate client data for ETL. Notes from the Field #099.