SQLSaturday #158 - New York City 2012 8/4/2012 12:00:00 AM (GMT-05:00) Eastern Time (US and Canada) SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. #sqlsat158 Microsoft New York Metro Office 1290 Avenue of the Americas, Sixth Floor New York NY 10104 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 2266 Quest Software Gold Sponsor http://www.quest.com http://www.sqlsaturday.com/files/e931c81e-6ea4-4f25-9a53-747b79018707.jpg 60 170 2294 GridIron Systems Gold Sponsor http://www.gridironsystems.com http://www.gridironsystems.com/wp-content/uploads/2011/02/GridIron_Logo42.png 60 170 2343 Pragmatic Works Gold Sponsor http://pragmaticworks.com/ http://pragmaticworks.com/images/logo/PragmaticWorksLogo.jpg 60 170 2327 Xtivia Silver Sponsor http://www.Xtivia.com http://www.xtivia.com/images/XtiviaLogo-170x60.jpg 60 170 2350 Idera Silver Sponsor http://www.idera.com http://www.idera.com/images/promos/Idera_60.jpg 60 170 2244 Joes 2 Pros Bronze Sponsor http://www.joes2pros.com/index.php http://joes2pros.com/about/Joes2Pros.jpg 60 170 2304 CozyRoc Bronze Sponsor http://www.cozyroc.com http://www.cozyroc.com/sites/default/files/down/cozyroc-big.png 60 170 2305 Red Gate Bronze Sponsor http://www.red-gate.com/?utm_source=ugutm_medium=uglogoutm_content=dotnetmiamiugutm_campaign=redgate http://www.sqlsaturday.com/files/0924f866-00f8-4ed1-b039-7335f5947d94.JPG 60 170 2336 Confio Software Bronze Sponsor http://www.confio.com http://www.confio.com/images/assets/confio_logo.jpg 60 170 2362 Melissa Data Bronze Sponsor http://www.melissadata.com http://www.melissadata.com/home/new-2009/melissa-data-logo.GIF 60 170 2380 SQLHA Bronze Sponsor http://www.sqlha.com http://www.sqlha.com/wp-content/themes/sqlha/images/logo.png 60 170 2391 Aspect Consulting Bronze Sponsor http://www.aspect-consulting.com http://www.aspect-consulting.com/media/17527/aspect_logo.jpg 60 170 2393 Ntirety Bronze Sponsor http://www.ntirety.com https://dl.dropbox.com/u/44594813/Ntirety%20Database%20Expert%20Logo.jpg 60 170 2394 Linchpin People, LLC Bronze Sponsor http://www.linchpinpeople.com http://linchpinpeople.com/wp-content/uploads/2012/02/linchpin_logo_trans.png 60 170 2367 Craig Purnell Blog Sponsor http://www.craigpurnell.com http://www.craigpurnell.com/wp-content/uploads/2012/03/CraigPurnellSQLSatLogo.jpg 40 100 2544 SAPIEN Technologies, Inc. Blog Sponsor http://www.sapien.com http://www.sapien.com/assets/img/logo3.png 40 100 9229 SQLSaturday 158 Track 1 Room A 8/4/2012 11:30:00 AM 8/4/2012 12:30:00 PM 9229 SQLSaturday 158 Track 2 Room B 8/4/2012 11:30:00 AM 8/4/2012 12:30:00 PM 9229 SQLSaturday 158 Track 3 Room C 8/4/2012 11:30:00 AM 8/4/2012 12:30:00 PM 9229 SQLSaturday 158 Track 4 Room D 8/4/2012 11:30:00 AM 8/4/2012 12:30:00 PM 9229 SQLSaturday 158 Track 5 Room E 8/4/2012 11:30:00 AM 8/4/2012 12:30:00 PM 9229 SQLSaturday 158 Track 6 Room F 8/4/2012 11:30:00 AM 8/4/2012 12:30:00 PM 9229 SQLSaturday 158 Track 7 Room G 8/4/2012 11:30:00 AM 8/4/2012 12:30:00 PM 9229 SQLSaturday 158 Track 8 Room H 8/4/2012 11:30:00 AM 8/4/2012 12:30:00 PM 9238 Edwin Sarmiento Track 8 Room H This is a demo-driven session that will focus on designing and implementing a multi-site, geographically dispersed SQL Server 2012 Failover Cluster instance across multiple data centers. We will cover the considerations on implementing such an architecture to address high availability and disaster recovery requirements for your mission-critical databases. 8/4/2012 4:15:00 PM 8/4/2012 5:30:00 PM 9243 Kevin Goff Track 2 Room B It might seem far-fetched that a company would upgrade to SQL Server 2012 “just” for a database index. But after you see the performance enhancements gained from the new columnstore index in SQL Server 2012, you’ll see why many are calling this one of the most important features in the history of SQL Server. In this presentation, I’ll talk about the physical aspects of columnstore index in SQL Server 2012, how to create it, and what environments (mainly data warehousing environments) and queries can make use of it. I’ll show performance benchmarks between columnstore indexes in SQL Server 2012, and compare them to index strategies prior to SQL Server 2012. I'll also show how the new Batch execution mode can improve performance as well 8/4/2012 4:15:00 PM 8/4/2012 5:30:00 PM 9251 Kevin Goff Track 2 Room B In this presentation, I'll go through all the new features in SQL Server 2012. I won't cover any one area heavily - the goal is just to identify (and in some cases, briefly show) as many new features as possible....from the new columnstore index, to T-SQL enhancements, to a greatly iimproved SSIS tool, to a new model for creating analytic databases, and more. SQL Server 2012 has a large amount of new functionality that helps all sorts of database developers. After this presentation, I can almost promise you'll be VERY interested in upgrading to SQL Server 2012. 8/4/2012 3:00:00 PM 8/4/2012 4:15:00 PM 9254 Mike Hillwig Track 4 Room D Mike Hillwig is known as the Cranky DBA. You probably have pain points in your environment that make you cranky, too. Mike has lots of horror stories to tell about bad SQL Server implementations and practices. More importantly, he has developed a list of 12 key tips for managing your SQL Server environment. By following these tips, you’ll make your DBAs, developers, and system administrators a little less cranky. 8/4/2012 3:00:00 PM 8/4/2012 4:15:00 PM 9265 Scott Klein Track 1 Room A This session will take an exploratory look at Microsoft's cloud-based relational database offering. We'll lift the hood and look at its many benefits and features, and how it easily fills the need for a highly available and scalable database service in the cloud. We'll discuss how SQL Azure helps ease provisioning and deployment, and how Microsoft takes care of the physical administration so that developers and DBA's alike can focus on the aspects of their job they really care about. 8/4/2012 12:30:00 PM 8/4/2012 1:45:00 PM 9266 Scott Klein Track 1 Room A With more and more companies moving to a cloud solution, the necessity to easily and efficiently scale their database solution is critical. This session will discuss how to scale SQL Azure using SQL Azure Federations, a recent addition to SQL Azure that provides the ability to build scalable, elastic, and multi-tenant solutions in SQL Azure. SQL Azzure Federations bring the sharding pattern into SQL Azure as a first class citizen as a way to achieve greater scalability and performance from the database tier of your application through horizontal partitioning at the database level. This session will look at Federations from a real-world point of view, by applying Federations to a real-life database. We will also look at performance benefits. 8/4/2012 1:45:00 PM 8/4/2012 3:00:00 PM 9270 Steve Simon Track 3 Room C SSRS 2012: Having just completed a PRACTICAL dashboard to answer JUST this exact question, we shall be looking at how to create a reporting tool that will provide YOUR management with all their answers. We shall be focusing on the plethora of information that may be reaped from Dynamic Managment Views (DMV) and see how KPI's may be incorporated into the mix. 8/4/2012 1:45:00 PM 8/4/2012 3:00:00 PM 9300 Jason Thomas Track 7 Room G SSRS 2008 R2 has been a game changer for SQL Server in terms of visualization techniques. With a wide range of available options for charting, BI professionals struggle to get familiar with even the basic functionalities of most charts. This session will talk about the basic functionalities of all the charts as well as some tips and tricks around them. Come to this session and take your charting skills to the next level. 8/4/2012 1:45:00 PM 8/4/2012 3:00:00 PM 9315 Ron Johnson Track 8 Room H Creating a performance baseline for a SQL Server instance provides many benefits including defining a starting point for optimization efforts, documenting the server, a reference point for capacity planning, and providing a reference for ongoing performance comparison. This session will provide a detailed presentation of an approach for collecting, storing, and presenting performance metrics for use in developing a baseline performance assessment of a SQL Server instance. 8/4/2012 12:30:00 PM 8/4/2012 1:45:00 PM 9317 AJ Mendo Track 6 Room F If you have wanted to learn how to use Extended Events and have had a hard time trying to figure out where to start then this session is for you. This session is designed for someone that has never used Extended Events before. After this session you will know the basics of how to setup and use this highly scalable and configurable architecture to trouble shoot server issues. You will see how to use them in SQL 2008 and how they have been beefed up in SQL 2012. This will be a demo rich session so come prepared to finally get to know Extended Events. 8/4/2012 9:00:00 AM 8/4/2012 10:15:00 AM 9324 Mark Stacey Track 7 Room G There are many treatments of table design for slowly changing dimenions, and almost as many on doing ETL on an SCD. Much less has been said about building a cube around a slowly changing dimension. In this session, Mark will review the types of slowly changing dimensions, describe the performance implications of various methods of loading SCDs in SSIS (SCD task, Lookups, Merge, and Script component), and build the versioning directly into the dimension in Analysis Services 8/4/2012 3:00:00 PM 8/4/2012 4:15:00 PM 9326 Mark Broadbent Track 4 Room D In this diverse session we will take an in-depth look at moving to the SQL 2012 platform and the upgrade strategies at your disposal. Specifically we will take a deep dive into preparing and reporting for upgrade, upgrade strategies, performing the upgrade and knowing the upgrade was successful. This session will also look at several advanced scenarios such as migrating to SQL Server 2012 on Server Core, AlwaysOn Availability Groups and AlwaysOn Fail-over Clustered Instances. Attend this must see session and you too can have the “Moves like Jagger”. 8/4/2012 12:30:00 PM 8/4/2012 1:45:00 PM 9327 Mark Broadbent Track 4 Room D Do you really understand SQL Servers’ Concurrency behaviour? Are you sure that Transactions are an ALL or NOTHING operation? Do you believe Read operations cannot start a Transaction? Do you really know if READ_UNCOMMITTED is safe for reporting? Is being Optimistic really better than being Pessimistic? Can SQL Server 2012 be the solution to all our problems or our worst nightmare? I look forward to you joining me in this very revealing and thought provoking session where I will provide answers to all these questions and more and make you wish you had known all of this sooner. 8/4/2012 1:45:00 PM 8/4/2012 3:00:00 PM 9348 Ira Whiteside Track 8 Room H Fuzzy Matching, Similarity Matching or Record Linkage is the most critical and least understood process in any Data Warehouse, BI, Integration, Big Data , Data Quality, MDM , Social Network or integrating crap effort. Over at LinkedIn there is Group run by Henrik Liliendahl Sorensen for Data Matching, Bill Winkler, principal researcher at the US Census' has written a series of white papers on record linkage and particular a technique called 'Blocking Indexs'. In addition we wil cover William Cohen Research Professor, Machine Learning Department, Carnegie Mellon University white papers an implementations. Presented will be our collection of 'real world' examples(Code) and you will leave a master of record linkage and the concepts behind it 8/4/2012 10:15:00 AM 8/4/2012 11:30:00 AM 9360 Robert Pearl Track 3 Room C In my session, I will offer some practical tips and tricks on a wide-array of Index Analysis methods that will allow you to find out everything about a client's indexes and were afraid to ask! What better way to optimize the performance of the database than talk about their indexes. What do you need to know in order to make these suggestions, and implement them. This session will cover the basics on indexes, and then demonstrate ways to improve DB performance. Missing Indexes, Duplicate Indexes, Fragmented Indexes, Covering Indexes, Clustered Nonclustered indexes, and the queries that love them. I will also demo ways in which you can correlate the worst performing queries with missing indexes 8/4/2012 12:30:00 PM 8/4/2012 1:45:00 PM 9400 Martin Schoombee Track 5 Room E Snapshot fact tables are a common approach when a point-in-time reference is required. In some cases though, even snapshots are not an option due to the amount of data it will generate. In this session we will walk through a practical example of when and how to implement temporal fact tables, and how these can be a viable alternative to snapshots in certain situations. 8/4/2012 10:15:00 AM 8/4/2012 11:30:00 AM 9462 Alex Grinberg Track 6 Room F Practical XML usage for SQL Server 2005 and up. Working examples how to load, create, and shred the XML using XPath query methods. The XML tips and tricks. 8/4/2012 1:45:00 PM 8/4/2012 3:00:00 PM 9489 William E. Pearson III Track 7 Room G The Analysis Services 2012 Business Intelligence Semantic Model (BISM) unifies Multidimensional (OLAP) and Tabular (relational) options for organizational BI. BI professionals can implement Multidimensional cubes, or they can deploy Tabular models developed by business users to a dedicated server. Those new to Tabular, or those embarking upon BI for the first time with Analysis Services 2012, may find it difficult to choose between the two paths. In this session, BI Architect and MVP Bill Pearson overviews the nature and design goals of each option, comparing Multidimensional and Tabular features. He then offers guidance on selecting the appropriate model, providing real world examples to illustrate approaches for given scenarios. 8/4/2012 4:15:00 PM 8/4/2012 5:30:00 PM 9493 Peter Myers Track 7 Room G SQL Server 2012 PowerPivot will allow analysts to use Excel 2010 to load and prepare large volumes of data from various data sources to create a data model. The data model can then be enriched with calculations to become a data source for Excel PivotTable, PivotChart and CUBE function reports. And as compelling as these BI experiences can be that’s not the end of the story. A PowerPivot workbook deployed to SharePoint Server 2010 can be used to create even more compelling BI experiences using Reporting Services and PerformancePoint Services. In this presentation learn about the fundamentals of PowerPivot data model creation, and the exciting ways PowerPivot data models can be used to visualize and share data. 8/4/2012 10:15:00 AM 8/4/2012 11:30:00 AM 9496 Peter Myers Track 6 Room F Data mining as a technology is designed to analyze large volumes of data looking for patterns that accurately predict behavior. These patterns can then be used to derive knowledge about data, and in turn this knowledge can be used to enhance application designs and the user experience. In this presentation, you will be introduced to Microsoft SQL Server 2005 and 2008 Data Mining and demonstrations on how to develop data mining models that can be embedded into your applications. Demonstrations are based on SQL Server 2008 R2 Data Mining. This presentation is a must for any developer looking to embed “Artificial Intelligence” into their solution design to take their applications to the next level. 8/4/2012 4:15:00 PM 8/4/2012 5:30:00 PM 9542 Dan Clark Track 5 Room E A large volume of analysis that a business typically performs on its data involves dates and/or times. For example, you may need to compare sales from one year to the next or aggregate transactions over time. DAX incorporates many built in time intelligence functions to help make date-time based calculations easier. Although the time intelligence functions are very beneficial, they can be misused and give erroneous results. To avoid this, it is imperative that you understand what functions to use and how to use them. This session is designed to guide you through the various time intelligence functions available in DAX and provide practical examples of how to use them. 8/4/2012 3:00:00 PM 8/4/2012 4:15:00 PM 9545 Christina Leo Track 3 Room C Creating a query plan can be a time consuming and expensive process. To avoid repeating these costly steps, SQL Server stores its query plans, in the plan cache where they can be reused as needed. In this session, we’ll look at how the plan cache is organized, what plans are saved, when plans are reused and when they are recreated, methods for observing the contents of the plan cache, and finally, methods for manipulating plan reuse and recreation. 8/4/2012 4:15:00 PM 8/4/2012 5:30:00 PM 9565 Rick Morelan Track 8 Room H Gone are all the spaghetti errors of past versions of SQL. For example did you know that BEGIN TRAN…COMMIT TRAN is not enough to make everything work together? People are often shocked when they see the demo in this talk where the first statement fails and all others statements still commit. This can still happen to you in SQL 2012 if you are not aware of the options. In fact did you know that when SQL encounters an error of Severity 11 (or higher), there a 4 different ways it can react? Learn how to predict the Error Action and control it. This is possible with or without structured error handling. See both ways to control the outcome to the way you want it. 8/4/2012 9:00:00 AM 8/4/2012 10:15:00 AM 9658 Ben DeBow Track 8 Room H Each application and system is different, but all have a similar quality: there will be times where the systems are used more, and other times where they may appear to be sleeping. Good examples are monthly, quarterly, and yearly for financial systems and the holiday season for retail. The last thing you want to have in these time frames is your CxO standing at your desk wondering why things are slow or possibly down. Ensuring that your SQL Servers are optimally configured for those heavy usage periods cannot be done with a wing and a prayer – you need an actionable, realistic plan. This session will discuss how to guarantee that your SQL Server instances and the configurations they use are as scalable and reliable as possible. 8/4/2012 1:45:00 PM 8/4/2012 3:00:00 PM 9691 Andy Novick Track 7 Room G Stored procedures and functions are the mainstay of SQL Server coding. In this presentation you will learn techniques to locate problem code and to improve it's performance. Step 1 is to discover where the time is going using server traces, code to analyzes the traces, and the new Extended Events. Once we know where the time is going we look at strategies to improve performance: Managing indexes on temp tables and why heaps are often the best choice for temp tables; determining if an index is helping; Rewriting scalar and multi-statement functions as inline functions and why it’s so important; mastering minimally logged operations and the “Go Faster” switch. Each technique is illustrated with examples 8/4/2012 9:00:00 AM 8/4/2012 10:15:00 AM 9714 Leonard Lobel Track 3 Room C With the release of SQL Server 2012, the new SQL Server Data Tools serves as your primary development environment for building applications on top of SQL Server. SSDT plugs in to Visual Studio with tooling designed specifically for the application developer. With SSDT, developers no long need to constantly switch between VS and SSMS. In this session, Lenni demonstrates how SSDT is used to develop for (and deploy to) on-premise and SQL Azure databases. You will learn how to use code navigation, IntelliSense, and refactoring with your database model, and how to design databases offline and under source control right from VS. Don’t miss out on this demo-centric information-packed session on the next generation of database tools for developers! 8/4/2012 10:15:00 AM 8/4/2012 11:30:00 AM 9718 Leonard Lobel Track 3 Room C As SQL Server evolves, so does Microsoft continue to improve and enhance Transact SQL (T-SQL). In SQL Server 2012, T-SQL remains the primary language for programming the relational database engine. In this informative and demo-packed session, Lenni will guide you through the T-SQL enhancements in the very latest release of SQL Server. We’ll dive into powerful new windowing enhancements with the OVER clause, running and sliding aggregations, new T-SQL functions (all 22 of them!), improved error handling with THROW, server-side paging with OFFSET/FETCH NEXT, sequence generators, and rich metadata discovery techniques. If you want to learn the new T-SQL enhancements in SQL Server 2012, you won’t want to miss out on this session! 8/4/2012 9:00:00 AM 8/4/2012 10:15:00 AM 9747 Mike Hillwig Track 6 Room F See those things around your ankles? You hope they're your socks because no DBA wants to be caught with their pants down. Whether you're an accidental DBA, a DBA who has just inherited a bunch of servers, or someone who works in a shop that won't buy monitoring tools, this session will help you get basic monitoring in place to make sure you know what's going on in your environment. You'll learn how to implement seven simple scripts that perk their ears up and start barking like a dog after a stranger walks in the house. They are the canary in your coal mine. You'll know when backups fail, when they run longer than usual, when data files are getting full, when transaction logs have excessive VLFs, and more. 8/4/2012 10:15:00 AM 8/4/2012 11:30:00 AM 9756 Brent Ozar Track 2 Room B SQL Server speed boils down to how fast we can get data in and out of storage. Sooner or later, we're going to run out of memory to cache. In this session, we take a lesson from Microsoft's blazing-fast Fast Track Reference Architectures, look at why they work so well for the wildest queries, and explain how to build our own SQL Servers for quick queries. Brent Ozar shows you how to test your own servers and compares them to servers he's worked with in the field. 8/4/2012 12:30:00 PM 8/4/2012 1:45:00 PM 9757 Brent Ozar Track 2 Room B You want to deploy AlwaysOn, but you're concerned about hidden drawbacks, performance impacts, and how it affects development. Brent Ozar has deployed SQL 2012 Availability Groups at big web sites including StackOverflow.com and the Discovery Channel, plus used it to scale out reads at data warehouses. Come learn what he's found in real-life deployments of AlwaysOn. 8/4/2012 1:45:00 PM 8/4/2012 3:00:00 PM 9802 Tim Radney Track 8 Room H You say you have a backup strategy, but what is your recovery strategy? In this session I will demonstrate several methods for performing much-needed backups and how to recover those backups to include FULL, DIFFERENTIAL, FILE GROUP, and TRANSACTION LOG. He will also demo performing a peace meal restore as well as backing up and restoring the tail end of the log after the data file becomes corrupt. I will discuss industry best practices for backing up and recovering your data. The goal of this session is to educate you on the various backup strategies so you can decide which is best for your organization, demonstrate how to recover your databases, and to create the desire for you to go back and validate your current strategies 8/4/2012 3:00:00 PM 8/4/2012 4:15:00 PM 9805 Linchi Shea Track 6 Room F Solid State Drives (SSD) are becoming one of the mainstream storage solutions, and many firms have started placing SQL Server database files on SSD in hope of gaining performance. However, how to best run SQL Server on SSD is not a settled question. Conflicting opinions abound. This session is packed with first-hand data points, sharing with you the results from a series of extensive performance tests on SSD, either with or without SQL Server. You will learn the basic performance characteristics of SSD, and what SQL Server/SSD configurations may give you best results. 8/4/2012 3:00:00 PM 8/4/2012 4:15:00 PM 9824 Allan Hirt Track 4 Room D Bad Windows builds? No HA? No backups? SQL Server considered the non-mission critical platform yet you have hundreds of instances? Over the years I've seen most, if not all of, the good, bad, and ugly of being a SQL Server DBA from being both a full time employee as well as a consultant. If you want to skip 20 years of ups and downs, come to this session to hear how you can be a better DBA for your SQL Server deployments, avoid pitfalls, and hopefully laugh at a few of my misadventures over the course of my career. 8/4/2012 4:15:00 PM 8/4/2012 5:30:00 PM 9892 Marc Jellinek Track 6 Room F Get an overview of the problem domain, architecture and solution space for Data Quality Services. See how Data Quality Services works hand-in-hand with Master Data Management to create master data, matching rules and leverage both to deduplicate data 8/4/2012 12:30:00 PM 8/4/2012 1:45:00 PM 9915 John Miner Track 5 Room E Today's large data fields (LDF) are full of unstructured information stored in varchar, text, varbinary or xml data types. How do you write an application to search the column for patterns? Traditional SQL techniques using a column INDEX and LIKE operator result in a query plan that contains a full table scan. I will be introducing the brother's grimm database that has the full text of each fairy tale. I will create a full text catalog / index, select a change tracking strategy, define optional stop list / thesaurus file, and then populate the index. I will use CONTAINS and FREETEXT operators in SELECT queries to leverage the FTI. This resulting query plan performs index seek. 8/4/2012 4:15:00 PM 8/4/2012 5:30:00 PM 9979 Randy Knight Track 3 Room C If you've ever found yourself stating the above, this session is for you. For many developers, writing T-SQL that works is not the challenge. But too often, functional T-SQL is not the same as good T-SQL. In this session, we will examine why 'SQL that works' is not good enough. Understanding indexes, exectuion plans, sargability, and more are all critical to writing good T-SQL. We will also examine several real-world examples of T-SQL that 'worked great in dev' but caused major issues when it hit production. 8/4/2012 3:00:00 PM 8/4/2012 4:15:00 PM 9991 SB Chatterjee Track 1 Room A PowerShell is a command-line scripting language primarily designed for system administration development. Unlike VBScript or DOS batch files, PowerShell is built upon the .NET Platform which makes it customizable and extensible. This introductory session will show the PowerShell language constructs scripts and how it can be used for SQL Server administration (using SMO WMI providers) and development (ADO.Net OLEDB providers). 8/4/2012 4:15:00 PM 8/4/2012 5:30:00 PM 10005 Brian Knight Track 2 Room B In this demo-rich presentation, Brian shows you some of the common and not so common ways to tune SQL Server Integration Services (SSIS). Learn how to tune the data flow using some of the advanced SSIS options and how to avoid common SSIS mistakes. See how to measure performance and how to keep SSIS from monopolizing your server's resourcing. Lastly, discover SQL Server 2008 and 2012 features that will make SSIS more efficient. 8/4/2012 9:00:00 AM 8/4/2012 10:15:00 AM 10008 Brian Knight Track 2 Room B In this session, you'll learn how to cleanse your data and apply simple to complex business rules in SSIS. Learn how to solve complex data problems quickly in SSIS using Data Quality Services (DQS). The speaker will show you how to incorporate scripting into your SSIS data flow to find and fix bad data. Then he'll show how to use advanced fuzzy logic to satisfy data duplication issues. Lastly, he’ll show you how to implement advanced data cleansing and normalization in SQL Server 2012 SSIS with DQS and MDS. 8/4/2012 10:15:00 AM 8/4/2012 11:30:00 AM 10011 Todd McDermid Track 5 Room E You rarely hear of a data integration project that doesn't involve a spreadsheet as a source document, a lookup reference, or an output. It's the ambiguously ubiquitous container for business data because it's so flexible and familiar to users. Unfortunately, the same features those business users crave tend to cause huge problems for data professionals. In this session we'll look at typical integration issues with Excel, explain why they occur, and show you more options than just the Excel Source or COM API. In a world where spreadsheets are the 'database of choice' for business users, knowing how to get SSIS to interact reliably with Excel is an essential skill. 8/4/2012 1:45:00 PM 8/4/2012 3:00:00 PM 10030 Kevin Kline Track 1 Room A 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. 8/4/2012 10:15:00 AM 8/4/2012 11:30:00 AM 10031 Kevin Kline Track 7 Room G Considering a promotion into management? This session will teach you the fundamental skills needed to effectively lead an IT team. Topics include motivational skills, conflict resolution skills, communication skills and project/job tracking skills. Attendees will also learn: 1. How to motivate a team and keep the members of that team focused and on task. 2. How to resolve conflicts, address performance problems, and handle project/job missteps. 3. How to gain support for your ideas, earn upper management support, and communicate with top management. 8/4/2012 12:30:00 PM 8/4/2012 1:45:00 PM 10033 Michael Corey Track 4 Room D An SQL Server database is resource-intensive by its very nature and one of the most resource-intensive Business Critical applications you will ever virtualize. If best practices are not followed, the database will never perform as needed. This presentation will teach the DBA best practices for Virtualizing SQL Server on VMware. Key Takeaway 1 Key Database Best Practices Key Takeaway 2 Common Mistakes How to Avoid Them Key Takeaway 3 Many resources available and where to find them 8/4/2012 9:00:00 AM 8/4/2012 10:15:00 AM 10041 Hilary Cotter Track 5 Room E Replication is a native SQL Server component which is used for copying, distribution and aggregating data between databases and servers. In this presentation SQL Server MVP discusses the different replication types and technologies and their sweet points. He also shows common use cases, gotcha's, and performance tuning and troubleshooting techniques. 8/4/2012 9:00:00 AM 8/4/2012 10:15:00 AM 10062 Andrew Brust Track 1 Room A Big Data entails collecting and analyzing large volumes of data obtained from Web, social media, scientific and other pools of fast-growing event-driven data. Recently, Microsoft announced its Windows Server and Windows Azure implementations of Hadoop, the open source distributed processing engine widely used in Big Data implementations. And the plot thickens, as Microsoft also fits SQL Server business intelligence (BI) tools on top of Hadoop, to make the analysis part of Big Data work with familiar and accessible Microsoft technologies. Come to this session to get an overview of Big Data, Hadoop and its integration with te Microsoft BI stack. See how your skills can be applied to this rapidly growing part of the industry. 8/4/2012 9:00:00 AM 8/4/2012 10:15:00 AM 10063 Andrew Brust Track 4 Room D It’s one thing to have a high-level understanding of Big Data, Hadoop and MapReduce; it’s quite another to feel comfortable working with the tools. In this demo-heavy session, ZDNet Big Data blogger and Visual Studio magazine columnist Andrew Brust will take a look at actual MapReduce code and see Hadoop ecosystem components HBase, Hive, Pig and Mahout in action. 8/4/2012 10:15:00 AM 8/4/2012 11:30:00 AM 10128 SQL Saturday SQL Saturday Track 4 Room D SQL Saturday 8/4/2012 8:30:00 AM 8/4/2012 9:00:00 AM 10128 SQL Saturday SQL Saturday Track 3 Room C SQL Saturday 8/4/2012 8:30:00 AM 8/4/2012 9:00:00 AM 10128 SQL Saturday SQL Saturday Track 1 Room A SQL Saturday 8/4/2012 8:30:00 AM 8/4/2012 9:00:00 AM 10128 SQL Saturday SQL Saturday Track 2 Room B SQL Saturday 8/4/2012 8:30:00 AM 8/4/2012 9:00:00 AM 10128 SQL Saturday SQL Saturday Track 5 Room E SQL Saturday 8/4/2012 8:30:00 AM 8/4/2012 9:00:00 AM 10128 SQL Saturday SQL Saturday Track 6 Room F SQL Saturday 8/4/2012 8:30:00 AM 8/4/2012 9:00:00 AM 10128 SQL Saturday SQL Saturday Track 7 Room G SQL Saturday 8/4/2012 8:30:00 AM 8/4/2012 9:00:00 AM 10128 SQL Saturday SQL Saturday Track 8 Room H SQL Saturday 8/4/2012 8:30:00 AM 8/4/2012 9:00:00 AM 10129 SQL Saturday SQL Saturday Track 8 Room H SQL Saturday 8/4/2012 5:30:00 PM 8/4/2012 6:00:00 PM 10129 SQL Saturday SQL Saturday Track 7 Room G SQL Saturday 8/4/2012 5:30:00 PM 8/4/2012 6:00:00 PM 10129 SQL Saturday SQL Saturday Track 6 Room F SQL Saturday 8/4/2012 5:30:00 PM 8/4/2012 6:00:00 PM 10129 SQL Saturday SQL Saturday Track 5 Room E SQL Saturday 8/4/2012 5:30:00 PM 8/4/2012 6:00:00 PM 10129 SQL Saturday SQL Saturday Track 2 Room B SQL Saturday 8/4/2012 5:30:00 PM 8/4/2012 6:00:00 PM 10129 SQL Saturday SQL Saturday Track 1 Room A SQL Saturday 8/4/2012 5:30:00 PM 8/4/2012 6:00:00 PM 10129 SQL Saturday SQL Saturday Track 3 Room C SQL Saturday 8/4/2012 5:30:00 PM 8/4/2012 6:00:00 PM 10129 SQL Saturday SQL Saturday Track 4 Room D SQL Saturday 8/4/2012 5:30:00 PM 8/4/2012 6:00:00 PM 11093 Edwin Sarmiento Track 1 Room A SQL Server DBAs have relied so much on graphical user interface (GUI) to administer and manage database servers. So, why take away the GUI? If you’re more into using the command-line and PowerShell to manage your servers, come to this session to learn how to implement SQL Server 2012 on Windows Server Core 8/4/2012 3:00:00 PM 8/4/2012 4:15:00 PM