Week 1 in Review
Missed it by that much! - For those that missed the memory/data cache
ratio correction, on day 1 Mike meant to say 30/70 instead of 20/80
Show me the data! - Want data to run Mikes queries again? Download Adventure
Works 2008 here: Adventure Works
Better than Oprah! - To get your free edition of SQL Script Pro from BlowFrog Software
, go to http://blowfrogsoftware.com and download the trial. After that
email mike at Mike.Hotek at blowfrogsoftware.com and he will issue a professional license.
Scripts! - click here for the scripts from Week 1
Week 2 in Review
Full Alert - on Wed, we talked about base alerts and how they are removed in SQL 2005/2008. If you want the linky goodness, then you can get the long version from Tibor - http://www.karaszi.com/SQLServer/util_agent_alerts.asp or the short version from my blog - http://datachomp.com/archives/sql-server-20052008-alert-pack/
Scripts! - click here for the scripts from Week 2 and 3
Week 3 in Review
Scripts! - click here for the scripts from Week 2 and 3
Save The Date! - Our final class of the year will be a B.I. Bootcamp! It will take place on the following dates: 8/2(Mon), 8/3 (Tues), 8/10 (Tues), 8/11 (Wed), 8/16 (Mon), 8/17 (Tues), and 8/18 (Wed). Registration will likely be open a couple weeks before the class starts and we hope to see you there. For priority notication, make sure you are signed up on the OKC SQL mailing list found at http://okcsql.org