Mike Lawell shares six critical steps every DBA should follow when asked to implement an AlwaysOn Availability Group. Notes from the Field #104.
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.
SQL SERVER – Three Simple Guidelines for System Maintenance – Notes from the Field #098
Notes from the Field #098: three simple guidelines for system maintenance. Automate what you can, document the rest, and always validate.
Hey DBA – Do You Study Mistakes? – Notes from the Field #097
A scare with a chainsaw got Mike Walsh thinking. In Notes from the Field #097, he explains why DBAs should study their mistakes and learn from each one.
SQL SERVER – Are Power Options Slowing You Down? – Notes from the Field #095
John Sterrett explains how Windows power options, like the default balanced power plan, can slow SQL Server down. Notes from the Field #095.
SQL SERVER – Rewriting Database History – Notes from the Field #094
Kevin Hazzard tells the story of rewriting database history, a journey that starts and ends with ORM, in Notes from the Field #094.