One of the things I love most about Windows Azure SQL Database (WASD) is that you don’t have many options when it comes to performance tuning. WASD makes you focus on code and design in order to maximize performance. I would estimate that 98% of all performance issues are due to sub-optimal code and database design … Read more
One of the things I enjoy about working for Confio Software is that we are encouraged to find ways to give back to our communities. Two years ago I did our very first charity product demo, where we donated $5 to Community Food Share for every person that attended. We raised over $1,000 dollars that … Read more
Seriously? You did what now? OK, I’m sure it’s all shiny and new and takes up less space in your data center. That sounds wonderful, truly. But did you try anything else before agreeing to spend money like a sailor on shore leave? I’m here today to help you understand your performance tuning options before … Read more
I met a man once who told me how he wanted to be a butcher but his hands weren’t steady enough. So, he decided to become a dentist instead. The man, of course, was my dentist. And he said those words as he started up his drill. Good times. I often think about that dentist … Read more
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 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
