Yesterday we looked at how you could determine the cost of a single row stored in SQL Azure. Part of my focus for doing so was to help you understand that a bad database design can lead to higher costs. Creating unnecessarily wide tables will result in more storage which then results in a higher cost. You … Read more
Yesterday we talked about how you could find the size of your database, and the size of objects inside of your database. Today we are going to go one level deeper and look at the sizes of rows inside of SQL Azure. We will be using systems views that have already been covered previously in … Read more
It’s Sunday evening. You are sitting down to have dinner with your family. Suddenly your phone rings. You want to ignore it because, let’s face it, your phone rings a lot. But you see the person calling and knowing they don’t call very often you decide to answer. On the other end of the line … Read more
I know three areas of SQL 2012 that have bright future, and learning these three will serve you well for years to come. I am at the MVP Summit this week and I am soaking up as much information about these three items as I possibly can. 2012 is a release year. That means it … Read more
I came across an interesting scenario last week, someone needed to trace statements and they didn’t have SQL Profiler installed. Turns out they don’t actually need SQL Profiler in order to trace the statements hitting the instance. There is a trace flag (4032) that can be used to trace statements. When used with 3605, you … Read more
Don’t give up on Microsoft Connect. The process is not perfect but it can (and often does) work.
