sqlsathistory

Nr: 138

Back to Main list

SQLSaturday #138 - Sydney 2012

Start Time (24h)	Speaker	Track	Title
00:00:00	Bhavik Merchant	Smaller room	Accelerated BI Growth with Power View PowerPivot
00:00:00	Daniel Nolan	Smaller room	Database Development Agile: Strange Bedfellows?
00:00:00	Grant Paisley	Larger room	Killer Real-World PowerPivot Examples II
00:00:00	Greg Low	Larger room	Better Together: Merge, Partitioning, ColumnStore
00:00:00	Julie Koesmarno	Smaller room	DirectQuery vs Vertipaq mode in SSAS Tabular Model
00:00:00	Peter Ward	Larger room	The Dark Art of Performance Tuning
00:00:00	Rob Farley	Larger room	Analytic T-SQL Functions in 2012
00:00:00	Rod Colledge	Larger room	BI Architecture with SQL 2012 SharePoint 2010
00:00:00	Warwick Rudd	Smaller room	Keeping the light's on with SQL 2012 Always On

SessionID: 10417

Accelerated BI Growth with Power View PowerPivot

Back to calendar

Event Date: 21-04-2012 - Session time: 00:00:00 - Track: Smaller room

Speaker: Bhavik Merchant

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.

SessionID: 12148

Database Development Agile: Strange Bedfellows?

Back to calendar

Event Date: 21-04-2012 - Session time: 00:00:00 - Track: Smaller room

Speaker: Daniel Nolan

Title: Database Development Agile: Strange Bedfellows?

Abstract:

A look at the risks and challenges faced with meeting the demands of shorter, more frequent release cycles and how this may influence tool selection and shaping of deployment processes within the enterprise. This session will include practical examples on how to leverage source control, continuous integration as well as features of T-SQL itself to help you navigate the database deployment minefield and get the wheels of your development organisation turning more smoothly.

SessionID: 14721

Killer Real-World PowerPivot Examples II

Back to calendar

Event Date: 21-04-2012 - Session time: 00:00:00 - Track: Larger room

Speaker: Grant Paisley

Title: Killer Real-World PowerPivot Examples II

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

Better Together: Merge, Partitioning, ColumnStore

Back to calendar

Event Date: 21-04-2012 - Session time: 00:00:00 - Track: Larger room

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

DirectQuery vs Vertipaq mode in SSAS Tabular Model

Back to calendar

Event Date: 21-04-2012 - Session time: 00:00:00 - Track: Smaller room

Speaker: Julie Koesmarno

Title: DirectQuery vs Vertipaq mode in SSAS Tabular Model

Abstract:

The new and flashy Tabular Model for Analysis Services has been highly pitched with the in-memory (VertiPaq) capability allowing for complex queries to run very fast. Using live demo, this session will address: Advantages and disadvantages of using in-memory cache to store and query data; Restrictions on DirectQuery tabular model; Hybrid mode utilisation; Impersonation and Partitioning differences

SessionID: 22063

The Dark Art of Performance Tuning

Back to calendar

Event Date: 21-04-2012 - Session time: 00:00:00 - Track: Larger room

Speaker: Peter Ward

Title: The Dark Art of Performance Tuning

Abstract:

Despite all of the enhancements to the instrumentation in SQL Server, many database professionals still view performance tuning as a dark art. This session will provide database administrators and developers with valuable information on SQL Server performance tuning concepts. This presentation will walk you through proven performance tuning strategies and teach you how to use SQL Server tools to identify a performance bottleneck, isolate the root cause, apply possible resolutions, and then quantify performance improvements.

SessionID: 23202

Analytic T-SQL Functions in 2012

Back to calendar

Event Date: 21-04-2012 - Session time: 00:00:00 - Track: Larger room

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

BI Architecture with SQL 2012 SharePoint 2010

Back to calendar

Event Date: 21-04-2012 - Session time: 00:00:00 - Track: Larger room

Speaker: Rod Colledge

Title: BI Architecture with SQL 2012 SharePoint 2010

Abstract:

In this session, we'll cover new BI features in SQL Server 2012 including Power View, Tabular BISM, Report Alerts and SSRS Integration with SharePoint Server 2010. We'll then focus on the importance of Self-Service BI and how it fits into an overall enterprise Business Intelligence architecture. This session will be rich with demos of all the key BI tools, and will also cover installation and configuration on both new and existing Sharepoint farms. We'll also cover securely extending BI solutions over the internet, touching on Kerberos Delegation and Threat Management Gateway (TMG). Come along and discover the awesome power of the latest release of the Microsoft BI Platform.

SessionID: 27662

Keeping the light's on with SQL 2012 Always On

Back to calendar

Event Date: 21-04-2012 - Session time: 00:00:00 - Track: Smaller room

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.

This site is open source. Improve this page.