I came across an interesting scenario last week, someone needed to trace statements and they didn’t have SQL Profiler installed. Turns out they don’t actually need SQL Profiler in order to trace the statements hitting the instance. There is a trace flag (4032) that can be used to trace statements. When used with 3605, you … Read more
Don’t give up on Microsoft Connect. The process is not perfect but it can (and often does) work.
You never see the termites, you only see the damage they have done. And by then it is often too late. Same with corruption inside of your database. Often time most folks have no idea there is any issue until it is too late. Wouldn’t it be nice if there was a quick and easy … Read more
Every great DBA I know is both driven AND lazy. They are driven to be as efficient as possible, so they can do less work. It’s a wonderful pair of personality traits to have as a DBA. The unfortunate part is that the more driven they are, the more efficient and lazier they get, which … Read more
Ever try to troubleshoot something that doesn’t really exist? I think this virtualization thing is here to stay, I really do, but the trouble I see people having with virtualization is that they don’t know where the bottleneck truly lies. There are so many layers involved that most standard troubleshooting techniques fall short. Just think … Read more
Because the answers might surprise you. An interview should be a conversation, not a trivia contest. I’m not looking to stump someone during an interview. I don’t need for my DBA to know obscure facts such as database mirroring is only supported starting with SQL 2005 SP1. Memorizing such facts does not mean that you … Read more
