SQL

5 More Questions For Interviewing a Database Administrator

5 More Questions For Interviewing a Database Administrator

I’ve written before about interviewing a Database Administrator (DBA) and general hiring techniques. I’ve talked about how an interview should be a conversation, not a trivia contest.   I always describe the interview process as being a lot like being on a blind date. You shouldn’t be looking to stump someone during an interview. Memorization of obscure facts such(…)

Virtualizing SQL Server: 8 Things To Avoid

Virtualizing SQL Server: 8 Things To Avoid

Last year I wrote an article for SQL Server Pro Magazine on things to avoid when virtualizing SQL Server. I finally got around to putting the article into slide format and posted it to Slideshare. You’re welcome. The full link to the slides is here: http://www.slideshare.net/ThomasLaRock/virtualizing-sql-server-8-things-to-avoid If you find that you have been doing one(…)

HOW TO: ALTER TABLE in Windows Azure SQL Database Without Filling Up Your Transaction Log

HOW TO: ALTER TABLE in Windows Azure SQL Database Without Filling Up Your Transaction Log

One of the things I love most about Windows Azure SQL Database (WASD) is that you don’t have many options when it comes to performance tuning. WASD makes you focus on code and design in order to maximize performance. I would estimate that 98% of all performance issues are due to sub-optimal code and database design(…)

Why Windows Azure SQL Database May Be Right For You

Why Windows Azure SQL Database May Be Right For You

Grande. Bold. No room. It’s my standard order when at Starbucks. Despite there being thousands of ways to have my coffee prepared I prefer the simplest. It’s probably why I enjoy working with Windows Azure SQL Database (WASD) so much. The number of configuration options we have with WASD is limited. By limiting the options(…)

Load More