I have a new tune stuck in my head now. It got stuck there this afternoon shortly after my computer was forced into a reboot. I was in the middle of writing a blog post, working on some stored procs and some general queries. All of the sudden my system is shutting down and I can do nothing to prevent it.
After SSMS closes, my browser closes, the command prompt that is running a chckdsk is forced closed, then the logoff window appears and I see that windows updates are being applied. SOME OF IT ITCHES!!!!! Why can’t Microsoft allow us some latitude when running these updates? I could understand it if the patches were scheduled to be installed and prompted a reboot – I got none of that. Do I need to have critical updates forcibly applied to my systems so frequently? And believe me this is occurring much more frequently than the mythological 2nd Tuesday of the month.
In the end I am happy that these updates did not toast my windows install like an update did a few weeks ago. But I seriously have seen enough of these updates over the past few months and something has got to change.
In my last post concerning my certification journey I said I may post a study guide. I have thought it over and a sweetened condensed version of some of the topics covered would prove helpful. Based on the Skills Measured page for the exam, one can determine topics to study and pretty much google for related materials.
So let’s start with the high level of skills measured.
Designing a SQL Server Instance and a Database Solution
Collecting Data in regards to upgrade prep or installation and base-lining.
Designing a Database Server Security Solution
Designing a Database Solution for High Availability
Physical Architecture (Replication)
Designing a Backup and Recovery Solution
I won’t cover this topic at all. This should be a high priority topic for all Database Professionals. This is one of those areas that is best covered through practice and experience.
Designing a Monitoring Strategy
Correlate Monitoring Data – One should be acquainted with this topic. I have heard it in interviews. Furthermore, it really makes you a better DB professional.
Designing a Strategy to Maintain and Manage Databases
Central Management Server
Policy Based Management
Designing a Strategy for Data Distribution
As I said, this is a condensed version of some of the topics that I studied. Since these topics map directly back to the measured skills published by Microsoft, they are topics well worth studying. Whether or not they will be on your exam or not, who knows. You should also note, that these links pretty much point back to broad-sweeping topics and are not specific in nature. The one exception being the extra monitoring link I threw in because I feel it is important to know regardless of ability or exam preparation.
Despite my desire to do one exam a week in pursuit of the MCITP Certifications for DBA and Developer in SQL 2008, other things came up that have slowed me down considerably. It was only today that I realized that it has been one month since the last exam that I took. No single event is at the root of this delay – there are multiple.
As you can presume based on the title, I passed another exam. The latest exam was 70-450. I have mixed feelings about this exam. I also wish I could elaborate extensively concerning these feelings, but will not be able to without violating the NDA. I will however, be able to discuss some of the concerns since I do not feel they pertain to the NDA.
First impression from the exam came within the first couple of questions. That impression was that this exam really has less to do with technical skill than I think it should. I felt that I was doing a lot of interpreting and extrapolating in order to derive a plausible answer. Much of this was due to the poor grammar and incomplete sentences demonstrated throughout the exam. Some of it was just due to assumptions one had to make concerning the scenario.
Second impression is that the exam cares less about the correct answer than trying to trip you up. In doing this, there is a correct answer for the exam and then there is the real world correct answer. I had heard this sentiment from others who had taken the exam and hadn’t given it a whole lot of thought until I was in the middle of my exam and I started to see a pattern. There were a couple of questions that had no correct answer based on the question.
There is also an opinion out there that this exam tests you on what was in BOL at the writing of the exam – despite much of that information being recognized as incorrect now. This leads me to my third impression. This exam is more about memorization and finding obscure entries in BOL that may or may not be correct.
All of that said, despite those obvious problems surrounding this second tier of exams for the SQL 2008 track – the exam is passable and really not too terribly difficult. I had expected it to be more in-depth. I would also say that it is due to these problems that there should be some sort of Certification between the MCITP and MCM. That notion was started some time ago – and I feel there is more validity to it now than there was one year ago.
All of that said, I hope to be finishing up with these exams next week when I take 70-451. Then I will someday move on to complete the BI exams. I may also post a short little study guide to cover some of the topics covered in 70-450.
This is a real quick update. It has been requested that we go ahead and provide LiveMeeting for tonight as well. Thus Charley will be presenting in person but the meeting will be available to all who want to attend.
Entry into this meeting is open to the public – join if you are interested. Here is the original info on tonights meeting.
Here is the information you will need to attend the LiveMeeting.
Attendee URL: https://www.livemeeting.com/cc/UserGroups/join?id=M5QTCQ&role=attend
Meeting ID: M5QTCQ
Entry Control: Attendees have free entry
Come join for a new perspective on OLAP from Charley.
This month we have an interesting topic for Meme Monday. This is hosted by Thomas LaRock and the topics revolve in some way around SQL Server. As Tom brought up, the saying is that “there are no stupid questions.” I have long disagreed with that statement. I think many people would disagree but it is a tool used by instructors to invoke questions from the crowd. I think there are plenty of stupid questions. For me, a stupid question is simply a question to which you already know the answer.
A common question that I hear that could fall into that category is “How do I select information out of table ZYX?”
For that question, pick your response du jour. Typically the response may be preceded with at least one question trying to garner more information such as “Well, what data do you want to select from the table?” If they can answer this question, then the first question seems a bit on the stupid side since they already know the essential pieces to the answer of their question. This holds true, so long as the data retrieval is a basic SELECT.
So there you have it, short and sweet.
It’s Grillin’ Time
OK, so we won’t be grilling inside the meeting – or even at the meeting. But it sure sounds good. There will likely be Pizza and drinks.
For any who are interested, The S3OLV meeting will be held this Thursday June 9 at 18h30 PDT.
This month Charley Jones will be test driving a new presentation. He has been working feverishly to learn about cubes and how to create them. He will be teaching us this month how to do this from the mind-set of an OLTP DBA in his presentation titled “OLTP Moving to OLAP.” I think this will be a great opportunity for those of us who are weak or strong in OLAP to learn a bit and see how this transition may make sense from an OLTP perspective.
Come join the fray at the Learning Center. At this point there will not be a LiveMeeting for this meeting unless I get enough feedback requesting it. It would be nice to know there is a continued interest in having these meetings be available virtually. And, thus that is really the only reason at this point. If there is continued interest, I will create a LiveMeeting and share the information for the Livemeeting.