SQLSaturday #140 - Perth 2012
Event Date: 04/28/2012 00:00:00
Event Location:
- New Horizons Learning Centre
- 12/251 Adelaide Terrace
- Perth, 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: Accelerated BI Growth with Power View PowerPivot
Abstract: 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.
Speaker(s):
- Bhavik Merchant
Track and Room: Business Intelligence - N/A
Title: X-ray Vision 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 !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.
Speaker(s):
- Peter O’Gorman
Track and Room: Business Intelligence - 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: 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: SQL Server - N/A
Title: DBCA - Database Consolidation Appliance
Abstract: 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.
Speaker(s):
- Raja N
Track and Room: SQL Server - N/A
Title: Migrating Config and Deployment to SSIS 2012
Abstract: 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.
Speaker(s):
- Bhavik Merchant
Track and Room: Business Intelligence - 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: 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: SQL Server - N/A
Title: Golden Nuggets
Abstract: 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.
Speaker(s):
- Paul te Braak
Track and Room: Business Intelligence - 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
Speakers
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
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
Bhavik Merchant
Twitter: - @BhavikMerchant
Contact: http://bhavikmerchant.wordpress.com
Bhavik is a Microsoft vTSP for BI, leads a national team of consultants and has over 7 years of experience across the entire Microsoft BI stack.
He speaks regularly at public events and has presented a theatre session at Microsoft TechEd and topics at various Sharepoint Saturday and SQLSaturday events around Australia. He also presents at Sharepoint and SQL Server User Groups and for the PASS BI Virtual Chapter.
He has been delivering formal training for over 3 years, teaching classes on SSAS, SSRS, SSIS, PowerPivot and Sharepoint BI.
He has a genuine and zealous passion for Microsoft BI and the value it can bring to business when implemented correctly!
Bhavik Merchant
Twitter: - @BhavikMerchant
Contact: http://bhavikmerchant.wordpress.com
Bhavik is a Microsoft vTSP for BI, leads a national team of consultants and has over 7 years of experience across the entire Microsoft BI stack.
He speaks regularly at public events and has presented a theatre session at Microsoft TechEd and topics at various Sharepoint Saturday and SQLSaturday events around Australia. He also presents at Sharepoint and SQL Server User Groups and for the PASS BI Virtual Chapter.
He has been delivering formal training for over 3 years, teaching classes on SSAS, SSRS, SSIS, PowerPivot and Sharepoint BI.
He has a genuine and zealous passion for Microsoft BI and the value it can bring to business when implemented correctly!
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.
Raja N
TBC
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.
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.
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
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
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.
Sponsors
The following is a list of sponsors that helped fund the event: