Posts by Derik Hammer

Query Tuning Without Production Data

No Comments
Target Audience: DBA or Database Developer who query tunes. Abstract: The DBA is constantly ringing your phone complaining about why you did not include an index to support your new stored procedure. They have full access to production and do not understand how hard it is to tune a query with an under-powered development machine…
Read More

Architecting Availability Groups

Target Audience: A DBA new to Availability Groups. Familiar with basic clustering and database mirroring concepts. Abstract: This session will cover the pros and cons of four typical configurations of AlwaysOn Availability Groups; stand-alone instances, fail-over cluster instances, multi-subnet, and a hybrid approach that I call disaster-recovery-on-the-cheap. It will also include their exclusive features such…
Read More