Nr: 140
SQLSaturday #140 - Perth 2012
SessionID: 10411
Accelerated BI Growth with Power View PowerPivot
Event Date: 28-04-2012 - Session time: 00:00:00 - Track: Business Intelligence
Speaker: Bhavik Merchant
Title: Accelerated BI Growth with Power View PowerPivot
Abstract:
SessionID: 10412
Migrating Config and Deployment to SSIS 2012
Event Date: 28-04-2012 - Session time: 00:00:00 - Track: Business Intelligence
Speaker: Bhavik Merchant
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.
SessionID: 14828
Better Together: Merge, Partitioning, ColumnStore
Event Date: 28-04-2012 - Session time: 00:00:00 - Track: SQL Server
Speaker: Greg Low
Title: Better Together: Merge, Partitioning, ColumnStore
Abstract:
SessionID: 21519
DBCA - Database Consolidation Appliance
Event Date: 28-04-2012 - Session time: 00:00:00 - Track: SQL Server
Speaker: Raja N
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.
SessionID: 22060
If you had $10K what would you spend it on?
Event Date: 28-04-2012 - Session time: 00:00:00 - Track: SQL Server
Speaker: Peter Ward
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.
SessionID: 22380
Tabular Modelling and Design Concepts
Event Date: 28-04-2012 - Session time: 00:00:00 - Track: Business Intelligence
Speaker: Paul te Braak
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).
SessionID: 22381
Golden Nuggets
Event Date: 28-04-2012 - Session time: 00:00:00 - Track: Business Intelligence
Speaker: Paul te Braak
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.
SessionID: 23189
Analytic T-SQL Functions in 2012
Event Date: 28-04-2012 - Session time: 00:00:00 - Track: SQL Server
Speaker: Rob Farley
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.
SessionID: 23192
The MERGE Statement - T-SQL's Swiss Army Knife
Event Date: 28-04-2012 - Session time: 00:00:00 - Track: SQL Server
Speaker: Rob Farley
Title: The MERGE Statement - T-SQL's Swiss Army Knife
Abstract:
SessionID: 9062
X-ray Vision For SQL Server Error Logs
Event Date: 28-04-2012 - Session time: 00:00:00 - Track: Business Intelligence
Speaker: Peter O'Gorman
Title: X-ray Vision For SQL Server Error Logs
Abstract: