MSSQL

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

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