ToyboxCreations SELECT * FROM [My Life]

Quick Update

I'm currently working on a batch of 12 articles that will fill in details on the study guides I've published over the last week.  These articles are all a part of the training I've being putting myself through to take the 70-433 at the end of this month.

Heh.

Considering how busy I've been between work, getting ready for the reception, and my other side projects, I'm pretty happy to say I'm making great progress on creating these study materials.  I've also had a few requests to form a study group.  If you're interested in joining the group, please let me know.  Our next meeting is scheduled for Thursday next week.  The plan is to cover the materials I'm finishing up now, and go through them... hopefully I'll find ways of improving them before releasing them on the site.

If you have any other questions, send them in!  I'm here to help!

Microsoft Exam 70-433 (part 7)

I'm putting together a new series to cover the materials you'll need to know in order to pass the 70-433.  Microsoft's exam that covers Database Development using Microsoft SQL Server 2008.  I'm going to list the topics covered in several posts, each one will include links to details to those topics.  If you have any questions, let me know!

Gathering Performance Information (11 percent)

• Capture execution plans.
  This objective may include but is not limited to: graphical execution plans; SHOWPLAN
• Gather trace information by using the SQL Server Profiler.
• Collect output from the Database Engine Tuning Advisor.
  This objective may include but is not limited to: prepare a workload
• Collect information from system metadata.
  This objective may include but is not limited to: Dynamic Management Views (DMVs), catalog views

Microsoft Exam 70-433 (part 6)

I'm putting together a new series to cover the materials you'll need to know in order to pass the 70-433.  Microsoft's exam that covers Database Development using Microsoft SQL Server 2008.  I'm going to list the topics covered in several posts, each one will include links to details to those topics.  If you have any questions, let me know!

Working with XML Data (12 percent)

• Retrieve relational data as XML.
  This objective may include but is not limited to: FOR XML
• Transform XML data into relational data.
  This objective may include but is not limited to: OPENXML, sp_xml_preparedocument, sp_xml_removedocument
• Query XML data.
  This objective may include but is not limited to: XQUERY, XPATH
• Manage XML data.
  This objective may include but is not limited to: XML datatype, XML indexes, XML schema collections