Ottawa Code Camp
Platinum Sponsors
Gold Sponsors
Silver Sponsors
Bronze Sponsors

Saturday, April 16, 2011

Ottawa IT Camp Sessions

Web and Cloud Track

How to make Oracle play nice with ASP.NET 4.0: A look at data access , providers, and some best practices for Oracle Packages.

By Joel Hebert

In this session we will create an asp.net 4.0 application from scratch with the Oracle providers for asp.net 4, we will use the Express Database and the 11r2 client for connectivity and take a look at the Oracle.DataAccess ....as a bonus we will look at the new Entity Framework provider for Oracle and how Code Smith can be leveraged for effective and fast data access methodologies.

 

Using Roles to build access-restricted applications?

By Charles Wiebe

"What is a Role?  How do Roles work?  How are Roles used to access methods in an application? How are Roles implemented in asp.net vs MVC vs DSL applications? 

Roles are used to create access rules in applications.  Roles are used in websites to control"

 

Getting started with Azure

By Christian Beauclair

In this session, we'll review the new features of the Azure SDK 1.3 and some of the new Beta features. You will also see how to build and deploy an app.

 

Intro to NoSQL

By Peter Ritchie

“NOSQL” or non-relational databases have gotten a lot of focus in the past little while.  Despite the implication of the name, it doesn’t mean relational databases are generally bad or should be banned.   This session covers what  “NOSQL” really means to designing data storage, how it relates to relational databases and how to take a NOSQL approach to architecture and design that improves and applications design, scalability, and separation of concerns.  Learn what kinds of non-relational database they are and where non-relational databases best fit, how to fit them into typical architectures, an architecture to benefit from non-relational.

 

Using Mocking Framework in Unit Test

By Taswar Bhatti

Unit testing means verifying a piece of code in isolation. If the code you test needs to communicates with a dozen of other components (WCF Web Service, Database, File System etc), you need to isolate them all - otherwise you will have brittle test and would fail for unknown reasons or bugs.

That's where mocking comes to rescue. With it, you can easily imitate any interactions, return the data you want, throw exceptions you want, etc. You can test scenarios that are difficult even to reproduce in real life.

 

SQL Track

Building a Scale-Out SQL Server 2008 R2 Reporting Services Farm

By Edwin Sarmiento

Delivering reports is becoming more critical due to the increasing demand for business intelligence solutions. And while there are a lot of guides that walk us through building a highly available database engine, you’ll rarely see one for SQL Server Reporting Services. This session will walk you through building a scale-out SQL Server 2008 R2 Reporting Services farm from the ground up. You’ll be surprised how easy it is to do so that you can start building your own test environment.

 

Why SSIS Config is Rocket sciences

By Jean-rene Roy

Learning SQL Server Integration Service (SSIS) is not that difficult but the deployment in production is. Why? Because SSIS package Configurations is Rocket Science. This session will present many examples of SSIS configuration and show you the pit fall, tips and tricks and best practices for SSIS. This session is not just for the DBA but also for the developers. Attending this session can save you many frustrations. You need to see it.

 

SSIS  Whats new in SQL Server Denali?

By Christian Cote

This session will demonstrate SQL Server Denali's new features such as Server Deployment Model, Environments, etc. All these novelties will be shown by migrating a 2008 SSIS solution to Denali.

 

Deploy your database with VS2010 Database Development Tools

By Christian Cote

In this session you will learn the various ways to deploy your database using VS2010 Database Development tools.Usage of MSBuild and TFSBuild will be covered as well as branching and versioning the database.

 

SSIS Performance Design Patterns

By Matt Masson

Need a fast data integration solution, but don't have the time or budget for heavy performance tuning? Come learn how to maximize your ROI by applying trusted design patterns to your Integration Services packages. We’ll start off by looking at how to set performance expectations, and see how you can easily put together a simple framework to record benchmarks for your ETL process. We’ll then dive into a number of common design patterns, such as surrogate key generation, advanced Lookup patterns, parallel processing, change data capture, and different ways of handling slowly changing dimensions.

 

Windows Phone 7 Track

Data Binding, from nothing to something!

By Peter Henry

You know you need to load data into your application but are you confused on where to start?  POCOs, web services, EF, binding, paths, XMLs, Blend, data context... if these terms confuse or intimidate you, come check out this presentation to give you a leg up on learning how to data bind different kinds of data in your WP7 application.

 

How to Use Windows Phone 7 Hardware API's

By AHMED AL-ASAAD

Windows Phone 7 gives developers the ability to access some of the phone's hardware using API's. Attend this session to learn how to access device information, camera, GPS, accelerometer, and other API's.

 

Building MVVM applications on Windows Phone

By Colin Melia

So you’ve created your first Windows Phone Silverlight application and now you’re on to your second and bigger project.  You want to create something substantial and maintainable in the long run and perhaps leverage the Data-bound Visual Studio project template and that MVVM pattern about which you’ve heard so much.  This reference demo video will help explain how to get started with the MVVM pattern on Windows Phone using the platform, project templates and 3rd-party libraries.

 

Create Your Own Language Using Linq Expression

By John Hansen

Linq Expression trees (.net 3.5 and 4.0) support the generation of high performance IL code dyamically.      This course will discuss the rationale behind developing a custom scripting language and walk through  implementation of simple language using C# Linq Expression, a component of DLR.   The course will show 1)how to use C# regular expressions  to tokenize your language, 2)use a simple variant of the Edsger Dijkstra's shunting algorithm to generate a language abstract expression tree and 3)finally using Linq Expression trees to generate IL code for a simple custom scripting language that can directly access .net objects and can be compiled on the fly.

 

Hot off the press from Mix11 - What's new for Windows Phone

By Colin Melia

You've heard that more cool things are coming to Windows Phone and SIlverlight but you don't have time to condense the fire hose of recent news from Mix.  Just back from Vegas the day before, Windows Phone developer trainer and Silverlight MVP, Colin Melia has the news on what's coming next.

 

ITPro Track

DPM and Opalis better together

By Islam Gomaa

Islam will show how to use Opalis with System Center Data Protection Manager to automate your backup jobs, daily maintenance tasks and integrate IT tools to drive down the cost  IT operations, while improving the reliability of IT processes.

 

Kill Bugs Faster and Build and Run Your Virtual Test Lab Using Microsoft Visual Studio Lab Management 2010

By Wes MacDonald

Developers, testers, project managers, and pointy-haired bosses... Come one, come all, and learn how to add a new tool to your kit to find and kill bugs faster. Watch as Wes fires up Microsoft’s new Visual Studio Lab Management 2010 with Team Foundation Server 2010. He’ll use this to create a virtual test environment on top of Hyper-V that mimics a production environment. Something you can do too—whether for an in-house configuration or for your customers. Using the Build features of Team Foundation Server 2010 with Team Lab, you can automate the deployment of a single virtual machine or an entire virtual domain, and Wes shows you how. Then you can execute automated tests in this virtual environment to increase your automated test coverage. In addition, your testers can use the virtual environment to run manual tests. Finally, the best part of all of this is that if a bug is found, they can snapshot the virtual environment and provide that to a developer so they can ferret out the bug right where it reared its ugly head. Wes shows you this, too and why you’ll want to create your own virtual test lab and manage it with Visual Studio Lab Management.

 

Microsoft Virtualization for the Vmware Administrator

By Mitch Garvis

Microsoft’s Hyper-V 2008R2 has come from behind to become a real player in the virtualization game.  For IT Pros who are familiar with VMware the switch to Microsoft virtualization may be tempting but daunting, especially with the thought of having to replace an existing infrastructure.  This session will introduce the IT Pro to both Hyper-V and System Center Virtual Machine Manager, and will demonstrate how to manage both Hyper-V and ESX hosts from one central console.

 

Busting the Myth: Upgrading from Windows XP to Windows 7 using the Microsoft Deployment Toolkit

By Mitch Garvis

In this fun, interactive session we will take a machine running Windows XP (32-bit) with 60 Gigabytes of data, and in under an hour upgrade it to Windows 7 64-bit.  We will use the Microsoft Deployment Toolkit 2010 to create the deployment point on either a network share or USB key, and for extra credit, we’ll even create a key that will install both 32-bit and 64-bit Windows with all of your applications!

 

Sex, Lies and VDI: The Raw Truth about VDI

By Bradley Bird

Virtual Desktop Infrastructure (VDI) is the latest buzz in virtualization.  From the streets of Montreal to Amsterdam, everyone is talking about VDI.  What’s VDI really about?  Is VDI for me?

Come out and see this session to learn about VDI, what it’s about and how it is used.  We’ll tell you the things that the grown-ups won’t…

User Groups
Ottawa .NET Community
Ottawa Windows Server User Group
Professional Association for SQL Server
TrackerRealm Content Management Solutions