We talked about stuff!   Stuff like this!

• 86 groupies
• Preshow video: Eye of the Tiger (thanks @nodns!)
• Alan Hirt’s whitepaper is up! Applying Updates to a Clustered Instance of SQL Server 2008 or SQL Server 2008 R2 
• Best out of context tweet
• NERDIST INTERVIEW WITH STNG PR0N PERSON
• Diet we’re on: Four Hour Body by Tim Ferriss, http://www.fourhourbody.com/ 
• Twitter update:
  • SQLSoldier: Seen on the SSC forum: “Is this a joke??? I am a little bit socially challenged and I don’t always correctly identify humor.” #AwesomeSauce
  • SQLSarg -> SQLPoolBoy
  • Buck: Free Comic Book Day – http://bit.ly/l3C1aP  (I’m such a nerd)
  • SQLSoldier: #HowToMakeADBACry “They’re going to talk about your resume on #DBAsAtMidnight . You should tune in.”
• Freddie sneezed
• Sean told a story about a man and a mainframe…
• Stealer! http://sqlserver-training.com/ (He’s taken down the aggregated content)
• Itzik Bengali, visit #2!
• Generic update time:
• I got interviewed by SQLPASS
• Interview…DICK
• Midnight Reading Rainbow: Paul Randal’s Top ten mistakes to make when attending a class
• Rant! “Because you’ve never heard of it doesn’t mean it’s untested.”
• Tech! Server Side Traces. See http://sqlserverpedia.com/wiki/The_Server-side_Trace:_What,_Why,_and_How (I need to update option to NOT be 6)

— Set the trace status to start

exec sp_trace_setstatus @TraceID, 1

— exec sp_trace_setstatus 2, 0       — stop trace 2

— exec sp_trace_setstatus 2, 2       — kill trace 2

— select * from fn_trace_getinfo (NULL) — check to see what traces are running

• Tech – big boxes. Reference Sean’s article Troubleshoot a Slow Database in SQL Server 2008  
• Blablabla
• Wrapup:
  • “A script is worth a thousand GUI clicks.” #PowerShell makovec
  • SQLRally this week – Code Sins, lightning talk, WIT luncheon, after hours
  • Groupies website
  • MidnightDBA.com for tutorials, and links to Sean’s and my blogs
  • ITBookworm.com – “new” review!
• Our cheesecake recipe FOR GROUPIES ONLY!

Preview: