Nr: 134
SQLSaturday #134 - Johannesburg 2012
SessionID: 11607
SQL Server Internals: It's What's for Dinner!
Event Date: 05-05-2012 - Session time: 00:00:00 - Track: Virtual/remote
Speaker: Christina Leo
Title: SQL Server Internals: It's What's for Dinner!
Abstract:
Ever wondered what happens under the hood when you query your SQL Server database? Well, it’s somewhat like asking for a special meal for dinner. During this session, I will use a cooking analogy to describe the life cycle of a query and the journey it takes through SQL Server’s working parts. By comparing the concepts of SQL Internals to a familiar idea, you will have a clear understanding of the underlying processes involved in returning data from a SELECT query. Once we’ve established a frame of reference for a simple read operation, we’ll look at an UPDATE statement and consider the additional factors associated with a write operation. By session's end you should have a clear overview of what happens when a query hits your server.
SessionID: 12424
Layered partitioning in a Data Warehouse
Event Date: 05-05-2012 - Session time: 00:00:00 - Track: Track 1
Speaker: David Peter Hansen
Title: Layered partitioning in a Data Warehouse
Abstract:
SessionID: 14365
Bad plan! Sit!
Event Date: 05-05-2012 - Session time: 00:00:00 - Track: Track 2
Speaker: Gail Shaw
Title: Bad plan! Sit!
Abstract:
In this session we’ll look at some things that make a plan ‘bad’, how you might detect such plans and various methods of fixing the problem, both immediately and long-term.
SessionID: 15525
Data has "R" value
Event Date: 05-05-2012 - Session time: 00:00:00 - Track: Track 2
Speaker: Jacques Mostert
Title: Data has "R" value
Abstract:
Many companies take data for granted, and see it as a liability instead of an asset. In this session we will discuss some of the elements of how you can start to measure the “cost” of your data and if that data was lost what would it cost the company to recover. Your companies data must be a measurable asset.
SessionID: 17604
Powershell for the DBA
Event Date: 05-05-2012 - Session time: 00:00:00 - Track: Track 2
Speaker: Jody Roberts
Title: Powershell for the DBA
Abstract:
SessionID: 19300
Building and Implementing SQL 2012 Data Warehouse
Event Date: 05-05-2012 - Session time: 00:00:00 - Track: Track 1
Speaker: Luis de Sousa
Title: Building and Implementing SQL 2012 Data Warehouse
Abstract:
An overview of building a Data Warehouse using SQL 2012 SSIS (SQL Server Integration Services), DQS (Data Quality Services) and MDS (Master Data Services)
SessionID: 19342
The new package deployment model in SQL Server 201
Event Date: 05-05-2012 - Session time: 00:00:00 - Track: Track 1
Speaker: Michael Johnson
Title: The new package deployment model in SQL Server 201
Abstract:
SQL server 2012 brings many new features to integration services, the biggest of which has to be the new package deployment model. In this session we will look at how BI developers can use SSDT to develop data integration packages using many of the new features.
SessionID: 20113
PowerPivot with NASA data
Event Date: 05-05-2012 - Session time: 00:00:00 - Track: Track 1
Speaker: Mark Stacey
Title: PowerPivot with NASA data
Abstract:
Using DAX, you will see how to create time-intelligence driven visualisations, and then dive into the new enhancements for the date table, relationshios, perspectives and KPIs.
As an added bonus, you will see how to pull the model into Visual Studio, decorate it with new attributes, and show the visualisations in other tools such as Performance Point and Crescent (PowerView)
SessionID: 21326
Extended Events – New Age of Profiling
Event Date: 05-05-2012 - Session time: 00:00:00 - Track: Virtual/remote
Speaker: Neil Hambly
Title: Extended Events – New Age of Profiling
Abstract:
Extended Events is the replacement for profiler in many respects, and will be the choice of capturing data from within SQL Server now and in future editions, so we need to understand the differences it has to profiler "old guard" and why we should be using this new feature for this purposeI'll take you on a Guided tour of the key aspects, and show you simply how in just minutes you can up and running and capturing data using this new method and how to analyze it effectivelyFollow me to the "new age" of understanding your systems activity
SessionID: 25156
SSIS Enhanced Threading Framework
Event Date: 05-05-2012 - Session time: 00:00:00 - Track: Virtual/remote
Speaker: Josef Richberg
Title: SSIS Enhanced Threading Framework
Abstract:
How is it possible to aggregate 12,000,000 records of sales data in a short time window? In this presentation you will learn the techniques used to make this possible. These include workload distribution, pipeline elimination and thread management.
SessionID: 27713
Windowing Functions in SQL Server 2012
Event Date: 05-05-2012 - Session time: 00:00:00 - Track: Virtual/remote
Speaker: Wayne Sheffield
Title: Windowing Functions in SQL Server 2012
Abstract:
SQL Server 2012 brings with it nearly full ANSI compliance with the windowing functions. Come to this code filled session to find out the changes to existing windowing functions, and the new windowing functions that have been added.
SessionID: 9486
SQL Considerations for SharePoint 2010 Farms
Event Date: 05-05-2012 - Session time: 00:00:00 - Track: Track 2
Speaker: Andrew Thornton-Smith
Title: SQL Considerations for SharePoint 2010 Farms
Abstract:
SharePoint is to be hosted on your SQL farm... Now what?
In this session, we will cover some need to know for SQL administrators who are now responsible for SharePoint's DBs.
In our journey, topics we will cover will be from, Farm sizing's architecture considerations for SQL , Enterprise Search considerations for crawling public drives, followed by the myriad of SharePoint Databases and which to watch out for.
Also touch on maintenance plans and health analyser rules.
And finally what tasks in SharePoint are the heavy weights in terms of IOPS, CPU RAM.