SQLSaturday #123 - Western Cape 2012
Event Date: 03/03/2012 00:00:00
Event Location:
- Torque-IT offices 2nd Floor, Gihon Building
- Cnr Bill Bezuidenhout Sportica Avenues, Tyger Valley
- Cape Town, Western Cape, South Africa
This event has completed. All data shown below is from the historical XML public data available.
If there are any data quality issues or corrections needed, please contact the webmaster for this site or submit a pull request for the appropriate file(s).
Sessions
This is a list of sessions from the event, based on the schedule in the XML files.
Title: SQL 2012 High Availabilty
Abstract: Loooks at SQL 2012 High Availabilty
Speaker(s):
- Gary Hope
Track and Room: DBA - N/A
Title: What’s in SQL Server 2012 for the DBA?
Abstract: In this session, you’ll learn how the new SQL Server 2012 features like Always On will help you create a better high availability experience for your users and applications. Then, you’ll learn about the new table types (file table) and how you can use it to create a better content management system. Lastly, we’ll cover new indexing strategies that SQL Server 2012 now allows called Column Store indexes to potentially give your queries a 500x boost!
Speaker(s):
- Brian Knight
Track and Room: DBA - N/A
Title: BI LifeCycle
Abstract: A 3 way approach to BI
Speaker(s):
- Saratoga Software
Track and Room: BI - N/A
Title: What’s New in BI in SQL Server 2012
Abstract: In this session, you’ll go through a whirlwind tour of what’s new in one of Microsoft’s biggest releases of SQL Server in its history: SQL Server code named SQL Server 2012. You’ll learn about the upcoming Crescent feature, which allows users to build ad-hoc reports easily. You’ll also learn about the Tabular Model in SSAS and the huge enhancements to SSIS. Lastly, Brian will cover the database engine enhancements that make BI more accessible and faster.
Speaker(s):
- Brian Knight
Track and Room: BI - N/A
Title: Agile for Developers
Abstract: We will look at what Agile Software development means and then look at some examples of the benefits that our developers have seen by working in an Agile environment
Speaker(s):
- Alain King
Track and Room: DEV - N/A
Title: BI for the DBA - DeepDive
Abstract: Business Intelligence requirements create a completely different workload to a traditional SQL implementation - both in terms of the load placed upon the infrastructure, as well as the load placed upon the database engine itself.
As BI adoption grows, DBAs are going to be expected to maintain and enhance both the BI infrastructure, and make sure that the databases support the requirements adequately. In this session, Mark will dive into the tradeoffs of various architectures for a BI platform, and work through the nuances of managing SSIS, SSAS and SSRS, both in terms of administering the instances, and also cover how a BI workload differs from an OLTP workload
Speaker(s):
- Mark Stacey
Track and Room: DBA - N/A
Title: Performance Tuning SQL Server Integration Services
Abstract: In this demo-rich presentation, Brian shows you some of the common and not so common ways to tune SQL Server Integration Services (SSIS). Learn how to tune the data flow using some of the advanced SSIS options and how to avoid common SSIS mistakes. See how to measure performance and how to keep SSIS from monopolizing your server’s resourcing. Lastly, discover SQL Server 2008 and 2012 features that will make SSIS more efficient.
Speaker(s):
- Brian Knight
Track and Room: DEV - N/A
Title: TBA - Presented by Torque-IT
Abstract: TBA - Presented by Torque-IT
Speaker(s):
- Torque-IT Torque-IT
Track and Room: BI - N/A
Speakers
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
Brian Knight
Twitter: - @BrianKnight
Contact: http://www.bidn.com/people/brianknight
Brian Knight, a SQL Server MVP, MCSE, and MCDBA, is the owner and founder of Pragmatic Works. He is also the co-founder of SQLServerCentral.com, BIDN.com, and SQLShare.com. Brian runs the local SQL Server users group in Jacksonville (JSSUG), is a contributing columnist at several technical magazines, and does regular webcasts at PragmaticWorks.com. He is the author of 15 SQL Server books and a frequent speaker at conferences such as PASS Summit, SQL Connections, TechEd, and many Code Camps.
Saratoga Software
d
Brian Knight
Twitter: - @BrianKnight
Contact: http://www.bidn.com/people/brianknight
Brian Knight, a SQL Server MVP, MCSE, and MCDBA, is the owner and founder of Pragmatic Works. He is also the co-founder of SQLServerCentral.com, BIDN.com, and SQLShare.com. Brian runs the local SQL Server users group in Jacksonville (JSSUG), is a contributing columnist at several technical magazines, and does regular webcasts at PragmaticWorks.com. He is the author of 15 SQL Server books and a frequent speaker at conferences such as PASS Summit, SQL Connections, TechEd, and many Code Camps.
Torque-IT Torque-IT
Contact: http://www.torque-it.co.za/
Torque Technical Computer Training (Pty) Ltd was acquired by the JSE-listed Kelly Group Ltd during August 2008 and currently trades as a wholly owned subsidiary of the leading people solutions provider in South Africa. The Kelly Group is in the business of providing people management solutions that add value to every link in the human capital management chain.
Brian Knight
Twitter: - @BrianKnight
Contact: http://www.bidn.com/people/brianknight
Brian Knight, a SQL Server MVP, MCSE, and MCDBA, is the owner and founder of Pragmatic Works. He is also the co-founder of SQLServerCentral.com, BIDN.com, and SQLShare.com. Brian runs the local SQL Server users group in Jacksonville (JSSUG), is a contributing columnist at several technical magazines, and does regular webcasts at PragmaticWorks.com. He is the author of 15 SQL Server books and a frequent speaker at conferences such as PASS Summit, SQL Connections, TechEd, and many Code Camps.
Mark Stacey
Twitter: - @MarkGStacey
Contact: http://MarkGStacey.net
Mark Stacey founded the Aphelion Software Group, and works tirelessly to cross the business/technical boundaries in Business Intelligence, working in both SharePoint and SQL. He has published two books on BI - Sharepoint 2010 BI and Visual Intelligence and frequently speaks at both SQLSaturday and SharePoint Saturday events. Mark is one of the few Microsoft PDW trainers, and has trained in Africa, India and Europe on the PDW, as well as all over the world on other technologies
Gary Hope
Gary is a legend
Alain King
TBA
Sponsors
The following is a list of sponsors that helped fund the event: