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 system view [...]
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 this system view [...]
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 you [...]
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 will [...]