SQLSaturday #162 - Cambridge 2012 9/8/2012 12:00:00 AM (GMT) Greenwich Mean Time : Dublin, Edinburgh, Lisbon, London SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. #sqlsat162 SQLSaturday #162 Information Travel
Venue at: Crowne Plaza
Downing St
Cambridge , United Kingdom CB2 3DT 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 2297 Red Gate Platinum http://www.red-gate.com http://www.red-gate.com/archive/redgatelogo_black.jpg 60 170 2468 Fusion-io Pre-Con + Gold Sponsor http://www.fusionio.com/ http://www.sqlsaturday.com/files/85e014cb-1739-4b4e-9ec1-c2ebf848beba.jpg 60 170 2300 Copper Blue Consulting Ltd Gold Sponsor http://www.copperblueconsulting.com http://www.copperblueconsulting.com/sites/default/files/final_design_small_0.png 60 170 2595 Quest Software UK Ltd Gold Sponsor http://www.quest.com http://www.sqlsaturday.com/files/436d32ca-5068-43fd-b8a7-93c73f7ad588.jpg 60 170 2610 SQLCloud Limited Gold Sponsor http://sqlcloud.co.uk http://www.sqlsaturday.com/files/5f55ad65-85ae-43f0-a2e5-688a3030e460.png 60 170 2428 Idera Silver Sponsor http://www.idera.com http://www.idera.com/campaign_images/logo_Idera_tag_170x60.png 60 170 2578 SQL Sentry, Inc. Silver Sponsor http://www.sqlsentry.net http://www.sqlsentry.net/UI/customMenu/headLogo.png 60 170 2446 Confio Software Bronze Sponsor http://www.confio.com http://www.confio.com/images/assets/confio_logo.jpg 60 170 2557 Prodata SQL Centre of Excellence Bronze Sponsor http://www.prodata.ie http://www.prodata.ie/images/Prodata_Logo.jpg 60 170 2589 Purple Frog Bronze Sponsor http://www.PurpleFrogSystems.com http://www.purplefrogsystems.com/images/PurpleFrogLogo170.png 60 170 2611 Clear Sky SQL Bronze Sponsor http://clearskysql.co.uk http://www.clearskysql.co.uk/images/8059952_l.jpg 60 170 2444 SAPIEN Technologies, Inc SWAG Sponsor http://www.sapien.com http://www.sqlsaturday.com/files/cfb209ad-aa73-4b94-a41d-d6034cd092ae.jpg 40 100 2588 Pluralsight SWAG Sponsor http://www.pluralsight.com http://www.sqlsaturday.com/files/d654bcf1-7ba8-4db5-8527-aba875d3e053.png 40 100 2612 Wrox/ Wiley SWAG Sponsor http://www.wrox.com/WileyCDA/ http://www.sqlsaturday.com/files/09a80092-068b-48fd-9cde-9508d8e62224.jpg 40 100 2333 Mark Broadbent Friends Of http://tenbulls.co.uk http://www.sqlsaturday.com/files/c22db5eb-2516-4e4d-9740-b2a3f6b52b3e.png 40 100 9451 SQLSaturday 162 Track 1 Room 1 9/8/2012 8:55:00 AM 9/8/2012 9:05:00 AM 9451 SQLSaturday 162 Track 1 Room 1 9/8/2012 11:15:00 AM 9/8/2012 11:25:00 AM 9451 SQLSaturday 162 Track 1 Room 1 9/8/2012 3:30:00 PM 9/8/2012 3:50:00 PM 9451 SQLSaturday 162 Track 2 Room 2 9/8/2012 8:55:00 AM 9/8/2012 9:05:00 AM 9451 SQLSaturday 162 Track 2 Room 2 9/8/2012 11:15:00 AM 9/8/2012 11:25:00 AM 9451 SQLSaturday 162 Track 2 Room 2 9/8/2012 3:30:00 PM 9/8/2012 3:50:00 PM 9451 SQLSaturday 162 Track 3 Room 3 9/8/2012 8:55:00 AM 9/8/2012 9:05:00 AM 9451 SQLSaturday 162 Track 3 Room 3 9/8/2012 11:15:00 AM 9/8/2012 11:25:00 AM 9451 SQLSaturday 162 Track 3 Room 3 9/8/2012 3:30:00 PM 9/8/2012 3:50:00 PM 9451 SQLSaturday 162 Track 4 (special) Room 4 9/8/2012 8:55:00 AM 9/8/2012 9:05:00 AM 9451 SQLSaturday 162 Track 4 (special) Room 4 9/8/2012 11:15:00 AM 9/8/2012 11:25:00 AM 9451 SQLSaturday 162 Track 4 (special) Room 4 9/8/2012 3:30:00 PM 9/8/2012 3:50:00 PM 9452 SQLSaturday 162 Track 4 (special) Room 4 9/8/2012 12:20:00 PM 9/8/2012 1:35:00 PM 9452 SQLSaturday 162 Track 3 Room 3 9/8/2012 12:20:00 PM 9/8/2012 1:35:00 PM 9452 SQLSaturday 162 Track 1 Room 1 9/8/2012 12:20:00 PM 9/8/2012 1:35:00 PM 9453 Bruno Basto Track 2 Room 2 This session describes how SQL Server internally stores table data. Although you can use SQL without understanding the internals of data storage, a deep knowledge of how data is stored will improve the development of efficient applications. This session explores the basic of metadata that keeps track of data and index storage information. 9/8/2012 4:50:00 PM 9/8/2012 5:45:00 PM 9455 Andy Leonard Track 1 Room 1 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. 9/8/2012 10:20:00 AM 9/8/2012 11:15:00 AM 9473 Tobiasz Koprowski Track 3 Room 3 2AM. We sleeping well. And our mobile ringing and ringing. Message: DISASTER! In this session (on slides) we are NOT talk about potential disaster (such BCM); we talk about: What happened NOW? Which tasks should have been finished BEFORE. Is virtual or physical SQL matter? We talk about systems, databases, peoples, encryption, passwords, certificates and users. In this session (on few demos) I'll show which part of our SQL Server Environment are critical and how to be prepared to disaster. In some documents I'll show You how to be BEST prepared. 9/8/2012 9:20:00 AM 9/8/2012 10:15:00 AM 9476 Tobiasz Koprowski Track 4 (special) Room 4 Are You remember 'Sliders'? In my opinion Licensing World is similar to this series. How many time You tried to understand licensing? How many times You heard different opinions about same question? I'm sure, that You know what is CPU, CORE, SOCKET. Are You familiar with Processor / User / Device? And CAL / SAL/ SA too? Are You use SPLA program or just OEM or MOLP? Physical Instance, Virtual Instance, 90 Days, EULA, SPUR, LAR, Multiplexing, 5 Dollars (not 5 Cents)... It's not all the possibilities, if we are talking about licenses. Let's talk about it, from the Licensing Point of View 9/8/2012 2:35:00 PM 9/8/2012 3:30:00 PM 9517 Rob Volk Track 3 Room 3 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! 9/8/2012 2:35:00 PM 9/8/2012 3:30:00 PM 9535 Chris Webb Track 1 Room 1 The Tabular model in Analysis Services 2012 is the new alternative to building cubes: it’s easier to develop with (especially if you come from a relational database background) and its in-memory, column-store database provides blindingly fast performance. This session will provide a basic introduction to building Tabular models and discuss their strengths and weaknesses compared to cubes. 9/8/2012 3:50:00 PM 9/8/2012 4:45:00 PM 9566 Chris Testa-O'Neill Track 1 Room 1 This session will provide insight on what to expect when deploying a highly available end to end SQL Server 2012 Business Intelligence environment as experienced from the field. As well as leveraging the SQL Server Business Intelligence skills that you possess. You will also gain an insight into the additional skills and knowledge that you will need to ensure the successful delivery of technologies such as such as PowerPivot, PowerView, SQL Server Reporting Services and SQL Server Analysis Services on a robust architecture. 9/8/2012 4:50:00 PM 9/8/2012 5:45:00 PM 9568 Chris Testa-O'Neill Track 4 (special) Room 4 This 1 hour session will provide a thorough overview of the certification and training offered in by Microsoft in the area of SQL Server 2008 and SQL Server 2005 technologies. It is not a technical session but will provide the information that you require in order to complete the following certification •Microsoft Certified Technical Specialist •Microsoft Certified IT Professional •Microsoft Certified Master •Microsoft Certified Architect An exploration of the available learning channel to support you meeting your cetification requirements will also be explored including •Microsoft Official Courses – (Instructor Led Training) •Microsoft Elearning •Microsoft Press Books 9/8/2012 9:20:00 AM 9/8/2012 10:15:00 AM 9743 Mark Broadbent Track 4 (special) Room 4 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. 9/8/2012 4:50:00 PM 9/8/2012 5:45:00 PM 9753 Neil Hambly Track 2 Room 2 Extended Events is the replacement for profiler in many respects, and will be the choice of capturing data from within SQL Server now and in future editions, so we need to understand the differences it has to profiler 'old guard' and why we should be using this new feature for this purposeI'll take you on a Guided tour of the key aspects, and show you simply how in just minutes you can up and running and capturing data using this new method and how to analyze it effectivelyFollow me to the 'new age' of understanding your systems activity 9/8/2012 8:00:00 AM 9/8/2012 8:55:00 AM 9767 Niko Neugebauer Track 3 Room 3 There are very few applications which are being developed from zero, the most are apps are simply inherited from previous development teams. This session serves to show some easy implementable practices to follow after inheriting a database. Those practices allow to check some if the database design was done in regards to the actual data, or if while implementing some of the constraints and checks some tables were left behind. :) The practices shown in this session will allow to check the database design and identify some of the possible performance degradations. 9/8/2012 10:20:00 AM 9/8/2012 11:15:00 AM 9813 David Morrison Track 2 Room 2 In this session we will deep an in-depth look at some of the most common query plan operators. We'll look at what they do, how they do it and the circumstances in which they are chosen. We will look at the good and bad aspects of each and why sometimes they aren't the right tool for the job. Using lots of examples we'll investigate the usage and impact they have on your SQL Server. Hopefully you'll walk away from this session with the knowledge which will give you a deeper understanding of your query plans 9/8/2012 10:20:00 AM 9/8/2012 11:15:00 AM 9831 Duncan Sutcliffe Track 3 Room 3 This fast paced and fun session is a journey through business intelligence with SQL Server 2012 and SharePoint. It begins in Excel and shows how PowerPivot can be used to build useful information, how the data can be fed to the desktop, and how a user can develop their own notifications from that data. It then moves on to transform the data into a more cube-like experience by using external data and shows how dashboards and presentation-quality visualisations can be built easily from tabular models. Although this session is mildly technical, it is easy to grasp and uses 100% demos. 9/8/2012 11:25:00 AM 9/8/2012 12:20:00 PM 9832 Alex Whittles Track 3 Room 3 The T-SQL Merge statement provides a world of opportunities to save a lot of time.In this session we’ll look at how merge can be used to perform complex multi-stage tasks such as loading data into data warehouse dimensions, including the handling of type 0, 1 2 slowly changing dimensions.I’ll present a summary of my MSc dissertation findings, comparing the performance of using T-SQL Merge against other more traditional methods of loading slowly changing dimensions in SSIS.We’ll also look at how we can use dynamic SQL to completely automate the generation of the merge statement, resulting in an incredibly simple meta-data configured dimension loads in your data warehouse. 9/8/2012 3:50:00 PM 9/8/2012 4:45:00 PM 9896 Gavin Payne Track 3 Room 3 Most servers we deploy today use a NUMA rather than an SMP mainboard architecture and while we might conceptually understand what that means we often don’t appreciate the subtle changes to how Windows and SQLOS work when they run on a NUMA architecture server. To make things even more interesting, we can deploy Soft-NUMA ourselves to request some of the behaviour changes ourselves. This session will cover: what is NUMA and why it exists, how Windows responds to NUMA hardware how SQL Server 2012 changes its behaviour in the NUMA world. We’ll then look at some of the benefits NUMA brings us and how we sometimes need to adapt our monitoring for the NUMA world. 9/8/2012 4:50:00 PM 9/8/2012 5:45:00 PM 9905 David Peter Hansen Track 3 Room 3 Loading data into your Data Warehouse is not always a trivial task. Especially if the source systems can re-deliver data and you want to replace an old subset of your data. The quick answer you always hear is “just use partitioning”, but nobody really tells you how you should design or implement it. This session will show one way to load and access your data really fast, by using layered partitioning. We will walk through partitioned tables and partitioned views, before moving on to the concept of layered partitioning. We will also take a look at the management and performance benefits (and challenges) partitioning gives us. 9/8/2012 8:00:00 AM 9/8/2012 8:55:00 AM 9943 Bob Duffy Track 1 Room 1 Always On offers a huge leap forward in terms of high availability. This sessions is a demo based introduction to the high availability changes in Denali emphasising key features and benefits. During the demonstration we will show how to seamlessly upgrade a database from SQL 2005+ to Denali with ZERO down time and then use the Always on features to simplify reporting, availability and disaster recovery. This session will be useful for anyone who is working in a high availability environment or currently using replication to provide reporting and looking for a neater solution. 9/8/2012 1:35:00 PM 9/8/2012 2:30:00 PM 10037 Dave Ballantyne Track 2 Room 2 With the release of SQL Server 2012, the T-SQL language has been extended further to enable greater productivity and more optimal queries. Following the ANSI SQL standard support has been included for PAGING and SEQUENCES. Many cumbersome sub-queries will be banished by the clutch of new analytic functions, but perhaps the biggest is the window framing extensions. These now allow a true sliding window of data to process such common problems as rolling balances. This will be a high-level look session, but will be diving a bit deeper to highlight some caveats as we go as its not all plain sailing. 9/8/2012 11:25:00 AM 9/8/2012 12:20:00 PM 10077 Allan Mitchell Track 1 Room 1 We are storing more and more data FACT We have less time to move data around our environment FACT Businesses want close to real-time analytics FACT. We therefore need to plan our data movement strategy better. In this session I will show you the improvements to CDC being made in SQL Server 2012 and suggest why this is something you will want to know. 9/8/2012 2:35:00 PM 9/8/2012 3:30:00 PM 10579 Martin Cairns Track 4 (special) Room 4 Partitioning your data allows a whole host of benefits to the performance and maintainability of your databases but still seems to be a dark art known only to a few people. With every release of SQL Server more features become available to help solve various problems and a lot of them require that your database has been partitioned for that feature to be used effectively. The most recent feature requiring partitioning is Column Store indexes, without partitioning you would be required to drop them before modifying any data in the base table and then recreating them from scratch. 9/8/2012 11:25:00 AM 9/8/2012 12:20:00 PM 10622 Phil Quinn Track 4 (special) Room 4 A basic introduction of SQL Servers XML Capabilities, it will cover access of XML using .value and exist with variations of XPATH that can potentially improve the queries, explaining Typed and Untyped XML and cover the use of Primary and Secondary Indexes with XML and how these may (or may not) affect performance, and considerations to take before using XML at all. 9/8/2012 3:50:00 PM 9/8/2012 4:45:00 PM 10654 Peter Baddeley Track 4 (special) Room 4 SQL is fundamental to every deployment of SharePoint, and increasingly many organisations have or are planning some form of SharePoint deployment. As a SQL Professional you can't ignore SharePoint, and instead you should be actively engaged in its implementation to be to better support the solution. This session will be an introduction to some of the key considerations around SQL for SharePoint including different database, sizing, naming and a few common issues encountered. It will also introduce the SharePoint integration to Reporting Services which has been enhanced in SQL 2012. Finally it will make the case that you how and why you should get actively in your organisations SharePoint deployment. 9/8/2012 1:35:00 PM 9/8/2012 2:30:00 PM 10665 Jen Stirrup Track 1 Room 1 Microsoft has made serious commitments to mobile Business Intelligence, announced at SQLPass Summit 2011. What is the roadmap? What's available right now, and how can it be implemented at your organisation? Come to this session to learn about mobilising Business Intelligence using Sharepoint, Reporting Services, SQL Azure, Excel Services and Power Pivot. Yes, it is possible to have mobile Business Intelligence in your organisation, and come to this session in order to learn how! 9/8/2012 8:00:00 AM 9/8/2012 8:55:00 AM 10671 Mark S. Rasmussen Track 2 Room 2 Since SQL Server 2005, we've been able to use the vardecimal data type to store decimals efficiently. With SQL Server 2008 came row and page compression, resulting in much better options for compressing our data. However, neither row nor page compression are panaceas! In this session I'll walk you through the internals of row and page compression, and based on that knowledge, enable you to better evaluate when to use which type of compression, if compression should be used at all. Once used, how do we determine its effectiveness? What are the pitfalls? I'll give you a full tool belt of knowledge to bring home and put to use on your databases. 9/8/2012 2:35:00 PM 9/8/2012 3:30:00 PM 10699 Gavin Payne Track 4 (special) Room 4 IT teams today have many different types of architect, yet their technical skills are just the foundation for a range of soft skills that if they didn’t have wouldn’t earn them the title of architect. The session will help you understand the type of architect you are or want to become; define the leadership, design and implementation skills you’re likely to need; and review some of the methodologies you could use to help you become a more successful architect. While the subject is a generic professional discipline, the session is aimed at people with SQL Server DBA or development backgrounds, and refers to the requirements of the Microsoft Certified Architect certification. 9/8/2012 10:20:00 AM 9/8/2012 11:15:00 AM 10859 Andrè Kamman Track 2 Room 2 'Practical Powershell – How to design and build larger scripts'The best Powershell scripts, in my humble opinion, will think like you would and will solve a problem or do a task for you in such a way that you can call the script nine out of ten times with minimal parameters and let it figure out what smart defaults to use.In this session we’ll build a (1) Powershell script to automate one of our many (dba/dev) tasks in order to save us a lot of time.I’ll show you how I design, build, test and debug the bigger scripts and we’ll put in all the bells and whistles that those scripts commonly have. (Like support for –WhatIf and get-help etc.) 9/8/2012 9:20:00 AM 9/8/2012 10:15:00 AM 10875 Hugo Kornelis Track 2 Room 2 Do you want to speed up your reports over your large tables by 10, 20 or even 50x? Those are the performance improvements that Columnstore indexes can give you – when used properly. Often touted as a “BI” feature, in reality columnstore indexes can benefit any workload that involves some sort of reporting on large tables. In this session, we’ll first discuss how columnstore indexes work. Once past the basics, we’ll dive in and get dirty, looking at how to rewrite existing queries and change database designs to get the most out of this new index type. If you are running SQL Server 2012, you can add a columnstore index to your large tables and gain maybe 4x performance – or you can attend this session and make things really fly. 9/8/2012 1:35:00 PM 9/8/2012 2:30:00 PM 10951 SQLSaturday 162 Track 2 Room 2 9/8/2012 9:05:00 AM 9/8/2012 9:15:00 AM 10951 SQLSaturday 162 Track 1 Room 1 9/8/2012 9:05:00 AM 9/8/2012 9:15:00 AM 10951 SQLSaturday 162 Track 4 (special) Room 4 9/8/2012 9:05:00 AM 9/8/2012 9:15:00 AM 10951 SQLSaturday 162 Track 3 Room 3 9/8/2012 9:05:00 AM 9/8/2012 9:15:00 AM 10952 Buck Woody Track 1 Room 1 Windows Azure is an incredibly large set of features that technical professionals can use to solve almost any computing need. With that breadth of features, what can the data professional use to help their organizations with small, disconnected datasets all the way to 'Big Data'? Buck Woody, Senior Technical Professional on the Windows Azure Platform at Microsoft and a technical professional with close to 30 years of data implementations shows you what you need to know to leverage Windows Azure from a data perspective - when to use it, when to leave your data on-site, and how to create hybrid solutions that encompass both architectures. 9/8/2012 11:25:00 AM 9/8/2012 12:20:00 PM 10953 SQLSaturday 162 Track 3 Room 3 In this session you will first get wowed by Red Gate by a 30 minute session of 'How to Slash Your Storage Costs with SQL Storage Compress' and if that wasn't enough you will then be dazzled by several 5 minute lightning talks from a selection for SQL Experts and first timers! Join us for a non-stop ride of SQL goodness in 5 minute chunks. Who will win the showdown ...Professional software company Redgate or the motley selection of lightning speakers! Join us and find out! 9/8/2012 1:35:00 PM 9/8/2012 2:30:00 PM 10954 SQLSaturday 162 Track 3 Room 3 9/8/2012 5:45:00 PM 9/8/2012 6:00:00 PM 10954 SQLSaturday 162 Track 4 (special) Room 4 9/8/2012 5:45:00 PM 9/8/2012 6:00:00 PM 10954 SQLSaturday 162 Track 1 Room 1 9/8/2012 5:45:00 PM 9/8/2012 6:00:00 PM 10954 SQLSaturday 162 Track 2 Room 2 9/8/2012 5:45:00 PM 9/8/2012 6:00:00 PM 10956 Mark Pryce-Maher Track 4 (special) Room 4 In this session we will run through the history of SQL Server Management Studio Add-ins, then goto through the step by step process of creating an Add-in for SQL Server Management Studio 2012. We will look at some of the cool things you can do and break. This session is for people who have some C# knownledge and want to extend SQL Server Management Studio. 9/8/2012 8:00:00 AM 9/8/2012 8:55:00 AM 11029 Red Gate Track 2 Room 2 Keeping track of database versions, deployment scripts, and any number of ad hoc database changes is a pain. In this session, you’ll see how to manage database changes easily using source control within SQL Server Management Studio. Source controlling databases is faster than you think with SQL Source Control; you can track who made database changes, what they changed, when, and why. 9/8/2012 12:20:00 PM 9/8/2012 1:35:00 PM 11222 Aaron Bertrand Track 1 Room 1 In this session we will go over several bad habits that are quite pervasive in the SQL Server community, and show with demos and samples why these habits can be bad. We'll also illustrate some good habits that are less common and why they should be adopted. The goal is to have every user in the room walk away with immediately actionable knowledge to improve their existing stored procedures, raise their overall T-SQL skill, and change the way they think about writing code. 9/8/2012 9:20:00 AM 9/8/2012 10:15:00 AM 11413 James Boother Track 2 Room 2 TBD 9/8/2012 3:50:00 PM 9/8/2012 4:45:00 PM