Event Location:
Edge Church
Hindley St
Adelaide, , Australia
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,
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,
Abstract:
Building business applications became more simple with LightSwitch and Azure. This demo can explain some aspects of database and application life cycle from design stage to deployment into cloud. Simple design, practical experience and examples.
Speaker(s): Andrew Butenko,
Abstract:
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.
Speaker(s): Paul White,
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,
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,
Abstract:
· Overview of SQL Server Consolidation and DBCA · Technical features and Performance metrics of DBCA · Demo:- · Showcase MAPT Profiling reports · P2V Migration · SCVMM – Live Migration (Planned) · SCVMM – Dynamic Elastic resourcing · Self Service Provisioning of a new VM - End to End · HA Capabilities – Couple of demos with some load simulators – Remove blade which is hosting VM, Remove one of the iSCSI or Network cable or HDD
Speaker(s): Raja N,
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,
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,
Abstract:
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.
Speaker(s): Paul White,
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
LinkedIn: http://au.linkedin.com/in/petersward/
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.
LinkedIn: http://au.linkedin.com/in/robfarley/
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
TBC
LinkedIn: http://au.linkedin.com/in/petersward/
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.
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.
Contact: http://sqlblog.com/blogs/paul_white/default.aspx
Paul White is an independent SQL Server technical consultant, specializing in performance tuning. He lives in Paraparaumu, New Zealand, and has worked with SQL Server since version 6. Paul writes a highly-regarded SQL Server technical blog and has been a SQL Server MVP since 2011.
LinkedIn: http://www.linkedin.com/in/paultebraak
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.
Contact: http://andrewbutenko.wordpress.com/
MCSE,MSDBA,MCITP. 20 years in IT
LinkedIn: http://au.linkedin.com/in/robfarley/
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
Contact: http://sqlblog.com/blogs/paul_white/default.aspx
Paul White is an independent SQL Server technical consultant, specializing in performance tuning. He lives in Paraparaumu, New Zealand, and has worked with SQL Server since version 6. Paul writes a highly-regarded SQL Server technical blog and has been a SQL Server MVP since 2011.
The following is a list of sponsors that helped fund the event.