SQLSaturday #88 - Western Cape 2011 9/3/2011 12:00:00 AM SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. #sqlsat88 Western Cape , 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 1495 Saratoga Software Gold Sponsor http://www.Saratoga.co.za http://www.saratoga.co.za/images/nav_placeholder.jpg 60 170 1524 Red Gate Software Silver Sponsor http://www.red-gate.com http://www.red-gate.com/assets/images/common/logo.png 60 170 1526 Kalahari.com Silver Sponsor http://www.kalahari.com http://mail.google.com/mail/?ui=2ik=a9be65b45dview=attth=131d363aeebeb0c9attid=0.1disp=inlinerealattid=f_grf2qx6i0zw 60 170 1529 Pragmaticworks Silver Sponsor http://pragmaticworks.com http://pragmaticworks.com/images/PW_header_logo.jpg 60 170 1531 Osmosis Consulting Silver Sponsor http://www.osmosisconsulting.co.za http://www.osmosisconsulting.co.za/images/logo.gif 60 170 1532 iSolve Silver Sponsor http://www.isolve.co.za http://www.isolve.co.za/PublishingImages/TopBanner.png 60 170 1533 IT Business Silver Sponsor http://www.itbusiness.co.za http://www.itbusiness.co.za/images/itb_logo.png 60 170 1346 Idera Bronze Sponsor http://www.idera.com http://www.idera.com/images/promos/idera_with-tag.jpg 60 170 1527 Microsoft Bronze Sponsor http://www.microsoft.com/en/za/default.aspx http://www.microsoft.com/en-us/homepage/shared/templates/components/hpFooter/images/microsoft.png 60 170 1528 Morgan Kaufmann Publishers Bronze Sponsor https://www.focalpress.com http://www.focalpress.com/images/fplogo.png 60 170 4759 Stephan Lawson DBA Room 1 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. 9/3/2011 11:00:00 AM 9/3/2011 12:00:00 PM 5186 Steve Simon BI/DEV Room 2 The dirty dozen, 12 ways to write poorly performing MDX queries 9/3/2011 3:15:00 PM 9/3/2011 4:00:00 PM 5533 Theo Potgieter DBA Room 1 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! 9/3/2011 2:00:00 PM 9/3/2011 3:00:00 PM 5633 Peter Willmot DBA Room 1 Things that DBAs need to know about ORM 9/3/2011 9:00:00 AM 9/3/2011 10:00:00 AM 5635 Rupert Nicolay BI/DEV Room 2 SharePoint as your business-focussed BI front-end 9/3/2011 1:00:00 PM 9/3/2011 2:00:00 PM 5637 Mark Stacey BI/DEV Room 2 '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 9/3/2011 11:00:00 AM 9/3/2011 12:00:00 PM 5638 Monty Swanepoel DBA Room 1 SSIS for DBA's 9/3/2011 3:15:00 PM 9/3/2011 4:00:00 PM 5639 Jody Roberts DBA Room 1 Recovering SQL Servers 9/3/2011 4:00:00 PM 9/3/2011 5:00:00 PM 5640 Toufiq Abrahams BI/DEV Room 2 Kimball lifecycle and Methodology 9/3/2011 10:15:00 AM 9/3/2011 11:00:00 AM 5641 Siqhamo Mashologu BI/DEV Room 2 SQL Server Integration Services (SSIS) for a Business Intelligence Platform 9/3/2011 4:00:00 PM 9/3/2011 5:00:00 PM 5643 Alistair Pugin DBA Room 1 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. 9/3/2011 1:00:00 PM 9/3/2011 2:00:00 PM 5644 Jason Haddock DBA Room 1 Coffee, Sex and BI: Creating a compelling user experience. 9/3/2011 8:45:00 AM 9/3/2011 9:00:00 AM 5644 Jason Haddock BI/DEV Room 2 Coffee, Sex and BI: Creating a compelling user experience. 9/3/2011 8:45:00 AM 9/3/2011 9:00:00 AM 5644 Jason Haddock BI/DEV Room 2 Coffee, Sex and BI: Creating a compelling user experience. 9/3/2011 9:00:00 AM 9/3/2011 10:00:00 AM 5645 Mark Stacey DBA Room 1 Introduction to Analysis Services for the DBA 9/3/2011 10:15:00 AM 9/3/2011 11:00:00 AM 5646 Lunch Lunch DBA Room 1 Lunch 9/3/2011 12:00:00 PM 9/3/2011 1:00:00 PM 5646 Lunch Lunch BI/DEV Room 2 Lunch 9/3/2011 12:00:00 PM 9/3/2011 1:00:00 PM 5647 Break Break BI/DEV Room 2 Break 9/3/2011 10:00:00 AM 9/3/2011 10:15:00 AM 5647 Break Break BI/DEV Room 2 Break 9/3/2011 3:00:00 PM 9/3/2011 3:15:00 PM 5647 Break Break DBA Room 1 Break 9/3/2011 10:00:00 AM 9/3/2011 10:15:00 AM 5647 Break Break DBA Room 1 Break 9/3/2011 3:00:00 PM 9/3/2011 3:15:00 PM 5648 Registration Registration DBA Room 1 Registration 9/3/2011 8:00:00 AM 9/3/2011 8:45:00 AM 5648 Registration Registration BI/DEV Room 2 Registration 9/3/2011 8:00:00 AM 9/3/2011 8:45:00 AM 5649 Stehan Lawson BI/DEV Room 2 The SQL Stack – Configuring For High Availability The SQL Stack – Configuring For High Availability 9/3/2011 2:00:00 PM 9/3/2011 3:00:00 PM