Featured

Upgrading to SQL Server 2014: A Dozen Things to Check

Upgrading to SQL Server 2014: A Dozen Things to Check

Here we go again! It seems that it was only yesterday we were talking about all the things you want to look out for when upgrading to SQL Server 2012. Now, just two years since SQL Server 2012 was released, we have a shiny new version with SQL Server 2014. And that means, of course,(…)

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

SQL Server 2014 In-Memory OLTP Hekaton Useful Links

SQL Server 2014 In-Memory OLTP Hekaton Useful Links

SQL Server 2014 is nearly here. When it ships it will come with an “In-Memory OLTP” feature. This feature is generally known by its codename: Hekaton. Why that code name? Well, hekaton is Greek for a hundred, and that was the targeted performance improvement that Microsoft set out to achieve when building this new technology.(…)

Upgrading To SQL 2012: Ten Things You Don’t Want To Miss

Upgrading To SQL 2012: Ten Things You Don’t Want To Miss

Many novice administrators make the common mistake of believing that the upgrade process for a database server is as easy as pressing a few buttons. While you can certainly click “Next, Next, Finish” and consider your task to be complete the truth is that the upgrade process is often considerably more complex. A proper upgrade(…)

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

Load More