SQLSaturday #33 - Charlotte 2010 3/6/2010 12:00:00 AM SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. #sqlsat33 Charlotte NC 28273 http://www.sqlsaturday.com/images/sqlsaturday_gb_icon.png http://www.sqlsaturday.com/images/sqlsaturday_gb_image.png Conference Information general True 1 default Maps maps False 2 default Schedule of Events schedule True 3 default Sponsors List sponsorslist True 4 default Twitter twitter True 5 default Todo List todo False 6 default My Schedule myschedule True 7 default Feedback feedback False 8 default Key Events keyevents False 9 default Share share True 10 default 406 SQL Sentry Platinum Sponsor http://www.sqlsentry.net http://www.sqlsentry.net/images/ext/SQLSentryLogo148.jpg 60 170 415 Microsoft Platinum Sponsor http://www.microsoft.com/sqlserver http://www.sonetring.net/images/microsoft-logo-oct.jpg 60 170 416 Quest Gold Sponsor http://www.quest.com http://www.quest.com/images/common/quest-logo.gif 60 170 422 Confio Software, Inc. Silver Sponsor http://www.confio.com http://www.sqlsaturday.com/images/Confio_LogoLg_0106.jpg 60 170 428 Red Gate Software Silver Sponsor http://www.red-gate.com/about/community_relations/sql_saturday.htm?utm_source=ugutm_medium=uglogoutm_content=charlotteutm_campaign=redgate http://www.sqlsaturday.com/images/redgatelogo.jpg 60 170 436 New Horizons Charlotte Silver Sponsor http://www.nhcharlotte.com http://www.newhorizonscourses.com/gui/images/new-horizons-logo.gif 60 170 392 Intellinet Bronze Sponsor http://www.intellinet.com http://www.intellinet.com/media/31199/intellinet_tagline.png 60 170 417 CozyRoc Bronze Sponsor http://www.cozyroc.com http://www.cozyroc.com/sites/default/files/down/cozyroc-big.png 60 170 435 TEKSystems Bronze Sponsor http://www.teksystems.com http://www.teksystems.com/Images/Layout/teksystems.gif 60 170 897 Aaron Nelson Track 8 AP2-Matterhorn In this session we will learn to perform several everyday DBA tasks like backing up user databases, scripting table objects and evaluating disk space usage with PowerShell. For each tasks we will explore the benefits is using PowerShell over the standard method. Only a basic understanding of PowerShell or DOS is needed. This session should serve as a good introduction to PowerShell for database users. The goal is to get data professionals feet wet about PowerShell. 3/6/2010 1:30:00 PM 3/6/2010 2:30:00 PM 903 Mike Walsh Track 4 AP1-Training 3 Whether you are new to the role of DBA, being 'forced' to take on the responsibility of one or are starting at a new role as a DBA, knowing where to start can often mean the difference between success or failure. In this chat, Mike will help us wade through the noise that attacks a DBA and figure out just what our priorities should be. By focusing on the 'itties' of Database Administration (Recoverability, Availability - Health Performance - , Security and Reliability) we can see a natural priority build. Throughout this interactive discussion we will also have a look at some of the available tools and scripts to help us see where our environments rate with the 'itties' of Database Administration. 3/6/2010 9:00:00 AM 3/6/2010 10:00:00 AM 904 Mike Walsh Track 2 AP1-Training 1 In this talk, Mike will show us some of the tools that come with SQL Server and how they can be used to analyze the performance of our database code. We will take a quick walk through indexing, best practices, some quick tips and then have a more in depth look at Execution Plans, IO Statistics and Profiler. Plus as a DBA, Mike can give a few pointers in working with your organization's own 'Dr. No' along the way. Rough Agenda: • Review of Best Practices • Indexing/Table Structure High Level Overview • Will your queries use the index? • Query Plans don’t have to be scary • IO Statistics, Profiler • Put Them Together (Use the tools before you say, 'Done!' • Interaction with the DBA (How to be a partner in performance with the DB 3/6/2010 2:45:00 PM 3/6/2010 3:45:00 PM 949 Steve Wright Track 3 AP1-Training 2 In this presentation Steve Wright will discuss methods used to manage memory in SQL Server Analysis Services, focusing primarily on memory limits and preallocation. He will also present some examples from the field of performance issues due to mis-configuration, how they were identified, and ultimately resolved. 3/6/2010 9:00:00 AM 3/6/2010 10:00:00 AM 968 Dave Turpin Track 4 AP1-Training 3 If you never click on the estimated/actual query plan icons because it looks like a foreign language to you AND you want your queries to really run fast... This session is for you. Starting from the beginning, we'll go through the key things to look for when reviewing your queries' estimated and actual plans. 3/6/2010 4:00:00 PM 3/6/2010 5:00:00 PM 1010 Aaron Nelson Track 7 AP2-Mt. Kilimanjaro With the list of features of SQL Server growing constantly the need to sandbox and test drive features in a separate environment that can communicate with but not interfere with your existing environment has become vital. With virtualization, setting up consistent test, dev, and even sandbox environments can happen minutes instead of hours AND be consistent with previous/ existing environments. In this session we will focus on Microsoft Virtualization solutions that you can leverage starting with your desktop/laptop and extending to your server environments. Even if you aren’t going to be doing the virtualization yourself it’s good to know what your options are. 3/6/2010 9:00:00 AM 3/6/2010 10:00:00 AM 1035 Andrew Kelly Track 6 AP2-Mt. McKinley Since SQL Server 2000 we have had the ability to collect statistics on two key areas in terms of performance directly from within SQL Server. More specifically these are the File Wait statistics and the information that can be gleaned from these has increased dramatically with each new release. SQL 2008 currently has over 480 events so far. This session will show you how to efficiently capture and analyze the information provided by a set of DMV’s in SQL Server 2005 SQL Server 2008. This knowledge will dramatically decrease the amount of time spent looking for bottlenecks in your system. 3/6/2010 11:30:00 AM 3/6/2010 12:30:00 PM 1036 Andrew Kelly Track 6 AP2-Mt. McKinley Lack of plan reuse is one of the biggest performance killers in SQL Server and almost everyone has experienced problems in this area before. We will explore exactly how to determine if this is an issue for you and more importantly, how to address it. See what factors determine if a plan gets reused or not and why. We will cover how to issue calls to the database that guarantee reuse and peak performance. Understanding this aspect of SQL Server is something every good DBA should be fully aware of and attending this session will get you the insight to get started immediately. 3/6/2010 1:30:00 PM 3/6/2010 2:30:00 PM 1039 Geoff Hiten Track 7 AP2-Mt. Kilimanjaro Learn about the major changes in clustering in recent SQL and Windows releases and how clustering is something you can implement that will actually make your work life easier. 3/6/2010 11:30:00 AM 3/6/2010 12:30:00 PM 1040 Geoff Hiten Track 2 AP1-Training 1 Learn to write (or at least recognize) T-SQL code that consumes hundreds of times more I/O and CPU Resources than optimal code. More importantly, see what the optimal counterpart looks like. 3/6/2010 4:00:00 PM 3/6/2010 5:00:00 PM 1066 Patrick LeBlanc Track 4 AP1-Training 3 In this session I will explain SQL Server Data compression (Page and Row), provide scripts and tips that will help you identity the compression state that should be configured in your Warehouse environment and also provide demo scripts showing you how to configure compression at the Table and Index level. 3/6/2010 1:30:00 PM 3/6/2010 2:30:00 PM 1126 Andy Warren Track 5 AP1-Training 4 This beginner to intermediate level session will introduce you to statistics, including how to create, manage, troubleshoot, and more! Statistics are a key part of getting solid and repeatable performance and is easily just as important as having indexes. Whether you're a DBA or trying to get by without one, this session will give you the information you need to know. 3/6/2010 10:15:00 AM 3/6/2010 11:15:00 AM 1134 Timothy Ford Track 2 AP1-Training 1 Having had to support a large number of SQL Server instances as a solo DBA for many years I’ve developed a toolbox of scripts and arsenal of processes that I rely upon to give insight into disk space, file growth, backup status, Agent job outcomes, and login management. Some of these I’ve shared on various websites and blogs; others see the light of day for the first time in this session. Attendees leave the session with processes and code they can begin to use immediately. 3/6/2010 11:30:00 AM 3/6/2010 12:30:00 PM 1135 Timothy Ford Track 6 AP2-Mt. McKinley Use the right tool from your SQL toolbox to maintain those indexes, determine which indexes are being used (and more importantly which ones are NOT being used), and get recommendations on indexes to create all from Dynamic Management Views. Walk away with scripts you can use in your environment IMMEDIATELY. 3/6/2010 9:00:00 AM 3/6/2010 10:00:00 AM 1150 John Welch Track 8 AP2-Matterhorn SSIS data flows are great tools for moving data. But what if you need to go beyond the out-of-the-box components provided with SSIS? Custom components are a great way to encapsulate and reuse functionality for the data flow in SSIS. We will discuss what it takes to create and deploy custom components in SSIS, review the pros and cons of using custom components instead of scripts, and discuss some of the common challenges and issues with creating them. 3/6/2010 10:15:00 AM 3/6/2010 11:15:00 AM 1158 Jason Hall Track 2 AP1-Training 1 This is a beginning to intermediate level presentation that aims to enlighten users of some of the more useful yet underutilized features of SQL Server Management Studio 2008. There will be explanations of the features and techniques as well as simple demonstrations throughout. This session provides something for both DBAs and developers of TSQL alike. 3/6/2010 10:15:00 AM 3/6/2010 11:15:00 AM 1161 Rushabh Mehta Track 7 AP2-Mt. Kilimanjaro PowerPivot (project Gemini) introduces an innovative platform for self-service analysis. In this session, we will very briefly look at the user-facing features and functionality of PowerPivot before we dive deep into a behind-the-scenes look at PowerPivot, understand limitations and finally drill into some best practices and lessons learnt from actual customer implementations. 3/6/2010 2:45:00 PM 3/6/2010 3:45:00 PM 1162 Rushabh Mehta Track 1 AP1-MPR In this session, we will use the features of the PowerPivot add-in for Excel to import data from various sources, cleanse and prepare the data for analysis and finally use the data to build complex reports and publish. We will also take a look at Data Analysis Expressions (DAX) and how to use them to extend the functionality of the model and the reports. 3/6/2010 10:15:00 AM 3/6/2010 11:15:00 AM 1164 John Welch Track 9 AP2-VTC SQL Server, Integration Services, and Analysis Services are used together to deliver BI solutions but development efforts are carried out separately, without sharing of metadata between the products. This creates duplicate effort and compromises the ability to develop agile, iterative solutions. Vulcan is an open source project from Microsoft (http://vulcan.codeplex.code) that helps bridge this gap, while also providing many of the benefits of code focused approaches used in application development. It allows you to define the relational data marts, ETL, and OLAP cube portions of your BI solution in a common language, and seamlessly uses that information to generate the appropriate database schemas, SSIS packages, and SSAS cubes. 3/6/2010 1:30:00 PM 3/6/2010 2:30:00 PM 1165 Andy Leonard Track 8 AP2-Matterhorn This highly-interactive, demo-intense presentation is for beginners and developers just getting started with SSIS. Attend and learn how to build SSIS packages from the ground up. 3/6/2010 9:00:00 AM 3/6/2010 10:00:00 AM 1166 Alejandro Mesa Track 5 AP1-Training 4 In this session we will learn about:- What is parameter sniffing?- What can we do when it doesn't help?- Statistics used by Sql Server- The OPTION clause- Plan Guides 3/6/2010 4:00:00 PM 3/6/2010 5:00:00 PM 1169 Amy Styers Track 5 AP1-Training 4 Understanding a SQL application's data and storage needs is often overlooked - yet it can yield GREAT RETURNS when performance tuning. I will discuss and demonstrate how to plan for better performance with IO tuning. 3/6/2010 1:30:00 PM 3/6/2010 2:30:00 PM 1170 Sergey Pustovit Track 6 AP2-Mt. McKinley There are number of tools available on the market for the SQL Server performance troubleshooting. But do we use the full power of the internal SQL Server Data Management Views (DMVs)? Some very challenging issues can be solved using DMVs. What the Dynamic Management Views are? How diagnostics data is getting populated? Using the examples we are going to talk about diagnostic data analysis using T-SQL queries against SQL Server DMVs. 3/6/2010 10:15:00 AM 3/6/2010 11:15:00 AM 1174 Sergey Pustovit Track 1 AP1-MPR During this session we will go over the features been introduced in SQL Server 2008 and upcoming SQL Server 2008 R2. 3/6/2010 9:00:00 AM 3/6/2010 10:00:00 AM 1175 Chris Skorlinski Track 3 AP1-Training 2 This presentation will provide an overview of the techniques used by Microsoft SQL Server Replication Support team for troubleshoot Transactional Replication performance. Topics covered include: Overview of Agent Reader/Writer threads, Monitoring Replication Performance, Common causes of Latency, tools for identifying Replication latency, and best practices for improving Transactional Replication Performance. 3/6/2010 11:30:00 AM 3/6/2010 12:30:00 PM 1205 Rafael Salas Track 9 AP2-VTC BOS30-200: SSIS, You , and Better ETLDid you already learned SSIS, and now want to get serious about ETL? Did you become an SSIS developer by accident, but wonder what makes a good ETL solution? Is your current SSIS solution falling apart and you need to revamp it? The Complexity and importance of Extract, Transform and Load (ETL) projects are often underestimated, and the consequences of a poor crafted solution would inevitable lead to maintenance nightmares, or worse yet to the failure of the whole project. In this session we will try to bridge SSIS and a ETL architecture based on good practices while looking to some lessons learned from real world implementations. 3/6/2010 2:45:00 PM 3/6/2010 3:45:00 PM 1227 Chris Skorlinski Track 3 AP1-Training 2 This sessions provides a high level overview and comparison of various Microsoft SQL Server Replication technologies including 1) Snapshot, 2) Change Tracking, 3) Change Data Capture, 4) Transactional, 5) Peer-2-Peer, 6) Merge Replication, 7) Web Sync, 8) Sync Services. 3/6/2010 10:15:00 AM 3/6/2010 11:15:00 AM 1275 Brett Tomson Track 9 AP2-VTC Microsoft SQL Server 2008 was released to much fanfare, excitement and anticipation in the IT community. The bevy of enhancements made to the various components coupled with sweeping performance gains made SQL Server 2008 one of the most competitive and feature-rich database platforms on the market. In this session, we will examine the enhancements made to Reporting Services in SQL Server 2008 as well as what changes to expect in R2 slated for release in early 2010. 3/6/2010 9:00:00 AM 3/6/2010 10:00:00 AM 1276 Brett Tomson Track 5 AP1-Training 4 It happens to everyone. One day your database is humming along quietly serving up choice nuggets of information quickly and efficiently while growing at a slow, steady rate. Then next day, your database has quadrupled in size and performance has ground to a halt as the system strains under the load. Management is screaming for answers and you're coworkers are running in circles screaming for their lives. In this session, we will examine best practices to apply to reporting databases that grow to become much larger than expected. We will examine a real-world scenario and discuss the strategies and techniques implemented in order to get the database back on track. 3/6/2010 11:30:00 AM 3/6/2010 12:30:00 PM 1283 Andy Leonard Track 9 AP2-VTC This session is for experienced SSIS developers. Attend and learn the Parent-Child SSIS design pattern, how to leverage less-than-well-documented characteristics of SSIS to centralize logging, and how to pass variable values between parent and child packages by value and by reference. 3/6/2010 4:00:00 PM 3/6/2010 5:00:00 PM 1287 Kendal Van Dyke Track 7 AP2-Mt. Kilimanjaro Solid State Drives are being heralded as game changers in the world of SQL IO. What was once was a costly technology only available to those with deep pockets is now becoming affordable for mainstream use. This session look into the how SSDs work, how they perform compared to traditional hard drives, and highlight the things you need to consider when implementing SSDs on your SQL Servers. Be sure not to miss a live demonstration of solid state technology in action! 3/6/2010 1:30:00 PM 3/6/2010 2:30:00 PM 1288 Kendal Van Dyke Track 4 AP1-Training 3 Are you thinking of starting a blog? Or are you interested in presenting at events like SQL Saturday but not sure what to do to get started? This panel style session with established SQL bloggers will give you tips on blogging platforms, choosing topics, techniques for giving presentations, and sage advice from years of experience. 3/6/2010 10:15:00 AM 3/6/2010 11:15:00 AM 1292 Aaron Bertrand Track 2 AP1-Training 1 A collection of tips, tricks and gotchas revolving around the use of Management Studio for database development, administration and maintenance. Will also outline a few alternative tools. 3/6/2010 9:00:00 AM 3/6/2010 10:00:00 AM 1302 Janis Griffin Track 5 AP1-Training 4 Many DBAs and developers are faced with tuning poorly performing SQL statements. There is no way to learn everything you need to know about SQL tuning in an hour, but you can learn a process to employ when badly written SQLs are ruining database performance. However, many tuning projects fail because the process being used is inefficient. This presentation will walk through a process Confio Software uses with great success and will include topics such as: SQL diagramming, wait type data, column selectivity, and several more that will help you succeed on future tuning projects. 3/6/2010 2:45:00 PM 3/6/2010 3:45:00 PM 1305 Jessica Moss Track 9 AP2-VTC Do you already have a SharePoint implementation and now you need reporting capabilities? Attend this session to learn about incorporating SQL Server Reporting Services into your existing SharePoint installation. We will discuss the reasons why you would want to do this, and how to install, use, and access SSRS reports from SharePoint. 3/6/2010 10:15:00 AM 3/6/2010 11:15:00 AM 1306 Jessica Moss Track 9 AP2-VTC Producing a good looking report will wow your business users even if your data isn't all that impressive. If you've ever had trouble finding the best way to display that data or how to show trends appropriately, this is the session for you. We will review grouping logic, graphs, gauges, and more in Reporting Services 2008. With the knowledge in this session, you won't ever need to show a plain, boring report again! 3/6/2010 11:30:00 AM 3/6/2010 12:30:00 PM 1310 Jana Sattainathan Track 2 AP1-Training 1 • What is partitioning? • Why and when to partition your data? • History of Partitioning in SQL Server • How does partitioning in SQL Server compare to partitioning in Oracle? • Understanding partitioning in SQL Server and types of partitioning • Benefits of partitioning • Organizing partitions: File groups, files, partitions, indexes and constraints • Partition operations - merge/split partitions, exchange partitions to tables and vice versa (switch in and switch out) • Partitioning and archiving • System tables related to partitioning • Demoes • How to build a generic framework to manage partitioning? • How to convert non-partitioned tables into patitioned tables and vice versa? • Best practices • Downloads/References 3/6/2010 1:30:00 PM 3/6/2010 2:30:00 PM 1325 Steve Jones Track 4 AP1-Training 3 Learn how to better set yourself apart from the pack in this presentation on building a modern resume and brand using social networking, volunteerism, blogging, and more. Presented by Steve Jones, founder of SQLServerCentral. 3/6/2010 11:30:00 AM 3/6/2010 12:30:00 PM 1327 Denny Cherry Track 1 AP1-MPR One of the biggest issues in database performance centers around storage. It’s also one of the hardest places to troubleshoot performance issues because storage engineers and database administrators often do not speak the same language. In this session, we’ll be looking at storage from both the database and storage perspectives. We’ll be digging into LUNs, HBAs, the fabric, as well as RAID Groups. In addition to theory, we’ll be looking at an actual EMC SAN so that we can translate what we see in the Storage Array with what we see on the actual server. 3/6/2010 2:45:00 PM 3/6/2010 3:45:00 PM 1328 Denny Cherry Track 7 AP2-Mt. Kilimanjaro We’ll be looking into the pros and cons of moving SQL Servers into a virtual server environment. Specifically we’ll be looking into when it’s a good idea and when it’s probably not a good idea. Like all problems in the database world there are no hard set answers as to if virtualization is a good idea, but there are some times when virtualizing a SQL Server is a good idea, and can save you some money. There are some other times when you will be shooting yourself in the foot and shouldn’t. We’ll be focusing on when how to make this decision, and how to gather the metrics that you need in order to come to this decision. 3/6/2010 10:15:00 AM 3/6/2010 11:15:00 AM 1329 Denny Cherry Track 7 AP2-Mt. Kilimanjaro 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. 3/6/2010 4:00:00 PM 3/6/2010 5:00:00 PM 1333 Allen White Track 8 AP2-Matterhorn Most administrative functions consist of repetitive sequences of tasks which just take time. PowerShell is a powerful scripting environment which allows an administrator to automate those repetitive tasks, providing better results to the organization while saving the administrator time, and ensuring that the tasks get done properly every time. This session will give an introduction to PowerShell and demonstrate a number of scripts which help SQL Server administrators effectively manage their environments. 3/6/2010 2:45:00 PM 3/6/2010 3:45:00 PM 1335 Allen White Track 8 AP2-Matterhorn We all know how important it is to keep a baseline of performance metrics that allow us to know when something is wrong and help us to track it down and fix the problem. We don't always know how to do this easily and consistently. This session will walk you through a series of PowerShell scripts you can schedule which will capture the most important data and a set of reports to show you how to use that data to keep your server running smoothly. 3/6/2010 4:00:00 PM 3/6/2010 5:00:00 PM 1341 Aaron Nelson Track 8 AP2-Matterhorn In this session we will begin exploring the amazing world of the PowerShell language. We will compare cmdlets/operations to similar syntax/patterns in the T-SQL language.  We'll also step through one of the most talked about topics (the foreach-object command).  PowerShell has been bragged about since the beginning because of how much you can accomplish in just one line of code. When you leave this session YOU will be bragging about what YOU can do in just ONE line of code! 3/6/2010 11:30:00 AM 3/6/2010 12:30:00 PM 1364 SQL Sentry Track 1 AP1-MPR - 3/6/2010 12:30:00 PM 3/6/2010 1:00:00 PM 1366 Bill Walker Track 1 AP1-MPR Here's your chance to speak directly with members of the SQL Server Support Team based in Charlotte. 3/6/2010 1:30:00 PM 3/6/2010 2:30:00 PM 1367 Kevin Kline Track 1 AP1-MPR SQL Server encompasses a wide variety of domains – administrative, development, and design. But despite years of experience with relational databases, SQL Server practitioners frequently make the same mistakes over and over again. Wouldn’t you like to learn about those mistakes before they ever happen? This session will answer questions like: - What’s the most common Transact-SQL programming mistake and how do I fix it? - How do database designers cause problems for future generations of application developers and database administrators? - Why do inexperienced database administrators make their own job more difficult and less efficient? 3/6/2010 4:00:00 PM 3/6/2010 5:00:00 PM 1368 Kevin Kline Track 6 AP2-Mt. McKinley Let’s face it. You can effectively do many IT jobs related to SQL Server without knowing the internals of how SQL Server works. Many great developers, DBAs, and designers get their day-to-day work completed on time and with reasonable quality while never really knowing what’s happening behind the scenes. But if you want to take your skills to the next level, it’s critical to know SQL Server’s internal processes and architecture. This session will answer questions like: - What’s different about 32- and 64-bit systems? - What are the various areas of memory inside of SQL Server? - How are queries handled behind the scenes? - What does SQL Server do with procedural code, like functions, procedures, and triggers? - ...and much more. 3/6/2010 2:45:00 PM 3/6/2010 3:45:00 PM 1371 Jeffry Schwartz Track 6 AP2-Mt. McKinley This session will delve into a variety of unique and not-so-obvious correlation and analysis techniques using Windows performance metrics and SQL Server DMV's to uncover previously hidden performance bottlenecks in your SQL Server systems. 3/6/2010 4:00:00 PM 3/6/2010 5:00:00 PM 1376 Wayne Snyder Track 3 AP1-Training 2 If you plan to use SSRS in a large enterprise there are many things you should do be successful - things that do not seem to have much prescriptive guidance for. The purpose of this session is to provide you with guidance around those administrative things you should do to have a successful, maintainable SSRS Site in a large Enterprise. We wll discuss How should folder structure and security be set up? Are there best practices around data sources? Are SSRS 2008 Report Models Models ready for the enterprise? How should projects be organized? Is Report Builder 2.0 good enough yet? What works well and what will cause you pain? We will spend our time in a very practical discussion to help you get SSRS deployed and working. 3/6/2010 2:45:00 PM 3/6/2010 3:45:00 PM 1425 Evan Basalik Track 1 AP1-MPR Evan will talk about how SQL Azure works behind the scenes, plus demonstrate how to use the cloud-based sibling of SQL Server. He will also discuss how to best design your applications to take advantage of the power of SQL Azure. 3/6/2010 11:30:00 AM 3/6/2010 12:30:00 PM 1426 Evan Basalik Track 3 AP1-Training 2 Evan will show you how to diagnose and solve common connectivity issues. This will include covering GNEs, Kerberos, and completely inaccessible SQL Servers. He will demonstrate how to use UDLs and network traces to easily identify the problem, plus provide tips that often solve the problem in seconds. 3/6/2010 4:00:00 PM 3/6/2010 5:00:00 PM 1427 Andy Warren, Steve Jones, Rushahb Mehta Track 1 AP1-MPR SQLSaturday founders Andy Warren and Steve Jones, and current PASS President Rushabh Mehta, will conduct an open forum discussion on SQLSaturday -- where it has been, and where it will be heading under PASS management. Microsoft's Bill Walker will also be covering venue logistics, and CSSUG's Peter Shire will be going over prize drawings and after-party details. PLEASE DO NOT MISS! 3/6/2010 8:15:00 AM 3/6/2010 8:45:00 AM 1428 Microsoft Cafeteria Track 2 AP1-Training 1 Meet for lunch in the Microsoft cafeteria! 3/6/2010 12:30:00 PM 3/6/2010 1:00:00 PM 1442 Mark Tabladillo Track 3 AP1-Training 2 Microsoft provides excellent tutorials and information about data mining through the fictional Adventure Works demos. However, what happens when you stray off that neat-and-tidy path? Data miners should be concerned about data preparation, proper algorithm selection, and correct interpretation. This interactive experience will consist of succinct audience participation demos to introduce some practical issues in real-world data mining. 3/6/2010 1:30:00 PM 3/6/2010 2:30:00 PM 1453 Ashton Hobbs Track 4 AP1-Training 3 This session will cover the different forms of compression in SQL 2008, Backup and Data compression. The session will also explore best practices and how to overcome some of the limitations within the different compression technologies. 3/6/2010 2:45:00 PM 3/6/2010 3:45:00 PM 1466 Andy Kelly Track 5 AP1-Training 4 Do you know what counters, statistics, events and other information you should be collecting on a regular basis to properly monitor your SQL Server instances? Do you know where your current bottlenecks really are or how to even look for them. In this session we will cover the basics when it comes to monitoring the database, server and hardware that give us the biggest bang for the buck. See how a little bit of effort upfront can lead to a much better understanding of your database environment and put you in a position to spot potential issues before they become real trouble. 3/6/2010 9:00:00 AM 3/6/2010 10:00:00 AM