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 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
This past Monday I listed out the five trends that data professionals need to be aware of and how it will impact their careers. I’m here to tell you something else: Dont just love your data, that isn’t enough. You need to make love to your data using tools like PowerPivot. Yesterday Rob Collie (blog | @powerpivotpro) provided a … 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
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
