Yesterday we talked about one aspect of SQL Azure pricing but it was only tied to database usage. Today we will talk about the other piece of SQL Azure costs: pushing and pulling data to SQL Azure. The dirty details can be found inside the sys.bandwidth_usage system view: SELECT * FROM sys.bandwidth_usage Go ahead and … Read more
Yesterday we talked a bit about the sys.databases system view in SQL Azure. It contains some decent information about your SQL Azure databases but what it doesn’t tell you is the one thing many folks want to know about their SQL Azure databases; what is this costing me? What is this system view for? This … Read more
Yesterday we talked about the user information you can get from SQL Azure. Today we are going to focus on the details you can gather about the databases for your SQL Azure instance. You can run the following code to view details about the databases for your SQL Azure server instance: SELECT * FROM sys.databases What is … Read more
Yesterday we started this blog post series with a look at the sys.sql_logins system view in SQL Azure. Today we will look inside the user information found in the sys.sysusers table. Unlike the sys.sql_logins view which is found only in the master database, the sys.sysusers view is in each database. After connecting to your SQL Azure instance … Read more
It’s that time of year again folks and March Madness is upon us. Last year I did a blog series on the system tables found within SQL Server. This year I am leaving the earth-bound editions of SQL Server behind and will focus on SQL Azure. If you are new to SQL Azure then I … Read more
There is no question in my mind right now that the SQL Server 2012 book I am most looking forward to having on my bookshelf is the Professional SQL Server 2012 Internals and Troubleshooting by Christian Bolton (blog | @christianbolton) et al. I enjoyed Christians first book (Professional SQL Server 2008 Internals and Troubleshooting) as well, and … Read more
