Global Nerdy

Speaker Idol takes place tomorrow night at the TechDays Ottawa venue – that’s the Hampton Inn Conference Centre on 100 Coventry Road. It’s a competition where new speakers – that’s right, these are people who aren’t “the usual suspects” who you’d expect to see speak in front of Ottawa’s tech community – get to test themselves against their peers. At stake: Visual Studio 2010 Ultimate and an MSDN Ultimate subscription, which normally retails for about 15 grand.

The Speaker Idol Competitors

Here’s the list of tomorrow night’s competitors and their presentations:

Ahmed Al-Asaad: Entity Framework

You can’t use the Entity framework or any other ORM for your data access layer…No problem. In 10 minutes I will be creating a handy utility to auto generate dataobjects, data access layer (i.e business objects) and CRUD stored procs using the SQLConnection.GetSchema() method.

Daniel Fitzgerald: 10 TSQL Tips in 10 minutes

Jean Sigouin: Take advantage of T-SQL “Common Table Expressions”

“Common Table Expressions” (CTE’s) have been available in SQL Server since version 2005. CTE`s can be leveraged to simplify queries that would otherwise require long stored procedures or scripts in order to achieve the same result. Unfortunately, a good number of DBA’s don’t know they exist or how to take advantage of this extremely useful tool. In this demo, I will de-mystify CTE’s. I will show simple examples of how you can use them to write great queries and solve problems such as:

• How to build hierarchies using recursive CTE queries
• How to create data load queries with a “Tally-Table-On-The-Fly” CTE
• How to use CTE’s as temporary tables
• How to optimizing query performance with CTE’s.

Wassim Sleiman: Customizing and controlling an MS-Word application using VB.Net

• Customizing the ribbon (enable/disable menu options)
• Applying the customization to an MS-Word document
• Launching MS-Word using VB.Net
• Loading a document
• Embedding the MS-Word application within a Windows form using the interop features of the CLR using Platform Invoke (PInvoke)
• Removing the customization from the MS-Word document

Sylvain Boucher: XNA Basics

I will be creating something from scratch that will fit into the 10 minute allocates slot. At the end we will have a working JezzBall like clone which will be playable from the users perspective. • Polling • Sprite’s and adding them to the project • Loading / Drawing Sprites • Animation • Collision Detection

Charles Wiebe: Help!

I just need to a little push to get started with Web Parts Classes have Properties. (Web Part) Properties are decorated by attributes. Reflection is used to discover the properties and attributes in a Web Part. Let’s explore how these properties and attributes are discovered and used to create simple and standard help documentation for Web Parts. Web Parts are used are used in ASP.NET and SharePoint sites.

Félix Langlois: C# Experimenting with Conditional Compilation

Come and see what you can do with Conditional Compilation. This is a very useful feature.

The event is free to attend and the fun starts on Tuesday, November 9th at 6:30 p.m.. For more details, see the Ottawa Code Camp page.

This article also appears in Canadian Developer Connection.

Since TechDays – Microsoft Canada’s cross-country developer and IT pro conference visiting 8 cities across Canada this fall – is a two-day event, we’ve got the venues for the entire 48-hour period, including evenings. Rather than have the session rooms (which are already set up for an audience, complete with A/V and seating) lie fallow, we decided to put them to good use and hold free community events in the evenings. One of these events is Go DevMENTAL, where we show college and university students what they can build using Microsoft’s tools and technologies and give them a lot of free stuff. Tomorrow night, Tuesday November 9th, we’re holding Go DevMENTAL Ottawa at the Hampton Inn Conference Centre (100 Coventry Road)!

Go DevMENTAL is a two-track conference, with one track devoted to web design and development using WebMatrix, Expression Blend and Silverlight, while the other covers mobile development for Windows Phone 7 using Silverlight and XNA. At the end of the evening, we give the students a token for DreamSpark, our program that gives them free Microsoft development tools and operating systems and a DVD full of goodies so they can start coding right away.

If you’re a college or university student and would like to have an informative and entertaining evening where you learn cool new things, get free cool stuff, connect with industry people and get some help with your career, register for Go DevMental!

This article also appears in Canadian Developer Connection.

Creative Commons Photo by Numan Q.

TechDays, Microsoft’s cross-Canada conference for developers and IT pros, offers its space to tech communities to hold events free of charge when TechDays itself isn’t happening. Last year it was a series of “Camp” style events along the lines of DemoCamp abd FailCamp, and this year, CloudCamp is holding events in all eight TechDays cities on the evening before Day 1 of TechDays. TechDays Ottawa starts tomorrow, which means that CloudCamp Ottawa happens tonight!

It doesn’t matter whether your preferred cloud computing system is Microsoft’s, Amazon’s, Rackspace’s or anyone else’s – CloudCamp is for anyone with an interest in the cloud, regardless of technology stack or vendor.

From the event description:

CloudCamp is an unconference where early adopters of Cloud Computing technologies exchange ideas. With the rapid change occurring in the industry, we need a place where we can meet to share our experiences, challenges and solutions. At CloudCamp, you are encouraged to share your thoughts in several open discussions, as we strive for the advancement of Cloud Computing. End users, IT professionals and vendors are all encouraged to participate.

Here’s the agenda:

When	What
5:30 p.m.	Registration and refreshments
6:00	Welcome and introductions
6:15	Lightning Talks Microsoft Azure by Rick Claus Opportunities and Challenges of Delivering Analytics in the Cloud by Rob Rose Books on the Ground; Data in the Cloud? – Libraries and Privacy in the Cloud by Heather Moulaison, Assistant Professor at the University of Ottawa School of Information
6:45	“Unpanel” discussion
7:15	Organize breakout sessions
7:30	Breakout sessions, round 1 Suggested topics: Intro to cloud computing Comparison of cloud platforms How to build an app in the cloud NoSQL Security in the cloud
8:15	Breakout session, round 2
9:00	Wrap-up
9:15	Where to next?

CloudCamp Ottawa takes place tonight at the Hampton Inn Convention Centre (100 Coventry Road) and admission is free. They’re even providing food!

This article also appears in Canadian Developer Connection.

I’m on VIA Rail train 42, bound for Ottawa as I write this. As a student at Crazy Go Nuts University (some of you may know it by its other name, Queen’s) with friends and family in the Toronto/Ottawa/Montreal triangle, riding on VIA was a ritual in which I partook at least a half-dozen times a year. If I were to go solely by outward appearances, my student self – I was a student from 1987 to 1994 – would recognize just about everything on this train car; to my eye, it looks exactly the same as a circa-1994 one does, except for two things: the power outlets and the sticker above the window announcing the availability of wifi.

TechDays Ottawa, the Ottawa edition of Microsoft’s cross-country conference from developers and IT pros, starts tomorrow. Hence my presence on this train: I’m heading to the nation’s capital to help the conference along with my fellow evangelists Damir Bersinic, Rick Claus and Christian Beauclair. Once you factor in the travel to and from airports, the airport security dance and all the waiting around you have to do, the time difference between travelling from Toronto to Ottawa by train isn’t all that difference from getting there via plane. Within 15 minutes of arriving at Union Station’s front door, I’d acquired my ticket, bought breakfast, taken my seat on the train, fored up my laptop and gone online.

For those of you curious about the wifi on the train, SpeedTest.net reports that that I’m getting a download speed of 0.77 Mb/s and an upload speed of 0.76 Mb/s (you can see their report to the right). It’s usable for email, web, social networking and even for testing networked Windows Phone 7 apps in the emulator. It’s certainly not for downloading large files, and they block access to high-bandwidth sites like YouTube. It’s still better than the complete lack of internet access on most flight, and if I had higher-bandwidth needs, I could always switch to my internet stick.

I’m making a mental note to favour the train for any business trips to Ottawa or Montreal. This is especially useful for Montreal. since their Gare Centrale is right under the Fairmont Queen Elizabeth, Microsoft Canada’s preferred hotel.

The train left Toronto at 9:30 and will arrive in Ottawa’s so-called “Downtown” station at around 2:00 p.m.. VIA Rail is playing a little fast and loose by calling the Ottawa’s main train station “downtown”, but for my purposes, it’s at a convenient location: TechDays Ottawa’s venue is the Hampton Inn Conference Centre on Coventry Road, which is barely a kilometre away.

This afternoon, I’ll be helping set up the presentation rooms, hooking up the presentation computers for both developer tracks (Developing for Three Screens and the Cloud and Optimizing the Development Process) as well as the Local Flavours track, and then heading to speaker dinner later this evening to catch up with the presenters. Tuesday and Wednesday will be all TechDays, all the time, with Day 1 being a 14-hour day starting with the professional-focused TechDays during the day and the student-focused Go DevMental conference in the evening. Day 2 is a relatively languid 10 hours. Thursday puts me on a return trip to Toronto, this time in the form of a road trip with Damir, my road-tripping buddy from last year’s TechDays.

Watch this space for more reports from TechDays and the road!

This article also appears in Canadian Developer Connection.

From now until November 10th, you can save 40% off a a large selection of books on .NET by Manning Publications! If you’ve been meaning to learn about developing for or with C#, Silverlight, Azure, Entity Framework, PowerShell, SharePoint or Windows Phone 7, Manning’s got the books and you can save money on them.

I’ve listed the applicable books and quick descriptions below. To get the discount, purchase the books from Manning’s site and enter the discount code n540 into the “Promotional Code” box when you check out.

Core .NET

C# in Depth, Second Edition: Guru Jon Skeet teaches you the techniques you’ll need to move from being a competent C# developer to tapping the full potential of the language–including the new C# 4 features. Mastering these techniques will make you a more valuable C# developer.

Azure in Action: Designed both for readers new to cloud concepts and for those familiar with cloud development but new to Azure, this book guides you all the way from your first app through more advanced concepts of the Windows Azure Platform.

Entity Framework 4 in Action: Written for Entity Framework 4! Through small examples and larger case studies this book presents the ORM model and shows you how EF offers a smooth transition from a traditional ADO.NET approach.

Multitouch on Windows (MEAP): This hands-on guide prepares you to create natural user interfaces (NUI) and great multi-touch experiences using the WPF and Surface APIs.

Silverlight

Silverlight 4 in Action: The definitive guide to Silverlight 4! Take a mind-expanding trip through the technology, features, and techniques required to build applications ranging from media, to custom experiences, to business applications, to games.

Hello! Silverlight (MEAP): Fast-paced, entertaining introduction to Silverlight. Authors Bill Reiss and Dave Campbell guide you hands-on from your first Hello World example through the techniques you’ll use to add life to your web applications. Examples are based on Silverlight 4.

ASP.NET

ASP.NET MVC 2 in Action: Fully updated for ASP.NET MVC 2, this new edition will help you build MVC-based applications using the latest version of Microsoft’s ASP.NET MVC framework. After a quick review, you dive head first into practical real-world topics and examples.

ASP.NET 4.0 in Practice (MEAP): Using a practical Problem-Solution-Discussion format, this book guides you through the most common scenarios you will face in a typical ASP.NET application, and provides solutions and suggestions to make you super-productive.

jQuery in Action, Second Edition: New edition of the bestselling jQuery book! This fast-paced guide introduces the jQuery library and shows you how to traverse HTML documents, handle events, perform animations, and add Ajax to your web pages.

Best Practices

Continuous Integration in .NET: Reimagine your development strategy by creating a consistent continuous integration process. Build on the tools you already know, .NET Framework and Visual Studio, along with MSBuild, Subversion, TFS 2010, Team City, NUnit, and Selenium.

Dependency Injection in .NET (MEAP): Dependency Injection is a pattern for creating loosely-coupled code that’s easier to maintain and resistant to change. This book introduces DI and presents practical examples using open source tools along with Microsoft’s latest technologies.

Brownfield Application Development in .NET: Don’t just maintain your legacy software–leverage your investments by adding new features and better functionality. Learn patterns and techniques for blending new development with existing systems.

The Art of Unit Testing: Using .NET examples, guru Roy Osherove teaches you to build practical and maintainable tests and presents best practices for frameworks, mock objects, and testing against a database.

DSLs in Boo: Domain Specific Languages, or DSLs, create a special coding vocabulary so your code expresses the intent of the application. In this book, Oren Eini, aka Ayende Rahien, introduces DSL concepts and how to apply them in the Boo language.

PowerShell, SQL Server and SharePoint

Windows PowerShell in Action, Second Edition (MEAP): PowerShell transformed the way administrators and developers interact with Windows. This updated second edition covers new developments, including Remoting, Modules, Events and Transactions, and the PowerShell Integrated Scripting Environment.

PowerShell in Practice: Hands-on, cookbook-style reference intended for administrators wanting to use PowerShell. Written from an administrator’s perspective, it concentrates on using PowerShell for practical tasks and automation.

SQL Server DMVs in Action (MEAP): Build better queries and improve performance using dynamic management views. This practical guide shows you how to obtain, interpret, and act on the information captured by DMVs to keep your system in top shape.

SQL Server 2008 Administration in Action: This must-have handbook for SQL Server DBAs covers all areas of SQL Server administration–from installation to disaster recovery. Learn hard-won (and hard-to-find) techniques and guidance based on years of DBA experience.

SQL Server MVP Deep Dives: This is no ordinary SQL Server book. 53 MVPs each pick an area of passionate interest to them and then share their insights and practical know-how with you. Author royalties go to support War Child International.

SharePoint 2010 Web Parts in Action (MEAP): This comprehensive guide covers everything from the basic foundations to how you can use web parts to implement robust, scalable, maintainable and user-friendly SharePoint applications.

SharePoint 2010 Workflows in Action: Hands-on tutorial that guides SharePoint developers and power users from workflow fundamentals and all the way to advanced techniques for complex workflow requirements.

SharePoint 2010 Site Owner’s Manual (MEAP): Build powerful SharePoint sites with no code. The book shows you how to get the most out of SharePoint without having to understand development or servers.

This article also appears in Canadian Developer Connection.