SQLSaturday #135 - Brisbane 2012
Event Date: 04/12/2012 00:00:00
Event Location:
- Queensland University Of Technology
- 2 George Street
- Brisbane, Australia
This event has completed. All data shown below is from the historical XML public data available.
If there are any data quality issues or corrections needed, please contact the webmaster for this site or submit a pull request for the appropriate file(s).
Sessions
This is a list of sessions from the event, based on the schedule in the XML files.
Title: A Lap Around SQL Azure
Abstract: In 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 Azure
Speaker(s):
- Rod Colledge
Track and Room: Business Intelligence - N/A
Title: BI Architecture with SQL 2012 SharePoint 2010
Abstract: In 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.
Speaker(s):
- Rod Colledge
Track and Room: Business Intelligence - N/A
Title: 3D Glasses for SQL Server Error Logs
Abstract: In 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 !
Speaker(s):
- Peter O’Gorman
Track and Room: Mixed - N/A
Title: Better Together: Merge, Partitioning, ColumnStore
Abstract: 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.
Speaker(s):
- Greg Low
Track and Room: SQL Server - N/A
Title: Tabular Modelling and Design Concepts
Abstract: 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).
Speaker(s):
- Paul te Braak
Track and Room: Business Intelligence - N/A
Title: Query Tuning Using Lessons Learned from SSIS
Abstract: 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.
Speaker(s):
- Rob Farley
Track and Room: Mixed - N/A
Title: The MERGE Statement - T-SQL’s Swiss Army Knife
Abstract: Despite 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.
Speaker(s):
- Rob Farley
Track and Room: Business Intelligence - N/A
Title: The Dark Art of Performance Tuning
Abstract: 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.
Speaker(s):
- Peter Ward
Track and Room: SQL Server - N/A
Title: Visualising your data with PivotViewer
Abstract: 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.
Speaker(s):
- Roger Noble
Track and Room: Business Intelligence - N/A
Title: Introducing Contained Databases in SQL Server 2012
Abstract: Portability 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.
Speaker(s):
- Heidi Wilson
Track and Room: Mixed - N/A
Title: Keeping the light’s on with SQL 2012 Always On
Abstract: In 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.
Speaker(s):
- Warwick Rudd
Track and Room: SQL Server - N/A
Title: Troubleshooting SQL Issues using Ring Buffers
Abstract: This 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.
Speaker(s):
- Rob Risetto
Track and Room: SQL Server - N/A
Title: Analytic T-SQL Functions in 2012
Abstract: 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.
Speaker(s):
- Rob Farley
Track and Room: SQL Server - N/A
Title: If you had $10K what would you spend it on?
Abstract: 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.
Speaker(s):
- Peter Ward
Track and Room: Mixed - N/A
Speakers
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
Peter Ward
Twitter: - @wardy
LinkedIn: Peter Ward
Contact: http://wardyit.com/blog
Peter Ward is WARDY IT Solutions Chief Technical Architect. Peter’s credentials and achievements include being a highly regarded speaker at SQL Server events; a sought after SQL Server consultant and trainer providing solutions for some of the largest SQL Server sites in Australia. Peter has been recognised as a Microsoft Most Valuable Professional for his technical excellence and commitment to the SQL Server Community.
Roger Noble
Twitter: - @Roger_Noble
Contact: http://www.rogernoble.com
Roger Noble is a Business Intelligence Consultant and MCT for LobsterPot Solutions. Based in Adelaide, Australia, he spends most of his time building BI solutions using the Microsoft stack. Specializing in SharePoint and Analysis Services, and one of the industry’s leaders in PivotViewer and HTML5 technologies, he regularly attends and speaks at the Adelaide SQL Server User Group and Adelaide SharePoint User Group.
Paul te Braak
Twitter: - @paultebraak
LinkedIn: Paul te Braak
Contact: http://www.paultebraak.wordpress.com
Paul te Braak is the principle consultant of abaX Data and has over a decade of experience in delivering reporting and business intelligence solutions across a variety of verticals. This experience includes systems auditing, planning and business simulation models that predict activity through heuristic rules imbedded into the model. He holds several qualifications including MCT, CA, MIT, MComm.
Rob Farley
Twitter: - rob_farley
LinkedIn: Rob Farley
Contact: http://blogs.lobsterpot.com.au
Rob Farley runs LobsterPot Solutions in Australia, where he’s a consultant in the Microsoft Data Platform and Analytics space. He’s been an MVP since 2006, probably because of his blogging, his presentations around the world, and his dedication to the Adelaide Data Analytics User Group which he has led since before the release of SQL Server 2005. He’s on Twitter at @rob_farley, but you can always email him using rob@lobsterpot.com.au
Rob Risetto
Contact: http://www.stratadb.com
Rob 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.
Greg Low
Twitter: - greglow
LinkedIn: Greg Low
Contact: http://blog.greglow.com
Greg Low is well-known in the SQL Server community as a mentor, trainer, author, and community leader. He is a certified master for SQL Server, was an instructor in that program, and holds a PhD in Computer Science. Microsoft often calls on Greg to develop data-related content, and to train their staff. He regularly speaks at tier-one conferences internationally. Greg is best known for his SQL Down Under podcast, SDU Tools, and his eBooks and whitepapers. He heads up a boutique consultancy called SQL Down Under in Melbourne Australia. Greg has been awarded as an MVP since 2001.
Rod Colledge
Contact: http://www.stratadb.com
Rod Colledge is a director and founder of StrataDB, a leading Australian-based provider of SQL Server solutions. With 15+ years of SQL Server experience, Rod’s commitment and depth of knowledge was recognized in 2010 with a Microsoft MVP award for SQL Server. Rod leads StrataDB’s Business Intelligence practice and has authored or contributed to three books, including the “SQL Server MVP Deep Dives” series. He’s a sought-after speaker at both local and international SQL Server conferences.
Peter Ward
Twitter: - @wardy
LinkedIn: Peter Ward
Contact: http://wardyit.com/blog
Peter Ward is WARDY IT Solutions Chief Technical Architect. Peter’s credentials and achievements include being a highly regarded speaker at SQL Server events; a sought after SQL Server consultant and trainer providing solutions for some of the largest SQL Server sites in Australia. Peter has been recognised as a Microsoft Most Valuable Professional for his technical excellence and commitment to the SQL Server Community.
Rod Colledge
Contact: http://www.stratadb.com
Rod Colledge is a director and founder of StrataDB, a leading Australian-based provider of SQL Server solutions. With 15+ years of SQL Server experience, Rod’s commitment and depth of knowledge was recognized in 2010 with a Microsoft MVP award for SQL Server. Rod leads StrataDB’s Business Intelligence practice and has authored or contributed to three books, including the “SQL Server MVP Deep Dives” series. He’s a sought-after speaker at both local and international SQL Server conferences.
Rob Farley
Twitter: - rob_farley
LinkedIn: Rob Farley
Contact: http://blogs.lobsterpot.com.au
Rob Farley runs LobsterPot Solutions in Australia, where he’s a consultant in the Microsoft Data Platform and Analytics space. He’s been an MVP since 2006, probably because of his blogging, his presentations around the world, and his dedication to the Adelaide Data Analytics User Group which he has led since before the release of SQL Server 2005. He’s on Twitter at @rob_farley, but you can always email him using rob@lobsterpot.com.au
Rob Farley
Twitter: - rob_farley
LinkedIn: Rob Farley
Contact: http://blogs.lobsterpot.com.au
Rob Farley runs LobsterPot Solutions in Australia, where he’s a consultant in the Microsoft Data Platform and Analytics space. He’s been an MVP since 2006, probably because of his blogging, his presentations around the world, and his dedication to the Adelaide Data Analytics User Group which he has led since before the release of SQL Server 2005. He’s on Twitter at @rob_farley, but you can always email him using rob@lobsterpot.com.au
Peter O’Gorman
Twitter: - @peterogorman
Contact: http://popbi.wordpress.com
Peter O’Gorman is a Business Intelligence consultant currently working in Queensland, Australia on a large Water Utility Asset Consolidation Project. 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.
Linked in http://au.linkedin.com/in/popbi Blog http://popbi.wordpress.com
Warwick Rudd
Contact: http://www.jnrit.com.au/Blog.aspx
Warwick Rudd is currently employed as a SQL Server Consultant and Certified Trainer for WARDY IT Solutions, Australia’s leading SQL Server consultants, trainers and Business Intelligence specialists. Warwick is a frequent speaker at local SQL Server user groups and SQLSaturday events in Australia. When not playing with the SQL stack, Warwick likes to get away to the cold and spend time snowboarding.
Heidi Wilson
Contact: http://sqlskirt.com
Heidi Wilson is an independent SQL Server Consultant and Microsoft Certified Trainer. Heidi has over 10 years of experience working with SQL Server and specialises in the design and implementation of highly available and disaster recoverable SQL Server solutions. Heidi regularly presents and volunteers at various events including SQLSaturday and SQL Server User Groups across Australia.
Sponsors
The following is a list of sponsors that helped fund the event: