SQLSaturday #136 - Wellington 2012 4/14/2012 12:00:00 AM (GMT+12:00) Auckland, Wellington SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. #sqlsat136 Whitireia Community Polytechnic Wi Neera Drive Porirua Wellington, New Zealand 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 1914 LobsterPot Solutions Whole Tour Gold http://lobsterpot.com.au http://lobsterpot.com.au/lp_100x40.png 60 170 1961 WARDY IT Solutions Whole Tour Gold http://www.wardyit.com http://www.wardyit.com/img/SQLSaturdayLogo.jpg 60 170 1996 SQL Down Under Whole Tour Gold http://www.sqldownunder.com/ http://www.sqldownunder.com/Portals/0/logo.png 60 170 2115 Fusion-io Whole Tour Gold http://www.fusionio.com/ http://lobsterpot.com.au/files/fusionio170.jpg 60 170 2154 Microsoft Whole Tour Gold http://www.microsoft.com/en-au/default.aspx http://www.sqlpass.org/images/chapterlogos/microsoft.jpg 60 170 1966 Trade Me Gold Sponsor http://www.trademe.co.nz http://wellington.sqlpass.org/Portals/73/WSSUG/Images/trade_me-standard.gif 60 170 2086 Idera Whole Tour Silver http://www.idera.com/ http://www.idera.com/images/Logo-Idera.png 60 170 2183 Theta Silver Sponsor http://www.theta.co.nz http://www.theta.co.nz/sites/default/files/theta_one_logo.gif 60 170 1975 StrataDB Whole Tour Bronze http://www.stratadb.com/ http://www.stratadb.com/StrataDB.png 60 170 2001 ReadyRoll Whole Tour Bronze http://ready-roll.com/ http://ready-roll.com/img/rr-sm-whitebg.png 60 170 2126 Confio Software Whole Tour Bronze http://www.confio.com/ http://www.confio.com/images/assets/confio_logo.jpg 60 170 2159 Whitireia Community Polytechnic Bronze Sponsor http://www.whitireia.ac.nz http://wellington.sqlpass.org/Portals/73/WSSUG/Images/whit_logo_sqlsaturday.jpg 60 170 1951 Auckland SQL Server User Group Whole Tour Friend http://aucklandsql.com/ http://aucklandsql.com/App_Themes/DotNetGroup/Images/aucklandsql_logo.gif 40 100 2007 SQL Concepts Whole Tour Friend http://www.sqlconcepts.co.nz http://www.sqlconcepts.co.nz/images/logo-100x40.png 40 100 7925 SQLSaturday 136 Track 1 Room 1 4/14/2012 9:45:00 AM 4/14/2012 10:00:00 AM 7925 SQLSaturday 136 Track 1 Room 1 4/14/2012 2:15:00 PM 4/14/2012 2:30:00 PM 7925 SQLSaturday 136 Track 1 Room 1 4/14/2012 3:30:00 PM 4/14/2012 3:45:00 PM 7925 SQLSaturday 136 Track 1 Room 1 4/14/2012 4:45:00 PM 4/14/2012 5:00:00 PM 7925 SQLSaturday 136 Track 1 Room 1 4/14/2012 11:00:00 AM 4/14/2012 11:15:00 AM 7925 SQLSaturday 136 Track 2 Room 2 4/14/2012 9:45:00 AM 4/14/2012 10:00:00 AM 7925 SQLSaturday 136 Track 2 Room 2 4/14/2012 2:15:00 PM 4/14/2012 2:30:00 PM 7925 SQLSaturday 136 Track 2 Room 2 4/14/2012 3:30:00 PM 4/14/2012 3:45:00 PM 7925 SQLSaturday 136 Track 2 Room 2 4/14/2012 4:45:00 PM 4/14/2012 5:00:00 PM 7925 SQLSaturday 136 Track 2 Room 2 4/14/2012 11:00:00 AM 4/14/2012 11:15:00 AM 7926 SQLSaturday 136 Track 2 Room 2 4/14/2012 12:15:00 PM 4/14/2012 1:15:00 PM 7926 SQLSaturday 136 Track 1 Room 1 4/14/2012 12:15:00 PM 4/14/2012 1:15:00 PM 7940 Martin Catherall Track 1 Room 1 We've all used SQL profiler, and most of us are familiar with server side traces. SQL SERVER 2008 brought us Extended Events (XEvents), a more lightweight and flexible form of tracing. However SQL SERVER 2008 has no native UI support for XEvents, which could be one reason for their apparent slow up take. Learning the syntax now - and seeing what goes on behind the scenes of an XEvent session - will give you a firm understanding of their power and flexibility and place you in the position of knowing what is going on in the background when SQL SERVER 2012 brings us a fully functional UI for XEvents management. 4/14/2012 1:15:00 PM 4/14/2012 2:15:00 PM 8149 Dave Dustin Track 1 Room 1 This session will cover many of the new features being delivered in the next major version of SQL Server, previously codenamed Denali, now known as SQL Server 2012 Including (but not limited to) - Changes and new features for the DB engine and language - New tools for management, development and reporting - Changes for deployment, High Availability and Manageability - Working with “The Cloud” - Plenty more Honestly. I could put hundreds of bullet points here but you'd lose interest 4/14/2012 2:30:00 PM 4/14/2012 3:30:00 PM 8151 Dave Dustin Track 1 Room 1 There are a great many theories, anti-patterns and just plain wrong ideas that people (mostly Devs, but including DBAs) believe about SQL Server. Yes, it’s enterprise ready. No, it doesn’t magically tune/tweak itself (it needs some lovin’ from time to time (just nowhere near as much as Oracle)). We’re going to look into debunking some of these falsehoods. 4/14/2012 10:00:00 AM 4/14/2012 11:00:00 AM 8193 Peter Ward Track 1 Room 1 You are looking at the Bill of Materials for the new shiny server that you are going to purchase for SQL Server and you realise that there is still $10,000 in the hardware budget - how do you spend it? Do you increase the core density, maybe increase the RAM or maybe even look at adding some solid state storage to the storage array. In this session we will explore how some small hardware investments made in the right place can pimp your next SQL Server deployment. 4/14/2012 8:45:00 AM 4/14/2012 9:45:00 AM 8194 Peter Ward Track 1 Room 1 Despite all of the enhancements to the instrumentation in SQL Server, many database professionals still view performance tuning as a dark art. This session will provide database administrators and developers with valuable information on SQL Server performance tuning concepts. This presentation will walk you through proven performance tuning strategies and teach you how to use SQL Server tools to identify a performance bottleneck, isolate the root cause, apply possible resolutions, and then quantify performance improvements. 4/14/2012 5:00:00 PM 4/14/2012 6:00:00 PM 8206 Kent Chenery Track 2 Room 2 You've heard about PowerShell but the amount of braces, at symbols and percent signs reminded you of a painful Perl experience. You're frustrated at having to run the same piece of code on all your servers time after time? You've only accidently clicked on the PowerShell icon and thought 'white on blue is nice, but what makes this so good?' You've heard its something to do with .Net, but you're a DBA and .Net is just for developers right? If that sounds like you, then this session is for you. We will cover some basics of PowerShell and take a look at some of the things it can offer the DBA and make their life a little bit easier. 4/14/2012 1:15:00 PM 4/14/2012 2:15:00 PM 8385 Roger Noble Track 2 Room 2 Discover the power of PivotViewer, the Silverlight control that enables users to visualise large data sets in an extremely effective and tangible way. Quickly filter, sort and see how your data relates to each other in a way that traditional reports cannot. This session will cover what the PivotViewer control is and how to get the most out of it with your own data. Even if you've used PivotViewer before, see what's new in the recent Silverlight 5 version to enable you to make the most out of your collections. 4/14/2012 10:00:00 AM 4/14/2012 11:00:00 AM 8402 Jannie Muller Track 1 Room 1 The talk will be about how to interpret DMVs in order to troubleshoot real databases. The talk will cover a logical flow of dmvs for fault finding, inspecting configuration and setting up maintenance plans by using dmvs. Topics will also include how to visualize data from dmvs in excel for quick conclusions. It also look at some best practises for configuration and maintenance. 4/14/2012 3:45:00 PM 4/14/2012 4:45:00 PM 8404 Paul te Braak Track 2 Room 2 Analysis Service in SQL2012 introduces the Vertipac engine and the tabular model. While the tabular model is delivered through SSAS, the model offers some unique design opportunities for users who would otherwise design a dimensional OLAP solution. This session looks at tabular modelling by comparing it to the multidimensional model. We address some of the advantages, considerations and restrictions of the tabular model and examine how the limitations of the native model can be overcome with DAX (the tabular query language). 4/14/2012 11:15:00 AM 4/14/2012 12:15:00 PM 8411 Paul White Track 1 Room 1 Take your query writing and performance diagnostic skills to the next level by becoming familiar with the internals of the SQL Server query optimizer and the execution plans it produces. This 400-level session covers deep optimizer internals and little-known query processor details that will give you new insights into the way SQL Server works behind the scenes. Armed with this information, you will be better placed to write queries that optimize well, and to debug plan-related performance problems when they occur. 4/14/2012 11:15:00 AM 4/14/2012 12:15:00 PM 8448 Rob Farley Track 2 Room 2 I'm sure you've noticed the similarities between an execution plan and an SSIS Data Flow Task. Of course there are major differences, such as the fact that you write Data Flow Tasks, whereas execution plans are created based on the T-SQL that you pass to the Query Optimizer and other things such as indexes, statistics and constraints. This talk will consider some of the things that SSIS developers look for when creating an effective Data Flow Task, and show you how those same concerns can be considered when writing queries. 4/14/2012 8:45:00 AM 4/14/2012 9:45:00 AM 8451 Rob Farley Track 2 Room 2 There are a bunch of new T-SQL functions in SQL Server 2012, and as usual there's a combination of the 'this is really useful' and the '...but there's a caveat'. In this presentation, Rob will take you through the new analytic functions, show you how they seriously enhance your reporting ability, and show you some of the ways that they don't behave the way you might expect. You may not be using SQL Server 2012 yet, but you're bound to recognise some of the problems that these functions solve. 4/14/2012 3:45:00 PM 4/14/2012 4:45:00 PM 8510 Clive Trott Track 2 Room 2 Probably the most important part of any Business Intelligence project. What are the different options for presenting data to end users? What are the pros and cons of each? What are the requirements for each of the different options? This session will show you that there is more than one way to visualise data and what works best. 4/14/2012 2:30:00 PM 4/14/2012 3:30:00 PM 8557 SQLSaturday 136 Track 2 Room 2 Attendee Registration 4/14/2012 8:00:00 AM 4/14/2012 8:45:00 AM 8557 SQLSaturday 136 Track 1 Room 1 Attendee Registration 4/14/2012 8:00:00 AM 4/14/2012 8:45:00 AM 8558 Reza Rad Track 2 Room 2 SQL Server Integration Services (SSIS) is a leading tool in the data warehouse industry - used for performing extraction, transformation, and load (ETL) operations. ETL is responsible for the extraction of data from several sources, their cleansing, customization, and loading into a central repository normally called Data Warehouse or Data Mart. SSIS 2012 comes with great new features which helps ETL Developers and Architects to create more robust and reliable packages to transfer data. This session will have a brief look at new features in SSIS 2012 and their usages in real-world scenarios.features such as; parameters, data flow changes, project deployment model, development changes, logging, environments, reports and ... will be discusse 4/14/2012 5:00:00 PM 4/14/2012 6:00:00 PM