SQLSaturday #140 - Perth 2012
4/28/2012 12:00:00 AM
(GMT+08:00) Perth
SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server.
#sqlsat140
New Horizons Learning Centre
Level 6, 5 Mill St
Perth
, Australia
6000
http://www.sqlsaturday.com/images/sqlsaturday_gb_icon.png
http://www.sqlsaturday.com/images/sqlsaturday_gb_image.png
1917
LobsterPot Solutions
Whole Tour Gold
http://lobsterpot.com.au
http://lobsterpot.com.au/lp_100x40.png
60
170
1965
WARDY IT Solutions
Whole Tour Gold
http://www.wardyit.com/
http://www.wardyit.com/img/SQLSaturdayLogo.jpg
60
170
1992
SQL Down Under
Whole Tour Gold
http://www.sqldownunder.com/
http://www.sqldownunder.com/Portals/0/logo.png
60
170
2112
Fusion-io
Whole Tour Gold
http://www.fusionio.com/
http://lobsterpot.com.au/files/fusionio170.jpg
60
170
2157
Microsoft
Whole Tour Gold
http://www.microsoft.com/en-au/default.aspx
http://www.sqlpass.org/images/chapterlogos/microsoft.jpg
60
170
2089
Idera
Whole Tour Silver
http://www.idera.com/
http://www.idera.com/images/Logo-Idera.png
60
170
2148
New Horizons Learning Centres
Silver Sponsor
http://www.nhaustralia.com.au
http://lobsterpot.com.au/files/NewHorizons.png
60
170
2129
Confio Software
Whole Tour Bronze
http://www.confio.com/
http://www.confio.com/images/assets/confio_logo.jpg
60
170
1997
ReadyRoll
Whole Tour Bronze
http://ready-roll.com/
http://ready-roll.com/img/rr-sm-whitebg.png
60
170
1978
StrataDB
Whole Tour Bronze
http://www.stratadb.com/
http://www.stratadb.com/StrataDB.png
60
170
2178
CSG
Bronze Sponsor
http://www.csg.com.au
https://www1.vtrenz.net/imarkownerfiles/ownerassets/2069/CSG_MB_FullCol_RGB_170x60.jpg
60
170
2226
McGraw-Hill Education Australia New Zealand
Whole Tour Friend
http://www.mcgraw-hill.com.au/
http://www.mcgraw-hill.com.au/images/home/mgh_education.jpg
40
100
1960
Auckland SQL Server User Group
Whole Tour Friend
http://aucklandsql.com
http://aucklandsql.com/App_Themes/DotNetGroup/Images/aucklandsql_logo.gif
40
100
2015
SQL Concepts
Whole Tour Friend
http://www.sqlconcepts.co.nz/
http://www.sqlconcepts.co.nz/images/logo-100x40.png
40
100
7933
SQLSaturday 140
T1
Coffee Break
4/28/2012 2:30:00 PM
4/28/2012 3:00:00 PM
7933
SQLSaturday 140
T1
Coffee Break
4/28/2012 10:15:00 AM
4/28/2012 10:45:00 AM
7933
SQLSaturday 140
T2
Coffee Break
4/28/2012 2:30:00 PM
4/28/2012 3:00:00 PM
7933
SQLSaturday 140
T2
Coffee Break
4/28/2012 10:15:00 AM
4/28/2012 10:45:00 AM
7934
SQLSaturday 140
T2
Lunch Break
4/28/2012 12:00:00 PM
4/28/2012 12:30:00 PM
7934
SQLSaturday 140
T1
Lunch Break
4/28/2012 12:00:00 PM
4/28/2012 12:30:00 PM
8091
Paul te Braak
T2
Tabular Modelling and Design Concepts
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/28/2012 10:45:00 AM
4/28/2012 12:00:00 PM
8133
Peter O'Gorman
T2
X-ray Vision For SQL Server Error Logs
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 !We will cover how to extract the error log into a SQL Server database, transform this into a dimensional model where we can apply powerful Analytics and Time Intelligence, and provide insightful visualisations of our errors. The demonstration will use the SQL Server 2012 Sharepoint platform to demonstrate the pillars of Business Intelligence can be used to benefit DBA's specifically.
4/28/2012 4:15:00 PM
4/28/2012 5:30:00 PM
8199
Peter Ward
T1
If 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/28/2012 1:15:00 PM
4/28/2012 2:30:00 PM
8282
Greg Low
T1
Better 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/28/2012 4:15:00 PM
4/28/2012 5:30:00 PM
8378
Bhavik Merchant
T2
Accelerated BI Growth with Power View PowerPivot
It is a known fact that a low rate of user adoption is a major issue in less than successful BI implementations. The most significant cause could arguably be the lack of simple, intuitive and flexible tools at the reporting/presentation layer. With PowerPivot, Microsoft gave us an easy way to mash-up data models, create Excel reports and surface them through Sharepoint.Now, with Power View in SQL 2012 we have an easy, sexy and compelling way for true business users visualise and present this information. With interactive demos you will learn about Power View, understand its dependencies, learn data model design tips and be made aware of any pitfalls and limitations.
4/28/2012 9:00:00 AM
4/28/2012 10:15:00 AM
8382
Bhavik Merchant
T2
Migrating Config and Deployment to SSIS 2012
In SQL 2012, SSIS has had its largest facelift since SQL 2005. A raft of new features have been introduced, and the most significant of them from an ETL framework perspective is the new Project Deployment model. This completely redefines how we could architect and deploy our solutions with configurations supporting multiple environments. It also raises some concerns around upgrading/migrating older solutions.This session briefly looks at common approaches for configuration management in SQL 2008R2. The new 2012 deployment and configuration model is then introduced and we look at how to best migrate these legacy configurations over.
4/28/2012 1:15:00 PM
4/28/2012 2:30:00 PM
8403
Paul te Braak
T2
Golden Nuggets
Too much data to think about and no idea where to start? Let the machine to the thinking and give data mining a try! This presentation looks into data mining: what it is, how to get it up and running, how to know if it makes any sense and (more importantly) how the use it. We look at the development and evaluation of models and then put them to work so they can be used to produce tangible benefits for your end users.
4/28/2012 3:00:00 PM
4/28/2012 4:15:00 PM
8479
Rob Farley
T1
Analytic T-SQL Functions in 2012
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/28/2012 10:45:00 AM
4/28/2012 12:00:00 PM
8482
Rob Farley
T1
The MERGE Statement - T-SQL's Swiss Army Knife
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.
4/28/2012 3:00:00 PM
4/28/2012 4:15:00 PM
8726
Raja N
T1
DBCA - Database Consolidation Appliance
Gain insights into SQL Server Database Consolidation Appliance (DBCA), first appliance in the industry specifically designed to meet the challenge of database sprawl and help customers regain control of their SQL Server environments. Come and Learn more about this pre-built hardware and management software and how to accelerate the consolidation efforts and eliminate the complexity of managing the database infrastructure for thousands of SQL instances while maintaining an highly performing environment at the same time.
4/28/2012 9:00:00 AM
4/28/2012 10:15:00 AM
8877
Fusion- IO
T1
Fusion-IO
During the lunch break, Fusion-IO will be presenting a session for interested attendees.
4/28/2012 12:30:00 PM
4/28/2012 1:00:00 PM
8878
New Horizons
T2
New Horizons
During the lunch break, New Horizons will be presenting a session for interested attendees.
4/28/2012 12:30:00 PM
4/28/2012 1:00:00 PM
9053
SQLSaturday 140
T2
Registration
Registration
4/28/2012 8:15:00 AM
4/28/2012 8:45:00 AM
9053
SQLSaturday 140
T1
Registration
Registration
4/28/2012 8:15:00 AM
4/28/2012 8:45:00 AM
9054
SQLSaturday 140
T1
Welcome
Welcome
4/28/2012 8:45:00 AM
4/28/2012 9:00:00 AM
9054
SQLSaturday 140
T2
Welcome
Welcome
4/28/2012 8:45:00 AM
4/28/2012 9:00:00 AM