SQLSaturday #211 - Chicago 2013 4/13/2013 12:00:00 AM (GMT-06:00) Central Time (US and Canada) SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. #sqlsat211 1221 N. Swift Rd. Addison IL 60101 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 2955 DeVry University You Rock! http://www.devry.edu/locations/campuses/loc_addisoncampus.jsp http://www.sqlsaturday.com/files/057911e9-7d09-4712-88bc-0d0847b5aa29.jpg.jpg 60 170 3194 TEKsystems You Rock! http://teksystems.com/ http://www.padnug.org/SponsorLogos/teksystems.png 60 170 3245 Violin Memory You Rock! http://www.violin-memory.com http://72.47.217.141/images/VIOLIN-MEMORY-LOGO-FULL-COLOR-SQL-PASS.PNG 60 170 3166 Idera Gold Sponsor http://www.idera.com http://www.sqlsaturday.com/files/75546684-873d-4d2a-b944-fe97c4869efb.png 60 170 3151 Tegile Systems Gold Sponsor http://www.tegile.com http://www.sqlsaturday.com/files/2566ae86-edcb-476c-8f3c-2c96d5faf32c.jpg 60 170 3035 Confio Software Gold Sponsor http://www.confio.com http://www.confio.com/images/assets/confio_logo.jpg 60 170 3102 Melissa Data Silver Sponsor http://www.melissadata.com http://www.melissadata.com/images/mdlogo-color-tag-170x60.gif 60 170 3335 SQL Sentry Silver Sponsor http://Www.sqlsentry.net http://www.sqlsentry.net/UI/customMenu/headLogo.png 60 170 3103 House of Brick Technologies Bronze Sponsor http://www.houseofbrick.com http://davidklee.net/hob_sqlsat_logo.png 60 170 3110 Sql Power Tools, Inc. Bronze Sponsor http://www.sqlpower.com http://www.sqlpower.com/img/spt_logo_sql_saturday.png 60 170 3162 COZYROC Bronze Sponsor http://www.cozyroc.com/ http://www.cozyroc.com/sites/default/files/down/cozyroc-big.png 60 170 3202 SQLskills Bronze Sponsor http://www.sqlskills.com http://www.sqlskills.com/sqlskillslogo.jpg 60 170 3210 SQLHA Bronze Sponsor http://www.sqlha.com http://www.sqlha.com/wp-content/themes/sqlha/images/logo.png 60 170 12853 SQLSaturday 211 Track 1 Room 214 4/13/2013 12:00:00 PM 4/13/2013 12:45:00 PM 12853 SQLSaturday 211 Track 2 Room 116 4/13/2013 12:00:00 PM 4/13/2013 12:45:00 PM 12853 SQLSaturday 211 Track 3 Room 216 4/13/2013 12:00:00 PM 4/13/2013 12:45:00 PM 12853 SQLSaturday 211 Track 4 Room 217 4/13/2013 12:00:00 PM 4/13/2013 12:45:00 PM 12853 SQLSaturday 211 Track 5 Room 117 4/13/2013 12:00:00 PM 4/13/2013 12:45:00 PM 12853 SQLSaturday 211 Track 6 Room 118 4/13/2013 12:00:00 PM 4/13/2013 12:45:00 PM 12853 SQLSaturday 211 Track 7 Room 215 4/13/2013 12:00:00 PM 4/13/2013 12:45:00 PM 12853 SQLSaturday 211 Track 8 Room 218 4/13/2013 12:00:00 PM 4/13/2013 12:45:00 PM 12854 SQLSaturday 211 Track 8 Room 218 4/13/2013 7:30:00 AM 4/13/2013 9:00:00 AM 12854 SQLSaturday 211 Track 7 Room 215 4/13/2013 7:30:00 AM 4/13/2013 9:00:00 AM 12854 SQLSaturday 211 Track 6 Room 118 4/13/2013 7:30:00 AM 4/13/2013 9:00:00 AM 12854 SQLSaturday 211 Track 5 Room 117 4/13/2013 7:30:00 AM 4/13/2013 9:00:00 AM 12854 SQLSaturday 211 Track 4 Room 217 4/13/2013 7:30:00 AM 4/13/2013 9:00:00 AM 12854 SQLSaturday 211 Track 3 Room 216 4/13/2013 7:30:00 AM 4/13/2013 9:00:00 AM 12854 SQLSaturday 211 Track 2 Room 116 4/13/2013 7:30:00 AM 4/13/2013 9:00:00 AM 12854 SQLSaturday 211 Track 1 Room 214 4/13/2013 7:30:00 AM 4/13/2013 9:00:00 AM 12855 SQLSaturday 211 Track 1 Room 214 4/13/2013 5:30:00 PM 4/13/2013 6:00:00 PM 12855 SQLSaturday 211 Track 2 Room 116 4/13/2013 5:30:00 PM 4/13/2013 6:00:00 PM 12855 SQLSaturday 211 Track 3 Room 216 4/13/2013 5:30:00 PM 4/13/2013 6:00:00 PM 12855 SQLSaturday 211 Track 4 Room 217 4/13/2013 5:30:00 PM 4/13/2013 6:00:00 PM 12855 SQLSaturday 211 Track 5 Room 117 4/13/2013 5:30:00 PM 4/13/2013 6:00:00 PM 12855 SQLSaturday 211 Track 6 Room 118 4/13/2013 5:30:00 PM 4/13/2013 6:00:00 PM 12855 SQLSaturday 211 Track 7 Room 215 4/13/2013 5:30:00 PM 4/13/2013 6:00:00 PM 12855 SQLSaturday 211 Track 8 Room 218 4/13/2013 5:30:00 PM 4/13/2013 6:00:00 PM 12865 Josh Fennessy Track 3 Room 216 With the release of SQL 2012, Analysis Services (SSAS) has seen some major changes. An entire new method of modelling analytic data has emerged and it's called Tabular Mode Analysis Services. In addition to that, a new semantic layer has been added to the tool, the Business Intelligence Semantic Model (BISM), which will help to bring the two modes -- Multidimensional and Tabular -- into one level playing arena. In this session, attendees will gain understanding of what Multidimensional and Tabular modelling IS, as well as how the BISM layer helps to translate user requests to ensure no confusion is made. Attendees will also learn how to BUILD a Tabular model, and will help design a solution live during the presentation. 4/13/2013 1:00:00 PM 4/13/2013 2:15:00 PM 12868 Allan Hirt Track 5 Room 117 The word cluster is used a lot in the IT world, especially when it comes to SQL Server. We have clustered instances of SQL Server, availability groups that require Windows failover clustering ... but how does a DBA make sense of it all? Wonder no more! This session will explain all the forms of clustering as they relate to SQL Server (including how Windows fits into the picture) and give you some of the top keys to success whether you are using an older version of Windows and SQL Server, or you're looking to deploy the latest and greatest. 4/13/2013 9:00:00 AM 4/13/2013 10:15:00 AM 12880 David Klee Track 5 Room 117 Sure, your SQL Server is up and running. Is it healthy? Is it performing the best that it can? Where are your performance bottlenecks? In an emergency, can you objectively demonstrate where a performance problem lies? This dynamic dialog session by David Klee (@kleegeek) will present a solid process for checking your environment's overall health and performance levels as well as solutions for common problems. Some of the items focused on include dynamic management views (DMVs), Windows Perfmon, and disk performance tools such as IOMeter and SQLIO. 4/13/2013 10:30:00 AM 4/13/2013 11:45:00 AM 12884 Merrill Aldrich Track 7 Room 215 If you haven't dug in to PowerShell at this point, you're missing out on some amazing, powerful, practical stuff that could save you time every day. PowerShell does have a learning curve at the outset, especially for those not already familiar with OO concepts or programming in a language like C#, so this introductory session will go through the very basics of PowerShell syntax. If that collection of pipes and hyphens and curly braces seems to be written in some incomprehensible foreign language, this session is for you. At the end of the session you should have a grasp of how and why a PowerShell script does what it does, and the confidence to dig in deeper and begin using POSH scripts in your own work. 4/13/2013 10:30:00 AM 4/13/2013 11:45:00 AM 12888 Terry Bunio Track 8 Room 218 Come to this session and learn how easy it is to install an SQL Server Reporting Services (SSRS) Environment with a SharePoint Foundation environment. Terry will share his lessons learned on how to install and configure an SSRS/Sharepoint environment. Terry will also share the lessons learned about what the books don't tell you and how to set up your SharePoint sites and security to lessen future grief. Terry will even cover some more detailed topics like how to configure Visual Studio to be able to deploy from within Visual Studio right to Sharepoint and how to call an SSRS report from Java. 4/13/2013 2:30:00 PM 4/13/2013 3:45:00 PM 12889 Chris Webb Track 1 Room 214 Excel 2013 is an exciting release for Microsoft BI, and in this session we’ll take a look at all the new BI-related features in it: the PowerPivot engine integrated directly into Excel; Power View integrated as a new type of worksheet; web-based reporting with Excel Services in Sharepoint 2013; new features for users connecting to SSAS (Tabular and Multidimensional); and many other new features and functions. It’s so exciting you’ll want to upgrade right away! 4/13/2013 9:00:00 AM 4/13/2013 10:15:00 AM 12901 Ross LoForte Track 5 Room 117 Availability Groups, a feature of SQL Server 2012 delivers mission critical high availability and disaster recovery in the same solution. This session covers capabilities, deployment architecutes, how to install, configure, manage and troubleshoot this new feature with best practices of customers who have deployed and are using Availability Groups. 4/13/2013 4:00:00 PM 4/13/2013 5:15:00 PM 12947 Jorge Segarra Track 3 Room 216 Have you ever read a job description (or needed to hire one yourself) asking specifically for a “BI DBA” and wondered what exactly that means? In this session we will discuss the expectations of the role, what the various pieces of the Microsoft BI stack are and what administrative components and gotchas are involved for each one. If you need to unveil the mysteries and intricacies of administrating an SSIS, SSAS and/or SSRS environment from a DBA perspective then check this session out! 4/13/2013 9:00:00 AM 4/13/2013 10:15:00 AM 13038 Leonard Murphy Track 3 Room 216 Power View is a visual data exploration tool that comes built into Excel 2013. With it you can build charts that seamlessly interact with each other and quickly map your data using Bing maps. In this session, you will learn how to get the most out of Power View: what it does well and what it doesn't so you can maximize the value you get out of it in a minimum amount of time. 4/13/2013 4:00:00 PM 4/13/2013 5:15:00 PM 13064 Neil Hambly Track 4 Room 217 SQL Server 2012 brings a wide range of changes from its previous versions - one key change is the way SQL Server memory is managed. With releases prior to SQL Server 2012, there were 2 memory managers, these have been merged into 1 with the latest version, and that’s just the start of the changes for SQL Server memory. This session will dive into questions related to memory primarily for SQL Server 2012. 4/13/2013 2:30:00 PM 4/13/2013 3:45:00 PM 13098 Sanil Mhatre Track 7 Room 215 Though most developers agree that unit testing plays an important role in software development, to ensure quality meet milestones, most developers write unit tests only as an afterthought. VSTS helps to mainstream Test Driven Development methodology (TDD) into world of database development. In this session, we will not only cover the basis of unit testing concepts and terminology, but also discuss how unit testing helps ensure and document the quality and accuracy of database deliverables. We will run through a demo of creating and running database unit tests using VSTS 2012, as well as upgrading from VSTS2010 database and unit test projects. 4/13/2013 2:30:00 PM 4/13/2013 3:45:00 PM 13163 Jason Strate Track 2 Room 116 You’ve spent the afternoon sweating over your T-SQL query. You’ve wrung out all of the wrinkles. It’s deployed, it’s running… now its waiting. In SQL Server the most performant query can become a problem query if there aren’t any resources in the SQL Server for it to use. In this session, we’ll look at wait statistics and what they are. We’ll look into how they are accumulated and how they can be monitored. By the end of the session, you’ll be equipped with the tools needed to determine if there are resource issues in your environment and methods to start mitigating them. 4/13/2013 1:00:00 PM 4/13/2013 2:15:00 PM 13165 Jason Strate Track 2 Room 116 Execution plans are stored after execution in the plan cache. This metadata about how queries are executed can provide insight into how your SQL Server environment is functioning. By using XQuery to browse and search the plan cache you can find potential performance issues and opportunities to tune your queries. This information can be used to help reduce issues related to parallelism, shift queries from using scans to using seek operations, or discover exactly which queries are using what indexes. All of this and more is readily available through the plan cache. In this session we will explore the plan cache and start you on the road to discovery. 4/13/2013 9:00:00 AM 4/13/2013 10:15:00 AM 13190 Rick Krueger Track 6 Room 118 When should you favor a NoSQL store over SQL Server, or consider polyglot persistence? In military and police operations, the rules of engagement determine when, where, and how force shall be used. As the “data police”, we are responsible for determining when, where, and how data is stored. As SQL Server professionals, it tends to be our first choice, even when there are other data storage options that are a ‘more natural’ fit. In this session, Rick and Dave will start with the NoSQL basics, and then dive into the different categories of NoSQL stores while explaining what each type is well suited for. (Pair Presented with Dave Valentine @IngeniousSQL) 4/13/2013 2:30:00 PM 4/13/2013 3:45:00 PM 13244 Kathi Kellenberger Track 2 Room 116 Have you heard about all the great new T-SQL features? Attend this session to learn about new functions, OVER clause enhancements, the Sequence Object and more! 4/13/2013 4:00:00 PM 4/13/2013 5:15:00 PM 13304 Julie Koesmarno Track 3 Room 216 One of the hottest trends in analytics right now is geospatial reporting. Long gone are the days of viewing region based data in a grid. Now it is possible to provide users with additional insight on the regional performance of business. In this session, Julie will show you three options for creating and delivering these analytics. First SQL Server Reporting Services 2012 will be presented to show how we can create custom shape objects to conform with business defined regions. Secondly, using the power of Excel 2013, Bing Maps and GeoFlow, learn how to build captivating visualizations directly in Excel. Finally, we'll show how easy it is to build interactive maps using Power View. 4/13/2013 2:30:00 PM 4/13/2013 3:45:00 PM 13322 Doug Lane Track 1 Room 214 In this Star Trek-themed presentation, we will explain the terms and concepts important to understand when participating in projects involving SQL Server Analysis Services (SSAS). You’ll learn the key differences between SSAS Multidimensional Model (Cubes) and SSAS Tabular Model. You’ll also learn the definitions and examples of key terms for each model, including but not limited to: measure groups, measures, dimensions, attributes, and hierarchies in the SSAS Multidimensional Model and tables, columns, and calculated measures in the SSAS Tabular Model. We will also demonstrate the basics of browsing of both Multidimensional and Tabular models using Excel 2013. 4/13/2013 1:00:00 PM 4/13/2013 2:15:00 PM 13349 Ted Krueger Track 1 Room 214 With SQL Server 2012 released and going strong, we’re all wanting the latest and greatest, high performing, SQL Engine sitting on our servers. How we do that is another question. How do you get a weekend of downtime? Do you like convincing the business you need it? I don’t and that is why we’re going to look at methods to upgrade or migrate SQL Server 2005, SQL Server 2008 and SQL Server 2008 R2 up to SQL Server 2012 with as little downtime as possible - minutes. In this session, we’ll see how mirroring, log shipping and even replication, can make us look like DBA Rock stars at upgrade time. 4/13/2013 2:30:00 PM 4/13/2013 3:45:00 PM 13354 Mike Donnelly Track 8 Room 218 With the release of SQL Server 2012 one of the biggest changes for SSIS Administration was the addition of the Integration Services Catalog and using parameters. The Catalog is the storage and logging location for SSIS 2012. Parameters are the new configurations in SSIS 2012 and once you start using them you will never go back. Package Variables, Configuration Strings, Package properties can all be configured using Parameters. You will learn how to create the catalog, use parameters to deploy packages through different environments and use the built in reporting to monitor packages as they run. 4/13/2013 9:00:00 AM 4/13/2013 10:15:00 AM 13362 Eddie Wuerch Track 5 Room 117 Managing data in ever-growing transaction and history tables can be challenging. Activities with large chunks of data such as moving data to archive tables, batch-importing many rows, or defragging an entire table when only the active portion changes introduces heavy I/O and blocking. Table partitioning seamlessly solves a host of headaches with minimal effort. Ever wanted to truncate or defrag part of a table, or insert an entire staging table of data into another table in milliseconds instead of hours? Come see what partitioning can provide for you. 4/13/2013 1:00:00 PM 4/13/2013 2:15:00 PM 13371 Joseph Vertido Track 3 Room 216 Learn about Microsoft’s Data Quality Services (DQS), what it is and how it works. You will discover how DQS sets itself apart from conventional data cleansing routines and go through examples on how to begin your own Data Quality Project. What really makes DQS unique and powerful is its ability to access shared knowledge, so we will show you how to access and use this shared knowledge to your benefit. 4/13/2013 10:30:00 AM 4/13/2013 11:45:00 AM 13428 Paul Turley Track 8 Room 218 When do you use a sparkline, column, or line chart? How do you create a business scorecard – and with what tool? Using Excel, Power View, and Report Builder, this session will guide you through the choices and help you apply the right visual to your business data. Come see what well-known industry experts have to say about the correct use of visualization choices and techniques, colors, backgrounds, borders, and 3-D effects. Then see demonstrations of how to create those rich visuals in the different reporting tools, used with PowerPivot and tabular semantic models. 4/13/2013 10:30:00 AM 4/13/2013 11:45:00 AM 13452 Hope Foley Track 8 Room 218 Ted Krueger will join Hope in presenting this session. Consulting is a mystical career path that is often questioned: should I do it, can I do it and why should I do it? Come join us on a discussion of the pros and cons to consulting with an emphasis on SQL Server and Microsoft Technologies. We'll field questions with real world experiences. Once you leave this open floor session, you'll be able to make better choices in your own professional development and how consulting may or may not effect it. 4/13/2013 4:00:00 PM 4/13/2013 5:15:00 PM 13477 Scott Shaw Track 4 Room 217 What will the DBA role look like in 10 years? 20 years? Will a DBA still be necessary? We'll explore a number of scenarios in an open forum as we try to determine how, as DBA's, we can position ourselve for a bright and productive future. I'll talk about the trends I'm seeing from companies of all shapes and sizes. This presentation isn't about consensus but about tackling the tough issues facing the future of our profession. 4/13/2013 9:00:00 AM 4/13/2013 10:15:00 AM 13491 Aaron Lowe Track 7 Room 215 As protectors of arguably, the most important asset companies’ have we are tasked with ensuring quality, security and performance. However the ways in which we utilize and obtain those assets are often not formalized and therefore suffer from degraded quality. Let's discuss some strategies that can be implemented to not only raise the bar of quality, but also make you sleep easier at night. 4/13/2013 9:00:00 AM 4/13/2013 10:15:00 AM 13493 Stacia Misner Track 8 Room 218 SharePoint makes it easy for users to create their own dashboards but there's more to dashboards than just fast and easy set-up. This session will explore not only the characteristics of an effective BI dashboard using SharePoint 2013, but also the design flaws to avoid. Attend this session and learn how to perform a dashboard makeover. Starting with a review of a dashboard that uses technology correctly but not as effectively as it could, you’ll explore common problems found in dashboards, learn the characteristics of good dashboard design and discover how to implement a dashboard that communicates information clearly and concisely. 4/13/2013 1:00:00 PM 4/13/2013 2:15:00 PM 13496 Paul Timmerman Track 5 Room 117 Until 2005, SQL Server was a very pessimistic RDBMS. However with the introduction of the Read Committed Snapshot database option and the new Snapshot Isolation level, that is no longer the case. After a high level look at all SQL Server isolation levels, we’ll spend the majority of this session discussing the implementation of optimistic concurrency control in SQL Server. We’ll look at the benefits and drawbacks of using an optimistic isolation level and discuss use cases where it may or may not be appropriate. Come learn how to put one of the more powerful, but least understood, aspects of SQL Server to work for you! 4/13/2013 2:30:00 PM 4/13/2013 3:45:00 PM 13510 Ed Leighton-Dick Track 6 Room 118 Pop quiz: How can SQL Server help developers build scalable, distributed, and asynchronous applications? Service Broker is the answer! In this presentation, I'll show you what it is; talk about when and why you might want to use it in your applications; walk through an example of how to set it up; and share a few lessons learned from our successful implementations. 4/13/2013 9:00:00 AM 4/13/2013 10:15:00 AM 13568 James Serra Track 1 Room 214 You’re a DBA, and your boss asks you to determine if a data warehouse would help the company. So many questions pop into your head: Why use a data warehouse? What’s the best methodology to use when creating a data warehouse? Should I use a normalized or dimensional approach? What’s the difference between the Kimball and Inmon methodologies? Does the new Tabular Model change things? What’s the difference between a data warehouse and a data mart? Is there any hardware that is optimized for a data warehouse? Join this session for the answers to all these questions. You’ll leave with information that will amaze your boss and lead to a big raise… – or at least lead you down the correct path to adding business value to your organization! 4/13/2013 4:00:00 PM 4/13/2013 5:15:00 PM 13571 James Serra Track 4 Room 217 BI is the “Gathering of data from multiple sources to present it in a way that allows executives to make better business decisions”. I will describe in more detail exactly what BI is, what encompasses the Microsoft BI stack, why it is so popular, and why a BI career pays so much. I will review specific examples from previous projects of mine that show the benefits of BI and its huge return-on-investment. I'll go into detail on the components of a BI solution, and I will discuss key concepts for successfully implementing BI in your organization. 4/13/2013 10:30:00 AM 4/13/2013 11:45:00 AM 13605 Joseph D'Antoni Track 6 Room 118 Back in the old days, compression and databases was a really bad idea. Now, with powerful CPUs we can use to both improve performance and save disk space. We will cover the basics of how all compression and deduplication works, and then we will learn how SQL Server page and row compression work, and the special compression that is used in SQL 2012 Columnstore Indexes. We will demo performance and space savings in using compression. 4/13/2013 1:00:00 PM 4/13/2013 2:15:00 PM 13616 Frank Gill Track 6 Room 118 Are you a DBA? Do you have more than one instance? An instance with more than one database? A database with more than one object? If you answered yes to any of these questions, join me to learn to administer multiple instances, databases and objects from a single query or script. Topics covered will include Central Management Server, loops with dynamic SQL and sqlcmd. 4/13/2013 10:30:00 AM 4/13/2013 11:45:00 AM 13672 Jason Thomas Track 1 Room 214 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. 4/13/2013 10:30:00 AM 4/13/2013 11:45:00 AM 13681 Kevin Kline Track 2 Room 116 Want to take your skills to the next level? Then it’s critical to know SQL Server’s internal processes and architecture. This session will answer questions like:- 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?- What happens during checkpoints? Lazywrites?- How are IOs handled with regards to transaction logs and database?This fast paced session will take you through many aspects of the internal operations of SQL Server. So strap on your silly, as we cover all these topics and more at speed with tongue planted firmly in cheek! 4/13/2013 2:30:00 PM 4/13/2013 3:45:00 PM 13708 Haidong Ji Track 6 Room 118 As an admin, we need to keep an eye on storage: What is the total size and available size on disk devices? What about mount points? How much space does each database take? What about breaking that down into schemas, tables, data size, and index size? Granted, some of that can be seen through Management Studio reports, but what if we want to keep a historical record of all that for planning and trending purposes? What if we are on a tight budget and cannot afford monitoring software. In this session, I will explain and demo a PowerShell/SQL Server combo solution that is simple, elegant, and works! You will come away with code and instructions on how to implement it. 4/13/2013 4:00:00 PM 4/13/2013 5:15:00 PM 13709 Luke Jian Track 7 Room 215 A lot of database professionals today do not have a Computer-Science Degree so they never attended a “Introduction to Databases” course. In this session we are trying to fix at least one thing and we’ll look in depth at the three types of join operations, visualize how their algorithms work in order to understand how query plans are computed, explain why these join operations have very different performance characteristics and why the optimizer chooses a specific join operator to use in a query plan. Will demonstrate that empirical cost calculations are similar to what Query Optimizer actually outputs. Good understanding of join algorithms is vital in order to diagnose and remedy issues related to bad query plans. 4/13/2013 4:00:00 PM 4/13/2013 5:15:00 PM 13711 Kyle Neier Track 4 Room 217 These terms seem to be thrown around all the time – but what do they all mean? In this session we’ll explore the different isolation levels in SQL Server and how they affect the way that blocking and locking behave within the database engine. We’ll dive into the most common locks and how they can be leveraged and avoided to improve your application experience. Once locks are explored, we’ll discuss the dreaded deadlock and discuss techniques to detect and mitigate this troublemaker in your environment. 4/13/2013 1:00:00 PM 4/13/2013 2:15:00 PM 13716 Rob Volk Track 7 Room 215 Never given time or care, never forming good relationships, becoming bloated, corrupt and rife with indistinguishable copies, and all so horrifyingly pervasive in society. But enough about the Kardashians, what about YOUR DATA? If you want to straighten it out and prevent it from going too far in the first place, this session is for you. We will cover constraint basics (not null, check, primary key/unique, foreign keys), provide standard use cases, and address misconceptions about constraint use and performance. We will also look at triggers and application logic and why these are NOT substitutes for (but can effectively complement) good constraint usage. Attendees will enjoy learning how to keep THEIR data off the tabloid page! 4/13/2013 1:00:00 PM 4/13/2013 2:15:00 PM 13721 Erin Stellato Track 2 Room 116 If you’re like me, you’ve been using SQL Trace and Profiler since you started using SQL Server. They’re like old friends, tried and true. You know how they work, you know what you can capture, you know how to find the data you need. But now you’ve been told that your good friends have been deprecated in SQL Server 2012, and you need to become best friends with Extended Events. What is THAT all about? It’s ok. Really. In this session we’ll look at Profiler and Extended Events side by side to see how easy it is to transition to Extended Events. We’ll step through real world examples using Extended Events to do what you’re used to doing with Trace, and even more. You can find the time learn Extended Events…today. 4/13/2013 10:30:00 AM 4/13/2013 11:45:00 AM 14743 Erin Stellato Track 4 Room 217 Database statistics are not made up numbers, like the statistics you may hear on TV or read in a news article. They are critical metadata used by SQL Server’s query optimizer. In this session, we will look at statistics from the ground up and remove the mystery that surrounds them. Demos and real-world examples will be used to explain what statistics are, why you should care about them, and what you can control. By the end of the session, you will understand: • How to view statistics and interpret the histogram • How and when to update statistics • How statistics affect the query optimizer • When you can let SQL Server manage statistics, and when you need to step in 4/13/2013 4:00:00 PM 4/13/2013 5:15:00 PM