Wednesday, April 30, 2008

Tech-Ed Orlando 2008

Tech-Ed Orlando 2008 is going to be pretty full on for me as not only will I be attending both the Developer and IT Pro weeks, I will also be helping out in the hands-on-labs (HOLS's), presenting and manning the SQL Server demo stations.

Here's what my schedule looks like so far:

Developer Conference

  • QA on the developer HOL's from 26th-30th May
  • Technical Learning Guide (TLG) for the developer HOL's
  • Presenting "DAT01-ILL - Microsoft SQL Server 2008 Service Oriented Architecture" on 3rd June @ 10:30am and 5th June @ 10:15am (See abstract below)

DAT01-ILL Abstract

This lab covers creating a Service Oriented Database Application on SQL Server 2008. After completing this self-paced lab you will be able to set up database objects and security for Service Broker, deploy a Service Oriented Database Application across multiple machines, set up a Service Broker Endpoint, explain the steps involved in converting a traditional application to a service oriented database application, explain Service Broker message types and contracts, troubleshoot a Service Broker application, and use the SQL Server Management Studio (SSMS) to manage solutions, projects, modify and execute SQLCMD mode scripts and execute queries and review their plan of execution.


MCT Train-the-Trainer (TTT)


  • SQL Server 2008 DBA Deep Dive on Saturday 7th June (See abstract below)
TTT Abstract

In Progress!

http://blogs.msdn.com/billchapman/archive/2008/04/24/train-the-trainer-teched-2008-orlando.aspx


IT Professional Conference


  • Presenting "DAT356 - Microsoft SQL Server Compact Edition for the DBA" on 12th June @ 8:30am (See abstract below)
  • Manning SQL Server Demo Stations - Daily
DAT356 Abstract

Microsoft SQL Server Compact Edition is the rebranding of Microsoft SQL Server Mobile Edition (SQL Server Mobile 3.0) without the desktop restriction. SQL Server Compact extends the SQL Server Mobile technology by offering a low maintenance, compact embedded database for single-user client applications for all Windows platforms including tablet PCs, pocket PCs, smart phones and desktops. Just as with SQL Server Mobile, SQL Server Compact is a free, easy-to-use, lightweight, and embeddable version of SQL Server for developing desktop and mobile applications. This session covers:


  • SQL Server Compact Edition (SSCE) Overview
  • SSCE Feature Limitations
  • Obtaining SSCE 3.x
  • Managing SSCE Databases
  • Securing the SSCE Database
  • Synchronization
  • Locking, Concurrency, and Isolations
  • Performance Tuning
  • What's new in SSCE 3.5
So if you plan on attending Tech-Ed this year, why don't you pop-in and say G'day. Who know's, I might even shout you a beer or two :-)

Saturday, April 05, 2008

Microsoft SQL Server 2008 Certifications

Gerry O'Brien has blogged about how to get certified in Microsoft SQL Server 2008.

For SQL Server 2008 you will now have the choice of obtaining a MCTS SQL Server 2008 in Database Administration (70-432), Database Developer (70-433) or Business Intelligence Developer (70-448). As a result of there only being one exam for each certification, there will be no upgrade exam from MCTS SQL 2005 to MCTS SQL 2008.

Beta exams are due to be released shortly (see MCP Flash) with the live exams due for release in late 2008.