My 1200th post, on the last day of 2009, looks back at a wonderful year and lists my top 7 community and personal events in the order they happened.
SQLAuthority News – Meeting SQL Expert Imran at Hyderabad
I finally met SQL expert Imran Mohammed, one of the top helpers on this blog, over dinner in Hyderabad. He was much younger than I expected.
Reading the Error Log With T-SQL
Reading the error log with T-SQL helps you search current and archived SQL Server messages, then set a useful log cycle schedule.
Following a Blocking Chain to the Head Blocker
Follow SQL Server blocking_session_id through a blocking chain, identify the head blocker, and choose a safe ending for the wait.
SQL Server for Oracle DBAs: The Vocabulary
SQL Server for Oracle DBAs translates instance, database, schema, tablespace, undo, and redo without pretending the two architectures are identical.
SQLAuthority News – Notes of Excellent Experience at SQL PASS 2009 Summit, Seattle
My notes from SQL PASS 2009 Summit in Seattle: why I went, from networking to putting faces to names, and links to my posts from all four days.
Storage Settings That Matter for SQL Server
Storage settings That Matter for SQL Server include latency, file placement, allocation unit size, and file growth; learn what to verify.