SSWUG.org SQL Server Virtual Conference

Session List
SESSIONS ARE STILL BEING ADDED, CHECK BACK FOR UPDATES
Session times are generated from your system clock GMT timezone. Make sure you have the proper timezone set as well as local time on your computer.
System Clock Snapshot:

Printable Version

Keyword Search:

Day 1

Day 2

Day 3

Day 1
Date/Time	Session	Description	Speaker	Rm
10/21 6:00:00 AM -to- 10/21 6:29:00 AM	Keynote		Stephen Wynkoop	A
10/21 6:30:00 AM -to- 10/21 7:29:00 AM	Live Session- Database Triggers	Triggers are one of those database objects where, if used wisely, they can be a great benefit for you system or application. And, if used poorly, they can be one of the biggest pains for your system or application. Attend this session and learn all about triggers in SQL 2008 and how they can be used effectively.	Thomas LaRock	A
10/21 6:30:00 AM -to- 10/21 7:29:00 AM	So this Query walks into a bar…	goes up to 2 tables and says, “May I Join You?” – if joins sound foreign to you, if you’re confused about inner join and outer joins, if you’d rather write a cursor to merge two tables, then this session is for you. Assuming that you’ve never heard of a join before, this session explains joins in plain English, from the natural inner join, to complex outer joins, and even theta joins.	Paul Nielsen	B
10/21 6:30:00 AM -to- 10/21 7:29:00 AM	Solving Business Pains with SQL Server Integration Services	SQL Server Integration Services (SSIS) offers a wide range of features and functionality that can be used to solve business pains within Extract, Transform, and Load (ETL) processes. These pains can be caused by the performance of current ETL process, the maintainability of ETL processes or represent a new pain that SSIS features can resolve. This presentation will provide a demonstration of real world scenarios where features of SSIS were used to solve business pains through modification of existing SSIS packages or through the creation of new SSIS packages. The session will also discuss current best practices in SSIS package design.	Jason Strate	C
10/21 6:30:00 AM -to- 10/21 7:29:00 AM	Intro SSRS 2008	Have you heard of SQL Server Reporting Services 2008 but havent taken a peek yet? Stop by for an introductory tour of this powerful and feature rich tool. We will discuss what Reporting Services is and how to get started. Well also go through several of the features and even take a high level look at the architecture.	Marc Beacom	D
10/21 6:30:00 AM -to- 10/21 7:29:00 AM	Enriching the Design of an Analysis Services Cube	In the most basic way, the Unified Dimensional Model (UDM) combines the best aspects of traditional OLAP analysis and relational reporting. In doing so it presents a "single version of the truth" that can satisfy multidimensional analysis and relationship reporting. But thats just the tip of the iceberg. The UDM can also define server-side calculations, Key Performance Indicators (KPIs), actions, perspectives, and translations to provide a richer experience than just querying for results from a database. So beyond storing your data, the UDM can store information about how our data is represented and how it should be delivered and presented to the business user. In this session, discover through theory, demonstration, and best practices discussion, how to enrich the design of the UDM beyond the data itself.	Peter Myers	E
10/21 6:30:00 AM -to- 10/21 7:29:00 AM	Capacity Planning	Capacity Planning is a process. SharePoint can be configured, deployed andused in a variety of ways. It can be used primarily as a collaborationenvironment, a corporate intranet, or even a public facing internet site.In this session we will discuss some of the various limits that you shouldbe aware of and also look at the SharePoint Compactly Planning Tool.	Shannon Bray	F
10/21 7:30:00 AM -to- 10/21 8:29:00 AM	Live Session- SQL Server Consolidation	Many companies are turning towards virtualization in an effort to consolidate their systems and reduce operational expenses. The days of excess are over, but where do you begin to start cleaning up your environment? Attend this session and become comfortable with the idea behind consolidation efforts.	Thomas LaRock	A
10/21 7:30:00 AM -to- 10/21 8:29:00 AM	The Top 10 Developer Mistakes That WIll Not Scale	Youve heard it before: "It worked fine on my machine, but the users say its too slow." Dont blame the developers: theyre using SQL Server features that look great on paper, but in reality, they wont scale up to production loads. Learn to recognize these common mistakes before they go into production, and be armed with easy fixes for:	Brent Ozar	B
10/21 7:30:00 AM -to- 10/21 8:29:00 AM	Understanding and Preventing SQL Injection Attacks	SQL Injection attacks are one of the most common hacker tricks used on the web. Learn what a SQL injection attack is and why you should be concerned about them. Through demonstrations, witness different types of SQL injection attacks, how to find them, and how to block them.	Kevin Kline	C
10/21 7:30:00 AM -to- 10/21 8:29:00 AM	Embedding Reporting Into Applications with the ReportViewer Control	Embedding reporting into Windows Forms and ASP.NET applications couldnt be simpler! The ReportViewer Control that ships with Visual Studio 2005 and 2008 provides developers with the opportunity to easily embed SQL Server Reporting Services reports into their applications. This session will explore the two process modes supported by the control: Remote and Local. This session is a must for any developer wanting to embed reporting into their .NET applications. While Reporting Services experience is not required, you will gain more from this session if you have some prior experience.	Peter Myers	D
10/21 7:30:00 AM -to- 10/21 8:29:00 AM	Add It Up: Analysis Services Aggregations	Are you looking to maximize the performance of your Analysis Services queries? This session explains what aggregations are and how they work. You’ll learn how to create aggregations, tune the aggregations based on actual usage, and design custom aggregations when necessary. You’ll discover the benefits and pitfalls of flexible aggregations, when to use rigid aggregations, and the meaning of lazy aggregation processing. You’ll dive into queries to see if aggregations are being used and learn when aggregations aren’t useful. If you thought aggregation design began and ended with the aggregation wizard, you owe it to yourself (and your cubes) to attend this session	Craig Utley	E
10/21 7:30:00 AM -to- 10/21 8:29:00 AM	Search Administration	MOSS 2007 has a powerful search engine built in. In this session we willdiscuss the various components and servers that make up your search service.You will come away with an clear understanding of exactly what is happeningunder the hood.	Shannon Bray	F
10/21 8:30:00 AM -to- 10/21 8:59:00 AM	Exhibit Hall		Stephen Wynkoop	A
10/21 9:00:00 AM -to- 10/21 10:59:00 AM	Live Session- DBA Survivor	So, you’ve decided to become a DBA. What will you do on your first day? How do you know where to focus your efforts as you start? Attend this session and learn how to better guide yourself along your new career path.	Thomas LaRock	A
10/21 9:00:00 AM -to- 10/21 9:59:00 AM	Aggravating Aggregations	So you have to write another group-by-sum-such type query and you find these queries a pain. No drama. I’ll show you exactly how they work, and how to tame the most complex aggregation query. From the basic sum() to dynamic cross-tab queries, this session sums up aggregations.	Paul Nielsen	B
10/21 9:00:00 AM -to- 10/21 9:59:00 AM	Professional Development / Social Networking	In this new age of social media, how can you leverage these tools to increase your value? Which tools are available to you, and how can you incorporate them into your busy schedule. Success stories and ideas will be shared to help you start or continue to use these tools to make yourself a better employee. Stand out in the crowd, be heard in the community, and gain the help that you need as well as helping others.	TJ Belt	C
10/21 9:00:00 AM -to- 10/21 9:59:00 AM	Developing Reports with SSRS 2008	SQL Server Reporting Services 2008 is a powerful toolset for developing feature rich reports. In this presentation, we will discuss and walk through developing reports utilizing this powerful tool. First, we will walk through and develop our first report using the Report Wizard. Then well focus in on BIDS (Business Intelligence Development Studio) and finally take a look at the Report Builder.	Marc Beacom	D
10/21 9:00:00 AM -to- 10/21 9:59:00 AM	Avoiding Common Analysis Services Mistakes	Are you concerned that the cubes you are planning to build, or that you have already built, are not performing at peak speeds or don’t give users the best analytic experience? As business intelligence (BI) grows in popularity and client tools become more powerful, more and more organizations are building data marts and data warehouses with SQL Server Analysis Services. Unfortunately, many companies new to BI with SSAS make the same mistakes over and over without realizing it. Craig Utley has seen Microsoft BI solutions at over 30 companies worldwide and has helped them overcome design and implementation issues. This session examines the common problems with the design of Analysis Services cubes and BI solutions on the Microsoft platform and gives practical advice on how to resolve these issues.	Craig Utley	E
10/21 9:00:00 AM -to- 10/21 9:59:00 AM	Configuring Search for MOSS 2007	In this session, we will discuss the various options that are available toyou as a Search Administrator. We will configure the Search components froma clean MOSS 2007 installation including building your first Shared ServiceProvider, setting up indexing schedules, scopes, and other powerful toolsbuilt into Enterprise Search.	Shannon Bray	F
10/21 10:00:00 AM -to- 10/21 10:59:00 AM	Necessarily Evils, Building Optimized CRUD Procedures	Every developer loves them and a lot of DBAs hate them. But there are many and valid reasons for creating generic SELECT, INSERT, UPDATE, and DELETE procedures. In this session, we’ll go through designing CRUD procedures that utilize new and existing SQL features to create CRUD procedures that are optimized for performance.	Jason Strate	B
10/21 10:00:00 AM -to- 10/21 10:59:00 AM	On Call Duties	When you find yourself on-call, there are many tasks that should be performed. Ensuring that you attack these duties in a coordinated and organized manner, while ensuring that you don’t get too busy with your day to day tasks is important. We’ll discuss a few ideas of tasks that should be performed. We’ll show ways that you can use to organize your on-call tasks, along with the daily results for all to keep track of. Examples of real-time on-call duties and results will be shared.	TJ Belt	C
10/21 10:00:00 AM -to- 10/21 10:59:00 AM	Managing SSRS 2008	So you know what Reporting Services is and have developed several reports by now. But whats next? We will first introduce Report Manager and then discuss how to manage your reports using the built in functionality. We will discuss some of the security features, what subscriptions and snapshots are.	Marc Beacom	D
10/21 10:00:00 AM -to- 10/21 10:59:00 AM	SSAS Performance Tuning and Scalability	More and more Analysis Services (SSAS) solutions are built each day because of the value it brings to Business Intelligence for advanced data analytics. However, many solutions run into performance problems because of high data volumes or poor design. Building a scalable SSAS solution cannot be done with the few clicks through a wizard! This session looks at the best practices for performance and tuning techniques to put your cubes on the right track to success by giving data to your users faster.	Erik Veerman	E
10/21 10:00:00 AM -to- 10/21 10:59:00 AM	Configuring the Business Data Catalog	MOSS 2007 allows you to integrate data from your line of business systems.This allows you to provide mission critical analysis of data that is onexternal systems.By planning your Business Data Catalog as part of your initial deployment,you can identify data from your LOB systems that is used on a regular basis,display this data in informative ways, and integrate this data with search.In this session we will discuss how the BDC works and you will come awaywith an understanding on how to configure it and use the BDC web parts.	Shannon Bray	F
10/21 11:05:00 AM -to- 10/21 12:05:00 PM	Live Q&A	Questions and Answers - Live Session	Stephen Wynkoop	A

Day 2
Date/Time	Session	Description	Speaker	Rm
10/22 6:00:00 AM -to- 10/22 6:29:00 AM	Keynote		Stephen Wynkoop	A
10/22 6:30:00 AM -to- 10/22 10:59:00 AM	Live Session - SQL Server Analysis Services: An examination of real-world performance tuning techniques	• Cube Design techniques – Prior to discussing measurement and tuning, we will discuss some common mistakes made within SSAS cube designs, and we will point out how to recognize these issues in production.• Partitioning and Aggregation Strategies – Here we will cover various aspects of partition and aggregation design and how to recognize inefficiencies in production• SSAS Cache – Here we will deep dive into the SSAS query cache, and how warming the cache might not be the most optimal strategy for tuning• Hardware Design Strategies – Here we will discuss the pros and cons of various hardware configurations, and why this is not the same as tuning a relational engine• Performance Tuning Tools – Here we will discuss both included as well as 3rd party performance tuning tools, and demonstrate various design and operation inefficiencies	Ted Malone	A
10/22 6:30:00 AM -to- 10/22 7:29:00 AM	Be Prepared for the New Virtual Reality	SQL Server does indeed work in virtual environments: the catch is that it doesnt always work well. After years of working with SQL Servers running inside VMware and Hyper-V, Brent has gained valuable experience and learned some ugly lessons that he will pass on to you during this session. He will explain:	Brent Ozar	B
10/22 6:30:00 AM -to- 10/22 7:29:00 AM	The Sci-Fi Database	Normalization and the relational database are thirty-something, so you’d think that the world of databases is a stable gray-haired marketplace. However, the database for my vertical application I’m building today looks nothing like the databases I built 10 or even 5 years ago. In this sci-fi session, I’m going to put on my Spock ears, dig out my copy of the Asimov’s Second Foundation, and prognosticate the future of the database.	Paul Nielsen	C
10/22 6:30:00 AM -to- 10/22 7:29:00 AM	DW Dimension Table ETL with SSIS	This session is focused on using SSIS to process Data Warehouse dimension table data. You will learn about the loading techniques for handling various changing dimensions type scenarios with SQL Server 2005/2008 Integration Services (SSIS). This session also will consider how you can design dimension processing in SSIS with performance, scalability, and flexibility in mind. Besides considering best practices for handling dimension change types and fact lookups, the session will also cover high volume dimension counts and alternates to using the built-in Slowly Changing Dimension.	Erik Veerman	D
10/22 6:30:00 AM -to- 10/22 7:29:00 AM	Performance Tuning SQL Server Integration Services SSIS	In this demo-rich presentation, Brian shows you some of the common and not so common ways to tune SQL Server Integration Services (SSIS). Learn how to tune the data flow using some of the advanced SSIS options and how to avoid common SSIS mistakes. See how to measure performance and how to keep SSIS from monopolizing your servers resourcing. Lastly, discover SQL Server 2008 features that will make SSIS more efficient.	Brian Knight	E
10/22 6:30:00 AM -to- 10/22 7:29:00 AM	Developing and Deploying an On-Premise .NET Application with Azure Table Storage	Azure Table Storage provides a scalable data access solution for applications hosted on-premise or in the Azure cloud. Learn how to get up and running with Table Storage with a look at building entities, provisioning Table Storage locally in Development Storage and in Azure Table Storage along with techniques for maintaining a consistent development experience when developing locally or against the cloud.	Rick Garibay	F
10/22 7:30:00 AM -to- 10/22 8:29:00 AM	DBA Checklist	If you’re new to SQL Server, one of the first things you should learn is the basic DBA checklist. Buck Woody, Microsoft’s “Real World DBA” will show you a checklist you should follow for basic system security and maintenance, and also explain resources for each line. You’ll learn what you need to do and when you need to do it for basic system management. Part of our “101” series.	Buck Woody	B
10/22 7:30:00 AM -to- 10/22 8:29:00 AM	TBD	TBD	Stephen Wynkoop	C
10/22 7:30:00 AM -to- 10/22 8:29:00 AM	Upgrading DTS Packages to SSIS	The Microsoft “End of Life” policy for SQL 2000 has encouraged many organizations to seriously look at migrating their SQL2000 servers to SQL2005 or 2008. One of the biggest obstacles to a rapid migration is the DTS package issue. To gain the performance benefits and a supported path forward for the functionality in DTS, these packages should be converted into native SSIS. As we all know, the conversion is NOT straightforward. SSIS is more powerful and significantly different from DTS. Join us as SQL Server and author, Brian Knight shares his knowledge about	Brian Knight	D
10/22 7:30:00 AM -to- 10/22 8:29:00 AM	7 Extraordinary Things To Do With Integration Services	In this demo-packed session you will be introduced to 7 capabilities of Integration Services that will help you improve your developer productivity and your package designs. Comprehensive demonstrations will include profiling data, performing fuzzy operations, removing duplicates, configuring Slowly Changing Dimensions, exporting BLOBs, integrating data mining results, handling errors and invoking web methods.	Peter Myers	E
10/22 7:30:00 AM -to- 10/22 8:29:00 AM	Developing and Deploying a WCF Application with Azure Compute Services and Azure Table Storage.	The Azure Compute Service provides robust hosting capabilities of you .NET application in the Azure operating system. Learn about Web Roles and Worker Roles and how to configure your .NET application for deployment to Windows Azure. We will also explore techniques for consuming data via Azure Table Storage and put at all together and deploy the application live to Windows Azure.	Rick Garibay	F
10/22 8:30:00 AM -to- 10/22 8:59:00 AM	Exhibit Hall		Stephen Wynkoop	A
10/22 9:00:00 AM -to- 10/22 9:59:00 AM	Files and File Groups	Every DBA needs to learn the basics about how the data is stored on the local disks or SAN subsystem to effectively plan for growth, tune systems, or perform maintenance. Buck Woody, Microsoft’s “Real World DBA” will show you a no-nonsense explanation on the I/O substructure, and where you can learn more about this important component of SQL Server. Part of our “101” series.	Buck Woody	B
10/22 9:00:00 AM -to- 10/22 9:59:00 AM	SQL Server Logical Query Processing	The first noticeable aspect of SQL that is different than other programming languages is the order in which the code is processed. In most programming languages, the code is processed in the order in which it is written. In SQL, the first clause that is processed is the FROM clause, while the SELECT clause, which appears first, is processed almost last. The following presentation will be a brief description of the different logical steps applied in both SQL Server 2000 and SQL Server 2005.	TJ Belt	C
10/22 9:00:00 AM -to- 10/22 9:59:00 AM	DW Fact Table ETL with SSIS	This session will apply SSIS to Data Warehouse fact table loading scenarios, discussing and demonstrating techniques for handling the various aspects of fact table ETL. You will learn how to develop fact processing packages in SSIS that are designed for performance, scalability, and flexibility. The common areas of fact table ETL involve acquiring dimension key, changing fact table source grain, calculating measures with efficiency, and tracking lineage from your source systems. This session will also highlight designing efficient processes for high volume scenarios including table partition handling.	Erik Veerman	D
10/22 9:00:00 AM -to- 10/22 9:59:00 AM	Administrating SQL Server Integration Services (SSIS)	In this session for DBAs, Brian Knight shows you how to configure your SSIS packages for a zero-touch deployment. Then Brian covers how to deploy, schedule and administer SSIS in production.	Brian Knight	E
10/22 9:00:00 AM -to- 10/22 9:59:00 AM	ESB Toolkit 2.0 Overview	An Enterprise Service Bus (ESB) is an architectural pattern and a key enabler in implementing the infrastructure for a service-oriented architecture (SOA). The ESB Toolkit for BizTalk Server 2009 implements best practices and patterns for building loosely coupled service oriented solutions using BizTalk as the bus. The ESB Toolkit 2.0 is one of the best new features of Microsoft BizTalk Server 2009! Join Brendon as he explains what the ESB Toolkit is, explores the features and capabilities and discusses the benefits of using the Toolkit for your BizTalk solutions.	Brendon Birdoes	F
10/22 10:00:00 AM -to- 10/22 10:59:00 AM	Learning more about SQL Server – Building a Plan	There’s a lot to learn about SQL Server – that’s why you’re here! Buck Woody, Microsoft’s “Real World DBA” will show you where to start learning about this product, using the web, books, conferences and more. Part of our “101” series.	Buck Woody	B
10/22 10:00:00 AM -to- 10/22 10:59:00 AM	Database Change Process	All databases receive changes from time to time. To protect the systems, we need to ensure that we follow best practices, along with our company’s processes and policies while releasing these changes. There are many ways to accomplish these goals. Many different applications can be used to reach these goals. Even manual systems can be implemented to push code. We’ll talk about a few ideas that I have witnessed, implemented, and followed as a Production DBA. Hopefully, you will be able to learn ideas to help out your systems.	TJ Belt	C
10/22 10:00:00 AM -to- 10/22 10:59:00 AM	SSAS Cube and Dimension Processing with SSIS	If you are using Analysis Services (SSAS) as part of your Business Intelligence Solution, then you will need to include in your ETL process a way to load data into SSAS. Effective data processing can be handled with SSIS as part of your recurring ETL. There are seveal methods in SSIS to process cubes and dimension, such as the built in SSAS processing task or the SSAS execute DDL task. But often times youll have advanced requirements like managing cube partitions or performing custom processing, which may require scripting or other alternatives. This session considers the best ways to use SSIS to process your cube data.	Erik Veerman	D
10/22 10:00:00 AM -to- 10/22 10:59:00 AM	Loading a Data Warehouse in SSIS	In this session, you’ll learn how to load a data warehouse using SQL Server Integration Services (SSIS). He’ll first cover the terminology to be expected when creating and loading a data warehouse. Then, you’ll learn the benefits and pitfalls of using the Slowly Changing Dimension transform (SCD Wizard) in SSIS and some alternatives to speeding up the load. Lastly, he’ll cover how to load the fact table and some alternatives to speeding up the load.	Brian Knight	E
10/22 10:00:00 AM -to- 10/22 10:59:00 AM	Implementing Messaging Solutions Using ESB Toolkit 2.0	Itinerary based routing is the key pattern in delivering solutions in the ESB Toolkit 2.0. The challenge though is how to take a traditional BizTalk scenario and implement it using the ESB Toolkit and itinerary based routing. This session will walk through a real world scenario and iteratively build the solution from a simple itinerary to a more complex itinerary including some of the more advanced capabilities of the Toolkit. This session will also take a closer look at the best new feature of the ESB Toolkit which is the Itinerary Designer that is fully integrated into Visual Studio 2008. If you are a BizTalk developer and would like to get an idea of the Toolkit development experience, this is a must see.	Brendon Birdoes	F
10/22 11:05:00 AM -to- 10/22 12:05:00 PM	Q&A	Questions and Answers - Live Session	Stephen Wynkoop	A

Day 3
Date/Time	Session	Description	Speaker	Rm
10/23 6:00:00 AM -to- 10/23 6:29:00 AM	Keynote		Stephen Wynkoop	A
10/23 6:30:00 AM -to- 10/23 7:29:00 AM	Live Session- Deploying ASP.NET Applications the Easy Way w/VS 2010	Deploying ASP.NET applications has been a bane to developers everywhere. Configuration, security and other inconsistencies between the development machine and server cause problems that can take hours to figure while dealing with local and remote instances of IIS can be nerve wracking at best. In this session you’ll see how to easily deploy ASP.NET web applications using Visual Studio 2010’s new deployment features such one-click publishing, web.config transformations and creating packages. We’ll also look at database deployment and utilities to help keep your packages in sync.	Rachel Appel	A
10/23 6:30:00 AM -to- 10/23 7:29:00 AM	Data Policies	Not every data rule can, or should , be implemented using constraints. For my vertical app, I’ve implemented a Data Policies feature that checks for questionable data, alerts the user, and monitors when the data is fixed. For example, if an order has not order details rows, or a customer hasn’t placed an order in 6 months, or a customer crossed a threshold and became a major customer. In this session I’ll show you how to build your own data policy feature for your database.	Paul Nielsen	B
10/23 6:30:00 AM -to- 10/23 7:29:00 AM	Performance Tuning for Race Car Drivers	Times are tough even for the best drivers: Helio Castroneves is dancing for money and Danica Patrick is doing ads for what appears to be an adult services company. Maybe its time to switch careers, and Brent has just the thing. Use your hard-earned knowledge of high speeds, million-dollar hardware and surviving disastrous crashes to become a SQL Server DBA!	Brent Ozar	C
10/23 6:30:00 AM -to- 10/23 7:29:00 AM	Intro to SSAS 2008	By now you have probably already heard about Analysis Services. Maybe youve even said to yourself that you were going to learn more about it but just havent found the time. The biggest barrier to learning something new is figuring out the first few steps. But where do you begin? Come learn those first few steps by attending this presentation. We will discuss what Analysis Services is, where it shines and more importantly, how to get started.	Marc Beacom	D
10/23 6:30:00 AM -to- 10/23 7:29:00 AM	Get ready for Microsoft Project Gemini	Project Gemini is a entirely new generation of analytic technology - an Excel add-in of unprecedented analytic power. Business users can work with 100s of millions of rows of data in the Excel environment: and they can share their analyses on Sharepoint with refreshable data sources, and a thin client experience for others. So, given this remarkably new product, how do you prepare your infrastructure, your data and your users (always the most difficult) for the world of Gemini? This session will describe the Gemini infrastructure and the tools which Microsoft delivers for the IT professional working with Gemini. We also explore the impact of Gemini on business users, with a view to helping you prepare your data governance processes for the various ways in which Gemini users can source, integrate and share data and analyses. Its an essential session as you prepare for SQL Server 2008 R2.	Donald Farmer	E
10/23 6:30:00 AM -to- 10/23 7:29:00 AM	Introduction to ADO .Net Sync Services	The ability to support mobile and remote workers is becoming more and more important for organizations every day. It is critical that organizations ensure users have access to the same information they have when they are in the office. In today’s discussion we will see how Sync Services for ADO.NET which is a part of the Microsoft Sync Framework (MSF) enables synchronization of information between database systems and how Sync Services for ADO.NET helps developers avoid many of the common issues associated with taking data offline.	Vishal Shukla	F
10/23 7:30:00 AM -to- 10/23 8:29:00 AM	Live Session - It’s the Least You Can Do: Improve Security in Your ASP.NET Applications	Come hear about the top overlooked security issues plaguing ASP.NET applications today and what you can do to prevent them. Some of the most common development errors have been extracted from the SANS institute’s report on the “Top 25 Most Dangerous Programming Errors” for use in this session. Of these you’ll learn how to prevent SQL injection attacks, bad cryptography, hard coded, clear text or weak passwords. We’ll also review preventing improper encoding and validation. Other techniques discussed in this session are how to implement proper access control to resources and properly enforce validation. You’ll be able to start applying strong security principles and techniques when you leave this session	Rachel Appel	A
10/23 7:30:00 AM -to- 10/23 8:29:00 AM	Improving Daily Imports with Partitioned Tables	At some point, everyone struggles with loading data to OLTP systems. The business needs the data loaded so that users can work through the data. But the users can’t afford the downtime to get the data into the production tables. In this session we’ll review this problem and how to use partitioning to alleviate this issue.	Jason Strate	B
10/23 7:30:00 AM -to- 10/23 8:29:00 AM	SQL Statement Tuning with Query Optimizer Strategies	The SQL Server query optimizer is the single most important technology within the query processing engine. It decides exactly how any given SQL statement is executed. If you want to write fast SQL statements with the least amount of contention on other sessions, you need to have a good understanding of how the query optimizer works. This session teaches you how the query engine works using a broad variety of examples that are examined in great detail.	Kevin Kline	C
10/23 7:30:00 AM -to- 10/23 8:29:00 AM	PerformancePoint Services 101	Are you interested in PerformancePoint Services but don’t know where to start? PerformancePoint Services is Microsoft’s business intelligence (BI) delivery tool that focuses on two major areas: Monitoring, and Analytics. This session provides an overview of PerformancePoint Services by showing examples of both areas. See how to build scorecards using the monitoring server and create reports and integrate with ProClarity in the analytics portion. If your organization has already built a warehouse or is thinking about it, see how Microsoft’s PerformancePoint Services enable delivery of data to a variety of users.	Craig Utley	D
10/23 7:30:00 AM -to- 10/23 8:29:00 AM	Data mining for DBAs	In the past data mining has been seen as a topic for the highly specialized and qualified analyst. Microsoft has done some important work in broadening the user base of our data mining technololgy, with APIs for developers and Excel Add-ins for power users. However, someone has to support these users, and that task often falls to the DBA. In this session well explain the underpinnings of the data mining platform and the tools and techniques available to help you better support your analysts. But hey ... its not all about supporting others. Well also show you some powerful ways in which data mining can help the DBA directly - by finding patterns and relationships in server performance and management data that can assist you to make more effective operational decisions.	Donald Farmer	E
10/23 7:30:00 AM -to- 10/23 8:29:00 AM	Introduction to Sketch flow	Have you ever got involved with preparing a prototype of a system for the client, if yes the Sketch flow is for you. With the release of Expression Blend 3 Microsoft is shipping a very exciting product called Sketch flow, in this presentation we will take a look at how easily one can create a prototype for any new system and can make it interactive with client so that the client can even give their feedback.	Vishal Shukla	F
10/23 8:30:00 AM -to- 10/23 8:59:00 AM	Exhibit Hall		Stephen Wynkoop	A
10/23 9:00:00 AM -to- 10/23 9:59:00 AM	Live Session- What’s New in ASP.NET 4.0	TBA	Rachel Appel	A
10/23 9:00:00 AM -to- 10/23 9:59:00 AM	Are You Following Your Own Best Practices?	Everyone has their own best practices that they try to follow. But often times we aren’t sure how well we are following our own or industry best practices. In this session we’ll go into monitoring and managing best practices throughout your environment. The session will look at how to create a solution using policy based management and other tools to report on your compliance to best practices.	Jason Strate	B
10/23 9:00:00 AM -to- 10/23 9:59:00 AM	SQL Statement Tuning with Showplan	The SQL Server query optimizer is the single most important technology within the query processing engine. It decides exactly how any given SQL statement is executed. One of the most useful tuning steps you can take when assessing the performance of a query is to examine its query plan. However, the query plan is full of jargon and obscurely defined operations. This session will take you through the basics of reading and understanding query plans, as well as covering the steps which indicate good performance and poor performance. When you’re done with this session, you will have a working knowledge of tuning SQL queries using the SET SHOWPLAN command and using the Graphic Showplan utility within SQL Server.	Kevin Kline	C
10/23 9:00:00 AM -to- 10/23 9:59:00 AM	Why Data Warehousing Projects Fail (And What You Can Do About It)	Is your organization planning to build a data warehouse or BI solution? Data warehousing projects, like many large IT projects, have high failure rates. While the exact rate of failure for data warehousing projects is difficult to pin down, the causes of these failures fall into a small number of categories. It is obviously possible to successfully complete a data warehousing project and deliver value to the business. Craig Utley has seen Microsoft BI solutions in various states of completeness at over 30 companies worldwide and has seen some awesome successes and some spectacular failures. This session addresses the reasons data warehousing projects fail and how you can succeed in overcoming these obstacles.	Craig Utley	D
10/23 9:00:00 AM -to- 10/23 9:59:00 AM	Financial analytics with SQL Server Analysis Services	One of the most common applications of Analysis Services in Business is to handle financial analytics - from the simplest budgeting scenario to the most complex multi-currency and account analyses. In this session, well look in detail at common financial calculations in Analysis Services, including parallel periods, running sums, currency conversions and more. Well explore the use of writeback for budgeting and what-if calculations. And well look at time intelligence as it applies to the financial analyst, covering topics such as financial calendars, and how to calculate closing and opening balances. All this with many examples and demos.	Donald Farmer	E
10/23 9:00:00 AM -to- 10/23 9:59:00 AM	Introduction to Entity Framework	Integrating the Database development and schema information into your front end development has always been a challenge. There has been a disconnect between 2, whenever objects on database side changes at schema level the process of informing the application development team has been manual and causes many problem. The entity framework was designed with the idea of bridging that gap, where the Solution Architect, DBAs and the application designers can all talk using same interface and your editor is aware of the database schema at design it. In this session we will take a high level overview of what entity framework has to offer for application developers.	Vishal Shukla	F
10/23 10:00:00 AM -to- 10/23 10:59:00 AM	Live Session- Get jQuery().ready; with Rachel Appel	Query aims to redefine the way we write JavaScript, and now with support built into Microsoft Visual Studio, you can more easily write client-side scripts than ever before. In this session, you will learn the basics of jQuery starting with downloading & installing jQuery. We’ll then move onto topics such as unobtrusive JavaScript, using jQuery wrapped sets and selectors, creating animations, and common scripting tasks.	Rachel Appel	A
10/23 10:00:00 AM -to- 10/23 10:59:00 AM	Resource Governor	SQL Server 2008 introduces great new features for performance tuning and management. The SQL Server Resource Governor is a feature that can help you do both – by limiting and controlling the CPU and Memory resources for a user or group of users, and you can even use it with “canned applications”, when you can’t change the code. Buck Woody, Microsoft’s “Real World DBA” will give you an overview of the Resource Governor, show you how and when to implement it, and where you can learn more.	Buck Woody	B
10/23 10:00:00 AM -to- 10/23 10:59:00 AM	SQL Statement Tuning with Indexing Strategies	Few things influence the speed and performance of SQL statements within SQL Server as much as indexes. This session will help you understand the basics of good index strategies and the direct impact your indexing strategy has on queries. This session uses a variety of examples to show exactly how indexes can affect query performance, as well as shows a variety of ways that queries can be written to leverage the indexes that are in place	Kevin Kline	C
10/23 10:00:00 AM -to- 10/23 10:59:00 AM	Enhancing Application Design with SQL Server Data Mining	Data mining as a technology is designed to analyze large volumes of data looking for patterns that accurately predict behaviour. These patterns can then be used to derive knowledge about data, and in turn this knowledge can be used to enhance application designs and the user experience. In this presentation, you will be introduced to Microsoft SQL Server 2005 and 2008 Data Mining and demonstrations on how to develop data mining models that can be embedded into your applications. Demonstrations are based on SQL Server 2008 Data Mining using Microsoft ASP.NET. This presentation is a must for any developer looking to embed “Artificial Intelligence” into their solution design to take their applications to the next level. It is guaranteed to thrill you with potential, and excite you with the ease in which it can be accomplished. Note that there is no requirement that attendees have any data mining background. Be warned that this session includes numerous demonstrations that show you how to embed data mining into your application designs. The demonstrations range from simple (involving no code!) to more sophisticated examples.	Peter Myers	D
10/23 10:00:00 AM -to- 10/23 10:59:00 AM	Full Spectrum Business Intelligence – aligning IT and Business in the new world of data	As businesses depend ever more on analytics to stay sharp and active, IT pros are faced with ever more demands: to provide Data Warehouses and Enterprise Reporting, to support Self-Service BI, to manage Master Data, Data Quality, Security, High Availability and more. In this session we explore ways in which you can develop a strategy that puts you ahead of the curve, when it comes to meeting these business needs. We’ll show how the various elements of the Microsoft Business Intelligence stack work together, how to phase implementations effectively for you and your users, and how to maximize the re-use of data, tools and resources. Demos will include new features of both SQL Server and Microsoft Office, along with new ways of making the most of existing features.	Donald Farmer	E
10/23 10:00:00 AM -to- 10/23 10:59:00 AM	What’s new in Visual Studio 2010 and .net 4.0	In this session we will take a look at the new IDE for Visual Studio 2010 and all the cool new features that it offers. We will also take a look at some of the new features in the .net framework itself (4.0) and what’s new in VB 2010.	Vishal Shukla	F
10/23 11:05:00 AM -to- 10/23 12:05:00 PM	Q&A	Questions and Answers - Live Session	Stephen Wynkoop	A