So I started a new job today. I'm very excited about it and look forward to the many challenges ahead of us. As I will be creating new procedures to troubleshoot and track the servers I will be managing I will be posting that information up here.
One useful tidbit that I always seem to lose track of is the exact Version of SQL I'm dealing with. Sure I know 8.0 is 2000 and 9.0 is 2o05 but what is 8.00.2039? Some out there will say that's SP4 and they would be right but they have also learned to remember this. Since I can't seem to remember anything perfectly I figured I would once again find the KB Article on it.
http://support.microsoft.com/kb/321185
This article will tell you what version of SQL your using instead of just the number. Very helpful if you can't always remember which Version your dealing with.
About Me
- Pat Wright
- I started in the DB world back in 1999 with Sybase Sql Anywhere 5.5. Like Many DBA’s there was no one else to work on it so I volunteered. We soon migrated that into MS Sql server 7.0 then worked our way up to Sql 2000. I learned a lot about the internals and workings of Sql server 2000 I had moved to a high transaction environment and was learning much more. I then started to work on reporting and DW projects. I started to learn to use DTS and SSIS. Today my primary focus is on DW and SSIS and most of my blogs will be centered around that. I am very Active in my community. The web is probably where I do the least activity I hope to change that with blogging more. I’ve been a SQL MVP for 2 years in 2006 and 2007. I hope to one day join that excellent group of people again.
User group sites around me
0 comments:
Post a Comment