SQLSaturday #134 - Johannesburg 2012 5/5/2012 12:00:00 AM (GMT+02:00) Harare, Pretoria SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. #sqlsat134 3012 William Nicol Drive Bryanston Johannesburg Gauteng, South Africa http://www.sqlsaturday.com/images/sqlsaturday_gb_icon.png http://www.sqlsaturday.com/images/sqlsaturday_gb_image.png Conference Information general True 1 default Maps maps False 2 default Schedule of Events schedule True 3 default Sponsors List sponsorslist True 4 default Twitter twitter True 5 default Todo List todo False 6 default My Schedule myschedule True 7 default Feedback feedback False 8 default Key Events keyevents False 9 default Share share True 10 default 7890 SQLSatruday 134 Track 1 Auditorum 1 5/5/2012 11:15:00 AM 5/5/2012 11:45:00 AM 7890 SQLSatruday 134 Track 1 Auditorum 1 5/5/2012 3:00:00 PM 5/5/2012 3:30:00 PM 7890 SQLSatruday 134 Track 2 Auditorium 2 5/5/2012 11:15:00 AM 5/5/2012 11:45:00 AM 7890 SQLSatruday 134 Track 2 Auditorium 2 5/5/2012 3:00:00 PM 5/5/2012 3:30:00 PM 7890 SQLSatruday 134 Virtual/remote Call centre 5/5/2012 11:15:00 AM 5/5/2012 11:45:00 AM 7890 SQLSatruday 134 Virtual/remote Call centre 5/5/2012 3:00:00 PM 5/5/2012 3:30:00 PM 7891 SQLSaturday 134 Virtual/remote Call centre 5/5/2012 12:45:00 PM 5/5/2012 2:00:00 PM 7891 SQLSaturday 134 Track 2 Auditorium 2 5/5/2012 12:45:00 PM 5/5/2012 2:00:00 PM 7891 SQLSaturday 134 Track 1 Auditorum 1 5/5/2012 12:45:00 PM 5/5/2012 2:00:00 PM 7896 Jody Roberts Track 2 Auditorium 2 This session will provide you with the knowledge to effectivelly perform DBA functions with powershell 5/5/2012 11:45:00 AM 5/5/2012 12:45:00 PM 7902 Wayne Sheffield Virtual/remote Call centre 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. 5/5/2012 11:45:00 AM 5/5/2012 12:45:00 PM 7905 Mark Stacey Track 1 Auditorum 1 Power Pivot is an amazing tool for mashing up data from a variety of sources ~ in this session, we will combine data from NASA, OpenGOV, and other publicly available sources, as well as from a prebuilt cube, to show the power of user driven analysis, and visualisation in Excel. 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) 5/5/2012 10:15:00 AM 5/5/2012 11:15:00 AM 7935 Neil Hambly Virtual/remote Call centre 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 5/5/2012 10:15:00 AM 5/5/2012 11:15:00 AM 8006 Christina Leo Virtual/remote Call centre 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. 5/5/2012 2:00:00 PM 5/5/2012 3:00:00 PM 8008 Josef Richberg Virtual/remote Call centre 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. 5/5/2012 3:30:00 PM 5/5/2012 4:30:00 PM 8766 Luis de Sousa Track 1 Auditorum 1 An overview of building a Data Warehouse using SQL 2012 SSIS (SQL Server Integration Services), DQS (Data Quality Services) and MDS (Master Data Services) 5/5/2012 11:45:00 AM 5/5/2012 12:45:00 PM 8808 Andrew Thornton-Smith Track 2 Auditorium 2 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. 5/5/2012 10:15:00 AM 5/5/2012 11:15:00 AM 8809 David Peter Hansen Track 1 Auditorum 1 How does one load a large fact table in a Data Warehouse, when the source system can deliver any chunk of the data at any given time? This session will show how to handle this by using layered partitioning. We will walk through table partitioning, partitioned views, and layered partitioning, as well as go through the management and performance benefits (and challenges) partitioning gives us. 5/5/2012 3:30:00 PM 5/5/2012 4:30:00 PM 8986 Frikkie Bosche Track 1 Auditorum 1 Opening keynote 5/5/2012 9:00:00 AM 5/5/2012 10:00:00 AM 8986 Frikkie Bosche Track 2 Auditorium 2 Opening keynote 5/5/2012 9:00:00 AM 5/5/2012 10:00:00 AM 8986 Frikkie Bosche Virtual/remote Call centre Opening keynote 5/5/2012 9:00:00 AM 5/5/2012 10:00:00 AM 8988 Michael Johnson Track 1 Auditorum 1 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. 5/5/2012 2:00:00 PM 5/5/2012 3:00:00 PM 9034 Jacques Mostert Track 2 Auditorium 2 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. 5/5/2012 3:30:00 PM 5/5/2012 4:30:00 PM 9447 Gail Shaw Track 2 Auditorium 2 Bad execution plans are the bane of database performance everywhere they crop up. But what is a bad execution plan? How do you identify one in your system and, once identified how do you go about fixing it? 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. 5/5/2012 2:00:00 PM 5/5/2012 3:00:00 PM