You Need Three Heads To Read This Post Properly

CXPACKET waits - You Need Three Heads To Read This Post Properly

I have a handful of things to share today. As a DBA it is my nature to be both driven and lazy so instead of three posts I am just going to combine them into one. You’re welcome. Here’s the first item for you: Recently Grant Fritchey (blog | @gfritchey) wrote an article titled “Be Cautious Offering Guidance”. The point … Read more

SQL Server 2014 In-Memory OLTP Hekaton Useful Links

SQL Server 2014 In-Memory OLTP Hekaton

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. … Read more

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 … Read more

Junior DBA Interview Questions – Updated

DBA interview questions

Four years ago I wrote a post titled Junior DBA Interview Questions. During that time the role of a traditional DBA has shifted. As a result of this shift I decided it was time to update my list of questions for a junior DBA. I’ve written earlier posts regarding how to do a job search as well … Read more