SQL MVP

You’re Doing It Wrong – Database Standards

You’re Doing It Wrong – Database Standards

Having standards is important. If you don’t believe me, just ask your spouse or significant other. Knowing that such things are important I am willing to wager that your company has spent time putting together a set of standards to be followed with regards to application development, including database standards. I’m here today to tell(…)

The Top 5 SQL Server Features You Aren’t Using And Why

The Top 5 SQL Server Features You Aren’t Using And Why

I’m throwing my money away. I know I am, and yet I still do it. It’s not a lot of money though. See, I pay for a services bundle (phone, internet, cable television) from the one-and-only provider for my town and I’m certain that I am not using every possible feature. For example, I have(…)

Choosing The Cloud Solution Provider That’s Right For You

Choosing The Cloud Solution Provider That’s Right For You

It’s hard to talk architecture these days without a mention of the Cloud finding it’s way into the conversation. Everyone wants to know “is the Cloud right for me?” Unfortunately a lot of people have no idea what “cloud” truly means. Do some digging on what “cloud” means and you will find a lot of information. You(…)

HOW TO: Connect To A Windows Azure VM Using SQL Server Management Studio

HOW TO: Connect To A Windows Azure VM Using SQL Server Management Studio

In 2013, right before I was helping to deliver a precon seminar at TechEd on Windows Azure SQL Database, Microsoft made available the ability for customers to use virtual machines running in Windows Azure. This allowed for users to run on-premises version of SQL Server but have the instance hosted in the cloud. The natural(…)

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(…)

Load More