Top 5 Most Common Problems With SQL Server
The Top 5 Most Common Problems With SQL Server

Over the years I've been able to compile a list of issues that I would consider to be common with SQL Server (and other database platforms like Oracle, no platform is immune to such issues). These are the issues that are often avoidable but not always easy to fix once...

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....

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...

SQL Server 2014 In-Memory OLTP Hekaton
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...

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...