Ottawa Code Camp
Ottawa .NET Community
Ottawa Windows Server User Group
Professional Association for SQL Server
Platinum Sponsors
Gold Sponsors
Silver Sponsors
Bronze Sponsors

Saturday, April 17, 2010 Ottawa IT Day Sessions
Coming in March 2010

IT Pro Track

How to Document your Servers aka How to make your Boss Happy

By Garth Jones

In this session Garth will show you how to automate the documentation of your servers using a few simple VB scripts. Using these VB scripts he will show you how to produce basic documentation for  your Windows Servers, SQL setup, System Center Configuration

Introduction to Microsoft System Center Data Protection Manager 2010 (DPM V3)

By: Islam Gomaa

Through discussions and demonstrations, we will be covering installation and configuration in DPM . We will talk about common situations and look at how DPM can meet these needs.

Windows 7 Media Center

By: Todd Lamothe

In this session, Todd will show you how to turn your Windows 7 computer into a HD PVR. He will also show you how to link the Media Center Extender, which connects to your television and stereo system, so that you can watch taped video, listen to your mp3

Test Lab on a budget

By: Brad Bird

Have you found that you need to work on some of your technical skills? Does your place of business not have an adequate test lab for your needs? Did you know that there are online resources just waiting to be tapped? I will demonstrate what I have done to

Windows Server 2008 R2 and PowerShell

By: Kirk Munro

Come to this session to find out how you can optimize your server management experience in Windows Server 2008 R2 with Windows PowerShell. This session will demonstrate new and improved features in Windows Server 2008 R2 including Server Manager Remoting,


SQL Track

Implementing SQL Server 2008 Database Mirroring for SharePoint 2007 High Availability and Disaster Recovery

By: David E. Myers

SQL Server is at the core of every SharePoint 2007 deployment.  This session will be a practical demonstration of how to configure Database Mirroring in order to provide high availability and disaster recovery for your SharePoint farm.  Throughout the demonstration security and performance best practices will be highlighted.

XML in SQL Server.  Why bother? 

By:Jean-René Roy

Many of the Developers and DBAs have the XML syndrome.  We can’t blame them because XML document are not simple.  But what most Developers and DBA don’t know is how SQL Server can help you overcome the XML syndrome.  XML is here to say, we will need to save some XML in the database more often than ever.  This session will cover usable scenarios when using Xpath, Xquery the XML type in SQL server and the XSD. We will look at the different tools available in SQL Server Management Studio (SSMS) and Visual Studio (VS).  This is the chance to bring the DBA and Developer to the same level in using XML in SQL Server. 

Manage your database with Visual Studio 2010

By: Christian Coté

Too many times, database maintenance and deployment represent a challenge during application development. And now with Visual Studio 2010, Oracle databases are first class citizens of development solutions. This session will demonstrate how Visual Studio Database Development Tools can ease database managements, deployment and version control integration. New features of 2010 will be covered as well as database unit testing and data generation. Developers will learn how database can be part of their Visual Studio solutions and how easy it is to deploy database objects with other projects.

Windows PowerShell for the SQL Server DBA

By: Edwin Sarmiento

Windows PowerShell is becoming the scripting language of choice for managing Microsoft servers and workstations. And while T-SQL is still the scripting language for DBAs to administer and manage SQL Server, there is tons of stuff that can be easily done with Windows PowerShell.

In this session, learn Windows PowerShell from the ground up and how you can use it with SQL Server Management Objects (SMO) to administer and manage a SQL Server instance.

Use the Management Data Warehouse to Monitor SQL Server Performance

By: Lynda Rab

Collecting meaningful performance, activity and trending statistics from multiple servers has often involved developing various complex homegrown solutions.  The new SQL Server 2008 Data Collector and Management Data Warehouse features can simplify and streamline those processes.  This presentation will walk you through setting up various generic and customized Data Collectors and the Management Data Warehouse that is used to store the data.  See how T-SQL, SQL Trace, Performance Counters and Query Activity collector types can be set up to gather a wide range of statistics from multiple servers within your organization.  We will also create simple reports to display this data for analysis and trending purposes.

.NET Track

A lap around Visual Studio 2010

By: Joel Hebert

The final version of Visual Studio 2010 is scheduled to be presented at the DevConnections conference on April 12–14. Visual Studio 2010 itself will be released on April 12, 2010, according to Microsoft's website. Joel Hebert of Opulent ASP Development has been using Visual Studio since the CTP , Beta 1, Beta 2 and the RC. This session will showcase the new additions as well as the feature enhancements for the IDE , some of the languages and some of the other notables like Code Contracts. If you are curious about what Visual Studio 2010 has to offer do attend this session. Whether you are using Visual Studio 2003 , 2005 or 2008 this session will allow you to make an effective decision as to whether you should move to the new version. Some of the items that we will cover are: The Code Search View Hierarchy, Intellisense Smart Lists, Profiling in Entity Framework, Code Contracts, and more.

Radically reduce WEB Application development  time by employing Jetfire

By: Charles Wiebe & John Hansen

Do you need a .net programming productivity boost?   Tired of battling 'down in the mud' database issues? Are you frustrated that you need to build countless classes to get your application running?  Do you struggle with frameworks that take months, if not years to master?  Do you dream of adding features such as audits, seamless updates, user developed scripts or enhanced security to your application?  Do you program in C# and don't want to learn another language?  Then you absolutely need to check out Jetfire.

Exploring LinQ to Object 

By: Vincent Grondin

Nearly 4 years after it was first introduced, LinQ has made great gains into the heart of many programmers.  Are you one of them?  No? Oh, then you're missing out on one heck of a technology!  Follow me for an hour of exploration on LinQ to Objects and dare not to dream about using it later...

SharePoint Server Branding

By: Wes MacDonald

Using WSPBuilder go through the exercise of Branding a SharePoint 2007 website

Advanced Dependency Injection Making Dependency Injection work for you with examples in Microsoft Unity

By: Peter Ritchie

Testability and decoupling are fine and dandy.  See how to make dependency injection work for you through easy injection of logic to facilitate debugging, tracing, and even extensibility. You've gone beyond simply injection and you have complex scenarios like run-time selection of injection parameters, chained dependencies, and object life-time management.  See how these scenarios can be achieved with an IoC container like Unity. 


Silverlight track

Part 1 of 5 - Silverlight Essentials

By: Colin Melia

Silverlight promises to be everywhere and Visual Studio 2010 makes it more accesible than ever for developers.  To get to grips with it, you should know the fundamentals.  This session leads you through some of the essential features which may include XAML, controls, events, binding, styles, animations, hosting, navigation, etc.

Part 2 of 5 - Application Jigsaw

By: Sylvain Boucher

Silverlight applications follow general layered architecture practices with a strong emphasis on user interface and interaction.  In this session we build out our application and bring out the arsenal of Silverlight features from the Essentials session.  We'll also show how to make the application available out of browser and touch on Blend as a design tool.

Part 3 of 5 - Data Matters

By: Louis-Philippe Pinsonneault

Silverlight can access data in various ways using the browser and client stack.  In this session we discuss these options and specifically take a data source and show how Silverlight hooks up to it asynchronously for our application.  We then discover how data templates and binding can be used to display the data.

Part 4 of 5 - The Silver Cloud

By: Colin Melia

Featuring free Azure trial access*.  With a Silverlight application and data on our machine, we are ready to go public.  We need to host our S+S solution on the Web.  We'll take a look at the Windows Azure Platform and how to deploy our application to the cloud.  Attendees can deploy their own copy of the app during the session or later on. *limited quantities/duration

Part 5 of 5 - Going Mobile

By: Peter Henry

Windows Phone 7 is out of the gate and Silverlight is the main application interface technology.  To get on this bandwagon you need to be familiar with Silverlight and the development tools.  In this session we'll look at the emulator tools and how we can migrate our desktop application to work on the phone while connecting to our cloud-based data.

TrackerRealm Content Management Solutions