SQLSaturday #162 - Cambridge 20129/8/2012 12:00:00 AM(GMT) Greenwich Mean Time : Dublin, Edinburgh, Lisbon, LondonSQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. #sqlsat162SQLSaturday #162 Information Travel Venue at: Crowne Plaza Downing St Cambridge , United KingdomCB2 3DT2297Red Gatehttp://www.red-gate.comhttp://www.red-gate.com/archive/redgatelogo_black.jpg601702468Fusion-iohttp://www.fusionio.com/http://www.sqlsaturday.com/files/85e014cb-1739-4b4e-9ec1-c2ebf848beba.jpg601702300Copper Blue Consulting Ltdhttp://www.copperblueconsulting.comhttp://www.copperblueconsulting.com/sites/default/files/final_design_small_0.png601702595Quest Software UK Ltdhttp://www.quest.comhttp://www.sqlsaturday.com/files/436d32ca-5068-43fd-b8a7-93c73f7ad588.jpg601702610SQLCloud Limitedhttp://sqlcloud.co.ukhttp://www.sqlsaturday.com/files/5f55ad65-85ae-43f0-a2e5-688a3030e460.png601702428Iderahttp://www.idera.comhttp://www.idera.com/campaign_images/logo_Idera_tag_170x60.png601702578SQL Sentry, Inc.http://www.sqlsentry.nethttp://www.sqlsentry.net/UI/customMenu/headLogo.png601702557Prodata SQL Centre of Excellencehttp://www.prodata.iehttp://www.prodata.ie/images/Prodata_Logo.jpg601702611Clear Sky SQLhttp://clearskysql.co.ukhttp://www.clearskysql.co.uk/images/8059952_l.jpg601702446Confio Softwarehttp://www.confio.comhttp://www.confio.com/images/assets/confio_logo.jpg601702589Purple Froghttp://www.PurpleFrogSystems.comhttp://www.purplefrogsystems.com/images/PurpleFrogLogo170.png601702612Wrox/ Wileyhttp://www.wrox.com/WileyCDA/http://www.sqlsaturday.com/files/09a80092-068b-48fd-9cde-9508d8e62224.jpg401002588Pluralsighthttp://www.pluralsight.comhttp://www.sqlsaturday.com/files/d654bcf1-7ba8-4db5-8527-aba875d3e053.png401002444SAPIEN Technologies, Inchttp://www.sapien.comhttp://www.sqlsaturday.com/files/cfb209ad-aa73-4b94-a41d-d6034cd092ae.jpg401002333Mark Broadbenthttp://tenbulls.co.ukhttp://www.sqlsaturday.com/files/c22db5eb-2516-4e4d-9740-b2a3f6b52b3e.png4010011222Aaron BertrandAaron is a senior consultant for SQL Sentry, Inc., makers of performance monitoring and event management software for SQL Server, Analysis Services, and Windows. He has been blogging here at sqlblog.com since 2006, focusing on manageability, performance, and new features; has been a Microsoft MVP since 1997 tweets as @AaronBertrand and speaks frequently at user group meetings and SQL Saturday events.@AaronBertrandhttp://sqlblog.com/blogs/aaron_bertrand/default.aspxhttps://api.twitter.com/1/users/profile_image?screen_name=@AaronBertrand48489832Alex WhittlesAlex is the owner and lead consultant at Purple Frog, a SQL Server Business Intelligence consultancy in the UK. Alex is leader of the Birmingham PASS chapter and runs the Midlands SQL Relay events. He has just completed an MSc in Business Intelligence, writing a thesis on the performance characteristics of loading type 2 SCDs into a data warehouse. He is also a regular speaker at SQL Bits, SQL Relay and various SQL Server user groups/PASS chapters around the UK.@PurpleFrogSyshttp://uk.linkedin.com/in/alexwhittleshttp://www.PurpleFrogSystems.comhttps://api.twitter.com/1/users/profile_image?screen_name=@PurpleFrogSys484810077Allan MitchellAllan is the joint owner of Copper Blue Consulting Ltd. Copper Blue Consulting focus on getting the right data to the right people at the right time and in the right format. We are passionate about data integrity and suitability. We have worked all over the world in a variety of industries.and on projects both large and small. We specialise in Extract, Transform and Load Complex Event Processing Master Data Management Data Visualisation Operational and Predictive Analytics.@allanSQLIShttp://uk.linkedin.com/pub/allan-mitchell/1/b4/5a9https://api.twitter.com/1/users/profile_image?screen_name=@allanSQLIS484810859Andrè KammanI'm a Dutch SQL Server consultant. Having worked as a DBA on 400+ instances for the past couple of years. I'm on a datawarehouse project right now where I find myself using SSIS mostly these days. I run the Dutch PASS chapter, and I'm a SQL Server MVP@AndreKammanhttps://api.twitter.com/1/users/profile_image?screen_name=@AndreKamman48489455Andy LeonardAndy Leonard is CSO of Linchpin People and SQLPeople, an SSIS Trainer and Consultant and developer, SQL Server database and data warehouse developer, community mentor, SQLBlog.com blogger, and engineer. He is a co-author of Professional SQL Server 2005 Integration Services and SQL Server MVP Deep Dives. His background includes web application architecture and development, VB, and ASP; SQL Server Integration Services (SSIS); data warehouse development using SQL Server 2000, 2005 and 200@AndyLeonardhttp://www.linkedin.com/in/andyleonardhttp://linchpinpeople.comhttps://api.twitter.com/1/users/profile_image?screen_name=@AndyLeonard48489943Bob DuffyBob Duffy is a SQL Server MVP from Dublin, Ireland who is MCA, MCM and Analysis Services Maestro certified. Bob has helped many enterprise customers implement high availability.@bob_duffyhttp://blogs.prodata.ie/author/Bob.aspxhttps://api.twitter.com/1/users/profile_image?screen_name=@bob_duffy48489453Bruno BastoSenior trainer and senior consultant at Rumos. First certification in SQL Server 6.5 in 1998. Work with MSFT tools and infrastructure since 1992 with projects in the financial marketing, banking and project management. Responsible for several training projects for software solutions with MSFT infrastructure delivered in Portugal, Brazil and USA.http://www.linkedin.com/profile/view?id=13726197trk=tab_prohttps://api.twitter.com/1/users/profile_image?screen_name=484810952Buck WoodyBuck Woody has been working with Information Technology since 1981. He has worked for the U.S. Air Force, at an IBM reseller as technical support, and for NASA as well as U.S. Space Command as an IT contractor. Buck Woody, Microsoft’s “Real World DBA”, is an author of five SQL Server books, over 600 database articles and an instructor on database technology at the University of Washington.@BuckWoodyhttp://linkedin.com/buckwoodyhttp://blogs.msdn.com/b/buckwoody/https://api.twitter.com/1/users/profile_image?screen_name=@BuckWoody48489535Chris Testa-O'NeillChris Testa-O'Neill is a SQL Server Microsoft Most Valuable Professional(MVP) and a Senior Consultant at Coeo specialising in SQL Server Business Intelligence. He is also a technical author, working on courses for SQL Server 2008 R2 with Microsoft Learning and advising on the SQL Server 2012 curriculum. Chris runs the Manchester SQL Server User Group and is an organiser for SQLBits. Chris has spoken at a range of events around the world.@Christopher Webb @technitrainhttp://uk.linkedin.com/pub/chris-webb/1/85/966https://api.twitter.com/1/users/profile_image?screen_name=@Christopher Webb @technitrain484810037Dave BallantyneDave is a freelance SQLServer database developer / designer and has been working in the IT field for over 20 years, the past 15 of which has been specialising within SQLServer environment. Dave regularly contributes to online forums and is a regular speaker at UK events such as SQL Bits and user groups. He also is founder of the Kent .NET/SqlServer user group and SQLLunch UK.@daveballyhttp://www.linkedin.com/profile/view?id=56897694http://sqlblogcasts.com/blogs/sqlandthelike/https://api.twitter.com/1/users/profile_image?screen_name=@davebally48489813David MorrisonDave Morrison is BI consultant for Itelligence. Having worked in the IT industry for around 11 years his main area of expertise is SQL Server, namely TSQL, query optimisation, indexing, performance tuning and internals etc.
He regularly speaks at sql server user groups and has also spoken at the previous three SQLBits events.@TSQLNinjahttp://tsqlninja.wordpress.comhttps://api.twitter.com/1/users/profile_image?screen_name=@TSQLNinja48489905David Peter HansenDavid Peter Hansen is a Principal Consultant, Practice Manager at Platon, a Scandinavian Information Management consultancy. He has worked with database development and administration for 11 years, and has worked with the Microsoft Business Intelligence platform since SQL Server 2000. He works mostly on projects in the financial sector, and specializes in developer coaching as well as scalable architecture and performance tuning on large scale data warehouses and BI solutions.@dphansenhttp://www.linkedin.com/in/davidpeterhansenhttp://dave.dk/https://api.twitter.com/1/users/profile_image?screen_name=@dphansen48489831Duncan SutcliffeI'm a senior architect for Microsoft business intelligence solutions at Hitachi Consulting, working with clients such as Tesco, the Bank of England, Sky, Experian Footfall and Betfair. With a good twelve years or more designing BI solutions under my belt, I specialise in architecture design, development frameworks and very high quality code. I spoke at SQLbits 8 and 9 (including a precon), various UK user groups, and at SQLRelay 2012.@duncansutcliffehttp://www.linkedin.com/profile/view?id=15059331http://www.duncansutcliffe.comhttps://api.twitter.com/1/users/profile_image?screen_name=@duncansutcliffe48489896Gavin PayneGavin is a Microsoft Certified Master and a senior consultant for Coeo Ltd, a Microsoft Gold Partner, where he architects, implements and troubleshoots mission critical SQL Server environments.@GavinPayneUKhttp://blog.gavinpayneuk.comhttps://api.twitter.com/1/users/profile_image?screen_name=@GavinPayneUK484810875Hugo KornelisHugo is co-founder and RD lead of perFact BV, a Dutch company that strives to improve analysis methods and to develop computer-aided tools that will generate completely functional applications from the analysis deliverable. The chosen platform for this development is SQL Server. In his spare time, Hugo likes to share and enhance his knowledge of SQL Server by frequenting newsgroups and forums, reading and writing books and blogs, and attending and speaking at conferences.@Hugo_Kornelishttps://api.twitter.com/1/users/profile_image?screen_name=@Hugo_Kornelis484811413James BootherJames Boother is a senior consultant for Coeo a Microsoft Gold Partner delivering SQL Server Consultancy services covering the entire IT lifecycle - including design, implementation and management of complex and mission critical environments, . He's a passionate .NET, PowerShell and SQL developer, a formula 1 fan and Dad to three.@JimmyBoohttps://twitter.com/JimmyBoohttp://www.coeo.com/https://api.twitter.com/1/users/profile_image?screen_name=@JimmyBoo484810665Jen StirrupJen Stirrup is a SQL Server MVP, and is Joint Owner of Copper Blue Consulting, delivering data and Business Intelligence solutions to global clients. Jen's focus is on the Microsoft BI stack, with a specific passion for Data Visualisation. Jen is passionate about using technology to help people obtain the most benefit from their investment in the Microsoft Business Intelligence stack, believing that data can help to drive enterprises forward.@jenstirruphttp://www.linkedin.com/in/jenstirruphttp://www.jenstirrup.comhttps://api.twitter.com/1/users/profile_image?screen_name=@jenstirrup48489743Mark BroadbentMark Broadbent is a SQL Server specialist with many years experience working with numerous HA solutions and is possibly the hardest drinking DBA on the planet. Mark is the SQLCambs UG Chapter Leader and has presented at UK Usergroups, SQLSaturdays, SQLBits 7/ 8/ 9/ X, SQLRally Orlando/ Dallas, SQLPASS 2011 and 24HOP. He was also awarded the Microsoft Community Contributor award in recognition of his contribution towards the SQL Server Community.@retracementhttp://uk.linkedin.com/in/retracement/http://tenbulls.co.ukhttps://api.twitter.com/1/users/profile_image?screen_name=@retracement484810671Mark S. RasmussenMark has worked extensively with SQL Server, primarily focused on performance optimization and internals. Besides SQL Server Mark is also proficient in the Microsoft .NET development stack with a decade of experience. Fueled by his interest in the nitty-gritty details and feedback from an early presentation, Mark started the OrcaMDF open source project that aims to provide a completely standalone parser for SQL Server MDF files. Furthermore he blogs actively at http://improve.dk@improvedkhttp://dk.linkedin.com/in/markrasmussenhttp://improve.dkhttps://api.twitter.com/1/users/profile_image?screen_name=@improvedk484810579Martin CairnsMartin Cairns, SQL Server MCM. Martin is a consultant with Purple Frog Systems a Business Intelligence Data Warehousing Consultancy. He provides expertise for some of the UK's most prestigious clients including ASOS, AOL and Tesco. Martin has been working with SQL Server since 1998 and currently is specialising on data warehousing projects incorporating SQL Server and Analysis Services. With extensive experience designing and optimising multi-terabyte data warehouses.@MartinCairnsSQLhttp://uk.linkedin.com/in/martincairnshttp://sqlbyparts.comhttps://api.twitter.com/1/users/profile_image?screen_name=@MartinCairnsSQL48489753Neil HamblyNeil Hambly (currently F/T DB Architect) A SQL Professional over the last 14 years, having started with version 6.5 and worked with all versions and features since thenA UG leader (London, UK) and presenter @ UK SQL Server User Groups along with sessions
@ SQLPASS Summit, SQLRally, 24HOP, SQLBits 7, 8, 9, 10, SQL-in-the-City (London) conferences
Can be frequently found doing his studies towards the SQL 2008 MCM certification@Neil_Hamblyhttp://www.linkedin.com/in/neilhamblyhttp://sqlblogcasts.com/blogs/NeilHamblyhttps://api.twitter.com/1/users/profile_image?screen_name=@Neil_Hambly48489767Niko NeugebauerNiko Neugebauer is a SQL Server MVP, who is works as a consultant for the biggest portuguese IT company - Novabase. As a Senior DBA, his task is to help achieving the established business goals for an international bank in Lisbon, Portugal. He is a founder and a current leader of the Portuguese SQL Server User Group as well as a PASS Western European Regional Mentor.@NikoNeugebauerhttp://pt.linkedin.com/in/webcaravelahttp://www.sqlport.comhttps://api.twitter.com/1/users/profile_image?screen_name=@NikoNeugebauer484810654Peter BaddeleyPeter is the Head of SharePoint Solutions at ISC Software Solutions a Microsoft Gold Partner based in Cambridgeshire. Peter has been working with Microsoft technologies since 2003 and primarily focuses on SharePoint. Peter also engaged in the Microsoft community speaking at a number of events, and organises the East Anglia region of the SharePoint User Group.@baddazhttp://uk.linkedin.com/in/baddazhttp://www.isc-software.comhttps://api.twitter.com/1/users/profile_image?screen_name=@baddaz484810622Phil QuinnPhil Quinn is a Database Developer working at UCAS currently developing systems producing prospectús for educational establishments. He has been working on SQL Server since version 2000, and has an MCITP Database Developer 2008.484811029Red GateSince 1999, Red Gate Software has produced ingeniously simple tools for over 500,000 technology professionals worldwide.We currently specialize in MS SQL Server, .NET, and Oracle tools.We are based in the beautiful, if rather flat, university town of Cambridge, UK.Our philosophy is to design highly usable, reliable tools that solve the problems of DBAs and developers.@redgatehttp://www.red-gate.comhttps://api.twitter.com/1/users/profile_image?screen_name=@redgate48489517Rob VolkRob Volk does deranged things with SQL Server, so you don't have to. A DBA in the Metro Atlanta area for the past 10 years, he has also abused other database and programming platforms elsewhere and elsewhen. In his spare time he accomplishes more than he does on the job, just don't tell his boss.@sql_rhttp://www.linkedin.com/pub/rob-volk/1/ba8/134http://weblogs.sqlteam.com/robv/https://api.twitter.com/1/users/profile_image?screen_name=@sql_r484810951SQLSaturday 16248489473Tobiasz KoprowskiCommunity leader focused on SQL Server, SharePoint, security, collaboration, and ITIL, DR, BCM and SLA. Love licensing stuff. MCT, Freelancer, consultant. Conducts audit projects, consulting and implementation in Poland and across Europe. Technical Team Leader in GITCA. Member of such Microsoft Terminology Community, Friends of RedGate, PASS, ISSA, ACM and several communities in the world. MVP for SQL Server. President of the Polish SQL Server USer Group. Creator of SQLDAY Conference.@KoprowskiThttp://pl.linkedin.com/in/koprowskithttp://koprowskit.eu/geek/https://api.twitter.com/1/users/profile_image?screen_name=@KoprowskiT484894519451SQLSaturday 162Room 1Coffee Break9/8/2012 8:55:00 AM9/8/2012 9:05:00 AM94519451SQLSaturday 162Room 1Coffee Break9/8/2012 11:15:00 AM9/8/2012 11:25:00 AM94519451SQLSaturday 162Room 1Coffee Break9/8/2012 3:30:00 PM9/8/2012 3:50:00 PM94519451SQLSaturday 162Room 2Coffee Break9/8/2012 8:55:00 AM9/8/2012 9:05:00 AM94519451SQLSaturday 162Room 2Coffee Break9/8/2012 11:15:00 AM9/8/2012 11:25:00 AM94519451SQLSaturday 162Room 2Coffee Break9/8/2012 3:30:00 PM9/8/2012 3:50:00 PM94519451SQLSaturday 162Room 3Coffee Break9/8/2012 8:55:00 AM9/8/2012 9:05:00 AM94519451SQLSaturday 162Room 3Coffee Break9/8/2012 11:15:00 AM9/8/2012 11:25:00 AM94519451SQLSaturday 162Room 3Coffee Break9/8/2012 3:30:00 PM9/8/2012 3:50:00 PM94519451SQLSaturday 162Room 4Coffee Break9/8/2012 8:55:00 AM9/8/2012 9:05:00 AM94519451SQLSaturday 162Room 4Coffee Break9/8/2012 11:15:00 AM9/8/2012 11:25:00 AM94519451SQLSaturday 162Room 4Coffee Break9/8/2012 3:30:00 PM9/8/2012 3:50:00 PM94529452SQLSaturday 162Room 1Lunch Break Sponsor Sessions9/8/2012 12:20:00 PM9/8/2012 1:35:00 PM94529452SQLSaturday 162Room 3Lunch Break Sponsor Sessions9/8/2012 12:20:00 PM9/8/2012 1:35:00 PM94529452SQLSaturday 162Room 4Lunch Break Sponsor Sessions9/8/2012 12:20:00 PM9/8/2012 1:35:00 PM94539453Bruno BastoRoom 2SQL Internal StorageThis 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 PM9/8/2012 5:45:00 PM94559455Andy LeonardRoom 1Designing an SSIS Framework 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 AM9/8/2012 11:15:00 AM94739473Tobiasz KoprowskiRoom 32 AM. A Disaster just began...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 AM9/8/2012 10:15:00 AM94769476Tobiasz KoprowskiRoom 4Welcome to the Licensing NightmareAre 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 View9/8/2012 2:35:00 PM9/8/2012 3:30:00 PM95179517Rob VolkRoom 3Tame Your Unruly Data...With Constraints!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 PM9/8/2012 3:30:00 PM95359535Chris WebbRoom 1Intro to Tabular Model in Analysis Services 2012The 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 PM9/8/2012 4:45:00 PM95669566Chris Testa-O'NeillRoom 1Notes on SQL 2012 Highly Available BI EnvironmentsThis 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 PM9/8/2012 5:45:00 PM95689568Chris Testa-O'NeillRoom 4Understanding Microsoft Certification in SQL ServeThis 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 AM9/8/2012 10:15:00 AM97439743Mark BroadbentRoom 4READPAST Furious-Transactions.Locking.Isolation.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 PM9/8/2012 5:45:00 PM97539753Neil HamblyRoom 2Extended Events – New Age of ProfilingExtended 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 activity9/8/2012 8:00:00 AM9/8/2012 8:55:00 AM97679767Niko NeugebauerRoom 3Inheriting a database for DevelopersThere 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 AM9/8/2012 11:15:00 AM98139813David MorrisonRoom 2Query Plan Operators Deep DiveIn 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 plans9/8/2012 10:20:00 AM9/8/2012 11:15:00 AM98319831Duncan SutcliffeRoom 3The Magic of SQL Server 2012 BI in SharePointThis 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 AM9/8/2012 12:20:00 PM98329832Alex WhittlesRoom 3Merge-tastic: a better way of loading dimensionsThe 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 PM9/8/2012 4:45:00 PM98969896Gavin PayneRoom 3NUMA Internals of SQL Server 2012Most 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 PM9/8/2012 5:45:00 PM99059905David Peter HansenRoom 3Layered Partitioning - (re)load your data fastLoading 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 AM9/8/2012 8:55:00 AM99439943Bob DuffyRoom 1SQL 2012 Always On-Deep DiveAlways 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 PM9/8/2012 2:30:00 PM1003710037Dave BallantyneRoom 2What's new in SQL Server 2012 - TSQLWith 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 AM9/8/2012 12:20:00 PM1007710077Allan MitchellRoom 1SQL Server 2012 SSIS Change Data CaptureWe 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 PM9/8/2012 3:30:00 PM1057910579Martin CairnsRoom 4Partitioning Design for Performance and MaintainabPartitioning 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 AM9/8/2012 12:20:00 PM1062210622Phil QuinnRoom 4XML: The Marmite of SQL ServerA 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 PM9/8/2012 4:45:00 PM1065410654Peter BaddeleyRoom 4I work with SQL why should I care about SharePointSQL 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 PM9/8/2012 2:30:00 PM1066510665Jen StirrupRoom 1Mobile Business Intelligence for Everyone, Now!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 AM9/8/2012 8:55:00 AM1067110671Mark S. RasmussenRoom 2Optimizing Storage and Performance Using Page and 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 PM9/8/2012 3:30:00 PM1069910699Gavin PayneRoom 4I want to be a better architectIT 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 AM9/8/2012 11:15:00 AM1085910859Andrè KammanRoom 2Practical PoSh – Design and build larger scripts'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 AM9/8/2012 10:15:00 AM1087510875Hugo KornelisRoom 2Make Your Queries Fly With Columnstore IndexesDo 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 PM9/8/2012 2:30:00 PM1095110951SQLSaturday 162Room 1Keynote - Buck Woody9/8/2012 9:05:00 AM9/8/2012 9:15:00 AM1095110951SQLSaturday 162Room 2Keynote - Buck Woody9/8/2012 9:05:00 AM9/8/2012 9:15:00 AM1095110951SQLSaturday 162Room 3Keynote - Buck Woody9/8/2012 9:05:00 AM9/8/2012 9:15:00 AM1095110951SQLSaturday 162Room 4Keynote - Buck Woody9/8/2012 9:05:00 AM9/8/2012 9:15:00 AM1095210952Buck WoodyRoom 1Windows Azure from a Data PerspectiveWindows 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 AM9/8/2012 12:20:00 PM1095310953SQLSaturday 162Room 3Red Gate followed by Lightning TalksIn 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 PM9/8/2012 2:30:00 PM1095410954SQLSaturday 162Room 1Prize Draw9/8/2012 5:45:00 PM9/8/2012 6:00:00 PM1095410954SQLSaturday 162Room 2Prize Draw9/8/2012 5:45:00 PM9/8/2012 6:00:00 PM1095410954SQLSaturday 162Room 3Prize Draw9/8/2012 5:45:00 PM9/8/2012 6:00:00 PM1095410954SQLSaturday 162Room 4Prize Draw9/8/2012 5:45:00 PM9/8/2012 6:00:00 PM1095610956Mark Pryce-MaherRoom 4Creating SSMS 2012 Add-ins for Crash Test Dummies 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 AM9/8/2012 8:55:00 AM1102911029Red GateRoom 2Improving DB Development with SQL Source ControlKeeping 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 PM9/8/2012 1:35:00 PM1122211222Aaron BertrandRoom 1T-SQL : Bad Habits and Best PracticesIn 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 AM9/8/2012 10:15:00 AM1141311413James BootherRoom 2Troubleshooting SQL Server with PowerShellTBD9/8/2012 3:50:00 PM9/8/2012 4:45:00 PM