SQLServerPedia Wiki

The Santa Cruz Experiment: Why You Should Care About Big Data

[This was first posted to Technorati on February 6th, 2012. You can read the original here.] I keep hearing the term “Big Data”. My old-school IT instincts always makes me think of inefficiently storing two-letter state abbreviation codes inside of an nvarchar(50) field because that’s the default data type you get when creating a database table from [...]

Meme Monday for February

Next Monday is the first Monday of the month, which means it is time for your writing assignments.
The topic this time around will be: working with deadlines.
Think about any tips or tricks you have with regards to working with (or around) deadlines. Your stories and experience with getting stuff done with only minutes to spare [...]

The Oddest Job Interview Questions for 2011

Since I wrote just last week about interview questions for a DBA, I came across this article and wanted to share it here also. I don’t believe that an interview should be a trivia contest. These questions aren’t about knowing a trivial piece of information. They are (probably) designed to illicit a response that helps [...]

The 5 DBA Interview Questions You Have to Ask

The 5 DBA Interview Questions You Have to Ask

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 will handle [...]