Session List
Full Schedule
Date/Time Session Room
10/20/2010 10:00 AM -to- 10:30 AM Keynote.
Stephen Wynkoop

Room 1
10/20/2010 10:00 AM -to- 10:30 AM Keynote
Stephen Wynkoop

Room 2
10/20/2010 10:00 AM -to- 10:30 AM Keynote
Stephen Wynkoop

Room 3
10/20/2010 10:00 AM -to- 10:30 AM Keynote
Stephen Wynkoop

Room 4
10/20/2010 10:00 AM -to- 10:30 AM Keynote
Stephen Wynkoop

Room 5
10/20/2010 10:00 AM -to- 10:30 AM Keynote
Stephen Wynkoop

10/20/2010 10:30 AM -to- 10:45 AM
Break
 

Room 1
10/20/2010 10:30 AM -to- 10:45 AM Break
 

Room 2
10/20/2010 10:30 AM -to- 10:45 AM Break
 

Room 3
10/20/2010 10:30 AM -to- 10:45 AM Break
 

Room 4
10/20/2010 10:30 AM -to- 10:45 AM Break
 

Room 5
10/20/2010 10:30 AM -to- 10:45 AM Break
 

Room 6
10/20/2010 10:45 AM -to- 11:45 AM Live - Data Mining with the Data Mining Plugin for Excel
Brian Knight
In this session, you’ll learn how to install, configure and ultimately use the Data Mining Plugin for Excel. The plugin allows you to do light to moderate data mining inside the Excel interface and simplifies a complex topic to two clicks in many cases. In this session, you’ll learn how to forecast future sales, pick the best customers to chase and how to determine where there are outliers in your data.
Room 1
10/20/2010 10:45 AM -to- 11:45 AM Back To Basics - Getting Back To The Basics of SQL Server
Denny Cherry
We will be getting back to the basics of Microsoft SQL Server and looking in depth at all of the object types within SQL Server as well as the commands to work with them.All to often people focus on the advanced high end parts of SQL Server without getting a good grounding in the basics of SQL Server.
Room 2
10/20/2010 10:45 AM -to- 11:45 AM Getting a Grip – Adventures in Multi-Server Management
Jason Strate
Today’s SQL Server environments have seen an explosion of databases without a similar increase in DBAs. This change has allowed management of non-mission-critical databases to interfere with mission-critical databases. Beginning with SQL Server 2008, a number of tools were introduced to help you take better control of your SQL Server environment and deal with “database sprawl.” Some of these tools include the advent of Policy Based Management to the addition of the Utility Control Point, in SQL Server 2008 R2. In this session, we’ll take a look at the tools already at your disposal and some free CodePlex tools that you can use to get a grip on your SQL Server environment.
Room 3
10/20/2010 10:45 AM -to- 11:45 AM Increasing Performance of Your .NET Applications: Part 1
Ben Hoelting
Caching is not new in .NET. However, it has been expanded on in 4.0. Part 1 will focus on how to implement caching to improve performance on the server and the client. Silverlight has changed the game in regards to caching. Silverlight provides access to Isolated Storage that allows us to cache data client side and not even make a round trip to the server. The demos will validate the benefits of the caching as well as demonstrate some of the pitfalls you might face when developing a caching strategy. The demoes start with a basic Silverlight application and add caching support step by step. This session will explore some of the traditional caching paradigms as well as introduce some new ones related to Silverlight.
Room 4
10/20/2010 10:45 AM -to- 11:45 AM Getting Started With SQL Azure
Glenn Alan Berry
SQL Azure is Microsoft's solution for hosting basic SQL Server relational databases in the cloud. Microsoft continues to add new features in each Azure Service Update that makes SQL Azure a more viable solution. For smaller databases that don't require features such as Reporting Services, Analysis Services, or Full Text Search, it can be an easy to use technology that can save lots of money in hardware, license and maintenance costs. This session shows you how to configure, connect to, and manage a SQL Azure database, both from SQL Server Management Studio and from a .NET application, and it gives best practices and tips on how to get the most benefit from SQL Azure.
Room 5
10/20/2010 10:45 AM -to- 11:45 AM Why Data Warehousing Projects Fail (And What You Can Do About it)
Craig Utley
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.
Room 6
10/20/2010 11:45 AM -to- 12:00 PM Break
 

Room 1
10/20/2010 11:45 AM -to- 12:00 PM Break
 

Room 2
10/20/2010 11:45 AM -to- 12:00 PM Break
 

Room 3
10/20/2010 11:45 AM -to- 12:00 PM Break
 

Room 4
10/20/2010 11:45 AM -to- 12:00 PM Break
 

Room 5
10/20/2010 11:45 AM -to- 12:00 PM Break
 

Room 6
10/20/2010 12:00 PM -to- 1:00 PM Live - Introduction to PowerPivot
Brian Knight
In this session, you’ll learn how to use PowerPivot to create self-service analytics in your organization. You’ll see how Office 2010 and SQL Server 2008 R2 will help your users answer their own questions and bring together datasets that may be heterogeneous like a SQL Server table and data feed from a website. Then, you’ll see how to take that data and create a striking report for your end users and collaborate with the data in SharePoint.
Room 1
10/20/2010 12:00 PM -to- 1:00 PM There's more to know about storage?
Denny Cherry
" That's right there is. As a followup session to the ""Storage for the DBA"" session which I gave last year. This time we will broaden the look to cover some of the different options that different storage providers are using to design their storage; as well and the pros and cons for each of these.From there we'll move into some of the more advanced features you can use with storage arrays that turn them from the large JBOD that most people think of them into advanced storage devices worth every penny that they cost."
Room 2
10/20/2010 12:00 PM -to- 1:00 PM Stored procedures best practices, including performance and nested transactions
Jeffrey Garbus
Learn the ins and outs of stored procedure coding best practices, from maintainability to performance issues.
Room 3
10/20/2010 12:00 PM -to- 1:00 PM Increasing Performance of Your .NET Applications: Part 2
Ben Hoelting
Part 1 focused on how to implement caching to improve performance on the server and the client. Part 2 will focus on caching data on the client for a different reason. Server side caching is important, but some applications need to work even when a network connection to the server is not available. This is especially true when running a Silverlight application in out of browser mode. With so many Wi-Fi hot spots and 3\4G networks these days the need to run disconnected is diminishing. The new requirement that is becoming more prevalent is the need to store data locally to increase performance. The size of today’s data is beginning to clog up the network bandwidth and developers are turning to client side data storage to reduce the traffic and speed up their applications. There are many different synchronization options to accomplish client side data storage, no matter what your reason for doing it. One of which is the new Sync Framework from Microsoft. At the end of this presentation we will explore this technology and compare it with other techniques for data synchronization and client side caching.
Room 4
10/20/2010 12:00 PM -to- 1:00 PM The business of BI: thinking through the data warehouse
Donald Farmer
Many aspects of data warehouse design are so familiar that we take them for granted. In this session we’re going to go deeper on some of these: surrogate keys, staging areas, slowly changing dimensions, and fact tables. Each of these subjects, however accustomed we are to them, is not quite so simple as they may appear. For beginners and experts, this session takes your thinking about the data warehouse to the next level.
Room 5
10/20/2010 12:00 PM -to- 1:00 PM Do It Right: Best Practices for Analysis Services 2005 and 2008
Craig Utley
Are you seeking practical, in-depth technical advice for building a BI solution using SSAS? Analysis Services changed tremendously with the advent of SQL Server 2005. It introduced a new way of building dimensions and cubes that required a new way of modeling the solution. This session examines the best practices for properly designing cubes for performance and usability. It discusses some high-level topics but also looks at advanced topics such as alternative approaches to many-to-many dimensions, SCOPE statements, aggregation design, scalability issues, processing techniques, server properties, and more. Craig Utley has been working with Microsoft’s BI products for 11 years and is a former Program Manager with the SQL Server Customer Advisory Team (SQLCAT), where he worked with some of the largest Analysis Services installations worldwide. In this session he brings his real-world experience with large, complex SSAS projects and presents best practices uncovered as companies deploy and use Analysis Services.
Room 6
10/20/2010 1:00 PM -to- 2:00 PM Networking Break
 

Room 1
10/20/2010 1:00 PM -to- 2:00 PM Networking Break
 

Room 2
10/20/2010 1:00 PM -to- 2:00 PM Networking Break
 

Room 3
10/20/2010 1:00 PM -to- 2:00 PM Networking Break
 

Room 4
10/20/2010 1:00 PM -to- 2:00 PM Networking Break
 

Room 5
10/20/2010 1:00 PM -to- 2:00 PM Networking Break
 

Room 6
10/20/2010 2:00 PM -to- 3:00 PM Live - Business Intelligence in SharePoint 2010
Brian Knight
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.
Room 1
10/20/2010 2:00 PM -to- 3:00 PM Getting SQL Service Broker Up and Running
Denny Cherry
"Microsoft SQL Server 2005 and 2008 include a fantastic feature that few people understand or use. That feature is the Microsoft SQL Server Service Broker. The SQL Service Broker is one of the least used features within the database engine, and that lack of use is simply from last of knowledge about the feature. In this session we’ll dig into how to configure the service broker for not only intra-database message queuing, but database to database queuing as well as server to server database queuing. We will also dig into a real life scenario where the SQL Server Service Broker was used to do ETL from an OLTP database to an OLAP database in near real time for near real time reporting. By the end of this session you'll understand where SQL Service Broker is the right fit to be used, and you'll hopefully be ready to deploy it within your environment. Learn about the SQL Service Broker database objects Learn how to send and receive messages within a databaseLearn how to send and receive messages between servers"
Room 2
10/20/2010 2:00 PM -to- 3:00 PM A case study on rewriting bad code
Jeffrey Garbus
Two examples of changing horrible code to good code, one example eliminates temp tables and horrible io, the other turns repeated temp table looping into a CTE
Room 3
10/20/2010 2:00 PM -to- 3:00 PM Choosing a UI Technology For Your .NET Applications
Ben Hoelting
This is the session for IT managers, Software Architects and Developers alike. In today’s world technology is changing at an incredible pace. Keeping up with the latest and greatest thing is overwhelming. As technology professionals it seems as soon as we update our skills, the next thing replaces the skill we just learned. This session will inform you on the UI technologies offered by Microsoft. The topics discussed will include ASP.NET, ASP.NET MVC, Silverlight, Windows Presentation Foundation (WPF) and some ones on the horizon. We will discuss the pros and cons of each as well as which one is best suited in certain situations. I wish I could say there is a clear winner, but the bottom line is the technology you choose depends on the requirements of the application. Attend this session to make sense of it all and gain the knowledge to make an informed decision when deciding on a UI technology.
Room 4
10/20/2010 2:00 PM -to- 3:00 PM Dr. DMV: How to Use Dynamic Management Views to Monitor and Diagnose Performance Issues With High Volume OLTP Workloads
Glenn Alan Berry
SQL Server 2005 introduced Dynamic Management Views (DMVs) that allow you to see exactly what is happening inside your SQL Server instances and databases with much more detail than ever before. SQL Server 2008 R2 adds even more capability in this area. You can discover your top wait types, most CPU intensive stored procedures, find missing indexes, and identify unused indexes, to name just a few examples. This session (which is applicable to both 2005, 2008 and 2008 R2), presents and explains over thirty DMV queries that you can quickly and easily use to detect and diagnose performance issues in your environment.
Room 5
10/20/2010 2:00 PM -to- 3:00 PM SSAS Security
Craig Utley
SQL Server Analysis Services provides a security mechanism that provides a variety of options for handling different scenarios. This session will examine standard SSAS security of both dimension members and cells, and then extend into dynamic security topics. You’ll discover how you can provide security using SSAS roles, a special dimension structure, and even external code. You’ll discover the pros and cons of each approach and understand the options available and when to use them.
Room 6
10/20/2010 3:00 PM -to- 3:15 PM Break
 

Room 1
10/20/2010 3:00 PM -to- 3:15 PM Break
 

Room 2
10/20/2010 3:00 PM -to- 3:15 PM Break
 

Room 3
10/20/2010 3:00 PM -to- 3:15 PM Break
 

Room 4
10/20/2010 3:00 PM -to- 3:15 PM Break
 

Room 5
10/20/2010 3:00 PM -to- 3:15 PM Break
 

Room 6
10/20/2010 3:15 PM -to- 4:15 PM Live - Brian Knight and Stephen Wynkoop
Brian Knight
Stephen Wynkoop
Live session and interview with Brian Knight and Stephen Wynkoop
Room 1
10/20/2010 3:15 PM -to- 4:15 PM Digging Deeper Into the Procedure Cache
Jason Strate
At the last SSWUG Virtual Conference, we scratched the surface of querying SQL Server’s procedure cache with XML. In this session, we’ll continue digging into the procedure cache to find more information regarding the performance of the SQL Server instance. We’ll look into indexes that could benefit from included columns along with the cost of operations. Armed with this information and much more you’ll be able to go deeper into your instance
Room 2
10/20/2010 3:15 PM -to- 4:15 PM Creating a preventive maintenance regimen
Jeffrey Garbus
Live example & walkthrough of a standard preventive maintenance regimen, from what you should do to what you must do, and under what circumstances
Room 3
10/20/2010 3:15 PM -to- 4:15 PM Developing a Windows Phone 7 Application in .NET
Ben Hoelting
Do you love gadgets? Do you dream of making gadgets do cool and amazing things? This is the session for you. Windows Phone 7 is the new mobile OS from Microsoft. The OS has already been released and the devices are set to hit the market for the Holidays. One of biggest stories of this ground breaking OS is app development. Developers will be able to use familiar languages and tools like C#, VB.NET, Visual Studio 2010 and Expression Blend 4 to develop applications for Windows Phone 7. In this session we will discuss how to configure your development environment for developing WP7 applications. We will also develop an application using the tools and the built in emulator. This stuff is hot off the presses and if you are a creative entrepreneur you could develop the next big thing.
Room 4
10/20/2010 3:15 PM -to- 4:15 PM Taking SSIS to the next level
Devin  Knight
This session will show you some of the more complex feature available in SSIS. These features can help your packages run more smoothly and handle problem areas better. See how to enable features like checkpoints and transactions on your packages. You will also learn how to use the native logging features to track package executions.
Room 5
10/20/2010 3:15 PM -to- 4:15 PM Delivering Self-Serve BI with PowerPivot
Craig Utley
If you are always looking for better ways to deliver value to the business as part of a BI project, make sure you examine the capabilities of PowerPivot. Using existing data and tools, users now have the ability to analyze vast quantities of data without first designing dimensions and measure groups. Users can explore the data and optionally share their analysis with others. See how PowerPivot opens the power of Analysis Services to non-technical users while still allowing the IT organization to administer and secure the data
Room 6
10/21/2010 10:00 AM -to- 10:30 AM Keynote.
Stephen Wynkoop

Room 1
10/21/2010 10:00 AM -to- 10:30 AM Keynote
Stephen Wynkoop

Room 2
10/21/2010 10:00 AM -to- 10:30 AM Keynote
Stephen Wynkoop

Room 3
10/21/2010 10:00 AM -to- 10:30 AM Keynote
Stephen Wynkoop

Room 4
10/21/2010 10:00 AM -to- 10:30 AM Keynote
Stephen Wynkoop

Room 5
10/21/2010 10:00 AM -to- 10:30 AM Keynote
Stephen Wynkoop

Room 6
10/21/2010 10:30 AM -to- 10:45 AM Break
 

Room 1
10/21/2010 10:30 AM -to- 10:45 AM Break
 

Room 2
10/21/2010 10:30 AM -to- 10:45 AM Break
 

Room 3
10/21/2010 10:30 AM -to- 10:45 AM Break
 

Room 4
10/21/2010 10:30 AM -to- 10:45 AM Break
 

Room 5
10/21/2010 10:30 AM -to- 10:45 AM Break
 

Room 6
10/21/2010 10:45 AM -to- 11:45 AM Live: GoldenGate Replication - Configuring & Monitoring
Tjay Belt

Room 1
10/21/2010 10:45 AM -to- 11:45 AM SQL Server Log Shipping and SMO
Ben Miller
Have you ever wondered what all is involved in Log Shipping? What are the moving parts? Have you ever wanted to use log shipping over a Wide Area Network (WAN) and have the database as a Warm Standby Reporting server? This presentation will mix slides with practical scripts that show you what the moving parts are and how they work to make log shipping happen. As a twist, I will go over the Powershell Component of SQL and show you how you can Log Ship over a WAN.
Room 2
10/21/2010 10:45 AM -to- 11:45 AM Migrating SharePoint 2003/2007 to SharePoint 2010
Josh Jones
With Microsoft’s latest entry in their ever growing SharePoint product line, organizations are eager to upgrade. New features such as Access Services, Excel Services, and a whole new level of Office interactivity are driving the upgrade push. In this session, come learn how you can safely upgrade your environment to get the most out of the new platform while retaining your configuration and, most importantly, your data.
Room 3
10/21/2010 10:45 AM -to- 11:45 AM The business of BI: Managing data as a business asset
Donald Farmer
How valuable is your data? Can you put a number to it? Do you really treat your data as a vital business asset? Through this sesson, we will explore what it means to invest in data as an asset of your enterprise. We’ll examine the consequences, both for business and technical users, of valuing, or too often, undervaluing, data assets. Naturally, We will also look at the Microsoft technologies and industry best practices that help you to grow, protect and invest in your business data.
Room 4
10/21/2010 10:45 AM -to- 11:45 AM Intro to MDX (Pt I): Getting Started with MDX
Bill Pearson
In this session, Part 1 of a mini-series of three parts, we will concentrate largely upon crafting simple MDX expressions and queries whose purposes, for the most part, are to return a set of data. We will overview the structure of a cube, using as a basis the sample Adventure Works cube that is available to anyone installing SQL Server Analysis Services 2008 R2. We will then outline the components of simple MDX syntax, and get started writing basic expressions and queries. We will expose basic member functions, introduce filters (or “slicers”), and begin exploring core MDX functionality, including calculated members and named sets.
Room 5
10/21/2010 10:45 AM -to- 11:45 AM Introduction to SSIS
Eric Johnson
In this session we will take a basic look at SQL Server Integration Services. We will cover Control Flow, Tasks, Transformations, Paths, and even build a simple SSIS package. By the end of the session, you should feel comfortable getting around inside of SSIS packages and be able to start exploring the more advanced features.
Room 6
10/21/2010 11:45 AM -to- 12:00 PM Break
 

Room 1
10/21/2010 11:45 AM -to- 12:00 PM Break
 

Room 2
10/21/2010 11:45 AM -to- 12:00 PM Break
 

Room 3
10/21/2010 11:45 AM -to- 12:00 PM Break
 

Room 4
10/21/2010 11:45 AM -to- 12:00 PM Break
 

Room 5
10/21/2010 11:45 AM -to- 12:00 PM Break
 

Room 6
10/21/2010 12:00 PM -to- 1:00 PM Live: Database Switch
Tjay Belt

Room 1
10/21/2010 12:00 PM -to- 1:00 PM SQL Server TDE
Ben Miller
There has not been a lot said about TDE and what it takes to set it up or what it means to your Enterprise. With data protection becoming more forefront than before, this technology can satisfy requirements of your data being Encrypted At Rest on the disk. This will be a practical demonstration of how to set it up and why you may want to use this feature.
Room 2
10/21/2010 12:00 PM -to- 1:00 PM SharePoint Administration “From Scratch”
Josh Jones
Are you one of those system administrators, developers, or DBAs who’ve been handed the responsibility of deploying or managing SharePoint? If so, then this session is for you. We’ll cover all of the bases for SharePoint Administrators, including: Pre-Installation Planning, Performing the Install, Central Administration, Site Deployment, Security, Backups, Patches and Hotfixes, and Disaster Recovery.
Room 3
10/21/2010 12:00 PM -to- 1:00 PM Agile 101 for Database Developers
Ted Malone
This session will discuss agile development techniques and how they apply to database developers. Attendees will learn how agile techniques, such as Test Driven Development (TDD) and Scrum can be implemented in a database development environment. Attendees will also learn about Visual Studio Team System 2010 for Database Developers.
Room 4
10/21/2010 12:00 PM -to- 1:00 PM Intro to MDX (Pt 2): Additional Functions & More
Bill Pearson
In Part 1 of this mini-series of three parts, we focused largely upon understanding the basic components of MDX, and began crafting simple MDX expressions and queries that generated result sets. In Part 2, we will work with slightly more sophisticated MDX syntax, and introduce additional functions (including the Date functions that are so readily useful in reporting and analysis), and then overview the concept of aggregation. 
Room 5
10/21/2010 12:00 PM -to- 1:00 PM SSIS Tips and Tricks
Eric Johnson
SSIS is a great tool for building robust ETL packages; however, even some simple tasks can be tricky. If you have been working with SSIS, you have probably noticed some quirky behavior, and to some degree become frustrated with the tool. In this session, we will identify some common problem areas and give you some tips for avoiding them. We will discuss text based data sources, sorting, package protection levels, building if then logic, and more.
Room 6
10/21/2010 1:00 PM -to- 2:00 PM Networking Break
 

Room 1
10/21/2010 1:00 PM -to- 2:00 PM Networking Break
 

Room 2
10/21/2010 1:00 PM -to- 2:00 PM Networking Break
 

Room 3
10/21/2010 1:00 PM -to- 2:00 PM Networking Break
 

Room 4
10/21/2010 1:00 PM -to- 2:00 PM Networking Break
 

Room 5
10/21/2010 1:00 PM -to- 2:00 PM Networking Break
 

Room 6
10/21/2010 2:00 PM -to- 3:00 PM Live: SQL Server Profiler & Track
Tjay Belt

Room 1
10/21/2010 2:00 PM -to- 3:00 PM SQL Server FILESTREAM
Ben Miller
SQL Server FILESTREAM is a new data type for SQL Server and has some specific benefits as well as some specific requirements to set it up and use it. I will go over how to enable it as well as how to set up a database and tables to utilize the FILESTREAM data type. I will also go over some guidelines of when you should or should not use this new data type.
Room 2
10/21/2010 2:00 PM -to- 3:00 PM Tuning SharePoint Site Performance
Josh Jones
When organizations deploy SharePoint, they often jump in head first, with no regard to future planning. Unfortunately, many of these organizations will run for 6 months, maybe even a year on a system before they start experiencing the inevitable performance problems. In this session, learn where to look first when SharePoint starts to bog down. We’ll cover server and network performance monitoring/analysis, common configuration problems, and forecasting to make sure your system stays one step ahead of the company’s needs.
Room 3
10/21/2010 2:00 PM -to- 3:00 PM Database Test Driven Development
Ted Malone
This session will cover Test Driven Development (TDD) for database developers and will introduce attendees to the Visual Studio 2010 Database toolkit. Attendees will learn how to incorporate true TDD techniques into their everyday development lifecycle, and will learn how Visual Studio 2010 and Team Foundation Server make TDD reality for database developers.
Room 4
10/21/2010 2:00 PM -to- 3:00 PM Intro to MDX, (Pt 3): More Advanced MDX Topics
Bill Pearson
Having exposed more basic MDX examples in Parts 1 and 2, we will devote Part 3 to exploring more advanced MDX syntax construction to help us meet real-world business needs. We will encounter more advanced functions, work further with calculated members and named sets (including the use of conditional logic in their creation), and overview additional concepts. We will next get some exposure to MDX scripts. Finally, we will touch upon ways can create and leverage Key Performance Indicators (KPIs).
Room 5
10/21/2010 2:00 PM -to- 3:00 PM SSIS Debugging and Troubleshooting
Eric Johnson
SSIS packages development is a lot like application development, as such you need to be able to identify and fix problems when they occur. In this session, we will look at data viewers, logging, setting breakpoints, viewing metadata and handling error output. We will focus the demos and discussion on what can go wrong, how to avoid it, and how to diagnose things when they do break. By the end of this session, you should feel comfortable identifying common issues in SSIS package.
Room 6
10/21/2010 3:00 PM -to- 3:15 PM Break
 

Room 1
10/21/2010 3:00 PM -to- 3:15 PM Break
 

Room 2
10/21/2010 3:00 PM -to- 3:15 PM Break
 
Room 3
10/21/2010 3:00 PM -to- 3:15 PM Break
 

Room 4
10/21/2010 3:00 PM -to- 3:15 PM Break
 

Room 5
10/21/2010 3:00 PM -to- 3:15 PM Break
 

Room 6
10/21/2010 3:15 PM -to- 4:15 PM Live: Tjay Belt and Stephen Wynkoop
Tjay Belt
Stephen Wynkoop

Room 1
10/21/2010 3:15 PM -to- 4:15 PM Using Data Compression and Backup Compression to Improve Performance
Glenn Alan Berry
Native Data Compression and Native Backup Compression are two very useful features that were added with SQL Server 2008 Enterprise Edition. Both of these features were improved in SQL Server 2008 R2, yet many database professionals are not familiar with how to use them effectively to reduce I/O requirements and improve overall performance. Modern multi-core processors make various forms of compression a much easier choice in many situations. Knowing how to determine which indexes are good candidates for data compression is extremely important if you want to get the best results. This session will give you real-world, practical examples and guidelines for how to take advantage of both data compression and backup compression.
Room 2
10/21/2010 3:15 PM -to- 4:15 PM Loading A Data Warehouse in SSIS
Devin  Knight
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.
Room 3
10/21/2010 3:15 PM -to- 4:15 PM Database Development and Continuous Integration
Ted Malone
This session will introduce the concept of Continuous Integration (CI) as it applies to database developers. Attendees will learn how Team Foundation Server and Team Build, along with the Visual Studio 2010 Database tools can be used to configure CI for database developers.
Room 4
10/21/2010 3:15 PM -to- 4:15 PM Introducing Attribute Discretization in Analysis Services
Bill Pearson

Attribute discretization is an often overlooked feature in Analysis Services that allows us to automatically create a manageable number of groups of attribute values that are clearly separated by boundaries. We can use discretization as a means of grouping contiguous values into sets of discrete values, via a system-generated collection of consecutive dimension members known as member groups. Discretization can help us to make it easier for information consumers to work with large numbers of possible attribute member values. In this session, we will discuss the varied options, the design (and other) considerations involved in the discretization of attributes, and best practices surrounding the use of this capability. Our focus will be upon the general exploitation of discretization to provide consumer-friendly support for the selection and delivery of enterprise data.
Room 5
10/21/2010 3:15 PM -to- 4:15 PM Building An Incremental Archive With SSIS
Jason Strate
Archiving production data can at times be a pain. The business may want some of the data or all of the data. They could want the latest version or all versions of the data. They could want 15 tables from the database and then 200 tables next week. All of these variations can at times drive us mad with building the correct solution. In this session we’ll review an incremental archiving solution. This solution is based on a previously deployed process that provided the end users what they needed while maintaining a flexible design.
Room 6
10/22/2010 10:00 AM -to- 10:30 AM Keynote.
Stephen Wynkoop

Room 1
10/22/2010 10:00 AM -to- 10:30 AM Keynote
Stephen Wynkoop

Room 2
10/22/2010 10:00 AM -to- 10:30 AM Keynote
Stephen Wynkoop

Room 3
10/22/2010 10:00 AM -to- 10:30 AM Keynote
Stephen Wynkoop

Room 4
10/22/2010 10:00 AM -to- 10:30 AM Keynote
Stephen Wynkoop

Room 5
10/22/2010 10:00 AM -to- 10:30 AM Keynote
Stephen Wynkoop

Room 6
10/22/2010 10:30 AM -to- 10:45 AM Break
 

Room 1
10/22/2010 10:30 AM -to- 10:45 AM Break
 

Room 2
10/22/2010 10:30 AM -to- 10:45 AM Break
 

Room 3
10/22/2010 10:30 AM -to- 10:45 AM Break
 

Room 4
10/22/2010 10:30 AM -to- 10:45 AM Break
 

Room 5
10/22/2010 10:30 AM -to- 10:45 AM Break
 

Room 6
10/22/2010 10:45 AM -to- 11:45 AM Live - BI in Real Time
Adam Jorgensen
Patrick LeBlanc
Have you wanted to take your BI infrastructure and implementation to the next level? Do your users want their data faster, with less latency? Are you tired of telling them they have to wait 15-30 minutes (or longer) to see what their company is doing? Authors, speakers, consultants and community pillars Adam Jorgensen and Patrick LeBlanc co-host and founder of SQLLunch.com, put their decades of expertise to work discussing and demonstrating techniques to deliver data in real time to reporting applications and dashboards.
Room 1
10/22/2010 10:45 AM -to- 11:45 AM An Introduction to Entity Framework 4
Chris Sutton

Room 2
10/22/2010 10:45 AM -to- 11:45 AM Beyond the Whiteboard: Enforcing Conceptual Integrity with Visual Studio 2010
Rick Garibay
Architecture and design decisions are made by teams every day. Whether subtle or significant, capturing these decisions in a low friction manner while making it seamless to reference is the key to ensuring that the conceptual integrity of a design survives beyond the whiteboard. Learn how to take advantage of model generation, UML 2.1 support and enforcement of separation of concerns by fully integrating these key artifacts with your application lifecycle management with Visual Studio 2010.
Room 3
10/22/2010 10:45 AM -to- 11:45 AM BizTalk Server 2010: First Looks
Brendon Birdoes
BizTalk Server is Microsoft’s solution to integrate systems in a loosely-coupled manner. The current iteration of the product introduces more than just a platform update to Visual Studio 2010 and .Net 4.0. This session will provide a BizTalk primer to help understand how the technology can be applied to solve business problems and then explore the new features in BizTalk Server 2010 including additional capabilities for Winders Server AppFabric solutions.
Room 4
10/22/2010 10:45 AM -to- 11:45 AM Patterns & Practices in Database Administration: Part 1
Kevin Kline
Mentoring for the Accidental DBA, Part 1: Context, Roles, and Responsibilities
Room 5
10/22/2010 10:45 AM -to- 11:45 AM SSIS Performance Part 1 – Tuning Tips and Tricks
Matt Masson
The first talk in the SSIS performance talk series will show you how to get the most out of your ETL investments by using proven tips and tricks put together by the SQL Customer Advisory Team (SQLCAT) and Integration Services development team. You'll learn how to create your own benchmarking platform, identify bottlenecks, optimize your environment, and incorporate parallelism into your package design. You'll also see how Microsoft set an ETL benchmark world record, and how the new Data Flow enhancements in SQL Server Integration Services 2008 will speed up your existing packages -- with no changes to your existing packages.
Room 6
10/22/2010 11:45 AM -to- 12:00 PM Break
 

Room 1
10/22/2010 11:45 AM -to- 12:00 PM Break
 

Room 2
10/22/2010 11:45 AM -to- 12:00 PM Break
 

Room 3
10/22/2010 11:45 AM -to- 12:00 PM Break
 

Room 4
10/22/2010 11:45 AM -to- 12:00 PM Break
 

Room 5
10/22/2010 11:45 AM -to- 12:00 PM Break
 

Room 6
10/22/2010 12:00 PM -to- 1:00 PM Live - Experts teaching Experts – Analysis Services
Adam Jorgensen
Patrick LeBlanc
Watch Adam Jorgensen teach SQL Server Guru Patrick Leblanc how to build a great SSAS Solution for reporting. We’ll cover the basics of building an Analysis Services solution as well as hear insightful questions from one of a real SQL Server gurus.
Room 1
10/22/2010 12:00 PM -to- 1:00 PM Entity Framework 4; Code First Development
Chris Sutton

Room 2
10/22/2010 12:00 PM -to- 1:00 PM Introducing Workflow Services in WF 4.0
Rick Garibay
There are many benefits to model-driven design, including transparency of design for multiple audiences and the simplification of low-level patterns which assist in realizing application designs that are simple to implement and understand. Come learn how simple it is to build workflow services with Windows Workflow Foundation (WF) 4.0.
Room 3
10/22/2010 12:00 PM -to- 1:00 PM Agile Management with Visual Studio 2010
Brendon Birdoes
Agile project management has definitely gained significant momentum and has moved up the adoption curve to be an accepted way to run software projects. With this evolution, Microsoft has also updated Visual Studio and Team Foundation Server to support agile processes. This session will go through a typical agile project cycle using the Scrum project methodology showcasing how the Visual Studio 2010 product portfolio supports agile teams.
Room 4
10/22/2010 12:00 PM -to- 1:00 PM Patterns & Practices in Database Administration: Part 2
Kevin Kline
Mentoring for the Accidental DBA, Part 2: Quick Rules of Thumb for the Accidental DBA
Room 5
10/22/2010 12:00 PM -to- 1:00 PM SSIS Performance Part 2 – Common Design Patterns
Matt Masson
In part 2 of this performance talk series you’ll learn how to maximize your ROI by applying trusted design patterns to your Integration Services packages. This talk has a strong focus on design patterns involving the key to performance for many ETL packages - the Lookup Transform. You'll also learn how to integrate SQL Server with you ETL processes to improve overall performance, and ways to handle common design problems, such as surrogate key generation, and how to range lookups to process late arriving facts.
Room 6
10/22/2010 1:00 PM -to- 2:00 PM Networking Break
 

Room 1
10/22/2010 1:00 PM -to- 2:00 PM Networking Break
 

Room 2
10/22/2010 1:00 PM -to- 2:00 PM Networking Break
 

Room 3
10/22/2010 1:00 PM -to- 2:00 PM Networking Break
 

Room 4
10/22/2010 1:00 PM -to- 2:00 PM Networking Break
 

Room 5
10/22/2010 1:00 PM -to- 2:00 PM Networking Break
 

Room 6
10/22/2010 2:00 PM -to- 3:00 PM Live - Experts teaching Experts – Reporting Services
Adam Jorgensen
Patrick LeBlanc
Watch Patrick LeBlanc teach Adam Jorgensen how to build a great SSRS Solution for reporting. We’ll cover the basics of building an Analysis Services solution as well as hear insightful questions from one of a real SQL Server gurus.
Room 1
10/22/2010 2:00 PM -to- 3:00 PM What's New in Report Builder 3
Chris Sutton

Room 2
10/22/2010 2:00 PM -to- 3:00 PM Building Composite Application Services with Windows Server AppFabric
Rick Garibay
Windows Server AppFabric extends the core capabilities of IIS by providing many of the cloud benefits on-premise including elastic scale and robust hosting capabilities. Come learn how Windows AppFabric can benefit your approach to building and supporting composite application services via enhanced lifetime management, tracking, persistence of long-running workflow services and caching for performance optimization.
Room 3
10/22/2010 2:00 PM -to- 3:00 PM A Lap Around WCF 4.0
Brendon Birdoes
Windows Communication Foundation is the primary framework for building distributed applications and services. The major focus of WCF 4.0 was simplifying the learning curve and increasing adoption of this core communication technology in the Microsoft .Net stack. This session will briefly explore the basics of what Windows Communication Foundation is and how Microsoft has simplified the developer experience. If you are still using class asmx to build web services, watch this session to see why it is time to finally make the leap over to WCF.
Room 4
10/22/2010 2:00 PM -to- 3:00 PM Patterns & Practices in Database Administration: Part 3
Kevin Kline
Mentoring for the Accidental DBA, Part 3: Day One for the Accidental DBA
Room 5
10/22/2010 2:00 PM -to- 3:00 PM SSIS Performance Part 3 - Advanced Design Patterns
Matt Masson
In part 3 of this performance talk series we'll continue to look at design patterns for common data integration problems. This talk will cover more advanced patterns, and how to deal with large amounts of data through partitioning, and parallel processing. We'll also take a closer look at how threading works within the SSIS data flow engine, and different patterns for handling Slowly Changing Dimensions.
Room 6
10/22/2010 3:00 PM -to- 3:15 PM Break
 
Room 1
10/22/2010 3:00 PM -to- 3:15 PM Break
 

Room 2
10/22/2010 3:00 PM -to- 3:15 PM Break
 

Room 3
10/22/2010 3:00 PM -to- 3:15 PM Break
 

Room 4
10/22/2010 3:00 PM -to- 3:15 PM Break
 

Room 5
10/22/2010 3:00 PM -to- 3:15 PM Break
 

Room 6
10/22/2010 3:15 PM -to- 4:15 PM Live - Adam Jorgensen, Patrick LeBlanc, and Stephen Wynkoop
Adam Jorgensen
Patrick LeBlanc
Stephen Wynkoop
Live session and interview with Adam Jorgensen, Patrick LeBlanc, and Stephen Wynkoop
Room 1
10/22/2010 3:15 PM -to- 4:15 PM SQL Server Database Mirroring Deep Dive
Glenn Alan Berry
Database mirroring is a valuable HA technology that can be an important component in your overall HA/DR solution. This session will cover how to effectively integrate database mirroring, fail-over clustering, log shipping and database snapshots to build a robust HA/DR solution that can meet your recovery time objective (RTO) and recovery point objective (RPO) requirements. This session goes far beyond the basics, showing you how to programatically set up, maintain and monitor database mirroring for maximum performance and reliability. Mirroring multiple databases on the same instance can be challenging from an administrative perspective, so this session has specific tips and techniques to automate this process, with practical techniques, scripts and tips to help you take advantage of database mirroring as part of an effective HA/DR strategy.
Room 2
10/22/2010 3:15 PM -to- 4:15 PM The business of BI: Data Quality today (and tomorrow)
Donald Farmer
Is your data complete, accurate, and fit for purpose? If not, in this session we’ll explain the 3 kinds of data quality you need to know about. And we’ll show you how to develop strategies and techniques for improving your data using SQL Server and Office tools. However, even if you do believe you have good data, you’ll still need to develop a strategy to maintain your data, and we can help there too. We’ll look at the tools available today, and the practical techniques and data resources you need.
Room 3
10/22/2010 3:15 PM -to- 4:15 PM Reporting Services Subscriptions
Devin  Knight
In this session, you’ll learn how to take advantage of a great feature in Reporting Services called Subscriptions. All gotcha settings will be uncovered so you can have your reports run unattended and delivered to either a windows file share or email. Then learn how to expand on the capabilities of Subscriptions by using Data Driven Subscriptions.
Room 4
10/22/2010 3:15 PM -to- 4:15 PM Patterns & Practices in Database Administration: Part 4
Kevin Kline
Mentoring for the Accidental DBA, Part 4: Four Essential Skills for the Accidental DBA
Room 5
10/22/2010 3:15 PM -to- 4:15 PM Gigs for Geeks: A Career Backup Plan for You, the IT Professional
Stan  Hustad

Room 6