Sessions
Practical SQL Server Reporting Services
Stan Bice
SQL Server Reporting Services is a powerful and flexible reporting platform. Reports can be executed within a browser, an ASP.NET application and a smart client applicaiton. This session will provide a solid overview of its licensing, capabilities and uses. We will look at several practical real-world examples and helpful tips. We will examine report creation, using different reporting controls and discuss deployment options.
Using .NET with SQL 2005 - 3-in-1 (SQLCLR, ADO.NET, Web Services)
Chad Boyd
You've probably heard about the integration of the Common Language Runtime (CLR) into SQL Server 2005, maybe you know about native HTTP endpoints and web services with Sql 2005, and you probably have begun using ADO.NET 2.0. Have you started leveraging many of the new features in each to solve old problems a new way (using features like Query Notifications and Cache Synchronization, multiple methods for Asynchronous database operations, and MARS)? Are you sure you understand when to use them and when not to? Come and see how your application can benefit from the new feature set and get guidance on when to use the CLR integration, when not to, and how to best leverage the power of the CLR running inside SQL Server; see how you can use ADO.NET 2.0 with Sql 2005 to do old things in new ways; and, get a peak at the new native HTTP support with Sql 2005.
T-SQL Enhancements with SQL 2005
Chad Boyd
With the new advent of using the CLR in SQL 2005, many people think T-SQL is a thing of the past - if you attended my other session, you'd realize this is definitely not the case. SQL 2005 introduces a wide variety of T-SQL enhancements that allow you the power to use set-based logic to solve many data related problems that were previously challenging at best. We'll be discussing a variety of topics (new data types, DDL specifics, xml, output expressions, cte's, pivoting, applying, ranking, exception handling, and more) and how they can be used in your database applications.
SQL Server 2005 Service Broker: Beyond the Simple Messaging
Chad Boyd
Service Broker is a new queuing and messaging technology available with Sql Server 2005. Service Broker can help database developers build secure, asynchronous, reliable, loosely-coupled, scalable applications without requiring complex and expensive add-on software or additional hardware. Because Service Broker is part of the Database Engine, administration of these applications is part of the routine administrative of the database. Find out how the Microsoft SQL Server 2005 Service Broker makes it easier than ever for you to build reliable, scalable, asynchronous, queued database applications. When combined with the common language runtime and XML features, SQL Server 2005 provides a great platform for building the next generation of business applications. This presentation will attempt to go beyond the beginning features of the Service Broker (such as queues, messages, simple activation, and reliable messaging) to look at scenarios for Service Broker applications, overview disaster recovery scenarios, and delve into some performance related topics.
Putting the Pieces Together: Dependency Injection with ObjectBuilder
Justin Burtch
Dependency Injection (DI) or Inversion of Control is key patterns to deliver a loosely coupled, highly cohesive application. DI is a pattern where object creation is removed from the typical creator and put into an underlying framework. At runtime, objects are combined to form a full solution. By reducing dependencies, the result are testable objects that can be unit tested independently through mock objects or interfaces. ObjectBuilder is a foundational library that shipped with Enterprise Library 2.0. This talk will focus on how to use ObjectBuilder in your designs to create a more testable application.
Building Applications with the Composite UI Application Block
Justin Burtch
The Composite UI Application Block (CAB) is a library created by the Patterns and Practices team at Microsoft. CAB is an application framework designed to allow independent parts of an application to interoperate in a decoupled manner. This allows a team to isolate major changes in functionality. Parts of the application including Menus, Toolbars, user controls and services can work together to deliver functions without directly knowing about each other. This talk will focus on how to use CAB to build an application from separate modules and incrementally deliver features.
Using Microsoft WSE 3.0 Security to Securely and Confidently Send Files via Web Service for B2B Interactions
Mike Wolf
SFTP/FTP is so Web 1.0. Learn how to utilize Microsofts WSE 3.0 to securely and confidently send files via web service for b2b interactions. This Session will focus on learning the basics of the WSE 3.0 including : configuration, certificate creation and management, ws-security, ws-addressing, and binary file transmission via mtom. Experience in creating and consuming web services in ASP.Net suggested.
Data Modeling with SQL Server 2005
Jeremy Kadlec
Building functional data models to meet the business needs are difficult without the right tool set. The data modeling features in SQL Server 2005 Management Studio enable developers and DBAs build the needed data models. Learn how to build data models rapidly, reverse engineer existing databases, migrate objects with the toolset and more! Come to this session a beginner and walk away with the skills to tackle your next project!
Microsoft BizTalk 2006 R2: The Adapter Framework and WCF
Jeff Sanders
BizTalk Server 2006 is a core component of Microsoft's "Real World" approach to SOA and Business Process Management (BPM). The WCF Adapter Framework is a new adapter framework that will ship at the same time as BizTalk Server 2006 R2. BizTalk already includes an adapter framework that makes it easy to connect BizTalk to a wide variety of transports and business applications. But what if you have an application where BizTalk is too heavy or costly a product to provide simple integration with a Line of Business system? Currently, you're out of luck. The new BizTalk Server 2006 R2 Adapter Framework, however, is built on the Windows Communication Framework (WCF), enabling you to take an R2 Adapter and use it in any application that supports WCF (Office, SharePoint, Sql Server, IIS, etc.), without requiring a BizTalk host instance. This means that it will be as easy to connect a WCF application to a SAP BAPI as it is to connect a WCF application to a SOAP web service. Whether you are a BizTalk expert or newbie, bring your questions, share your experience and learn about the latest in Microsoft's BizTalk-SOA solutions.
JavaScript and Ajax Security
Eric Pascarello
JavaScript and Ajax security has been a hot topic since the boom of Web 2.0. Developers have been using more JavaScript in their pages as users demand easier to use interfaces. The days of infinite JavaScript alert loops are over and more serious threats are out there. Worms such as Yammer and Sammy used Ajax to cause havoc on web sites. A web vulnerability scanner named Jikto showed proof of concept that browsers can be used to spread and search for security holes. There are probably many more things out in the wild that are undiscovered! In this talk we will look at the security issues that we face as a developers in traditional post back models and the Ajax based models. We will see how the worms work and how to protect our webpages from attacks.
Moving our Applications into the World of Web 2.0
Eric Pascarello
The popular trend today is to move our applications from a Web 1.0 world to the 2.0 version. Web 2.0 is not just another term for Ajax. Web 2.0 is a broad range of applications that range from basic forms in a browser, to client applications that interact with the internet, to mobile phones. These applications are full of buzz words, user generated content, alphas, betas, rounded corners, stripped backgrounds, and reflective logos. As a group we will try to investigate what is Web 2.0 exactly and what all the buzz words actually mean. A few questions that will come up are: What is Web 2.0? Is Web 2.0 right for my application? What data should we shared? What is a mash up? Do I have a long tail? What is 3.0? And whatever else you can come up with!
Unit Testing with RhinoMocks
Jonathan Cogley
Learn how to identify and eliminate dependencies in your code, speed up your unit test suites dramatically and generally improve the logical separation of your code for easier maintenance. This session will involve some complexity and requires a good understanding of unit testing with a tool such as NUnit and a good knowledge of C#.
Generics – The New Way to Define Your .NET Types
Osama Morad
This session explores the new C# 2.0 Generic feature and how it should be used in application development. In addition to examining the traditional benefits of type safety and performance, this session will focus on using generics as a new way to define .NET user-defined types in a two step process. Generic types (and their corresponding constructed types) like generic class, generic structures, generic interfaces, and generic delegates will be presented and discussed.
Introduction to WCF
Kevin S. Goff
This is an absolute beginner’s presentation on WCF. While it assumes that the developer has had some prior experience with either web services or remoting, I start with the basics and show the different ways that you can build distributed applications with WCF. The session also shows how interfaces can play a key role in using WCF effectively. Several simple but useful demos and samples to help newbies become productive with WCF.
Building data-driven web pages using ASP.NET 2.0, SQL2005, and ASP.NET AJAX
Kevin S. Goff
This is a workshop-style presentation that builds a data-driven lookup, search/results, and data maintenance web pages, using ASP.NET 2.0, SQL Server 2005, and ASP.NET AJAX. This session covers several aspects of a typical data-driven web application. It doesn’t delve too deeply into any one area [aside from perhaps data access], but provides good starting points for information and practices. The presentation is broken into the following:
- Defining the lookup criteria, result set, and data entry collection
- Building the stored procedures externally in SQL 2005
- Building a basic data access component, utilizing .NET Generics
- Create an ASP.NET 2.0 master page
- Build a lookup and result set web page that features custom paging of result sets
- Construct the web pages and build a reusable web usercontrol
- Incorporate ASP.NET AJAX to improve performance and responsiveness.
T-SQL 2005 for Application Developers
Kevin S. Goff
This session is for application developers who want to get the most out of writing SQL queries and stored procedures. I’ve done this presentation at user groups and other CodeCamp events, and it's always been very popular. The session has two parts - the first covers the new language enhancements in T-SQL 2005, such as PIVOT, recursive queries, APPLY, OUTPUT, advanced error-handling, and new XML functions. The second part covers different topics that apply to both SQL 2000 and 2005 - alternatives to dynamic SQL, derived tables and sub-queries, how to handle variable selections, and much more. You'll see a large amount of T-SQL code that you can leverage in your applications.
Reporting From the Front Lines
Jim Tomney
Visual Studio 2005 ships with the Report Viewer control to facilitate creating useful and stylish reports. The objective of this session will be to provide cookbook examples to help flatten the learning curve for the developer who is not familiar with the tool. The emphasis will be on creating reports locally (RDLC) rather than with SQL Server Reporting Services so that any data source can be utilized.
BDC: Business Data Catalog
Sahil Malik
The BDC is essentially a catalog of business applications that are of interest to SharePoint Server 2007 users, and it bridges the gap between the portal and business applications by bringing in key data from various applications to SharePoint sites, lists, search, and user profiles. In this session we will discuss the various ways BDC can be used.
10 Tips to Improve Your Virtual Server Performance
Sahil Malik
I have no idea how you are keeping up with technology, if you don’t use virtualization. Virtualization is a HUGE time saver. In this session, I share all I learnt the hard way.
Web Service Software Factory Deep Dive
Yuriy Shvadskiy
The session will focus on hands-on application of Web Service Software Factory. Speaker will share his experience of using Web Service Software Factory if real life applications.
SQL Server 2005 Development Tips and Tricks
Jeremy Kadlec
The changes from SQL Server 2000 to 2005 are the most significant of any previous release in the product line. In this session, we will tackle practical SQL Server development problems experienced with SQL Server 2000 and how to solve them with the native technologies available in SQL Server 2005. This fast paced session will be in the format of application development problem, solution, demo and next steps to leverage SQL Server in new and interesting ways!
Adventures with LINQ
Mitch Ruebush
How many times have you wished you had SQL like language for querying your in memory data structures? Microsoft Visual Studio Code Name �Orcas� Language-Integrated Query or LINQ is a new feature of C# 3.0 that supports "a set of features such as lambdas, extension methods, and query comprehensions that enable compilers to understand and implement query logic over in-memory collections of objects." according to the LINQ FAQ. So what does that mean, well basically it is a language that lets you query in memory data structures like collections, XML, etc more easily. I will introduce you to LINQ and then take you on an in depth look at LINQ and its uses in this presentation.
Building Extensible Frameworks with C# and .NET
Mitch Ruebush
We will look at using .NET to build frameworks that can be easily extended in the future without having to edit the original code. We will look at a plug-in model, extensibility at the presentation level, and other methods that I will think up.
Test Driven Development w/Testdriven.net and NUnit
John Baird
This presentation will cover the basics of test driven development and demonstrate the techniques to do so with nUnit/testdriven.net. We will also show a technique for doing UI testing.
Mobile App Development with .Net Compact Framework, SQLCE and PPC’s
John Baird
This introductory presentation will cover the basics of setting up the compact framework, SQLCE, working with emulators, active sync and the differences between developing using the regular .net framework and the compact framework.
Microsoft BizTalk 2006 – Introduction
Scott McHugh
Since its release, more than 6,000 companies have experienced the value and agility that BizTalk Server 2006 delivers. That momentum was sparked by the introduction of BizTalk Server 2004, which revolutionized the integration industry. BizTalk Server 2006 builds on that heritage and core architecture to provide you with a powerful tool that uses the latest Microsoft technologies and industry standards for automating and managing business processes. The core benefits include simpler setup, comprehensive management and deployment capabilities, seamless upgrading, richer business user and developer experiences, and faster application integration. This session will provide an introduction to BizTalk Server 2006 through demonstration of an end-to-end solution depicting its capabilities, environment, tools, configuration and implementation.
Microsoft BizTalk 2006 – Commerce Server 2007 Integration
Scott McHugh
One of the most exciting new features in Commerce Server 2007 is the addition of four new BizTalk adapters that are specifically designed to make it easier to integrate Commerce Server data with other layer-of-business (LOB) systems using BizTalk Server 2006. These four adapters are designed to work with the Orders, Catalog, Inventory and Profiles subsystems, and allow Commerce Server to perform bi-directional information exchange between any number of different back-end systems. Since the overall goal of any e-commerce solution is to fulfill a customer’s order, having a means to easily integrate the web “front-end” with the ERP system’s “back-end” is vital. This session will provide an introduction to BizTalk and Commerce Server integration through demonstration of an end-to-end solution depicting its capabilities, environment, tools, configuration and implementation.
Microsoft BizTalk 2006 R2 – EDI and AS2
Harish Bidadi
Microsoft BizTalk R2 includes native support for Electronic Data Interchange (EDI) data exchange and AS2 data transport. This support enables businesses to extend their EDI-based business process management solutions, taking advantage of the productivity improvements that the automated exchange of EDI transactions provides. This session will provide an introduction to BizTalk R2 EDI and AS2 integration through demonstration of an end-to-end solution depicting its capabilities, environment, tools, configuration and implementation.
Ruby on Rails for .NET Developers
Mike Richardson
Ruby on Rails (RoR) is one of the most well thought-out web development frameworks in use today. Similar to ASP.NET, JSP/Struts, and most other web frameworks, Rails offers the promise of high productivity and reduced development time, regardless of your platform preference. The purpose of this presentation is to familiarize Microsoft.NET framework developers (and other programmers) to this new and exciting web framework. Whether you decide to use RoR for rapid prototyping of new web applications or simply to increase your knowledge of web application frameworks in general, this seminar should provide you with a solid foundation for experimentation with Ruby on Rails. This seminar will speak to fundamental principles ("Don’t Repeat Yourself" and "Convention Over Configuration") as well as illustrate such topics as scaffolding, code generation, URL routing, and code-based database associations, demonstrating how they are harnessed to support Rails’ powerful MVC-based web framework.
Working with Workflow in Microsoft Office SharePoint Server 2007
Jean Barmash
One of the best new features in the new version SharePoint is its integration with Workflow Foundation. It allows to add business processes and tracking to SharePoint, something that was done only by third parties before. There are three modes of creating workflows: there are several common workflows included out of the box, you can create simple custom workflows through SharePoint Designer and for more advanced workflows you can use Visual Studio 2005. In this session we will discuss how workflow integrates with SharePoint, look at a few sample workflows created using different methods. We will also examine the difference between the three modes of workflow creation and talk about how to combine the strengths of each to deploy solutions most rapidly.
