sqlsathistory

Nr: 137

Back to Main list

SQLSaturday #137 - Canberra 2012

Start Time (24h) Speaker Track Title
00:00:00 Grant Paisley Everything SQL Killer Real-World PowerPivot Examples
00:00:00 Greg Low Everything SQL Better Together: Merge, Partitioning, ColumnStore
00:00:00 Martin Cairney Everything SQL SQL to the Core
00:00:00 Raja N Everything SQL Database Consolidation with HP’s DBCA
00:00:00 Roger Noble Everything SQL Visualising your data with PivotViewer
00:00:00 Warwick Rudd Everything SQL Keeping the light's on with SQL 2012 Always On

SessionID: 14722

Killer Real-World PowerPivot Examples

Back to calendar

Event Date: 19-04-2012 - Session time: 00:00:00 - Track: Everything SQL

Speaker: Grant Paisley

Title: Killer Real-World PowerPivot Examples

Abstract:

This session is even more jam packed with amazing PowerPivot report examples than last year's presentation. This is the session to attend if you want to get the most out of PowerPivot visualizations. See real-world PowerPivot reports from clients in Education, Retail, Banking, and Telco, and learn a variety of visualization techniques including sparklines, slicers, and charts. You will leave this fun session armed with plenty of ideas for your next personal BI project. Oh, and watch out for flying Koalas.

SessionID: 14827

Better Together: Merge, Partitioning, ColumnStore

Back to calendar

Event Date: 19-04-2012 - Session time: 00:00:00 - Track: Everything SQL

Speaker: Greg Low

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.

SessionID: 19725

SQL to the Core

Back to calendar

Event Date: 19-04-2012 - Session time: 00:00:00 - Track: Everything SQL

Speaker: Martin Cairney

Title: SQL to the Core

Abstract:

SQL Server 2012 is fully supported on Windows Server Core - a minimal installation of Windows Server 2008 that removes the services and features that are not absolutely essential for running core network services.This session will demonstrate the installation of SQL Server 2012 on Windows Core and identify some of the pros and cons arising from the use of Server Core.

SessionID: 21517

Database Consolidation with HP’s DBCA

Back to calendar

Event Date: 19-04-2012 - Session time: 00:00:00 - Track: Everything SQL

Speaker: Raja N

Title: Database Consolidation with HP’s DBCA

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: 23415

Visualising your data with PivotViewer

Back to calendar

Event Date: 19-04-2012 - Session time: 00:00:00 - Track: Everything SQL

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: 27661

Keeping the light's on with SQL 2012 Always On

Back to calendar

Event Date: 19-04-2012 - Session time: 00:00:00 - Track: Everything SQL

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.