Yesterday we talked about the sysdatabases system table and today’s entry is about the sysservers system table. As with other system tables, this one has the same disclaimer that this system table will be removed from a future version of SQL Server. So, yeah, you have been warned. What is this table for? From the … Read more
Yesterday we talked about the sysusers system table, and today we are going to talk about the sysdatabases system table. This table is scoped at the instance level and in case you need a reminder this system table will be removed from a future version of SQL Server. What is this table for? This table … Read more
March Madness continues and today we are going to talk about the sysusers system table. Unlike yesterday’s system table (syslogins) which was an instance level table, the sysusers table exists inside of every database on your instance. Most new DBAs are unaware of the system tables, and even more unaware that some tables are scoped … Read more
As both readers of this blog know by now I used to be somewhat of a basketball player and coach. Today starts the NCAA Men’s basketball tournament, which is a tournament for many of the US colleges and universities. The tournament is a single elimination format for 64 teams, conducted in eight days, spread over … Read more
As both readers of this blog already know, I am at the Microsoft MVP Summit this week held at the mothership in Redmond. It has been a great two days so far and I am looking forward to another day of sessions full of good content. This morning I was in a session that was … Read more
Welcome to this week’s installment of SQL University. I am writing this while in transit to the 2011 MVP Summit. Thankfully (?) Delta could not get an airplane out of the hangar on time at MSP this morning, which led to my 3 hour layover in the Sky Club and several glasses of wine and … Read more
