In my previous, meaning first post, I mentioned that today I would outline the resources we will use to walk down the SQL Server path. Taking the walk and learning more about SQL Server is our goal, but even to take a walk you have to do some planning. But how do you plan when you want to know everything that is knowable? What resources will we be using to guide us on this journey?
Who we chose as our guide is determined by my choice of destination. Our destination is really two-fold. First, to know everything that is knowable about SQL Server. Yeah, I know this isn’t really possible, but you understand my intent. The second goal is to pass the MCM exam. From what I have heard these two goals are one in the same. Taking the MCM exam is like having to know everything that is knowable. For this journey we need a guide. Who can serve as our guide through this process?
The www.sqlskills.com/MCM.asp and Microsoft MCM Path reading lists. These lists are incredible places just to peruse, when I have free time, because they provide some basic structure to preparing for the MCM exam. The reference links available through these reading lists are superb.
There is such a wealth on information available to help us take this stroll. Blogs, books, videos, conferences, twitters, SQL Server itself, etc. There are so many places to go to for information or even guidance. I can’t even come close to listing all the different resources that I have encountered over the last few weeks. How can you pick just a few when so many are worthy of recognition? Well, this list is a work in progress but you have to start somewhere. (Make sure you consistently check the Resource page for more links.)
lots more of these will be discovered as we travel along
- SQL Server 2008 Internals by Kalen Delany,et al (meaning other DBA greats)
- Excelptional DBA by Brad McGeHee
- SQL Server Maintenance Plans by Brad McGeHee
- Performance Tuning with SQL Dynamic Management Views by Louis Davidson and Tim Ford
- Smart Business Intelligence Solutions with Microsoft SQL Server 2008 by Lynn Langit, et al.
- DBA Best Practices by Brad McGeHee
- SQL Server 2008 Books on Line
- SQL Server MVP Deep Dives by Microsoft MVPs by the score
- Microsoft Self-Paced Training Kit for Database Administrator 2008
- Microsoft Self-Paced Training Kit for Database Developer 2008
- plenty more to come
- #sqlhelp Use this twitter link when you have a problem and need some SQL Server help.
- @sqlpass Want to find out what is happening at SQLPASS. This is the link to use.
- #sqlserver Where do you go for general guidance for SQL Server. This is the place.
- more later as we discover more fellow travelers
And one more item that is just to broad and important to fit in any one category.
http://www.sqlpass.org/ Professional Association for SQL Server. This is an incredible group of professional DBAs. The best of the best DBAs live here. You have been missing something very special is you haven’t attended the events offered by SQLPASS. 24 Hours of Pass, PASS SQL Rally, PASS Summit, Local Chapters, Virtual Chapters. There is nothing better to help gain an in-depth exposure to SQL Server than SQL Pass. The information and contacts you make will stand you in good stead in firefighting a crisis or avoiding it in the first place.
Not to shabby for a starter list. Can you imagine what this list will look like when we are through? This baby is gonna be one monster list.
Seems to me like we are ready for our journey. Tomorrow we take our first step. We begin for real!