sqlsathistory

Nr: 88

Back to Main list

SQLSaturday #88 - Western Cape 2011

Start Time (24h)	Speaker	Track	Title
00:00:00	Alistair Pugin	DBA	SharePoint 2010 Insights – For the DBA
00:00:00	Jason Haddock	BI/DEV	Coffee, Sex and BI
00:00:00	Jody Roberts	DBA	The Hangover
00:00:00	Monty Swanepoel	DBA	SSIS for DBA's
00:00:00	Mark Stacey	BI/DEV	Using Excel PowerPivot
00:00:00	Mark Stacey	DBA	Introduction to Analysis Services for the DBA
00:00:00	Peter Willmot	DBA	Things that DBAs need to know about ORM
00:00:00	Rupert Nicolay	BI/DEV	SharePoint as your business-focussed BI front-end
00:00:00	Siqhamo Mashologu	BI/DEV	SQL Server Integration Services (SSIS) for a Busin
00:00:00	Steve Simon	BI/DEV	MDX
00:00:00	Stephan Lawson	DBA	SQL Server - Transaction Log Optimization
00:00:00	Stephan Lawson	BI/DEV	The SQL Stack – Configuring For High Availability
00:00:00	Theo Potgieter	DBA	SQL CLR – SQL 1, CLR 0: Now for round 2
00:00:00	Toufiq Abrahams	BI/DEV	Kimball lifecycle and Methodology

SessionID: 28595

SharePoint 2010 Insights – For the DBA

Back to calendar

Event Date: 03-09-2011 - Session time: 00:00:00 - Track: DBA

Speaker: Alistair Pugin

Title: SharePoint 2010 Insights – For the DBA

Abstract:

SharePoint 2010 Insights provide users with various mechanisms of accessing and manipulating business information in the organisation. The biggest issue facing organisations is knowing what is available inside SharePoint and how to effectively utilize the BI toolset.

SessionID: 30512

Coffee, Sex and BI

Back to calendar

Event Date: 03-09-2011 - Session time: 00:00:00 - Track: BI/DEV

Speaker: Jason Haddock

Title: Coffee, Sex and BI

Abstract:

Coffee, Sex and BI: Creating a compelling user experience.

SessionID: 30892

The Hangover

Back to calendar

Event Date: 03-09-2011 - Session time: 00:00:00 - Track: DBA

Speaker: Jody Roberts

Title: The Hangover

Abstract:

Recovering SQL Servers

SessionID: 31968

SSIS for DBA's

Back to calendar

Event Date: 03-09-2011 - Session time: 00:00:00 - Track: DBA

Speaker: Monty Swanepoel

Title: SSIS for DBA's

Abstract:

SSIS for DBA's

SessionID: 32024

Using Excel PowerPivot

Back to calendar

Event Date: 03-09-2011 - Session time: 00:00:00 - Track: BI/DEV

Speaker: Mark Stacey

Title: Using Excel PowerPivot

Abstract:

"Using Excel PowerPivot to extract, transform and load Statistics SA data" In this session, Mark will extract data from the Statistics SA , transform it into a clean and usable format using Excel, and load it into a PowerPivot model

SessionID: 32025

Introduction to Analysis Services for the DBA

Back to calendar

Event Date: 03-09-2011 - Session time: 00:00:00 - Track: DBA

Speaker: Mark Stacey

Title: Introduction to Analysis Services for the DBA

Abstract:

Introduction to Analysis Services for the DBA

SessionID: 32359

Things that DBAs need to know about ORM

Back to calendar

Event Date: 03-09-2011 - Session time: 00:00:00 - Track: DBA

Speaker: Peter Willmot

Title: Things that DBAs need to know about ORM

Abstract:

Things that DBAs need to know about ORM

SessionID: 32540

SharePoint as your business-focussed BI front-end

Back to calendar

Event Date: 03-09-2011 - Session time: 00:00:00 - Track: BI/DEV

Speaker: Rupert Nicolay

Title: SharePoint as your business-focussed BI front-end

Abstract:

SharePoint as your business-focussed BI front-end

SessionID: 32923

SQL Server Integration Services (SSIS) for a Busin

Back to calendar

Event Date: 03-09-2011 - Session time: 00:00:00 - Track: BI/DEV

Speaker: Siqhamo Mashologu

Title: SQL Server Integration Services (SSIS) for a Busin

Abstract:

SQL Server Integration Services (SSIS) for a Business Intelligence Platform

SessionID: 33147

MDX

Back to calendar

Event Date: 03-09-2011 - Session time: 00:00:00 - Track: BI/DEV

Speaker: Steve Simon

Title: MDX

Abstract:

The dirty dozen, 12 ways to write poorly performing MDX queries

SessionID: 33198

SQL Server - Transaction Log Optimization

Back to calendar

Event Date: 03-09-2011 - Session time: 00:00:00 - Track: DBA

Speaker: Stephan Lawson

Title: SQL Server - Transaction Log Optimization

Abstract:

The session covers a brief overlook on the transaction log and possible performance bottlenecks when the Log is not properly taken into consideration when designing a database solution.

SessionID: 33199

The SQL Stack – Configuring For High Availability

Back to calendar

Event Date: 03-09-2011 - Session time: 00:00:00 - Track: BI/DEV

Speaker: Stephan Lawson

Title: The SQL Stack – Configuring For High Availability

Abstract:

The SQL Stack – Configuring For High Availability The SQL Stack – Configuring For High Availability

SessionID: 33376

SQL CLR – SQL 1, CLR 0: Now for round 2

Back to calendar

Event Date: 03-09-2011 - Session time: 00:00:00 - Track: DBA

Speaker: Theo Potgieter

Title: SQL CLR – SQL 1, CLR 0: Now for round 2

Abstract:

Yes, the SQL database engine is faster at dataset operations than CLR.

Yes, the SQL database engine is even faster if you let say, a wild monster loose on it (Awed and heaps and heaps of respect).

So what can we us this SQL CLR thing for? Well! Let us put it to work and make it crunch up some stuff and let me show you what SQL CLR can do for you!

SessionID: 34887

Kimball lifecycle and Methodology

Back to calendar

Event Date: 03-09-2011 - Session time: 00:00:00 - Track: BI/DEV

Speaker: Toufiq Abrahams

Title: Kimball lifecycle and Methodology

Abstract:

Kimball lifecycle and Methodology

This site is open source. Improve this page.