In this session, you’ll go through a whirlwind tour of what’s new in one of Microsoft’s biggest releases of SQL Server in its history: SQL Server code named Denali. You’ll learn about the upcoming Crescent feature, which allows users to build ad-hoc reports easily. You’ll also learn about the BI Semantic Model in SSAS and the huge enhancements to SSIS. Lastly, Brian will cover the database engine enhancements that make BI more accessible and faster.

Experienced .Net developers, learn how to expand your knowledge into the popular SharePoint platform. See an actual SharePoint environment and learn how to customize it with .Net code.

Mike shows you how to build script tasks in the control flow and Script components in the data flow of an SSIS package. If there is not a task in the toolbox that can do what you need, then a script task or component is used to complete these steps. Learn when to use them and when not to use them.

SQL Server Reporting Services is a fundamental part of Microsoft’s Business Intelligence suite of products which as its name suggests provides a centralized robust reporting solution for organizations. Using a familiar development environment (Visual Studio), we can create static and interactive reports that can be delivered to consumers in a variety of ways. Co-presenting with Brian will be Sherri McDonald and during this level 100-200 session, they will cover topics like: - What is reporting services and what can it be used for? - New Features included in 2008 R2 - Architectural Overview - Demonstrations to cover the entire process of developing, deploying and rendering reports using the built in Report Manager and URL Access. At the end of this session, one should be familiar with using SQL Server Reporting Services and have an overview of the steps required to build and deploy reports in their own environment.** This session is SQL Saturday favorite and is always packed full. Don't miss it **

What’s the use of having business intelligence if you can’t make it actionable? In this session you’ll learn how to better collaborate with SharePoint 2010 and Microsoft’s BI suite. You’ll learn how PowerPivot in SharePoint will allow your users to do self-service BI. You’ll also learn how to Performance Point can help you develop scorecards and aid your users in answering questions they didn’t even know they had.

SharePoint 2010 introduced numerous capabilities available to developers for building rich Silverligt applications. In this session we'll take a look at what is available to you specifically in the Client Object Model & REST services. We'll also look into some tips and tricks to improve the performance of your Silverlight application and how to leverage the very popular MVVM design pattern when building applications for SharePoint 2010.

Basic how to create reports using Report Designer and display them in a project using Report Viewer.

Do you apps and wesites need photos? Join Russ Fustino as he shares his recent photo editing experience using the new and improved Windows Live Photo Gallery 2011. If you have not seen the latest release, Windows Live Photo Gallery 2011 has been improved significantly. It is part of the Windows Live Essentials download pack. We will look at several editing features such as rename, resize, retouch, adjust timestamp, noise reduction, Auto adjust, color and exposure adjustment, effects, revert to original, straighten photos and even print your own photo book! This app is free by the way! Here is the outline:Where do I get Windows Live Photo Gallery 2011? Outline:Making one photo from more than one.• Photo Fuse• PanoramaEditing with Windows Live Photo Gallery 2011.• Auto Adjust• Crop• Revert• Brightness/Contrast• Retouch/Red Eye• Remove noise/StraightenOrganizing with Windows Live Photo Gallery 2011• Face Recognition• Tags and captions• Find • Slide Show ThemesSharing with Windows Live Photo Gallery 2011• Upload to Facebook• Email

Author stored procedures, triggers, user-defined functions, user-defined types, and user-defined aggregates in managed code and turn your SQL Server into the most powerful SQL Server on the block. Find out how powerful CLR code can be for your SQL Server. This extremely informative seminar will give you everything you need to know about running C# or VB.NET code in your SQL Server. (45 min to 1 hour).

In this session we will discuss code for getting data files/documents into your phone applications. We will build a very simple facility for transferring files from a user's cloud storage area (like DropBox or SkyDrive) to the phone. We will discuss both Windows Phone 7 and Windows Phone Mango. In the latter we will delve into Background File Transfers.

This interactive session discusses various ways and tools to govern, develop and maintain a software application.

Learn the Ins and Outs of TFS Team Build, starting with Build Controllers and Agents and then all the way through to the new Workflow-based templates. We will go over how to create custom activities, and much more in order to take full advantage of TFS's powerful build system and empower your team.

An overview of the language from the c# point of view. Will cover functions, objects, prototype inheritance. Also will explore some of the pitfalls to avoid such with issues like scope.

Interested in an architectural walk-through of a Windows Phone 7 mobile medical app built using Windows Azure? Join Jason Milgram, founder of Linxter, Inc for a review of TrackMyShots, an app for people suffering from multiple sclerosis, diabetes and other conditions requiring frequent injections.

Learn more about Metro Design Language which is used in Zune, XBOX, Windows Phone and coming soon to Windows "8" experience near you!

This session will cover how Lync Server 2010 administration can be automated using PowerShell. it will also cover some PowerShell basics as well as administering Active Directory using PowerShell. This will be a hands on presentation with PowerShell script examples.

In this session, you will learn to implement RESTful APIs using WCF in Windows Azure. You will look at all aspects of WCF RESTful implementation in order to be interoperable with the multiple clients. The session will cover implementation and deployment details, best practices, handling security, and versioning. You will learn to work with Windows Azure from development to production deployment.

Learn basic ideas around prototyping interactive experiences using Microsoft Expression Blend SketchFlow. Learn how this will increase quality of your product, help ALM and even improve Sales.

Why write repetitive code when you can generate it? By now you must have heard about Text Template Transformation Toolkit (T4) – the code generator built into Visual Studio and used by ASP.NET MVC, ADO.NET Entity Framework and other cutting edge technologies. T4 allows you to use simple ASP.NET-like template syntax to generate application source code, configuration files, stored procedures and more. This session shows you everything you need to start building your own or customizing existing code generators, including an overview of code generation, T4 template syntax and how to create a working template for generating CRUD stored procedures from scratch.

Whether you are currently looking for funding or think that you might want to at some time in the future, there are some things you should know. We will discuss various stages of business development and funding, as well as answer a few important questions about who does what and what you should consider when looking for funding.

This beginner to intermediate level session will introduce you to statistics, including how to create, manage, troubleshoot, and more! Statistics are a key part of getting solid and repeatable performance and is easily just as important as having indexes.

Intro to WP7 - includes info about the platform and getting started with Silverlight & XNA.

Getting familiar with XNA (covers differences in XNA programming model and what's in the framework)

Using Phone Features w/ XNA (this covers accelerometer, gestures, gps, camera, etc)

Scale Out your .NET applications by leveraging IIS7, AppFabric, Web Farm Framework, and Web Deploy

Learn about ASP.NET MVC, as well as the latest updates to the popular ASP.NET web application framework. This presentation will also include code first database prototyping using ASP.NET.

Dynamic Data is one of the best and undeservingly forgotten new features of ASP.NET 4.0. Have you looked at Dynamic Data in its initial release and decided it was too limited, too complex or could only be used for simple screens? Think again! Dynamic Data unlocks the true potential of WebForms and LINQ. It can be used in existing pages of traditional ASP.NET applications as well as new, completely dynamic web sites. This session will show you how to use this powerful framework, starting with the simple controls and templates that make your daily coding tasks so much easier, to the powerful URL routing and dynamic LINQ queries that allow you to generate entire web applications from a data model.

You are building a Windows Phone application but what would happen when millions of consumers start to use your application? To plan ahead for the huge number of users your application might attract, a more robust architecture must be considered. Windows Azure is exciting platform that empowers you as the developer to off-load the infrastructure needs to the cloud and helps you focus on building an application. In this session, you will learn to build Windows Phone Notepad application that will utilize the WCF RESTful service layer with SQL back-end built in Windows Azure cloud.

Join us for a code walk through on how to enable in-app purchasing in your .NET and Windows Phone 7 projects. Bring your laptop for optional hands-on participation. Jason Milgram, founder of Linxter, will demonstrate using CloudMiddleware.com, a hub of pre-built integration services running on Windows Azure for easily enabling financial transactions within your app.

Office 365 gives you the capability of taking your IT Operations “To the Cloud” with offerings for Exchange, Lync and SharePoint 2010 versions. No more need for on-premise infrastructure to implement messaging, communications and collaboration functions. Joe looks at how you can take your IT Operations “To the Cloud” and explores the different collaboration and software developer customizations available with SharePoint 2010 Online.

This talk will explore the various models available to build applications in Entity Framework 4. We will cover the three major code generation styles: database-first, model-first, and the newest - code-first. This is a code-heavy session with minimal slides, and is very compelling if you’re building Line of Business or other data-centric applications.