SQLSaturday #135 - Brisbane 20124/12/2012 12:00:00 AM(GMT+10:00) BrisbaneSQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. #sqlsat135Queensland University Of Technology2 George StreetBrisbane, Australia40001918LobsterPot SolutionsWhole Tour Goldhttp://lobsterpot.com.auhttp://lobsterpot.com.au/lp_100x40.png601701955WARDY IT SolutionsWhole Tour Goldhttp://www.wardyit.comhttp://www.wardyit.com/img/SQLSaturdayLogo.jpg601701989SQL Down UnderWhole Tour Goldhttp://www.sqldownunder.comhttp://www.sqldownunder.com/Portals/0/logo.png601702116Fusion-ioWhole Tour Goldhttp://www.fusionio.com/http://lobsterpot.com.au/files/fusionio170.jpg601702153MicrosoftWhole Tour Goldhttp://www.microsoft.com/en-au/default.aspxhttp://www.sqlpass.org/images/chapterlogos/microsoft.jpg601701973StrataDBGold Sponsorhttp://www.stratadb.comhttp://www.stratadb.com/StrataDB.png601702085IderaWhole Tour Silverhttp://www.idera.com/http://www.idera.com/images/Logo-Idera.png601702125Confio SoftwareWhole Tour Bronzehttp://www.confio.com/http://www.confio.com/images/assets/confio_logo.jpg601702002ReadyRollWhole Tour Bronzehttp://ready-roll.com/http://ready-roll.com/img/rr-sm-whitebg.png601702011SQL ConceptsWhole Tour Friendhttp://www.sqlconcepts.co.nz/http://www.sqlconcepts.co.nz/images/logo-100x40.png401001956Auckland SQL Server User GroupWhole Tour Friendhttp://aucklandsql.comhttp://aucklandsql.com/App_Themes/DotNetGroup/Images/aucklandsql_logo.gif401008278Greg LowGreg Low is an internationally recognised Consultant, developer and trainer. He has been working in development since 1978, holds a PhD in Computer Science and a host of Microsoft certifications. Greg is the Managing Director for SQL Down Under, a SQL Server MVP, a Microsoft Regional Director and a PASS Regional Mentor.@greglowhttp://www.linkedin.com/greglowhttp://www.sqldownunder.comhttps://api.twitter.com/1/users/profile_image?screen_name=@greglow48488085Heidi WilsonHeidi Wilson is a SQL Server Consultant at WARDY IT Solutions. WARDY IT Solutions are Australia's leading SQL Server consultants, trainers and Business Intelligence specialists.@sqlskirthttp://au.linkedin.com/pub/heidi-wilson/8a/611/7ba/https://api.twitter.com/1/users/profile_image?screen_name=@sqlskirt48488090Paul te BraakPaul te Braak is a Business intelligence consultant specialising in data warehouse model design and OLAP databases. Paul has worked with SQL server products since SQL2000 with a focuses on delivering business intelligence solutions for clients across a range of verticals.@paultebraakhttp://www.linkedin.com/in/paultebraak http://paultebraak.wordpress.com/https://api.twitter.com/1/users/profile_image?screen_name=@paultebraak48487977Peter O'GormanPeter O'Gorman is a Business Intelligence consultant currently working in Queensland on strategic business intelligence solutions for Queensland Government. Peter is passionate about helping people unlock the value in their data. Coming from a DBA background, Peter understands that DBA's are people too and can also reap all of the benefits that a self service business intelligence solution can provide.@peterogormanhttp://au.linkedin.com/in/popbihttp://popbi.wordpress.comhttps://api.twitter.com/1/users/profile_image?screen_name=@peterogorman48488189Peter WardPeter Ward is the Chief Technical Architect of WARDY IT Solutions, a company he founded in 2005. WARDY IT Solutions has been awarded the Microsoft Data Platform Partner of the Year since 2009 and has been a member of the Deloitte Technology Fast 500 since 2010. Peter is a highly regarded speaker at SQL Server events, a sought after SQL Server consultant, and a trainer who provides solutions for some of the largest SQL Server sites in Australia.@wardyhttp://www.linkedin.com/in/peterswardhttp://wardyit.com/blog/https://api.twitter.com/1/users/profile_image?screen_name=@wardy48488190Peter WardPeter Ward is the Chief Technical Architect of WARDY IT Solutions, a company he founded in 2005. WARDY IT Solutions has been awarded the Microsoft Data Platform Partner of the Year since 2009 and has been a member of the Deloitte Technology Fast 500 since 2010. Peter is a highly regarded speaker at SQL Server events, a sought after SQL Server consultant, and a trainer who provides solutions for some of the largest SQL Server sites in Australia.@wardyhttp://www.linkedin.com/in/peterswardhttp://wardyit.com/blog/https://api.twitter.com/1/users/profile_image?screen_name=@wardy48488202Rob RisettoRob has over 20 years' experience in managing and designing database environments and 15 years SQL Server experience. Rob’s efforts enabled Australia’s largest web hosting company to grow their SQL Server hosting business from 3 SQL Servers and a couple of hundred databases to 266 SQL Server Instances, 9000+ databases and over 4 terabytes of data. Rob’s extensive experience includes High Availability, Replication, Performance Tuning and Powershell scripting including SQL Cluster deployment.http://www.stratadb.com48488442Rob FarleyRob Farley is the owner and principal consultant of LobsterPot Solutions Pty Ltd, a consulting firm specialising in SQL Server and Business Intelligence out of Adelaide Melbourne. Rob is a Microsoft Certified Trainer, a SQL MVP since 2006, and Director of PASS. He was the author of two chapters in SQL Server MVP Deep Dives and one in SQL Server MVP Deep Dives 2, and is currently working on a book to help people pass 70-461.@rob_farleyhttp://au.linkedin.com/in/robfarleyhttp://sqlblog.com/blogs/rob_farleyhttps://api.twitter.com/1/users/profile_image?screen_name=@rob_farley48488443Rob FarleyRob Farley is the owner and principal consultant of LobsterPot Solutions Pty Ltd, a consulting firm specialising in SQL Server and Business Intelligence out of Adelaide Melbourne. Rob is a Microsoft Certified Trainer, a SQL MVP since 2006, and Director of PASS. He was the author of two chapters in SQL Server MVP Deep Dives and one in SQL Server MVP Deep Dives 2, and is currently working on a book to help people pass 70-461.@rob_farleyhttp://au.linkedin.com/in/robfarleyhttp://sqlblog.com/blogs/rob_farleyhttps://api.twitter.com/1/users/profile_image?screen_name=@rob_farley48488444Rob FarleyRob Farley is the owner and principal consultant of LobsterPot Solutions Pty Ltd, a consulting firm specialising in SQL Server and Business Intelligence out of Adelaide Melbourne. Rob is a Microsoft Certified Trainer, a SQL MVP since 2006, and Director of PASS. He was the author of two chapters in SQL Server MVP Deep Dives and one in SQL Server MVP Deep Dives 2, and is currently working on a book to help people pass 70-461.@rob_farleyhttp://au.linkedin.com/in/robfarleyhttp://sqlblog.com/blogs/rob_farleyhttps://api.twitter.com/1/users/profile_image?screen_name=@rob_farley48488096Rod ColledgeRod Colledge is a SQL Server MVP and Technical Director with StrataDB, a Microsoft Partner and leading provider of business solutions for the Corporate, Government and Education sectors. He’s an author of 3 SQL Server books, and is currently working with Microsoft on the development of the SQL Server 2012 certification exams. In his spare time, Rod enjoys interpretive line dancing, underwater poetry, breeding pocket dogs for Hollywood celebrities.@rodcolledgehttp://www.linkedin.com/in/rodcolledgehttp://www.stratadb.comhttps://api.twitter.com/1/users/profile_image?screen_name=@rodcolledge48488095Rod Colledge Matthew WarwickRod Colledge is a SQL Server MVP Technical Director with StrataDB. He’s an author of 3 books including the SQL Server MVP Deep Dives series, and is currently working with Microsoft on the development of the SQL Server 2012 certification exams.Matthew Warwick is a Microsoft Certified Professional with over 10 years experience with .Net and Business Intelligence. He’s a senior developer with Mexia Consulting, a Microsoft Gold Partner specialising in enterprise integration.@rodcolledgehttp://www.linkedin.com/in/rodcolledgehttp://www.stratadb.comhttps://api.twitter.com/1/users/profile_image?screen_name=@rodcolledge48488384Roger NobleRoger Noble is a Business Intelligence Consultant and MCT for LobsterPot Solutions. Based in Adelaide, he spends most of his time building BI solutions using the Microsoft stack. Specializing in SharePoint, Analysis Services and one of the industry’s leaders in PivotViewer technologies. He is a volunteer for the PASS BI Virtual Chapter in Australia and regularly attends and speaks at the Adelaide SQL Server User Group and SharePoint User Group.@Roger_Noblehttp://www.rogernoble.comhttps://api.twitter.com/1/users/profile_image?screen_name=@Roger_Noble48488352Warwick Rudd Henry Rooney Warwick Rudd is a SQL Server Consultant at WARDY IT Solutions.IT Solutions are Australia's leading SQL Server consultants, trainers and Business Intelligence specialists.@jnrt74http://www.linkedin.com/pub/warwick-rudd/0/956/718http://www.jnrit.com.au/Blog.aspxhttps://api.twitter.com/1/users/profile_image?screen_name=@jnrt74484879227922SQLSatruday 135SQL ServerRoom 1Coffee Break4/12/2012 10:15:00 AM4/12/2012 10:30:00 AM79227922SQLSatruday 135SQL ServerRoom 1Coffee Break4/12/2012 3:30:00 PM4/12/2012 3:45:00 PM79227922SQLSatruday 135SQL ServerRoom 1Coffee Break4/12/2012 11:45:00 AM4/12/2012 12:00:00 PM79227922SQLSatruday 135Business Intelligence Room 2Coffee Break4/12/2012 10:15:00 AM4/12/2012 10:30:00 AM79227922SQLSatruday 135Business Intelligence Room 2Coffee Break4/12/2012 3:30:00 PM4/12/2012 3:45:00 PM79227922SQLSatruday 135Business Intelligence Room 2Coffee Break4/12/2012 11:45:00 AM4/12/2012 12:00:00 PM79227922SQLSatruday 135MixedRoom 3Coffee Break4/12/2012 10:15:00 AM4/12/2012 10:30:00 AM79227922SQLSatruday 135MixedRoom 3Coffee Break4/12/2012 3:30:00 PM4/12/2012 3:45:00 PM79227922SQLSatruday 135MixedRoom 3Coffee Break4/12/2012 11:45:00 AM4/12/2012 12:00:00 PM79237923SQLSaturday 135MixedRoom 3Lunch Break4/12/2012 1:15:00 PM4/12/2012 2:15:00 PM79237923SQLSaturday 135Business Intelligence Room 2Lunch Break4/12/2012 1:15:00 PM4/12/2012 2:15:00 PM79237923SQLSaturday 135SQL ServerRoom 1Lunch Break4/12/2012 1:15:00 PM4/12/2012 2:15:00 PM79777977Peter O'GormanMixedRoom 33D Glasses for SQL Server Error LogsIn this session we explore the full potential of the SQL Server Error Log. The error log is painful to sift through at best, so we turn to Business Intelligence to provide us with an insightful 30,000 view of the error log, and will be amazed at what we can see !4/12/2012 2:15:00 PM4/12/2012 3:30:00 PM80858085Heidi WilsonMixedRoom 3Introducing Contained Databases in SQL Server 2012Portability and tempdb collation conflicts are challenges currently faced with traditional databases. SQL Server 2012 introduces a new feature called Contained Databases that overcomes these challenges. This session is an introduction to Contained Databases and will look at the different types of containment; how to create, connect to and manage a contained database; and database portability made easy.4/12/2012 10:30:00 AM4/12/2012 11:45:00 AM80908090Paul te BraakBusiness Intelligence Room 2Tabular Modelling and Design ConceptsAnalysis 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/12/2012 12:00:00 PM4/12/2012 1:15:00 PM80958095Rod Colledge Matthew WarwickBusiness Intelligence Room 2A Lap Around SQL AzureIn this fast paced session, we’ll cover SQL Azure from a number of angles. Strap on your belt and helmet as we race around the Azure track. TURN 1; SQL Azure Overview; What is it? Why would you use it? How much does it cost? Azure vs. Amazon vs. SalesForce.com. TURN 2; Provisioning an Instance of SQL Azure. TURN 3; Deployment and Management; How to deploy a database to Azure, Getting data in (and out), Azure database management and current limitations. TURN 4; Applications SQL Azure; Windows Azure Apps vs. On-Premises Apps, Azure Data Source for SSIS SSAS, Lightswitch. HOME STRAIGHT; Demos! – Moving Data to Azure with SSIS and Azure Migration Wizard, SSRS with an Azure Data Source, Deploying an SSRS Report to Azure4/12/2012 2:15:00 PM4/12/2012 3:30:00 PM80968096Rod ColledgeBusiness Intelligence Room 2 BI Architecture with SQL 2012 SharePoint 2010In this session, we'll cover new BI features in SQL Server 2012 including Power View, Tabular BISM, Report Alerts and SSRS Integration with SharePoint Server 2010. We'll then focus on the importance of Self-Service BI and how it fits into an overall enterprise Business Intelligence architecture. This session will be rich with demos of all the key BI tools, and will also cover installation and configuration on both new and existing Sharepoint farms. We'll also cover securely extending BI solutions over the internet, touching on Kerberos Delegation and Threat Management Gateway (TMG). Come along and discover the awesome power of the latest release of the Microsoft BI Platform.4/12/2012 9:00:00 AM4/12/2012 10:15:00 AM81898189Peter WardMixedRoom 3If you had $10K what would you spend it on?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/12/2012 9:00:00 AM4/12/2012 10:15:00 AM81908190Peter WardSQL ServerRoom 1The Dark Art of Performance TuningDespite 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/12/2012 3:45:00 PM4/12/2012 5:00:00 PM82028202Rob RisettoSQL ServerRoom 1Troubleshooting SQL Issues using Ring BuffersThis session will showcase the hidden treasures that are within SQL Server Ring Buffers and how they can be used to troubleshoot SQL Server issues. The session provides a demonstration of how to identify SQL exceptions, connection failures and SQL Server memory issues.4/12/2012 10:30:00 AM4/12/2012 11:45:00 AM82788278Greg LowSQL ServerRoom 1Better Together: Merge, Partitioning, ColumnStore Most SQL Server sessions are based around individual features but SQL Server really shines when you start to combine features. In this session, Greg will provide an introduction to ColumnStore indexes, review Table Partitioning and Merge and show how to combine these features to improve query performance while still being able to load data warehouse data quickly.4/12/2012 12:00:00 PM4/12/2012 1:15:00 PM83528352Warwick Rudd Henry Rooney SQL ServerRoom 1Keeping the light's on with SQL 2012 Always OnIn this session, we'll cover how HA DR is currently utlised and some misgivings. We'll then introduce the capabilities of Always On in SQL Server 2012 and how these can benefit your existing solution. This presentation will be rich with demo's covering installation and configuration of your Always On environment.4/12/2012 2:15:00 PM4/12/2012 3:30:00 PM83848384Roger NobleBusiness Intelligence Room 2Visualising your data with PivotViewerDiscover 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/12/2012 10:30:00 AM4/12/2012 11:45:00 AM84428442Rob FarleyMixedRoom 3Query Tuning Using Lessons Learned from SSISI'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/12/2012 12:00:00 PM4/12/2012 1:15:00 PM84428442Rob FarleyMixedRoom 3Query Tuning Using Lessons Learned from SSISI'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/12/2012 3:45:00 PM4/12/2012 5:00:00 PM84438443Rob FarleySQL ServerRoom 1Analytic T-SQL Functions in 2012There 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/12/2012 9:00:00 AM4/12/2012 10:15:00 AM84448444Rob FarleyBusiness Intelligence Room 2The MERGE Statement - T-SQL's Swiss Army KnifeDespite being around since SQL Server 2008 MERGE is one of the most underappreciated features in T-SQL. In many ways it's the Swiss Army Knife, able to be used in many different situations. It's not without it's frustrations though, and you'll see both sides of this useful tool in this presentation.4/12/2012 3:45:00 PM4/12/2012 5:00:00 PM