SQL Server
Kendal Van Dyke: Delegation: What It Is And How To Set It Up – The title says it all, folks.
wmarow’s disk & disk array calculator – Storage calculator. This wouldn't be terribly fascinating, except I know the performance characteristics of our I/O subsystem and when I plug in the variables, this is pretty close [...]
I was pretty excited to get home today, in part because I need to recharge the air conditioner in my car. Driving around in a mobile sauna isn’t anywhere near as much fun as you’d think it would be. For the record, I never thought it would be much fun in the first place. That [...]
SQL Server
Index-Index-Index-Index-GOOSE! (Part One) The always short, and occasionally humorous, Tim Ford dives into the statistics DMVs and returns with a good explanation of what they are and how to use them.
Suggested DBA Work Plan If you’re like me, you’re not a production DBA, yet. I’m an accidental DBA who became a development DBA who [...]
SQL Server
Set based random numbers George Mastros points out that generating a random number using RAND() in a set-based operation will always return the same value for every row in the result set. What’s a DBA to do? Luckily, George also covers a great way to get around this predicament.
Hardware for SQL Server 2008 Andrew [...]