I am very happy and super excited to announce that I will be doing a full day pre-con the day before SQLSaturday #327 Johannesburg on 29 August, as well as SQLSaturday #301 Cape Town on 5 September 2014. Having lived in South Africa, I have had the pleasure to visit Johannesburg, Cape Town and Stellenbosch on a number of occasions. I must say, I can’t wait to go back!
Two years ago, I started speaking at SQL Server conferences, when Jody Roberts (twitter) pinged me on Twitter and asked if I didn’t want to give a talk at SQLSaturday #134 Johannesburg. I gave my first talk on Layered Partitioning, and it was such an awesome experience that I decided to go all in; which has resulted in three big conferences (and quite a few smaller ones) this year.
So, this year I am going back to South Africa where it all started to give a full day pre-con on Understanding SSIS internals and performance tuning.
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.
If you are in Johannesburg or Cape Town (or feel like visiting the beautiful South Africa), I would be happy to see you at my pre-con.
I am very honored and happy to announce that I will be speaking at three major SQL Server conferences this year.
- SQLBits XII, 17-19 July, UK: I spoke last year for the first time at SQLBits, and am so happy they have invited me back. I will be giving two talks; one on SSIS internals and performance on Friday and one on Integration Services (SSIS) for the DBA on Saturday.
- SQL Server Days 2014, 30 September – 1 October, Belgium: First time at SQL Server Days, and first time in Belgium. Can’t wait! I will give my SSIS internals and performance talk on day 2.
- PASS Summit 2014, 4-7 November, USA: This is the largest SQL Server conference there is, and I can’t wait to meet everyone again. It is like a big family reunion, and I get to spend 75 minutes talking about Integration Services (SSIS) for the DBA.
Update: I will also be giving my SSIS internals and performance talk at SQLSaturday #310 Dublin, and am looking forward to
battling beating Bob Duffy (Blog | Twitter) in Giant Jenga and a 5 minute “call my SQL bluff” lightening talk.