| Full Schedule | ||
| Date/Time | Session | Room |
| 4/20/2011 9:00 AM -to- 9:15 AM | Opening Remarks |
Room 1 |
| 4/20/2011 9:30 AM -to- 10:30 AM | Keynote. Stephen Baker Day 1 - Watson Computer session |
Room 1 |
| 4/20/2011 10:30 AM -to- 10:45 AM | Break |
Room 1 |
| 4/20/2011 10:30 AM -to- 10:45 AM | Break |
Room 2 |
| 4/20/2011 10:30 AM -to- 10:45 AM | Break |
Room 3 |
| 4/20/2011 10:30 AM -to- 10:45 AM | Break |
Room 4 |
| 4/20/2011 10:30 AM -to- 10:45 AM | Break |
Room 5 |
| 4/20/2011 10:30 AM -to- 10:45 AM | Break |
Room 6 |
| 4/20/2011 10:45 AM -to- 11:45 AM | Using SQL Server Denali's Always on Denny Cherry Kevin Kline In this session we will look at the features which are provided with Microsoft SQL Server ""Denali"" as part of the ""Always On"" features including site to site configurations to allow of a large scale high availability solution without the need for any high end SAN storage solution. Additionally we will be looking at the ability to have redundant servers which can be used for reporting or for taking your backups reducing the load from the production database. Learn how to setup ""Always On"" Lean how to leverage ""Always On"" to increase production performance by offloading reporting and backups. |
Room 1 |
| 4/20/2011 10:45 AM -to- 11:45 AM | Growth Pains; Part 1 Christopher Shaw |
Room 2 |
| 4/20/2011 10:45 AM -to- 11:45 AM | Building Occasionally Connected Hybrid Applications Rick Garibay Keeping applications and devices synchronized with a company’s back office is a common challenge. Retail, transportation and oil and gas are just a few industries that rely on the ability of software solution deployed outside of the data center to be respond to external events that may occur virtually anywhere. As organizations move certain assets to the cloud, occasionally connected applications are becoming the norm, creating a new breed of hybrid applications. In this session, learn how to implement a sophisticated pattern for enabling push synchronization across your applications and services using Microsoft Sync Framework and WCF 4. |
Room 3 |
| 4/20/2011 10:45 AM -to- 11:45 AM | Backup and Restore with Powershell Ben Miller Eric Johnson Backups are common things that we think about every day. Restores are critical to recovery or refreshing other environments. But there is more to the Backups and Restores than just doing them. What other information is lurking in a Backup? This session will dive into the Backup and Restore objects in SMO and with Powershell we will see a wealth of information inside. |
Room 4 |
| 4/20/2011 10:45 AM -to- 11:45 AM | Intro To Agile For DBA’s and Developers Llewellyn Falco Eric Johnson We hear so much about agile these days. Which practices are here to stay, which will help you to improve, and which are only temporary fads? This session will help to show some of the core principles of Agile which can help you in understand which practices and which parts are right for you. Using real world examples we will show where development can go wrong and how specific agile practices can address these problems. Both situation and code examples will be used. |
Room 5 |
| 4/20/2011 10:45 AM -to- 11:45 AM | 15 Things I learned about Silverlight Michael Crump This session is great for an audience that has never worked with Silverlight. It describes my real-world experience developing for Silverlight 4. It should help the audience avoid some of the beginner mistakes with working with Silverlight. |
Room 6 |
| 4/20/2011 11:45 AM -to- 12:00 PM | Break |
Room 1 |
| 4/20/2011 11:45 AM -to- 12:00 PM | Break |
Room 2 |
| 4/20/2011 11:45 AM -to- 12:00 PM | Break |
Room 3 |
| 4/20/2011 11:45 AM -to- 12:00 PM | Break |
Room 4 |
| 4/20/2011 11:45 AM -to- 12:00 PM | Break |
Room 5 |
| 4/20/2011 11:45 AM -to- 12:00 PM | Break |
Room 6 |
| 4/20/2011 12:00 PM -to- 1:00 PM | Using Storage to Increase Database Performance Denny Cherry Kevin Kline In this session we'll look at some ways that your storage solution can be configured to increase database performance. We'll look at some of the things to lok at when selecting the correct RAID level to use, as well as how to setup the cache in your storage array or DAS. We'll then look at some of the newer technologies like FLASH Cache to improve even more the caching abilities of the storage arrays. We'll finish up with looking at some of the differences between iSCSI and Fibre Channel and the use of Tiered storage from both a performance and finance perspective. |
Room 1 |
| 4/20/2011 12:00 PM -to- 1:00 PM | Growth Pains; Part 2 Christopher Shaw This 2 part session address many of the issues that you may come across as you work on a database that grows over time. We will look at not only the technical issues you may face, but non-technical as well. Each of the issues will be presented to you in a format that offers not only the issues but the resolutions as well. A few of the issues we will review include database design, change management, security, and Maintenance. |
Room 2 |
| 4/20/2011 12:00 PM -to- 1:00 PM | Building Composite Enterprise Hybrid Services with AppFabric and BizTalk 2010 Rick Garibay AppFabric and BizTalk 2010 provide a comprehensive middleware platform for developing, deploying, and managing composite enterprise capabilities both on-premise and in the cloud. Come learn how AppFabric and BizTalk Server can benefit your approach to building and supporting application services at enterprise scale while transcending traditional trust boundaries and enabling the hybrid enterprise. |
Room 3 |
| 4/20/2011 12:00 PM -to- 1:00 PM | Beyond Plateaux: Optimize SSAS via Best Practices Bill Pearson Adam Jorgensen Whether we inherit our Analysis Services environments from predecessors or create them - learning as we go - ourselves, we often conclude that performance (processing and / or querying) and functionality can be enhanced. In this session, Microsoft BI Architect and SQL Server MVP Bill Pearson overviews ways to launch new capabilities and to propel performance beyond its current plateau, using design best practices to better meet consumer performance and functional needs. This is the initial session of a set of detailed Best Practices presentations |
Room 4 |
| 4/20/2011 12:00 PM -to- 1:00 PM | Capturing Requirements with User Stories Llewellyn Falco Eric Johnson Before you could even talk people have been telling you stories. Human are uniquely adapted to understand and conveying ideas and situations via stories. Requirements, on the other hand, tend towards a more mathematical side of our brain. One that few people and truly good at creating, and yet we constantly go to this format when asking users & customers what they want. This session will show how easy it is to quickly get complete specs by turning to stories and examples instead. |
Room 5 |
| 4/20/2011 12:00 PM -to- 1:00 PM | Tools and Utilities for the .NET Developer Michael Crump This is usually one of my favorite sessions because it shows the tools that I use at a .NET developer to do my job day in and day-out. The audience usually leaves with a better understanding of some of the FREE tools available for .NET developers. |
Room 6 |
| 4/20/2011 1:00 PM -to- 2:00 PM | Exhibit Hall |
Room 1 |
| 4/20/2011 2:00 PM -to- 3:00 PM | Where should I be encrypting my data Denny Cherry Kevin Kline In this session we'll be looking at all the various places within the application stack that data can be encrypted. This includes the application layer, the database layer, encrypting over the wire, transparent data encryption, encrypting using your MPIO driver and offloading encryption to your HBAs. Encrypting and Hashing data within Application Tier Encrypting data within the Database tier Encrypting data within the MPIO / HBA |
Room 1 |
| 4/20/2011 2:00 PM -to- 3:00 PM | Preparing for your next DBA Job Christopher Shaw People make mistakes day in and day out. But the time you don’t want to make a mistake is during an interview. In this session, we will review a number of interviews that I have conducted and the mistakes that were made that inspired me to continue looking for the right candidate. The goal of this session is to learn from the mistakes of others so that we can put our best foot forward. |
Room 2 |
| 4/20/2011 2:00 PM -to- 3:00 PM | Securing your WCF Services using ASP.NET Authentication and SSL Ben Hoelting Windows Communication Foundation (WCF) is a pretty simple yet powerful technology. Most sessions and demos brush through the creation of WCF services. WCF RIA services make it even easier to create services that are available via the WCF technology. What most sessions leave out is how to secure these services. You can secure WCF just like you do web applications using ASP .NET Authentication and Secure Sockets Layer (SSL). Security is a very important part of every application and is usually the last thing a developer thinks about. Join me during this session to learn the benefits of securing your WCF communications. Not only will you learn “why” you should secure these services but I will also show you how to do it. |
Room 3 |
| 4/20/2011 2:00 PM -to- 3:00 PM | Entity Framework DBA meets Developer Llewellyn Falco Lynn Langit Entity framework (an ORM) is fast becoming the way that developers are accessing SqlServer Databases. The meeting of the Developer mind and the DBA mind has long been “contentious”. In this session Lynn will speak for the DBA’s and Llewellyn will speak for the Developers. Are there Best Practices they both can agree on? Maybe there are at least some Worst Practices they can both agree to avoid? Listen in and find out… |
Room 4 |
| 4/20/2011 2:00 PM -to- 3:00 PM | SQL Profiler and Extended Events Cage Match Jason Strate Kevin Kline Rival technologies often need to be thrown into a cage match to determine which is the victor. This time the rival technologies are SQL Profiler and Extended Events. SQL Profiler is the tried and true champion when it comes to performance monitoring and troubleshooting. But Extended Events is the newcomer that promises to ""float like a butterfly and sting like a bee."" In this session, we'll briefly review the core architecture of extended events. We'll also take a look at a number of performance monitoring scenarios and compare the application of SQL Profiler and Extended Events to the issue. |
Room 5 |
| 4/20/2011 2:00 PM -to- 3:00 PM | 20 Tips and Tricks for the Silverlight Developer Michael Crump 20 Tips and Tricks to make your Silverlight Development go faster. If you work with Silverlight daily then this is the session for you. |
Room 6 |
| 4/20/2011 3:00 PM -to- 3:15 PM | Break |
Room 1 |
| 4/20/2011 3:00 PM -to- 3:15 PM | Break |
Room 2 |
| 4/20/2011 3:00 PM -to- 3:15 PM | Break |
Room 3 |
| 4/20/2011 3:00 PM -to- 3:15 PM | Break |
Room 4 |
| 4/20/2011 3:00 PM -to- 3:15 PM | Break |
Room 5 |
| 4/20/2011 3:00 PM -to- 3:15 PM | Break |
Room 6 |
| 4/20/2011 3:15 PM -to- 4:15 PM | Can I really consolidate my SQL Server Database Denny Cherry Kevin Kline In this session we will look at the available techniques for consolidating a SQL Server database, and when to use each technique to help reduce capital expenses. Most importantly we will talk about how to decide when not to consolidate your databases. Learn when and how to consolidate your SQL Server Databases, how to decide which technique to use when consolidating your SQL Server databases, and learn when consolidation will hurt performance. |
Room 1 |
| 4/20/2011 3:15 PM -to- 4:15 PM | Adding a Windows Phone 7 frontend to an Existing Application Ben Hoelting The Windows Phone 7 release has been all the buzz. The new mobile OS is aimed at the consumer market and all kind of prospectors are rushing to strike gold and make their fortune. What has been forgotten in all the commercials and reviews is the story for developers. Developing on WP7 is pretty straight forward. It is basically Silverlight 3 development with some slight differences. This talk will start with an overview of WP7 development focused on topics specific to WP7. After that we will take an existing application and extend it to WP7. Windows Phone 7 is the future of the Microsoft mobile platform. This session with give you a solid foundation to developing apps for it. |
Room 3 |
| 4/20/2011 3:15 PM -to- 4:15 PM | Entity Strategies: Structuring Your Consultancy Bill Pearson Independent BI consultant, MSSQL Server MVP, and practicing CPA Bill Pearson examines the various options available for organizing and protecting your consulting business. In this section, he covers C Corp, S Corp, LLC, Partnership, and Sole Proprietorship (“Schedule C”) options, as well as other practical advice (trademarks, etc.) useful in forming your business entity. |
Room 4 |
| 4/20/2011 3:15 PM -to- 4:15 PM | Taking a Crack at CLR Jason Strate Kevin Kline A few years back the talk of CLR was all the rage. As time has gone on, the roars of the marketing crows have waned and DBAs fearful of the CLR apocalypse have had to put away theirs signs. With those days behind us, it’s time to make sure that you’ve take a look at CLR and what it can do for your database and your environment. In this session, we’ll look at how to build and implement CLR objects. We’ll also look at some specific use cases that can help improve the performance of your SQL Server environment and leave that environment more secure. |
Room 5 |
| 4/20/2011 3:15 PM -to- 4:15 PM | Code-Free SharePoint Development Josh Jones In this session, we’ll explore all of the features of the preferred code-free tool for SharePoint 2010, SharePoint Designer 2010. Learn about the basic requirements, how the interface works, what it can and CAN’T do, and watch a basic application be built from the ground up. |
Room 6 |
| 4/20/2011 4:15 PM -to- 4:30 PM | Break |
Room 1 |
| 4/20/2011 4:15 PM -to- 4:30 PM | Break |
Room 2 |
| 4/20/2011 4:15 PM -to- 4:30 PM | Break |
Room 3 |
| 4/20/2011 4:15 PM -to- 4:30 PM | Break |
Room 4 |
| 4/20/2011 4:15 PM -to- 4:30 PM | Break |
Room 5 |
| 4/20/2011 4:15 PM -to- 4:30 PM | Break |
Room 6 |
| 4/20/2011 4:30 PM -to- 4:45 PM | Live - Recap - Key DBA Responsibility & Drawings Stephen Wynkoop How to apply conference sessions and best practices & tips to your systems. What's important, and what should you be thinking about. |
Room 1 |
| 4/21/2011 9:00 AM -to- 9:15 AM | Opening Remarks |
Room 1 |
| 4/21/2011 9:30 AM -to- 10:30 AM | Keynote. Buck Woody Day 2 - Cloud-based technologies |
Room 1 |
| 4/21/2011 10:30 AM -to- 10:45 AM | Break |
Room 1 |
| 4/21/2011 10:30 AM -to- 10:45 AM | Break |
Room 2 |
| 4/21/2011 10:30 AM -to- 10:45 AM | Break |
Room 3 |
| 4/21/2011 10:30 AM -to- 10:45 AM | Break |
Room 4 |
| 4/21/2011 10:30 AM -to- 10:45 AM | Break |
Room 5 |
| 4/21/2011 10:30 AM -to- 10:45 AM | Break |
Room 6 |
| 4/21/2011 10:45 AM -to- 11:45 AM | T-SQL Queries Part 1 Kathi Kellenberger Are you a complete T-SQL newbie? Get started writing T-SQL queries. Learn how to select rows from tables and how to filter those rows retrieving just the data that your application needs. SELECT statements are the basis for everything else you will need to know to become a proficient T-SQL developer |
Room 1 |
| 4/21/2011 10:45 AM -to- 11:45 AM | Life Lessons; and dealing with the Monsters in the Closet Tom Roush Christopher Shaw Communication: The monsters in the closets of our lives can take many forms, but they all have one thing in common. Tom gives some examples of how to control the various monsters, both in and out of the closet, and some of the dangers you can face if you lose control of the them. |
Room 2 |
| 4/21/2011 10:45 AM -to- 11:45 AM | Introduction to Replication Eric Johnson |
Room 3 |
| 4/21/2011 10:45 AM -to- 11:45 AM | Intro to SQL Azure Lynn Langit Eric Johnson In this demo-filled session, Lynn will explain the differences between Windows Azure storage and SQL Azure. She wil demonstrate working with SQL Azure storage in your application and discuss the option to connect a non-cloud hosted front end and/or a cloud-hosted front end to a SQL Azure back end solution. Lynn will also talk about migration strategies and best practices. In her talk, you wil also learn recommended business scenarios for cloud-based storage. Finally, she will cover in detail features of SQL Server RDMS which are and are not supported in SQL Azure. |
Room 4 |
| 4/21/2011 10:45 AM -to- 11:45 AM | Data File Sizes – How much is enough, if you don’t know what you got? Tjay Belt We often run a fine line between how much space we need, and how much space we have for our databases. Having too much drive space can be a waste of resources; however, running out of space is an obvious issue. Let’s find a way to straddle the line and determine just how much space we really need, give ourselves a bit more than that, and make it a regular process to baseline, then continue to monitor, make adjustments along the way if needed, and ultimately plan for just enough space to get us through the year on budget. We’ll talk about a stand-alone tool that I used to determine space use for baseline, continued monitoring of the space used, and ensuring we have enough but not too much space. |
Room 5 |
| 4/21/2011 10:45 AM -to- 11:45 AM | InfoPath 2010 – Forms for SharePoint Josh Jones In the latest incarnation of Microsoft’s premier form development tool, users can quickly build forms for a variety of business applications. In this session, come learn how InfoPath forms work, common usage scenarios, and see how to secure and publish your forms in SharePoint 2010. |
Room 6 |
| 4/21/2011 11:45 AM -to- 12:00 PM | Break |
Room 1 |
| 4/21/2011 11:45 AM -to- 12:00 PM | Break |
Room 2 |
| 4/21/2011 11:45 AM -to- 12:00 PM | Break |
Room 3 |
| 4/21/2011 11:45 AM -to- 12:00 PM | Break |
Room 4 |
| 4/21/2011 11:45 AM -to- 12:00 PM | Break |
Room 5 |
| 4/21/2011 11:45 AM -to- 12:00 PM | Break |
Room 6 |
| 4/21/2011 12:00 PM -to- 1:00 PM | T-SQL Queries Part 2 Kathi Kellenberger Now that you know how to write a SELECT statement it’s time to progress to the next step. Your queries will often require multiple tables. Learn how to join two tables, use Common Table Expressions, and more in this session. |
Room 1 |
| 4/21/2011 12:00 PM -to- 1:00 PM | Visualizing your Indexes Wendy Pastrick Christopher Shaw Indexes make queries run faster, right? Not always, no. And finding the right indexes for your needs is often more of an Art than a Science. Attend this session as we take a visual tour of how indexes are laid out and the way data is accessed when indexes are utilized. We will discuss clustered indexes as well as non-clustered indexes and also when to use indexed views along with some other variations. |
Room 2 |
| 4/21/2011 12:00 PM -to- 1:00 PM | Saving SharePoint Sean McDonough In this session, Sean will be discussing disaster recovery (DR) concepts and strategies for SharePoint in a format that highlights a combination of both business and technical concerns. He will define some critical planning terms such as “recovery time objectives” and “recovery point objectives,” and explain why they are so important to understand when trying to formulate a DR strategy. Sean will also identify the capabilities and limitations of the Microsoft tools that can used for backing up, restoring, and making SharePoint highly available for disaster recovery purposes. Changes that have arrived with SharePoint Server 2010 and how they affect DR planning and implementation will also be covered. |
Room 3 |
| 4/21/2011 12:00 PM -to- 1:00 PM | Migrating to SQL Azure Lynn Langit Eric Johnson Here Lynn will demo tools and techniques around migration from various sources into the SQL Azure environment. Presentation will include use of SQL Azure Migration Wizard, SQL Server Management Studio generating scripting, BCP, SSIS, specialized migration tools, such as the MySQL to SQL Azure Migration Wizard. Lynn will also cover DACPACs as they relate to migration and, finally, her session will include new product releases. |
Room 4 |
| 4/21/2011 12:00 PM -to- 1:00 PM | Introduction to SSIS Eric Johnson |
Room 5 |
| 4/21/2011 12:00 PM -to- 1:00 PM | SharePoint Development with Visual Studio 2010 Josh Jones In the past, developing applications for SharePoint led developers down several paths. From custom libraries, manual project folders, and post-build events to STSDEV and the old Visual Studio Extensions for Windows SharePoint Services (VSeWSS), many were left feeling overwhelmed with options and too little direction. Microsoft has helped shed some light on development in SharePoint with Visual Studio 2010. In this session, come look at the new features designed to help application developers build custom applications, web parts, and other functionality for SharePoint 2010. |
Room 6 |
| 4/21/2011 1:00 PM -to- 2:00 PM | Exhibit Hall |
Room 1 |
| 4/21/2011 2:00 PM -to- 3:00 PM | T-SQL Queries Part 3 Kathi Kellenberger Not only can you retrieve data from SQL Server as it is stored in the tables, there are also ways to perform calculations and summaries. Learn how to use the power of T-SQL to create efficient reports. You will learn about using expressions, functions and how to write aggregate queries.ll online purchase open i need to |
Room 1 |
| 4/21/2011 2:00 PM -to- 3:00 PM | Replication, Logshipping and Mirroring; Part 1 Wendy Pastrick Christopher Shaw With so many different high availability options available how do you know which one is right for you? How do you know which technology will meet your requirements? In this session we will take a tour of each option to highlight what makes them different. Attend and you will understand what problem each technology solves and how to make a good choice when needing to select one to best suit your needs. |
Room 2 |
| 4/21/2011 2:00 PM -to- 3:00 PM | Selecting and Protecting the Right SharePoint Backup Targets Sean McDonough SharePoint is a complex platform with many moving parts and dependencies, and most administrators know that they need some form of backup protection to safeguard their environments. When it comes to actually protecting a SharePoint environment, though, what should an administrator focus on? What's important? In this session, Sean will take a look at SharePoint disaster recovery with an eye towards identifying farm protection targets. He will examine all of the common (and many of the not-so-common) elements that need to be protected, discuss why those elements may or may not be important for any given environment, and talk about tools and technologies that are available for protection. Sean will also cover some special circumstances and watch-outs that may help or hinder efforts to protect targets that are selected within a farm. By the end of the session, you will be able to prioritize backup targets in you SharePoint environment and select appropriate strategies for protection. |
Room 3 |
| 4/21/2011 2:00 PM -to- 3:00 PM | Hosting WF Services in Windows Azure, Today & Tomorrow Rick Garibay Workflow Services bring many benefits that help you build modern, responsive composite applications. Learn best practice for building and hosting Workflow Services on-premise as well as how you can take advantage of Windows Azure for hosting your workflow services today along with improvements coming to Windows Azure which will make hosting your workflow services in Azure more compelling than ever. |
Room 4 |
| 4/21/2011 2:00 PM -to- 3:00 PM | Communication: When the Going gets Rough (for managers and dba’s) Tom Roush Christopher Shaw Communication can be difficult. Communicating when things go wrong, whether because of a mistake, a failure (technology or human), or an emergency, is even more challenging, and even more critical. Through stories that are rarely technical, but all too human, Tom gives examples of how these things happen, some ways to handle the situations – both for employees and managers – and how to keep the most valuable resource you have – (you) performing and communicating when the going gets rough. |
Room 5 |
| 4/21/2011 2:00 PM -to- 3:00 PM | Testing Triggers, Stored Procedures and Functions Ben Taylor It is easy to write code in SQL Server; It is harder to make sure that the code performs as expected. This session demonstrates techniques you can use while writing triggers, functions and stored procedures, assuring that the code works as expected. You need to be familiar with basic SQL syntax and SQL Server Management Studio in order to take advantage of this session. |
Room 6 |
| 4/21/2011 3:00 PM -to- 3:15 PM | Break |
Room 1 |
| 4/21/2011 3:00 PM -to- 3:15 PM | Break |
Room 2 |
| 4/21/2011 3:00 PM -to- 3:15 PM | Break |
Room 3 |
| 4/21/2011 3:00 PM -to- 3:15 PM | Break |
Room 4 |
| 4/21/2011 3:00 PM -to- 3:15 PM | Break |
Room 5 |
| 4/21/2011 3:00 PM -to- 3:15 PM | Break |
Room 6 |
| 4/21/2011 3:15 PM -to- 4:15 PM | Server Consolidation Thomas LaRock 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? If anyone says to start with their ”low hanging fruit” I will throw a USB stick at the camera because no one picks their own fruit anymore. I’ll help you understand the scope of a consolidation project and give you an idea about how to get started. |
Room 1 |
| 4/21/2011 3:15 PM -to- 4:15 PM | Replication, Logshipping and Mirroring; Part 2 Wendy Pastrick Christopher Shaw With so many different high availability options available how do you know which one is right for you? How do you know which technology will meet your requirements? In this session we will take a tour of each option to highlight what makes them different. Attend and you will understand what problem each technology solves and how to make a good choice when needing to select one to best suit your needs. |
Room 2 |
| 4/21/2011 3:15 PM -to- 4:15 PM | "Caching-In" for SharePoint Performance Sean McDonough Caching is a critical variable in the SharePoint scalability and performance equation, but it’s one that’s oftentimes misunderstood or dismissed as being needed only in Internet-facing scenarios. In this session, Sean will build an understanding of the caching options that exist within the SharePoint platform and how they can be leveraged to inject some pep into most SharePoint sites. He will also cover some sample scenarios, caching pitfalls, and watch-outs that every administrator should know. |
Room 3 |
| 4/21/2011 3:15 PM -to- 4:15 PM | Beginner's Guide to Silverlight Development Michael Crump This session to to introduce Silverlight and get the audience familiar with XAML. We create a basic Silverlight Application and describe the Silverlight run-time. |
Room 4 |
| 4/21/2011 3:15 PM -to- 4:15 PM | Intro to PowerShell Aaron Nelson What is it PowerShell? How do I use it? Why would I use it? We’ll answer these questions as we step through how to get started with PowerShell and walk through a few Common first scripts. We’ll spend a few minutes going over some basic troubleshooting in case you get stuck. Beyond just doing ad-hoc tasks we’ll also take a look at using PowerShell in our production environment and what we might want to handle differently. |
Room 5 |
| 4/21/2011 3:15 PM -to- 4:15 PM | Server Profiler and Tracing, a "How To" Tjay Belt We have all needed to know what is happening in our database systems. We have often been tasked with finding poor performing queries. Maybe we are being hit with Auditing and Compliance needs. All these and many more issues can be resolved with SQL Server Profiler. Maybe with SQL Server Trace. But which one, and when? Auditing databases can be tiresome, but a good trace and supporting reports can really help out. This presentation will show you some of my own ideas, along with others' ideas on best uses for Profiler and Trace. Once armed with this knowledge, you should be able to take it back to your shops and implement systems that assist you track down these issues more easily. |
Room 6 |
| 4/21/2011 4:15 PM -to- 4:30 PM | Break |
Room 1 |
| 4/21/2011 4:15 PM -to- 4:30 PM | Break |
Room 2 |
| 4/21/2011 4:15 PM -to- 4:30 PM | Break |
Room 3 |
| 4/21/2011 4:15 PM -to- 4:30 PM | Break |
Room 4 |
| 4/21/2011 4:15 PM -to- 4:30 PM | Break |
Room 5 |
| 4/21/2011 4:15 PM -to- 4:30 PM | Break |
Room 6 |
| 4/21/2011 4:30 PM -to- 4:45 PM | Live - Recap - Cloud Solutions & Drawings Stephen Wynkoop How to apply conference sessions and best practices & tips to your systems. What's important, and what should you be thinking about. |
Room 1 |
| 4/22/2011 9:00 AM -to- 9:15 AM | Opening Remarks| Room 1 |
|
| 4/22/2011 9:30 AM -to- 10:30 AM | Keynote. Donald Farmer Day 3 - The Business of BI: Answering the Next Question For me, Business Intelligence has always presented one fascinating opportunity: every answer leads to another question. What? leads to Why? leads to How? leads to When? Although exploration is at the heart of BI, designing systems to optimize exploration as been a neglected area. In this session we will explore data models and user experience designs that help your users to answer the next question. |
Room 1 |
| 4/22/2011 10:30 AM -to- 10:45 AM | Break |
Room 1 |
| 4/22/2011 10:30 AM -to- 10:45 AM | Break |
Room 2 |
| 4/22/2011 10:30 AM -to- 10:45 AM | Break |
Room 2 |
| 4/22/2011 10:30 AM -to- 10:45 AM | Break |
Room 3 |
| 4/22/2011 10:30 AM -to- 10:45 AM | Break |
Room 4 |
| 4/22/2011 10:30 AM -to- 10:45 AM | Break |
Room 5 |
| 4/22/2011 10:30 AM -to- 10:45 AM | Break |
Room 6 |
| 4/22/2011 10:45 AM -to- 11:45 AM | The Business of BI: Dealing with Different Thinkers Donald Farmer In any data-driven business you quickly discover that there are quite different personalities at work there. Some people need rich, 3-D visualizations to feel comfortable with data, others demand to just see the numbers. This session will help you to understand the different thinking styles in your organization. We’ll find ways to target reports and solutions to different audiences while still maintaining data integrity and analytic accuracy. Examples and demos will be from different platforms and tools. |
Room 1 |
| 4/22/2011 10:45 AM -to- 11:45 AM | Database Maintenance with Powershell Ben Miller Eric Johnson Maintenance and performance is an important part of a DBA’s life. We will take a look under the hood of the tables, indexes and statistics objects and how they relate to our life as a DBA. We will see some reusable scripts that can help you find problems and also fix the problems using Powershell. |
Room 2 |
| 4/22/2011 10:45 AM -to- 11:45 AM | Introduction to SSRS Eric Johnson |
Room 3 |
| 4/22/2011 10:45 AM -to- 11:45 AM | Introduction to NUnit Ben Taylor NUnit is an open systems framework allowing code to be tested without actually running an application. NUnit tests are written in a Dot Net language such as C#, the language used for this introduction. User defined tests are evaluated using NUnit assertions for pass/fail. This course will help you install NUnit, build a test project, and demonstrate how to perform unit tests, and create unit tests against an SQL database. It is helpful if you are familiar with C#, Java or VB.Net. The demonstration will utilize ADO.Net. |
Room 4 |
| 4/22/2011 10:45 AM -to- 11:45 AM | What Are You Waiting For? Jason Strate Kevin Kline You’ve spent the afternoon sweating over your T-SQL query. You’ve wrung out all of the wrinkles. It’s deployed, it’s running… now its waiting. In SQL Server the most performant query can become a problem query if there aren’t any resources in the SQL Server for it to use. In this session, we’ll look at wait statistics and what they are. We’ll look into how they are accumulated and how they can be monitored. By the end of the session, you’ll be equipped with the tools needed to determine if there are resource issues in your environment and methods to start mitigating them. Prerequisites Understanding of performance tuning Goals: 1. Understanding of wait statistics 2. Demonstrate methods for resolving issues related to wait statistics 3. Demonstrate process for monitoring wait statistics |
Room 5 |
| 4/22/2011 10:45 AM -to- 11:45 AM | Querying and updating your data with LINQ Chris Sutton LINQ is a set of language extensions that lets you query data in a natural way in C# and VB.NET. We will explore the range of query operators available to us and how we can use them to easily find, filter and update our data. |
Room 6 |
| 4/22/2011 11:45 AM -to- 12:00 PM | Break |
Room 1 |
| 4/22/2011 11:45 AM -to- 12:00 PM | Break |
Room 2 |
| 4/22/2011 11:45 AM -to- 12:00 PM | Break |
Room 3 |
| 4/22/2011 11:45 AM -to- 12:00 PM | Break |
Room 4 |
| 4/22/2011 11:45 AM -to- 12:00 PM | Break |
Room 5 |
| 4/22/2011 11:45 AM -to- 12:00 PM | Break |
Room 6 |
| 4/22/2011 12:00 PM -to- 1:00 PM | Session Cancelled |
Room 1 |
| 4/22/2011 12:00 PM -to- 1:00 PM | T-SQL in Denali Kathi Kellenberger The next release of SQL Server is codenamed “Denali.” Much of the excitement around this release is about the enhanced BI capabilities and new AlwaysOn functionality. Did you know that there are also some new T-SQL features? Learn about the improved error trapping, sequences, and more in this session. |
Room 2 |
| 4/22/2011 12:00 PM -to- 1:00 PM | Waits and Queues and You Thomas LaRock Many database professional have little to no understanding about how to use wait events as part of an overall performance tuning process. And yet wait events are the secret sauce that many leading experts have been using for years. Attend this talk and you will gain an understanding of the SQLOS execution model, an understanding of how to use DMVs to find out what your queries are waiting for, and why using wait events could be the best thing to happen for your career as a DBA. |
Room 3 |
| 4/22/2011 12:00 PM -to- 1:00 PM | Building a Business Web Application using ASP.NET and HTML 5 Ben Hoelting HTML 4 has been with us for almost a decade. HTML 5 is a new standard that web browser are starting to support. Currently, ASP.NET web applications are still widely used. Some developers have started to use ASP.NET MVC. No matter what technology you prefer HTML 5 can help your application. HTML 5 adds many new input types that can now be used natively in browsers that support HTML 5. HTML 5 also introduces new support for media and offline storage of data. In this session we will run through some of the new stuff available in HTML 5 as well as how to integrate that with your ASP.NET and ASP.NET MVC applications. |
Room 4 |
| 4/22/2011 12:00 PM -to- 1:00 PM | Performance Tuning With Extended Events Jason Strate Kevin Kline SQL Server 2008 saw the launch of a new performance tuning tool was made available. That tool was Extended Events. Where some previous tools were clumsy and intrusive, Extended Events is flexible and light. It’s able to extract exactly the information that you need when you need it. In this session, we’ll explore some common performance issues related to SQL Server and demonstrate method to resolve those issues. |
Room 5 |
| 4/22/2011 12:00 PM -to- 1:00 PM | Building a data driven website with Entity Framework Chris Sutton Entity Framework provides a model that we can use to easily query and update data in the context of a .NET application. Entity Framework along with LINQ to Entities gives the ability to quickly query data and to make data updates from user input. We’ll explore how to use Entity Framework to quickly build a data driven website. |
Room 6 |
| 4/22/2011 1:00 PM -to- 2:00 PM | Exhibit Hall |
Room 1 |
| 4/22/2011 2:00 PM -to- 3:00 PM | Quickly Gather Performance Data with PowerShell Aaron Nelson Continuously gathering performance data to log history and develop a baseline is a really important task in any environment. Having quick access to what’s happening right now is equally important. In this session we’ll take a look at how to continuously gather Perfmon counters and DMV info. We’ll also take a look at how to Visualize the data using charts. |
Room 1 |
| 4/22/2011 2:00 PM -to- 3:00 PM | Zero to Cube - Introduction to Analysis Services Adam Jorgensen This hands on session will demonstrate how to build a cube from the ground up and then how to make sure you maintain it and keep it in tip top share. |
Room 2 |
| 4/22/2011 2:00 PM -to- 3:00 PM | Administration by Powershell and SMO Ben Miller Eric Johnson Ever wanted to get away from Management Studio to do regular DBA tasks? Do you lay awake at night thinking about how many clicks you performed during the day to accomplish your work? This session will illustrate reusable code or process improving scripts to keep you at the top of your game and get more done in less time. |
Room 3 |
| 4/22/2011 2:00 PM -to- 3:00 PM | Documentation – you know you love it Tjay Belt "We will discuss some of the most important things that you as a Data Professional can document to make your job much easier, ensure information consistency between groups, and better prepare your organizations for raising the bar on your day to day business. Think of this as a sort of Database Library that allows you to finally detail the processes you follow currently to perform repetitive tasks. This Library will also allow you to simply document your systems for your and others knowledge. Some of the documents and processes we will review are: • Database Inventory • Job review (information pertinent to job execution baselines) • Data File Sizes baseline and continuing documentation • Backup and Recovery Process and Policy • Backup Testing policy • Fragmentation baseline • Change Control Policy • User Access / User Access Change • Technical Service Guides – Trouble Shooting Guides • On-Call issues " |
Room 4 |
| 4/22/2011 2:00 PM -to- 3:00 PM | Automated Stored Procedure Testing Using NUnit Ben Taylor How do you know if you can safely change the way something works in a database? This is a difficult question to answer, and becomes more difficult as your database grows. Automated testing is a technique that provides the developer with confidence to make change because they know the impact of that change. If you have unit tests that may be executed against your database, validating assertions against how code works in triggers, stored procedures and user defined functions, as well as the state of data, you may make modifications to some aspect of the database, run all your tests, and validate that you have not introduced bugs into your system. This session relies heavily on the NUnit framework, C#, ADO.Net and Visual Studio. This is not intended to test an Object Relationship Mapping layer of your program. It tests code embedded in your database, and other aspects of your database as well. |
Room 5 |
| 4/22/2011 2:00 PM -to- 3:00 PM | Code First: Building a Cleaner Model with Entity Framework Chris Sutton Code First is a new approach to building your model in Entity Framework 4 that allows you to create your domain model with plain .NET classes that are under your control. Previously in Entity Framework you were required to build your model with an EDMX XML file that forced your model to be expressed in a visual designer. While this approach works in some situations, it can get in the way of your development work-flow and can create extra baggage for application developers. Code First relies on a set of conventions that handle connection strings, mapping to your storage solution, defining primary keys, finding relationships between classes and more. Of course all of these conventions can be overridden in code as well, which gives you plenty of flexibility.In this talk I’ll describe and demonstrate the core features of Code First so you can make an informed decision as to its usefulness in your environment. |
Room 6 |
| 4/22/2011 3:00 PM -to- 3:15 PM | Break |
Room 1 |
| 4/22/2011 3:00 PM -to- 3:15 PM | Break |
Room 2 |
| 4/22/2011 3:00 PM -to- 3:15 PM | Break |
Room 3 |
| 4/22/2011 3:00 PM -to- 3:15 PM | Break |
Room 4 |
| 4/22/2011 3:00 PM -to- 3:15 PM | Break |
Room 5 |
| 4/22/2011 3:00 PM -to- 3:15 PM | Break |
Room 6 |
| 4/22/2011 3:15 PM -to- 4:15 PM | Performance Tuning Made Easy Thomas LaRock Performance tuning is hard, everyone knows that. Attend this session and learn how to define, measure, and analyze performance issues as well as implementing changes and also how to make sure those changes continue to have the desired effects. In short, I break down performance tuning into pieces that anyone can understand. Leave this session knowing what actions to take when you get back to work. |
Room 1 |
| 4/22/2011 3:15 PM -to- 4:15 PM | Stand-alone DBA daily/weekly/monthly tasks Tjay Belt You are the only DBA your shop has. Maybe there has never been a DBA there before. Maybe you are one in the long line of DBAs supporting these systems. Maybe you are trying to determine if your organization needs a DBA at all. There are many things that non-DBAs have learned and implemented in your database infrastructure to get your organization by. However, you’ve got that sneaking feeling that there may be more benefit you can wring from your databases. Maybe you are the new DBA and want to ensure that you provide sufficient benefit to warrant your position. Maybe you want to wow your colleagues. Let’s talk about some of the frequent and repetitive tasks that can be implemented. What best practices can you implement to ensure that your databases perform better each day that you are there? What tasks can be automated. What Best Practices can you implement to bring benefit? |
Room 2 |
| 4/22/2011 3:15 PM -to- 4:15 PM | Many-to-Many: Multiple Calendars in a Single Cube Bill Pearson Adam Jorgensen Including the fiscal calendars of major customers within the date dimensions of their own cubes has great appeal to many organizations, including financial services firms and the like. After all, having customer calendars in their cubes' date dimension means sales and marketing managers can analyze - and report upon - data according to the fiscal calendar of the customer, as well as within the context of their own. In this session, we look at a way we can accomplish this by implementing a SQL Server Analysis Services "many-to-many" dimension scenario. |
Room 3 |
| 4/22/2011 3:15 PM -to- 4:15 PM | Building a Business Web Application using Silverlight Ben Hoelting Is Silverlight Dead? Many experts are saying HTML 5 makes technologies like Silverlight, AIR, Flash and Flex obsolete. I say not so fast. HTML 5 provides some great functionality via HTML, JavaScript and CSS but I prefer to use managed C# code when building business applications. Sure HTML 5 will make it easier to do media over the internet, but what about rich, robust and user friendly business applications? Silverlight is still the best technology to deliver “Windows Forms” like applications over the internet. It also enables developers to allow users to install and run their application out of the browser. Finally, Silverlight is a development option for deploying mobile applications to Windows Phone 7 devices. Silverlight is not dead and is still a great technology for business applications. This session will highlight Silverlight’s ability to develop and deliver the highest quality business application available. |
Room 4 |
| 4/22/2011 3:15 PM -to- 4:15 PM | Date and Time Techniques Ben Taylor This session focuses on one of the most valuable and difficult attribute to track in a database; time. Time is a complicated attribute because it may be defined in many ways. Time may be a point in time, but that point may be as small as a nanosecond or as large as a year. Time may also be a range. For example, One day is a range of 24 hours, or 24 x 60 minutes, etc. We will cover questions such as: • How do you store a point in time, how big is it? • How do you store dates without time? • How to you store time without dates? • How do you store a range of time? • How do you Query time based on a range of dates? • How do you query time based on a set of date ranges? • How do you query time stored in the database as a range against a filter of a range? This session covers techniques for storing time in your database, and querying time contained in your database. A basic understanding of TSQL is required to understand the concepts taught in this session. |
Room 5 |
| 4/22/2011 3:15 PM -to- 4:15 PM | Getting Started in ETL with Powershell Aaron Nelson In this session we’ll take a look at how to load data into SQL Server using various data sources such as: text, csv, table. We’ll also load data from XML files; update data inside of XML files; and even kick off SSIS packages all from PowerShell. |
Room 6 |
| 4/22/2011 4:15 PM -to- 4:30 PM | Break |
Room 1 |
| 4/22/2011 4:15 PM -to- 4:30 PM | Break |
Room 2 |
| 4/22/2011 4:15 PM -to- 4:30 PM | Break |
Room 3 |
| 4/22/2011 4:15 PM -to- 4:30 PM | Break |
Room 4 |
| 4/22/2011 4:15 PM -to- 4:30 PM | Break |
Room 5 |
| 4/22/2011 4:15 PM -to- 4:30 PM | Break |
Room 6 |
| 4/22/2011 4:30 PM -to- 5:30 PM | Live - Recap - Developer Tips & Drawings Stephen Wynkoop How to apply conference sessions and best practices & tips to your systems. What's important, and what should you be thinking about. |
Room 1 |