SQLSaturday #111 - Atlanta 2012 4/14/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. #sqlsat111 Georgia State University - Alpharetta 3775 Brookside Pkwy Alpharetta GA 30022 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 1681 Idera Platinum Sponsor http://www.idera.com http://www.idera.com/images/promos/Idera_60.jpg 60 170 1859 Red Gate Software Ltd Platinum Sponsor http://www.red-gate.com/ http://www.red-gate.com/archive/redgatelogo_black.jpg 60 170 1725 Intellinet Gold Sponsor http://www.intellinet.com http://www.intellinet.com/media/79328/intellinet_color_horiz_tag_170x60.png 60 170 1861 Enterprise Software Solutions Gold Sponsor http://www.entsoftsol.com http://www.codegumbo.com/images/entsoftsol.png 60 170 1938 SQL Sentry Gold Sponsor http://sqlsentry.net http://www.sqlsentry.net/images/ext/SQLSentryLogo148.jpg 60 170 1945 Quest Software Gold Sponsor http://www.quest.com/ http://www.quest.com/images/common/quest_logo.gif 60 170 2104 MDI Group Gold Sponsor http://www.mdigroup.com/ http://www.mdigroup.com/logos/MDI-Logo_4c-tag_letterhead.jpg 60 170 2108 WhipTail Gold Sponsor http://www.whiptail.com http://whiptail.com/wp-content/uploads/2012/03/WhipTail-100x40.jpg 60 170 2139 EMC Gold Sponsor http://www.emc.com http://www.codegumbo.com/images/EMC_notag_BK.jpg 60 170 1666 Confio Software Silver Sponsor http://www.confio.com http://www.confio.com/images/assets/confio_logo.jpg 60 170 1812 Perpetual Technologies, Inc. Silver Sponsor http://pti.net/ http://pti.net/logo/logo.png 60 170 2136 Fusion-io Silver Sponsor http://www.fusionio.com http://www.fusionio.com/images/fusionio-logo.gif 60 170 1850 Pragmatic Works Bronze Sponsor http://www.pragmaticworks.com http://pragmaticworks.com/images/pw_logo.jpg 60 170 1907 Linchpin People LLC Bronze Sponsor https://www.linchpinpeople.com http://linchpinpeople.com/wp-content/uploads/2012/02/linchpin_logo_trans.png 60 170 2066 LeanKit Bronze Sponsor http://blog.leankitkanban.com/landing/smpl http://leankitblog.com/wp/wp-content/uploads/2012/03/LeanKit_Logo_small.png 60 170 2105 Morgan Kaufmann Bronze Sponsor http://www.mkp.com http://mkp.com/wp-content/themes/Reshma_MK/images/mk_logo.jpg 60 170 1699 StrateSQL Blog Sponsor http://www.jasonstrate.com/ http://www.jasonstrate.com/images/StrateSQLProfile.jpg 40 100 1718 Shannon Lowder Blog Sponsor http://shannonlowder.com http://shannonlowder.com/wp-content/themes/vigilance_pro/images/lowder-wp-logo.png 40 100 1746 codegumbo Blog Sponsor http://www.codegumbo.com http://www.codegumbo.com/images/codegumbo_small.png 40 100 1774 SQLChick Blog Sponsor http://www.sqlchick.com http://melissacoates.squarespace.com/storage/SQLChick_Logo_100x40.png 40 100 1837 MarkTab Consulting Blog Sponsor http://www.marktab.net http://www.marktab.net/images/MarkTabNet_100x40.gif 40 100 1857 SQLvariant Blog Sponsor http://sqlvariant.com/wordpress http://sqlvariant.com/BlogSupport/Images/SQLvariant_Logo.png 40 100 1879 InfoAdvisors Blog Sponsor http://blog.infoadvisors.com http://blog.infoadvisors.com/loveyourdata100x40.jpg 40 100 2054 Steve Hughes - Data on Wheels Blog Sponsor http://www.dataonwheels.com http://dataonwheels.files.wordpress.com/2011/12/dataonwheelslogolglines.png 40 100 2143 Craig Purnell Blog Sponsor http://www.craigpurnell.com http://www.craigpurnell.com/wp-content/uploads/2012/03/CraigPurnellSQLSatLogo.jpg 40 100 6166 Jonathan Boulineau POW Room 1 Moore's law is not dead; it lives on as CPU manufacturers add more and more CPU cores to the same chip real estate. In this session, we will look at the ways in which you can leverage concurrent processing in your PowerShell code to dramatically increase the efficiency of your code. Speed up those ETL processes, execute code on multiple servers at the same time, and complete your maintenance tasks much faster using the techniques you will learn. 4/14/2012 2:30:00 PM 4/14/2012 3:30:00 PM 6168 Vicky Harp DBA\DEV Room 10 Introduced in SQL 2005, Common Table Expressions, or CTEs, are temporary result sets that offer increased flexibility in your T-SQL coding and provide a simple syntax for recusive queries. In this session for intermediate T-SQL coders, learn how to use CTEs to improve the readability and maintainability of your most complex queries. 4/14/2012 3:45:00 PM 4/14/2012 4:45:00 PM 6190 William E. Pearson III DBA\DEV Room 6 Microsoft BI Architect and SQL Server MVP Bill Pearson overviews PowerPivot for Excel, the client side of Microsoft’s foray into self-service BI. The targeted audience includes BI professionals who are seeking an introduction to what PowerPivot offers their organizations. Among others interested will be Excel power users who are fluent with PivotTables and want to understand the new capabilities. 4/14/2012 2:30:00 PM 4/14/2012 3:30:00 PM 6249 Tim Radney DBA\DEV Room 7 TEMPDB is just for temporary data right? It is installed by default and gets recreated it time SQL is restarted so what does it matter right? WRONG. This session will give you great insight into what uses TEMPDB, why TEMPDB is important, what are some best practices for configuring TEMPDB, and how to determine if you have contention. If you have systems where TEMPDB hasn't been touched since the install, you need to attend this session. 4/14/2012 2:30:00 PM 4/14/2012 3:30:00 PM 6254 Stuart Ainsworth DBA\DEV Room 8 Most database professionals know (from firsthand experience) that there continues to be a 'data explosion', and there's been a lot of focus lately on 'big data'. But what do you do when your data's just kind of 'biggish'? You're managing Terabytes, not Petabytes, and you're trying to squeeze out as much performance out of your aging servers as possible. The focus of this session is to identify some key guidelines for the design, management, and ongoing optimization of 'larger-than-average' databases. Special attention will be paid to the following areas: * query design * logical and physical data structures * maintenance backup strategies 4/14/2012 3:45:00 PM 4/14/2012 4:45:00 PM 6260 Christina Leo DBA\DEV Room 8 You may have heard that it’s a good idea to use a server-side trace to capture SQL profiler data, but do you know how to create one? And, do you know how to process the data you’ve captured? If not, then this session is for you. First, we’ll examine the anatomy of a server-side trace script and look at the different ways it can be customized. Then, we’ll talk about methods for stopping and starting the trace, how to know what traces are already running, and ways to schedule a trace to start under certain server conditions. Last, we’ll look at different tools available to you for analyzing the data you’ve gathered, including the SQL Server Profiler client application, “home-grown” T-SQL queries, ClearTrace, and the ReadTrace. 4/14/2012 9:00:00 AM 4/14/2012 10:00:00 AM 6302 Bob Langley DBA\DEV Room 6 With the new data security standards and legislation, encryption has become a necessity in today’s business world. This session will introduce SQL Server column-level encryption and show how it can easily be implemented as part of a comprehensive security initiative (even in SQL Server Express Edition!). The session will include slides and discussions to introduce concepts and will also have a live demo of a simple implementation of column-level encryption. This is intended for anyone who is interested in SQL Server encryption, or those who need to implement column-level security in their databases as part of their overall database information security strategy. 4/14/2012 3:45:00 PM 4/14/2012 4:45:00 PM 6413 Rob Volk DBA\DEV Room 9 In a world…where DBAs are blamed, mistreated, and overworked…one man….WILL. GET. EVEN. In this entertaining and impractical follow-up to the entertaining and impractical Revenge: The SQL, Rob Volk will show you even more impractical but oh-so-tempting ways to get back at those who abuse SQL Server and make you clean it up. Techniques will cover: preventing sa use, preventing ad-hoc SQL, hiding and obfuscating data and code, and the ever-popular trigger mayhem. And if you stay for the after-credits sequence you may encounter the evil twins, duplicate primary keys! 4/14/2012 3:45:00 PM 4/14/2012 4:45:00 PM 6429 Denny Cherry DBA\DEV Room 7 During this session we will be digging into the internals of SQL Server indexes. 4/14/2012 1:00:00 PM 4/14/2012 2:15:00 PM 6432 Denny Cherry DBA\DEV Room 7 In this session we will be looking at the SQL Server table partitioning features which were introduced in SQL Server 2008. We will look at how to create partitioned tables and indexes as well as the internals of the table. We will also look at how to move data from one partition to another and from one table to another with minimal to no impact to the users. 4/14/2012 3:45:00 PM 4/14/2012 4:45:00 PM 6515 Karen Lopez DBA\DEV Room 8 A highly interactive and popular session where attendees evaluate the options and best practices of common and advanced design issues, such as: * Natural vs. Surrogate keys * Classwords and other Naming Standards * Varchar Minimums *Identity Crisis * Who Calls the Shots and Who Does What? ...and others. Bring your votes, your debates, and your opinions. 4/14/2012 10:15:00 AM 4/14/2012 11:30:00 AM 6565 Wesley Brown DBA\DEV Room 6 Benchmarking, Baselines and Monitoring Storage There are several steps in the life cycle of your storage systems. We have several tools to help us understand our storage systems from initial deployment through its useful life. We will cover: SQLIO, a specific SQL Server benchmarking tool. Iometer, a general IO benchmarking tool and simulator. SQLIOSim a specific SQL Server base lining tool and simulator. TPC style testing focused on TPC-C, TPC-E and TPC-H. Monitoring your system using WMI and virtual file stats. Finally, what it all really means, how to read these results and compare them with each other. With these tools you can plan, deploy and manage your storage for years to come! 4/14/2012 1:00:00 PM 4/14/2012 2:15:00 PM 6659 Mark Tabladillo SSAS\IS\RS Room 5 SQL Server 2012 debuts a new Semantic Platform (commonly known as the applied task, Semantic Search). This text mining technology leverages the already established Full Text Index, and builds semantic indexes in a two-phase process. This presentation provides a science description and demo for the Enterprise implementation of Tag Index and Document Similarity Index. At present (RC0), the indexes work for 15 languages. Included are strategy tips for how to best leverage the technology along with already-existing Microsoft text mining and data mining. 4/14/2012 2:30:00 PM 4/14/2012 3:30:00 PM 6809 Wayne Sheffield DBA\DEV Room 10 Almost every SQL Developer is familiar with Table Variables and Temporary Tables. While each of these objects represent temporary storage, there are also substantial differences between them. Understanding the differences between Table Variables and Temporary Tables, and the ramifications that those differences cause, is essential to being able to properly select the appropriate object for use in your development tasks. In this code filled session, we’ll discover the differences and similarities of Temporary Tables and Table Variables, dispel some widespread myths about each, and answer the most important questions of them all, 'When do I use one or the other and what are the various impacts of doing so?' 4/14/2012 2:30:00 PM 4/14/2012 3:30:00 PM 6836 Sven Aelterman DBA\DEV Room 9 SQL Server 2012 introduces the first significant enhancement to FILESTREAM: FileTables. FileTables use the underlying FILESTREAM storage, but expose the stored data using traditional Windows file I/O APIs. In addition, they also support hierarchical data storage (read 'folders'). This session will show how to set up your SQL Server instance to support FileTables, how to create a FileTable and how to access it using standard Windows file APIs. It may be valuable to attend the Introduction to FILESTREAM session also. 4/14/2012 10:15:00 AM 4/14/2012 11:30:00 AM 6856 Grant Fritchey BEG Room 2 SQL Server backups can be burdensome to set up and maintain. All sorts of different problems can occur. This session targets the most common problems encountered while working with SQL Server backup and shows you how to identify these issues in your environment. In fact, I’ll walk you through how to prevent these common issues from ever cropping up within your systems in the first place. Be prepared for information you can take back to the office and put to work right away making your system backups more reliable. With backups running correctly all the time, you’ll be protecting your systems better, and feeling a lot less stress when it times to perform an emergency restore. 4/14/2012 3:45:00 PM 4/14/2012 4:45:00 PM 6873 Jen Underwood DBA\DEV Room 10 Get mobilized! Mobile business intelligence and mobile applications are hot in 2012. Learn how to leverage Microsoft Business Intelligence and SQL Server data platform technologies with a variety of mobile devices. The session will cover several options, tips, tricks, best practices and field lessons learned. 4/14/2012 10:15:00 AM 4/14/2012 11:30:00 AM 6875 Andy Leonard SSAS\IS\RS Room 4 In this “demo-tastic” presentation, SSIS trainer, author, and consultant Andy Leonard explains the what, why, and how of an SSIS framework that delivers metadata-driven package execution, connections management, and centralizes logging. Key takeaways: 1) Developers can migrate packages from Development, through their lifecycle, to Production without editing SSIS Connection Managers properties. 2) A metadata-driven approach to SSIS package execution. 3) Demonstration of a centralized logging reporting application. 4/14/2012 1:00:00 PM 4/14/2012 2:15:00 PM 6878 Jennifer McCown BEG Room 2 If you work with SQL Server at all, you need to know Transact-SQL, the SQL Server programming language. During this session, we’ll design and create our own table to demonstrate key concepts, query syntax, and more. If you’ve been meaning to learn T-SQL, here’s your chance! 4/14/2012 10:15:00 AM 4/14/2012 11:30:00 AM 6879 Jennifer McCown DBA\DEV Room 10 You’re a good SQL professional – you attend conferences and webinars, you read articles and books, and you know your way around SQL Server. But sometimes – just SOMEtimes – some piece of T-SQL slips by you unnoticed, or falls out of memory. Most of us are working with at least two or three out of the last five versions of SQL Server, so who can blame us for missing a feature or two? Come and revisit old favorites, and brush up on new T-SQL features and enhancements. In this session you will see SELECT turned inside-out. You’ll get really, really excited about OVER and PARTITION BY. This session is chock full of code examples, including before-and-after demos and how-to illustrations. 4/14/2012 1:00:00 PM 4/14/2012 2:15:00 PM 6880 Hal Rottenberg POW Room 1 Do you listen to podcasts? It's like the radio, but more Internetty. Well, Atlanta just so happens to be the home to the two co-hosts of the PowerScripting Podcast, the first podcast devoted to talking about Windows PowerShell. We have news, interviews, tips and resources that we present every week at powerscripting.net, but this time, the show is coming to you live! We'll come prepared to hit most any general PowerShell topic you want, and we'll probably sneak some SQL + PowerShell experts on stage to help out. This won't be a canned lecture, it will be more of a Birds of a Feather or talk show feel. Audience participation is REQUIRED! 4/14/2012 3:45:00 PM 4/14/2012 4:45:00 PM 6883 Jason Strate DBA\DEV Room 8 There are many ways to performance monitor your SQL Server environment. In this session we’ll review Extended Events, which is one of the newer SQL Server monitoring platforms. Learn the ins and outs of how to get detailed information on the errors and events that occur within SQL Server and how to dig into the information. With a few T-SQL statements, issues that could take weeks to research can be investigated in minutes. 4/14/2012 1:00:00 PM 4/14/2012 2:15:00 PM 6891 Ed Wilson POW Room 1 Learn Windows PowerShell best practices as they apply to each stage of the script development lifecycle. See the differences between working interactively from the Windows PowerShell prompt, writing an inline script, adding basic function, advanced functions and finally the implementation of Windows PowerShell Modules. What is a local best practice for Windows PowerShell development is not the same as a global best practice, and this talk covers those differences 4/14/2012 1:00:00 PM 4/14/2012 2:15:00 PM 6905 Rafael Salas SSAS\IS\RS Room 5 SSIS in SQL Server 2012 is getting major face lift and comes loaded with a great deal of enhancements and new features. In this session we explore the new the new project deployment model, design and runtime features along with deployment and management considerations using the also brand new SSIS catalog. This session provides you with valuable to get you going in your next SSIS 2012 project. 4/14/2012 10:15:00 AM 4/14/2012 11:30:00 AM 6922 Melissa Coates SSAS\IS\RS Room 3 You know BI. Right? Well kids, traditional Business Intelligence is changing … you heard about the ambitious data analyst down the hall who created a mashup of data from the internal data warehouse + Excel + an Azure feed? Empowering knowledge workers is Microsoft's vision of delivering 'BI for the Masses.' In this session we will dismiss the hype examine how this new world of 'Managed Self-Service BI' complements Corporate BI in SQL Server 2012 and SharePoint 2010. Goals: (1) Overview of each Self-Service component. (2) Introduce Codename 'Data Explorer' and Data As A Service. (3) Techniques to monitor, manage, secure the Self-Service BI environment. 4/14/2012 9:00:00 AM 4/14/2012 10:00:00 AM 6962 Grant Fritchey DBA\DEV Room 6 It’s one thing to know to look for scans instead of seeks, but if you really want to know what’s going on in an execution plan, you need to dive deep. This session will cover reading execution plans from the basics, but goes way beyond the basics to cover as much of the information available within an execution plan as you might possibly ever need. We’ll go into how to understand how to interpret parameter sniffing and spot when a join operation is not performing the way you would want. We’ll use the graphical plan and the XML behind to thoroughly explore execution plans. 4/14/2012 10:15:00 AM 4/14/2012 11:30:00 AM 7060 Geoff Hiten SSAS\IS\RS Room 3 Moving day is one of life's most stressful times. Details drown you, critical items consume time and attention, and there is always someone demanding you get something done now. This is true whether you are moving where you live or your data platform. SQL Server migrations are a core competency for a DBA. This presentation will give you a strong structured process for a successful SQL Server migration using examples focused on SharePoint workloads. 4/14/2012 1:00:00 PM 4/14/2012 2:15:00 PM 7065 Matt Masson SSAS\IS\RS Room 4 Enterprise Information Management (EIM) is an industry term for managing your data for data integration, quality, and governance. This session revolves around a demo which brings together the EIM functionality in SQL Server, a key part of our Credible, Consistent Data story for the 2012 release. We will show you how SQL Server Integration Services (SSIS), Data Quality Services (DQS), Master Data Services (MDS) and other Microsoft technologies work together to provide a comprehensive EIM solution. 4/14/2012 10:15:00 AM 4/14/2012 11:30:00 AM 7163 Jessica Moss SSAS\IS\RS Room 4 Using SQL Server 2008 R2 Reporting Services and Report Builder 3.0, report writers can store, re-use, and modify pieces of reports using 'report parts'. Report parts are stored on the report server and are provided to others for collaboration in a report part library to increase initial development productivity and decrease maintenance turn-around time. This presentation will describe how to set up a user-friendly and easily maintained report part library by discussing how to create report parts, how to store them on the report server, and how to import them into a new report. 4/14/2012 3:45:00 PM 4/14/2012 4:45:00 PM 7331 Brian Kelley DBA\DEV Room 7 In this session, we’ll take a look at Windows operating system internals, including kernel architecture, threads and processes, memory usage, and I/O, and how they affect how SQL Server performs and acts. By having a good understanding of how the operating system works under the covers and how it interacts with the SQL OS, you will gain a deeper knowledge of what’s going on with your SQL Servers and where performance issues may be on your systems. 4/14/2012 10:15:00 AM 4/14/2012 11:30:00 AM 7334 Brian Kelley BEG Room 2 Being a specialist means you're really, really good at one thing. Being a generalist means you're good at a a lot of different things. The generalist has an advantage over the specialist because he or she can see and solve problems the specialists can't. In this session I'll cover why it's important to diversify your skill set, not only for career protection, but to be better as a database professional. We'll look at what skill sets to build on to expand your abilities around SQL Server to include the operating system, development, networks, and security. Remember, this saying isn't complete, 'Jack of all trades, master of none.' The full saying is, 'Jack of all trades, master of none, though often times better than master of one.' 4/14/2012 9:00:00 AM 4/14/2012 10:00:00 AM 7365 Stacia Misner SSAS\IS\RS Room 3 Power View is the new data visualization and self-service BI tool that will debut in SQL Server 2012. To successfully roll-out this technology to your user community, you need to understand its architecture and data dependencies. Come to this session to get past the razzle dazzle that most Power View sessions offer, and peek behind the curtain to learn how to properly configure your environment to support Power View and how to prepare data for user consumption within Power View . 4/14/2012 3:45:00 PM 4/14/2012 4:45:00 PM 7412 Robert Cain SSAS\IS\RS Room 3 Reporting Services can be one of the easier tools to configure, once you understand how to use the configuration manager. In this session you'll explore the configuration settings available through the exploration of the Reporting Services Configuration Manager. You'll learn the different accounts Reporting Services will need in order to run, how to access Reporting Services via URLs, and the importance of encryption keys. 4/14/2012 10:15:00 AM 4/14/2012 11:30:00 AM 7413 Robert Cain BEG Room 2 Business Intelligence is one of the hottest job skills in the IT field. DBAs and Database Developers are being asked to implement databases with non-traditional design, and are having a lot of new vocabulary thrown their way. In this talk you will learn the concepts behind building and designing data warehouses, and cut through the buzz words so you will walk away with a clear understanding of what words like dimensions, facts, and measures mean. 4/14/2012 1:00:00 PM 4/14/2012 2:15:00 PM 7490 Pam Shaw SSAS\IS\RS Room 4 So the big wigs have come up with a “master” report that shows everything you could ever want on a single report. It includes grids and charts of varying sizes and complexities. Did I mention they want it pretty as well? In this session we will discuss how to use SQL Reporting Services 2008 R2 to bring it all together while avoiding the pit falls and mistakes. The demonstration will show how to build a multi-page, dashboard style report to manage your report server showing a multitude of grids and charts. We will discuss the challenges with data reuse and formatting while exploring techniques for getting them to work. To get the most out of this session, you should be able to build a report in SSRS. 4/14/2012 2:30:00 PM 4/14/2012 3:30:00 PM 7492 Hope Foley SSAS\IS\RS Room 5 Importing data is as common to SQL Server as bacon is to a savory breakfast sandwich. As most of us love to eat those breakfast sandwiches, SQL Server Integration Services (SSIS) loves to eat data in an Import/Export kind of way. Although a green chain of boxes in SSIS can be the ruling “Happy Dance” of any DBA or SQL Developer, we must still consider the performance of those tasks. In this session, we will go through performance tuning in SSIS 2012 after a successful SSIS package has been developed. When we are finished with this session, not only will you still have the mystic of green colors of successful execution of your SSIS import and export tasks, but the turbo boosters will be turned on as well. 4/14/2012 9:00:00 AM 4/14/2012 10:00:00 AM 7542 Jim Wooley DBA\DEV Room 8 As systems grow and evolve, we need tools to help manage these changes, including tracking changes to the database schemas, producing scripts to synchronize the changes between servers, and refactoring the corresponding application code based on the new structures. You'll see how you can use tools in Visual Studio to help manage these changes better. 4/14/2012 2:30:00 PM 4/14/2012 3:30:00 PM 7552 Jim Christopher POW Room 1 You know that problem you're working on? Chances are someone has already solved it, and has packaged their solution up in a nice pretty PowerShell module for you to use. Come learn about PowerShell modules - what they are, how you use them, where you can find them. And let's explore some of these modules and see what problems they can solve for us. 4/14/2012 10:15:00 AM 4/14/2012 11:30:00 AM 7553 Allen White POW Room 1 Windows Server 2008 introduced Server Core, the operating system without the Graphical User Interface. SQL Server 2012 is the first version of SQL Server to support Server Core. To gain the maximum efficiency from your servers you want to make use of Server Core and with PowerShell you can effectively manage SQL Server in that environment. This session will demonstrate how to manage SQL Server 2012 on Windows Server Core and provide scripts to help you perform the common tasks you need to perform on that platform. 4/14/2012 9:00:00 AM 4/14/2012 10:00:00 AM 7639 Eric Melcher SSAS\IS\RS Room 5 Recent changes in Business Intelligence have placed greater emphasis on on enabling end-user analytics. While compelling in theory, in practice there are many challenges when creating a foundation that supports end-users analytics. Many of these challenges revolve around making consistent reference (i.e. dimensional) data available to end users. This can be addressed using a Master Data Management solution. This session session will explore ways that Master Data Services 2012 can be used to support the definition and management of master data used to support analytics (BI) solutions. It will start with a high level overview of MDM and MDS 2012, and finish with a demo of an analytical MDM solution. 4/14/2012 1:00:00 PM 4/14/2012 2:15:00 PM 7642 Glen Gordon DBA\DEV Room 9 Learn about the various options for managing data in a Windows Phone application, including local storage, accessing data feeds, synchronization, and more. 4/14/2012 2:30:00 PM 4/14/2012 3:30:00 PM 7643 Teo Lachev SSAS\IS\RS Room 4 Confused about the BI alphabetical soup? Not sure which one makes sense for your organization? Join this session to learn you can use the Microsoft BI platform to address various analytical needs. Discover how to implement the Personal-Team-Organizational continuum on a single platform. I'll also discuss how Tabular and Multidimensional compare. 4/14/2012 9:00:00 AM 4/14/2012 10:00:00 AM 7677 Julie Smith BEG Room 2 You’ve finally gotten your first job working with SQL Server (SS) as the junior DBA at company XYZ. All the studying, the classes, the pricey SS certification exams, the User Group attendance has paid off. Your first day at the job your boss walks you through some new job duties. He wants you to remote out to the server to look at the file directory where the FTP process writes the encrypted files make sure the file share didn’t disappear when the cluster failed over. You slip away to the bathroom, lock yourself in a stall, have a seat and rock side to side muttering -What is he talking about?I thought there would be tables. If this sounds familiar this session is for you. Learn about the SS ecosystem how to navigate it as a new 4/14/2012 2:30:00 PM 4/14/2012 3:30:00 PM 7698 Erika Bakse SSAS\IS\RS Room 3 Reporting Services is a powerful tool that can make designing reports a snap...most of the time. But every once in a while you have to format a report very specifically, and that starts with your data query. In this session, we'll think outside the group! Learn about how to use named sets, dummy members, and other MDX tricks to craft your queries in a way that allows you to conquer the trickiest report layouts. 4/14/2012 2:30:00 PM 4/14/2012 3:30:00 PM 7699 Phil Pledger DBA\DEV Room 10 Over the years, I have seen NULL abused in many ways, often to the detriment of the application. This session will help you gain a deeper appreciation for what seems, on the surface, to be a simple topic. We will dig into how NULLs impact schema semantics, storage internals, and query performance. 4/14/2012 9:00:00 AM 4/14/2012 10:00:00 AM 7705 Kevin Boles DBA\DEV Room 6 This is a wonderful session for those that don't yet grok the three types of joins available to the SQL Server engine or the scenarios for which each join type is optimal. All will be explained here with some very slick visual demonstrations of internal data flow as well as TSQL code samples. We will also show how bad performance can get when suboptimal joins are used. 4/14/2012 9:00:00 AM 4/14/2012 10:00:00 AM 7751 Adam Machanic DBA\DEV Room 9 In today's multi-core-driven world, query performance is very much determined by how well you're taking advantage of the processing power at your disposal. In this session you will learn how to take full advantage of parallelism, from a developer's point of view. After a quick terminology review and technology refresher the session will go deep, covering T-SQL patterns that allow certain queries to scale almost linearly across your multi-core CPUs. Not all T-SQL queries can go parallel, so you'll also learn to watch for those things that can restrict the query optimizer's decisions. Along the way you'll learn to manipulate costs and row goals, challenge generally accepted tuning practices, and take complete control of your parallel queries. 4/14/2012 1:00:00 PM 4/14/2012 2:15:00 PM 7752 Jeremy Carroll DBA\DEV Room 7 In this session we will review the growing parts of rows and how to keep them as lean as possible. The following topics will be studied: • Row structure with a concentration on the parts that grow • Row and page compression and their effect on row structure • Prefix and Dictionary compression and their effect on row structure • The CPU cost of running queries against compressed data • Some strategies for compressing various data • Leave the attendees with additional demos and scripts for studying compression and testing it on your own machine 4/14/2012 9:00:00 AM 4/14/2012 10:00:00 AM 7764 John Welch SSAS\IS\RS Room 5 You’ve got your Analysis Services cube created, and deployed in production. However, you notice that every night, the cube is taking longer and longer to process, and users are starting to complain about their data not being ready when they arrive in the morning. If you’ve found yourself in this situation, or want to avoid being in it in the first place, come to this session. We’ll cover how to benchmark processing performance, track down bottlenecks, and how to tune things to get the best performance for processing your cube. 4/14/2012 3:45:00 PM 4/14/2012 4:45:00 PM 7776 Aaron Nelson DBA\DEV Room 9 SQL Server Management Studio can be really annoying sometimes. Over the years a few really nice features have been added that you may have overlooked or just couldn’t find. This session will focus some time saving tips and tricks for SSMS 2008 R2. We’ll also cover a few great new features being introduced in SSMS 2012. Since I can’t provide scripts for this session I guess I better get started working on some screen shots on where they hid all this stuff! 4/14/2012 9:00:00 AM 4/14/2012 10:00:00 AM