Sessions - SSWUG Ultimate Virtual Conference

Session Schedule

All times are adjusted to your local timezone. Printable Schedule || Times and presenters are subject to change.
Day 1 || Day 2 || Day 3

Time

Title

Speaker

Room

10/20/2010 11:00 AM
-to-
11:30 AM

Keynote.

Stephen Wynkoop

1
10/20/2010 11:00 AM
-to-
11:30 AM

Keynote

Stephen Wynkoop

2
10/20/2010 11:00 AM
-to-
11:30 AM

Keynote

Stephen Wynkoop

3
10/20/2010 11:00 AM
-to-
11:30 AM

Keynote

Stephen Wynkoop

4
10/20/2010 11:00 AM
-to-
11:30 AM

Keynote

Stephen Wynkoop

5
10/20/2010 11:00 AM
-to-
11:30 AM

Keynote

Stephen Wynkoop

6
10/20/2010 11:30 AM
-to-
11:45 AM

Break

1
10/20/2010 11:30 AM
-to-
11:45 AM

Break

2
10/20/2010 11:30 AM
-to-
11:45 AM

Break

3
10/20/2010 11:30 AM
-to-
11:45 AM

Break

4
10/20/2010 11:30 AM
-to-
11:45 AM

Break

5
10/20/2010 11:30 AM
-to-
11:45 AM

Break

6
10/20/2010 11:45 AM
-to-
12:45 PM

Live - Data Mining with the Data Mining Plugin for Excel

Brian Knight

1

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.
10/20/2010 11:45 AM
-to-
12:45 PM

Back To Basics - Getting Back To The Basics of SQL Server

Denny Cherry

2

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.
10/20/2010 11:45 AM
-to-
12:45 PM

Getting a Grip – Adventures in Multi-Server Management

Jason Strate

3

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.
10/20/2010 11:45 AM
-to-
12:45 PM

Increasing Performance of Your .NET Applications: Part 1

Ben Hoelting

4

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.
10/20/2010 11:45 AM
-to-
12:45 PM

Getting Started With SQL Azure

Glenn Alan Berry

5

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.
10/20/2010 11:45 AM
-to-
12:45 PM

Why Data Warehousing Projects Fail (And What You Can Do About it)

Craig Utley

6

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.
10/20/2010 12:45 PM
-to-
1:00 PM

Break

1
10/20/2010 12:45 PM
-to-
1:00 PM

Break

2
10/20/2010 12:45 PM
-to-
1:00 PM

Break

3
10/20/2010 12:45 PM
-to-
1:00 PM

Break

4
10/20/2010 12:45 PM
-to-
1:00 PM

Break

5
10/20/2010 12:45 PM
-to-
1:00 PM

Break

6
10/20/2010 1:00 PM
-to-
2:00 PM

Live - Introduction to PowerPivot

Brian Knight

1

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.
10/20/2010 1:00 PM
-to-
2:00 PM

There's more to know about storage?

Denny Cherry

2

" 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."
10/20/2010 1:00 PM
-to-
2:00 PM

Stored procedures best practices, including performance and nested transactions

Jeffrey Garbus

3

Learn the ins and outs of stored procedure coding best practices, from maintainability to performance issues.
10/20/2010 1:00 PM
-to-
2:00 PM

Increasing Performance of Your .NET Applications: Part 2

Ben Hoelting

4

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.
10/20/2010 1:00 PM
-to-
2:00 PM

The business of BI: thinking through the data warehouse

Donald Farmer

5

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.
10/20/2010 1:00 PM
-to-
2:00 PM

Do It Right: Best Practices for Analysis Services 2005 and 2008

Craig Utley

6

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.
10/20/2010 2:00 PM
-to-
3:00 PM

Networking Break

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

Networking Break

2
10/20/2010 2:00 PM
-to-
3:00 PM

Networking Break

3
10/20/2010 2:00 PM
-to-
3:00 PM

Networking Break

4
10/20/2010 2:00 PM
-to-
3:00 PM

Networking Break

5
10/20/2010 2:00 PM
-to-
3:00 PM

Networking Break

6
10/20/2010 3:00 PM
-to-
4:00 PM

Live - Business Intelligence in SharePoint 2010

Brian Knight

1

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.
10/20/2010 3:00 PM
-to-
4:00 PM

Getting SQL Service Broker Up and Running

Denny Cherry

2

"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"
10/20/2010 3:00 PM
-to-
4:00 PM

A case study on rewriting bad code

Jeffrey Garbus

3

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
10/20/2010 3:00 PM
-to-
4:00 PM

Choosing a UI Technology For Your .NET Applications

Ben Hoelting

4

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.
10/20/2010 3:00 PM
-to-
4:00 PM

Dr. DMV: How to Use Dynamic Management Views to Monitor and Diagnose Performance Issues With High Volume OLTP Workloads

Glenn Alan Berry

5

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.
10/20/2010 3:00 PM
-to-
4:00 PM

SSAS Security

Craig Utley

6

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.
10/20/2010 4:00 PM
-to-
4:15 PM

Break

1
10/20/2010 4:00 PM
-to-
4:15 PM

Break

2
10/20/2010 4:00 PM
-to-
4:15 PM

Break

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

Break

4
10/20/2010 4:00 PM
-to-
4:15 PM

Break

5
10/20/2010 4:00 PM
-to-
4:15 PM

Break

6
10/20/2010 4:15 PM
-to-
5:15 PM

Live - Brian Knight and Stephen Wynkoop

Brian Knight
Stephen Wynkoop

1

Live session and interview with Brian Knight and Stephen Wynkoop
10/20/2010 4:15 PM
-to-
5:15 PM

Digging Deeper Into the Procedure Cache

Jason Strate

2

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
10/20/2010 4:15 PM
-to-
5:15 PM

Creating a preventive maintenance regimen

Jeffrey Garbus

3

Live example & walkthrough of a standard preventive maintenance regimen, from what you should do to what you must do, and under what circumstances

Sponsored by:
10/20/2010 4:15 PM
-to-
5:15 PM

Developing a Windows Phone 7 Application in .NET

Ben Hoelting

4

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.
10/20/2010 4:15 PM
-to-
5:15 PM

Taking SSIS to the next level

Devin Knight

5

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.
10/20/2010 4:15 PM
-to-
5:15 PM

Delivering Self-Serve BI with PowerPivot

Craig Utley

6

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
Day 2
10/21/2010 11:00 AM
-to-
11:30 AM

Keynote.

Stephen Wynkoop

1
10/21/2010 11:00 AM
-to-
11:30 AM

Keynote

Stephen Wynkoop

2
10/21/2010 11:00 AM
-to-
11:30 AM

Keynote

Stephen Wynkoop

3
10/21/2010 11:00 AM
-to-
11:30 AM

Keynote

Stephen Wynkoop

4
10/21/2010 11:00 AM
-to-
11:30 AM

Keynote

Stephen Wynkoop

5
10/21/2010 11:00 AM
-to-
11:30 AM

Keynote

Stephen Wynkoop

6
10/21/2010 11:30 AM
-to-
11:45 AM

Break

1
10/21/2010 11:30 AM
-to-
11:45 AM

Break

2
10/21/2010 11:30 AM
-to-
11:45 AM

Break

3
10/21/2010 11:30 AM
-to-
11:45 AM

Break

4
10/21/2010 11:30 AM
-to-
11:45 AM

Break

5
10/21/2010 11:30 AM
-to-
11:45 AM

Break

6
10/21/2010 11:45 AM
-to-
12:45 PM

Live: GoldenGate Replication - Configuring & Monitoring

Tjay Belt

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

SQL Server Log Shipping and SMO

Ben Miller

2

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.
10/21/2010 11:45 AM
-to-
12:45 PM

Migrating SharePoint 2003/2007 to SharePoint 2010

Josh Jones

3

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.
10/21/2010 11:45 AM
-to-
12:45 PM

The business of BI: Managing data as a business asset

Donald Farmer

4

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.
10/21/2010 11:45 AM
-to-
12:45 PM

Intro to MDX (Pt I): Getting Started with MDX

Bill Pearson

5

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.
10/21/2010 11:45 AM
-to-
12:45 PM

Introduction to SSIS

Eric Johnson

6

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.
10/21/2010 12:45 PM
-to-
1:00 PM

Break

1
10/21/2010 12:45 PM
-to-
1:00 PM

Break

2
10/21/2010 12:45 PM
-to-
1:00 PM

Break

3
10/21/2010 12:45 PM
-to-
1:00 PM

Break

4
10/21/2010 12:45 PM
-to-
1:00 PM

Break

5
10/21/2010 12:45 PM
-to-
1:00 PM

Break

6
10/21/2010 1:00 PM
-to-
2:00 PM

Live: Database Switch

Tjay Belt

1
10/21/2010 1:00 PM
-to-
2:00 PM

SQL Server TDE

Ben Miller

2

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.
10/21/2010 1:00 PM
-to-
2:00 PM

SharePoint Administration “From Scratch”

Josh Jones

3

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.
10/21/2010 1:00 PM
-to-
2:00 PM

Agile 101 for Database Developers

Ted Malone

4

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.
10/21/2010 1:00 PM
-to-
2:00 PM

Intro to MDX (Pt 2): Additional Functions & More

Bill Pearson

5

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.
10/21/2010 1:00 PM
-to-
2:00 PM

SSIS Tips and Tricks

Eric Johnson

6

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.
10/21/2010 2:00 PM
-to-
3:00 PM

Networking Break

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

Networking Break

2
10/21/2010 2:00 PM
-to-
3:00 PM

Networking Break

3
10/21/2010 2:00 PM
-to-
3:00 PM

Networking Break

4
10/21/2010 2:00 PM
-to-
3:00 PM

Networking Break

5
10/21/2010 2:00 PM
-to-
3:00 PM

Networking Break

6
10/21/2010 3:00 PM
-to-
4:00 PM

Live: SQL Server Profiler & Track

Tjay Belt

1
10/21/2010 3:00 PM
-to-
4:00 PM

SQL Server FILESTREAM

Ben Miller

2

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.
10/21/2010 3:00 PM
-to-
4:00 PM

Tuning SharePoint Site Performance

Josh Jones

3

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.
10/21/2010 3:00 PM
-to-
4:00 PM

Database Test Driven Development

Ted Malone

4

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.
10/21/2010 3:00 PM
-to-
4:00 PM

Intro to MDX, (Pt 3): More Advanced MDX Topics

Bill Pearson

5

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).
10/21/2010 3:00 PM
-to-
4:00 PM

SSIS Debugging and Troubleshooting

Eric Johnson

6

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.
10/21/2010 4:00 PM
-to-
4:15 PM

Break

1
10/21/2010 4:00 PM
-to-
4:15 PM

Break

2
10/21/2010 4:00 PM
-to-
4:15 PM

Break

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

Break

4
10/21/2010 4:00 PM
-to-
4:15 PM

Break

5
10/21/2010 4:00 PM
-to-
4:15 PM

Break

6
10/21/2010 4:15 PM
-to-
5:15 PM

Live: Tjay Belt and Stephen Wynkoop

Tjay Belt
Stephen Wynkoop

1
10/21/2010 4:15 PM
-to-
5:15 PM

Using Data Compression and Backup Compression to Improve Performance

Glenn Alan Berry

2

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.
10/21/2010 4:15 PM
-to-
5:15 PM

Loading A Data Warehouse in SSIS

Devin Knight

3

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.
10/21/2010 4:15 PM
-to-
5:15 PM

Database Development and Continuous Integration

Ted Malone

4

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.
10/21/2010 4:15 PM
-to-
5:15 PM

Introducing Attribute Discretization in Analysis Services

Bill Pearson

5

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.
10/21/2010 4:15 PM
-to-
5:15 PM

Building An Incremental Archive With SSIS

Jason Strate

6

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.
Day 3
10/22/2010 11:00 AM
-to-
11:30 AM

Keynote.

Stephen Wynkoop

1
10/22/2010 11:00 AM
-to-
11:30 AM

Keynote

Stephen Wynkoop

2
10/22/2010 11:00 AM
-to-
11:30 AM

Keynote

Stephen Wynkoop

3
10/22/2010 11:00 AM
-to-
11:30 AM

Keynote

Stephen Wynkoop

4
10/22/2010 11:00 AM
-to-
11:30 AM

Keynote

Stephen Wynkoop

5
10/22/2010 11:00 AM
-to-
11:30 AM

Keynote

Stephen Wynkoop

6
10/22/2010 11:30 AM
-to-
11:45 AM

Break

1
10/22/2010 11:30 AM
-to-
11:45 AM

Break

2
10/22/2010 11:30 AM
-to-
11:45 AM

Break

3
10/22/2010 11:30 AM
-to-
11:45 AM

Break

4
10/22/2010 11:30 AM
-to-
11:45 AM

Break

5
10/22/2010 11:30 AM
-to-
11:45 AM

Break

6
10/22/2010 11:45 AM
-to-
12:45 PM

Live - BI in Real Time

Adam Jorgensen
Patrick LeBlanc

1

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.
10/22/2010 11:45 AM
-to-
12:45 PM

An Introduction to Entity Framework 4

Chris Sutton

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

Beyond the Whiteboard: Enforcing Conceptual Integrity with Visual Studio 2010

Rick Garibay

3

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.
10/22/2010 11:45 AM
-to-
12:45 PM

BizTalk Server 2010: First Looks

Brendon Birdoes

4

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.
10/22/2010 11:45 AM
-to-
12:45 PM

Patterns & Practices in Database Administration: Part 1

Kevin Kline

5

Mentoring for the Accidental DBA, Part 1: Context, Roles, and Responsibilities
10/22/2010 11:45 AM
-to-
12:45 PM

SSIS Performance Part 1 – Tuning Tips and Tricks

Matt Masson

6

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.
10/22/2010 12:45 PM
-to-
1:00 PM

Break

1
10/22/2010 12:45 PM
-to-
1:00 PM

Break

2
10/22/2010 12:45 PM
-to-
1:00 PM

Break

3
10/22/2010 12:45 PM
-to-
1:00 PM

Break

4
10/22/2010 12:45 PM
-to-
1:00 PM

Break

5
10/22/2010 12:45 PM
-to-
1:00 PM

Break

6
10/22/2010 1:00 PM
-to-
2:00 PM

Live - Experts teaching Experts – Analysis Services

Adam Jorgensen
Patrick LeBlanc

1

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.
10/22/2010 1:00 PM
-to-
2:00 PM

Entity Framework 4; Code First Development

Chris Sutton

2
10/22/2010 1:00 PM
-to-
2:00 PM

Introducing Workflow Services in WF 4.0

Rick Garibay

3

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.
10/22/2010 1:00 PM
-to-
2:00 PM

Agile Management with Visual Studio 2010

Brendon Birdoes

4

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.
10/22/2010 1:00 PM
-to-
2:00 PM

Patterns & Practices in Database Administration: Part 2

Kevin Kline

5

Mentoring for the Accidental DBA, Part 2: Quick Rules of Thumb for the Accidental DBA
10/22/2010 1:00 PM
-to-
2:00 PM

SSIS Performance Part 2 – Common Design Patterns

Matt Masson

6

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.
10/22/2010 2:00 PM
-to-
3:00 PM

Networking Break

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

Networking Break

2
10/22/2010 2:00 PM
-to-
3:00 PM

Networking Break

3
10/22/2010 2:00 PM
-to-
3:00 PM

Networking Break

4
10/22/2010 2:00 PM
-to-
3:00 PM

Networking Break

5
10/22/2010 2:00 PM
-to-
3:00 PM

Networking Break

6
10/22/2010 3:00 PM
-to-
4:00 PM

Live - Experts teaching Experts – Reporting Services

Adam Jorgensen
Patrick LeBlanc

1

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.
10/22/2010 3:00 PM
-to-
4:00 PM

What's New in Report Builder 3

Chris Sutton

2
10/22/2010 3:00 PM
-to-
4:00 PM

Building Composite Application Services with Windows Server AppFabric

Rick Garibay

3

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.
10/22/2010 3:00 PM
-to-
4:00 PM

A Lap Around WCF 4.0

Brendon Birdoes

4

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.
10/22/2010 3:00 PM
-to-
4:00 PM

Patterns & Practices in Database Administration: Part 3

Kevin Kline

5

Mentoring for the Accidental DBA, Part 3: Day One for the Accidental DBA
10/22/2010 3:00 PM
-to-
4:00 PM

SSIS Performance Part 3 - Advanced Design Patterns

Matt Masson

6

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.
10/22/2010 4:00 PM
-to-
4:15 PM

Break

1
10/22/2010 4:00 PM
-to-
4:15 PM

Break

2
10/22/2010 4:00 PM
-to-
4:15 PM

Break

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

Break

4
10/22/2010 4:00 PM
-to-
4:15 PM

Break

5
10/22/2010 4:00 PM
-to-
4:15 PM

Break

6
10/22/2010 4:15 PM
-to-
5:15 PM

Live - Adam Jorgensen, Patrick LeBlanc, and Stephen Wynkoop

Adam Jorgensen
Patrick LeBlanc
Stephen Wynkoop

1

Live session and interview with Adam Jorgensen, Patrick LeBlanc, and Stephen Wynkoop
10/22/2010 4:15 PM
-to-
5:15 PM

SQL Server Database Mirroring Deep Dive

Glenn Alan Berry

2

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.

Sponsored by:
10/22/2010 4:15 PM
-to-
5:15 PM

The business of BI: Data Quality today (and tomorrow)

Donald Farmer

3

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.
10/22/2010 4:15 PM
-to-
5:15 PM

Reporting Services Subscriptions

Devin Knight

4

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.
10/22/2010 4:15 PM
-to-
5:15 PM

Patterns & Practices in Database Administration: Part 4

Kevin Kline

5

Mentoring for the Accidental DBA, Part 4: Four Essential Skills for the Accidental DBA
10/22/2010 4:15 PM
-to-
5:15 PM

Gigs for Geeks: A Career Backup Plan for You, the IT Professional

Stan Hustad

6