This morning I took the Microsoft exam “TS: Microsoft SQL Server 2008, Database Development 70-433”. I was quite chuffed after I hit the ‘Finish’ button and it said I’d passed!

One thing different about today’s exam was that I chose to do it at Rockfort International Pty Ltd. An impressive name, but it turns out they appear to be a 2-man outfit in a quite tiny office. I wasn’t even sure I was in the right place until the guy turned up and confirmed that yes they did do exams! Having said all that, once I sat down at the exam PC it was pretty good – quiet, comfortable and the PC had a reasonable screen. I’ve done most of my other exams at Excom, and last time I was there they still had a crumby old CRT monitor (running at a really low refresh rate) and that room had pretty noisy air conditioning. So even though the office may not be quite as swish, I’d rate the actual examination environment higher.

Over the weekend I was doing some study toward the exam and came across the following things that were new to me. Some of them may be obvious to others, but they’re not things I’ve used before or been aware of.

  • You can create filtered indexes (an index that has a WHERE clause)
  • An indexed view needs to use WITH SCHEMABINDING, and as a consequence the index must be UNIQUE CLUSTERED.
  • Run a table-valued function against all the rows of a query using APPLY.

Note – these were things I came across BEFORE I did the exam. I am definitely not indicating these topics were either in or out of the exam (and no, there’s no hidden meaning here, I  really mean that). All I am saying is that by reviewing the curriculum I happened to learn some new things.

Finally, let me pre-empt the inevitable lazy sod who emails me and asks for some hints or answers to this exam (apart from the fact that by taking the exam, I’ve agreed to Microsoft’s Non-Disclosure Agreement which includes not “Disseminating actual Exam content” ) ..

Do what I did – use the product, and know all (or enough of) the stuff it says you need to know and you should pass!