Welcome to SQLSaturday #327
SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. This event will be held 29th and 30th Aug 2014 at 3012 William Nicol Dr, Sandton, Johannesburg, Gauteng, 2007, South Africa. Admittance to this event is free, all costs are covered by donations and sponsorships. Please register soon as seating is limited, and let friends and colleagues know about the event.
SQL Saturday #327 is run by the Johannesburg SQL User Group. This user
group also runs Monthly meetings, to find our more about attending these events
you can check out out website
Day 1: 29 August 2014
This year we are excited to be presenting put first ever precon by a renowned speaker and Microsoft certified Master.
Understanding SSIS internals and performance tuning with David Hansen MCM
You have worked with SQL Server Integration Services (SSIS) for a few years, but more often than not, you see performance problems with your packages. Some packages are running slow, while others are taking up more memory and CPU than before. But why are they slow or taking up a lot of resources? What is actually going on behind the scene? Join this full-day session to find out.
The first part will cover the internals of SSIS. Starting with an overview, we will move into the details of the control flow engine and the data flow engine. At the end of the internals section, you will have a deep understanding of the strengths and weaknesses of SSIS and what is the best way to design your packages.
The second part will cover how we can use the knowledge about the internals of SSIS to gain better performance. This part will show practical examples of common performance problems, and how these can be solved. Furthermore we will look at how designing and tuning your data flows can increase performance significantly.
Day 2: 30 August 2014
Free training event with a range of well-known speakers, MVPs and local speakers. Please see the schedule for more details.
Admittance to this event is free, all costs are covered by donations and sponsorships.
Please register soon as seating is limited, and let friends and colleagues know about the event