I am taking a bit of a right turn with this post and subsequent ones for this series. I am heading into the msdb database from here on out. I am doing this for two reasons: because there is less than a week left in the series and because these tables inside of the msdb [...]
March Madness – SQL Server System Tables – syscomments
I first learned about this table right as I was learning about being a DBA. No, not because this is a table that a new DBA would ever be thinking about. I learned about this table because we were migrating some databases from Sybase to SQL 2000 and we needed to scrub the stored procedures [...]
March Madness – SQL Server System Tables – sysdepends
Whenever someone asks a seasoned DBA a question their answer is almost always “it depends”. Today we are going to talk about sysdepends, one of the system tables which may or may not have the data you want. And why would that be true? Well, because “it depends” on how you deploy your code!
Before we [...]
SQL University – Cloud Week
Welcome back to another week of SQL University. This week we are going to spend some time getting familiar with SQL Azure, which is really just a fancy term for ‘distributed computing’. And while you may not have a need for such a thing today you should spend time getting familiar with SQL azure because [...]