Yesterday I showed you two ways to find out how changes to SQL Azure may impact your existing database. Today we shift gears a bit and go under the covers of your SQL Azure database to start looking at who is doing what to your database. For those of you used to administering an on-premise instance of … Read more
Yesterday we looked at how you can easily make a copy of a database in SQL Azure. You could even consider that copy to be a backup of your database. I know many DBAs that are reluctant to jump into SQL Azure because of the fact that there is no BACKUP command, and I was … Read more
Yesterday we looked at how much your indexes were costing you in SQL Azure. Today we shift focus a bit and I am going to show you something quick and easy for the weekend. We all know that you cannot take a backup of a SQL Azure database. For many DBAs I know this is … Read more
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
The past two days we talked about the billing aspects of SQL Azure and how to get an estimate of your charges. Today we will shift our focus a bit and talk about size. Since you pay for storage with SQL Azure it would be a good thing to know a bit more details about … Read more
