Nr: 135
SQLSaturday #135 - Brisbane 2012
SessionID: 14826
Better Together: Merge, Partitioning, ColumnStore
Event Date: 12-04-2012 - Session time: 00:00:00 - Track: SQL Server
Speaker: Greg Low
Title: Better Together: Merge, Partitioning, ColumnStore
Abstract:
SessionID: 22056
If you had $10K what would you spend it on?
Event Date: 12-04-2012 - Session time: 00:00:00 - Track: Mixed
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: 22057
Event Date: 12-04-2012 - Session time: 00:00:00 - Track: SQL Server
Speaker: Peter Ward
Abstract:
SessionID: 22376
Tabular Modelling and Design Concepts
Event Date: 12-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: 23208
Query Tuning Using Lessons Learned from SSIS
Event Date: 12-04-2012 - Session time: 00:00:00 - Track: Mixed
Speaker: Rob Farley
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.
SessionID: 23209
Analytic T-SQL Functions in 2012
Event Date: 12-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: 23210
The MERGE Statement - T-SQL's Swiss Army Knife
Event Date: 12-04-2012 - Session time: 00:00:00 - Track: Business Intelligence
Speaker: Rob Farley
Title: The MERGE Statement - T-SQL's Swiss Army Knife
Abstract:
SessionID: 23236
Troubleshooting SQL Issues using Ring Buffers
Event Date: 12-04-2012 - Session time: 00:00:00 - Track: SQL Server
Speaker: Rob Risetto
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.
SessionID: 23382
A Lap Around SQL Azure
Event Date: 12-04-2012 - Session time: 00:00:00 - Track: Business Intelligence
Speaker: Rod Colledge
Title: A Lap Around SQL Azure
Abstract:
SessionID: 23383
BI Architecture with SQL 2012 SharePoint 2010
Event Date: 12-04-2012 - Session time: 00:00:00 - Track: Business Intelligence
Speaker: Rod Colledge
Title: BI Architecture with SQL 2012 SharePoint 2010
Abstract:
SessionID: 23413
Visualising your data with PivotViewer
Event Date: 12-04-2012 - Session time: 00:00:00 - Track: Business Intelligence
Speaker: Roger Noble
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.
SessionID: 27660
Keeping the light's on with SQL 2012 Always On
Event Date: 12-04-2012 - Session time: 00:00:00 - Track: SQL Server
Speaker: Warwick Rudd
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.
SessionID: 34649
Introducing Contained Databases in SQL Server 2012
Event Date: 12-04-2012 - Session time: 00:00:00 - Track: Mixed
Speaker: Heidi Wilson
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.
SessionID: 9061
3D Glasses for SQL Server Error Logs
Event Date: 12-04-2012 - Session time: 00:00:00 - Track: Mixed
Speaker: Peter O'Gorman
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 !