The Scary DBA
Archives: June 2011
Presentations in Action
The first book I read for my 12 goal oriented books was Jerry Weissman’s Presentations in Action: 80 Memorable Presentation Lessons from the Masters.
Up front, let me say, this book met my expectations. I expected to see a lot of things I already knew. I expected to learn… Read more
1 comments, 111 reads
Posted in The Scary DBA on 27 June 2011
Make the Optimizer Work Harder
One of my favorite indicators for whether or not you have a good execution plan is when you see the “Reason for Early Termination” property in the TSQL operator like this:
The optimizer considered this particular plan “Good Enough.” which is what you want to see. When you see “Timeout”… Read more
2 comments, 604 reads
Posted in The Scary DBA on 20 June 2011
Rebind and Rewind in Execution Plans
Ever looked at an execution plan? If you answered no, you can’t possibly have ever tried to tune a query, or, you’re doing it wrong. For every one else, no doubt you’ve looked at the tool tips or the property sheets of an operator and you’ve seen the Rebind &… Read more
0 comments, 896 reads
Posted in The Scary DBA on 15 June 2011
Time for a Little PD
No, PD doesn’t stand for PowerShell Development. It stands for Professional Development. Sharks either swim or die (and yes, I know that’s not 100% accurate, but I need a hook on which to hang this lesson). Knowledge workers either develop more knowledge or become buggy whip manufacturers. It’s that simple.… Read more
1 comments, 242 reads
Posted in The Scary DBA on 13 June 2011
SQL Cruise Alaska 2011
Yes, I went on the SQL Cruise to Alaska. Yes, it was as grand as you’ve heard. Yes, I’m going to be putting up a series of blog posts about it. This is the first. It’s also part of my class work done during the cruise.
Three Reasons for Choosing…
0 comments, 108 reads
Posted in The Scary DBA on 8 June 2011



Subscribe to this blog