Monthly Archives: January 2015

Training Day sessions announced for SQL Saturday 2015

It’s here, we are pleased to announce the sessions for our Training Day are ready for you to select from, we have sessions on SSIS, Performance Tuning, DBA skills, BI techniques and more. For all the details you really will have to see for yourself.

Don’t put this to one side, our Early Bird rate of £150 is only available on bookings made in January. Yep, it’s only £150 for a full day of world class SQL Server training so take a look at the sessions and book your place there as soon as you can. Of course, if you are a member of a UK SQL Server user group then you will get a discount, please contact your user group leader for the code to apply when you book.

If you need help, contact us for more information

January meeting – Friday 16th January 2015

This month the user group is on a different day!

Hi Everyone,

Firstly let me wish you all a happy new year!

In January we will be running the UG on Friday 16th January (at the Jury’s Inn In Exeter – starting at 17:30).

SQL Skills session selection 2015
We have been very kindly offered a chance to have a couple of remote sessions for SQL South West members from SQL Skills ( during 2015, so here are the options so that we can try to get the most popular content to you.

The session date will depend on which session is selected and the availability of that speaker during the year. We’ll collate the results of your votes during January and then work with SQL Skills to schedule the sessions as close as possible to our normal third Thursday of a month.

You can select your favourite sessions using the form in this link- here are the options.

January sessions
We are starting the UG off in 2015 in a big way, with two speakers focusing on great BI topics.

Session 1
Our first session will be from Prathy Kamasani ( T ), a BI Consultant with DataSciences Consulting. Prathy will be presenting on “Loading Dimensions with SSIS

Abstract: There are many different ways of using SSIS to load data into a Data Warehouse. To populate a simple star schema it is quite easy to use an SCD transformation task  in SSIS. But when you want to handle advanced Data Warehouse requirements such as Type 3 SCDs, auditing execution details, error logs and fast performance, the SCD transformation makes it difficult. In this session I will present a pattern which can handle these in a scalable , efficient way in SSIS.I will also show how this pattern will benefit us when we use the Kimball audit model ,SSISDB and the SSIS catalog in SQL Server 2012.

Session 2
Then for the second half we have a session from Chris Webb ( B | T ). Chris is a seasoned presented, author and SQL Server MVP. Chris will be presenting on “Everything you wanted to know about Power BI but were too afraid to ask“.

Abstract: You’ve probably seen a lot of Power BI demos and been wowed by 3D maps, cool dashboards and tales of working with millions of rows of data in Excel. But do you actually know what Power BI is? Where does Office 365 fit in? Does your data have to be stored in the cloud? Which versions of Excel do you need? How does it compare to corporate BI tools like Reporting Services and Analysis Services? This session will answer all of these questions and more, and help you understand whether Power BI is right for you.

SQL Saturday Exeter 2015
We are close to announcing more details about sessions. Make sure you attend the January UG to receive your UG discount code for the Friday pre-conference sessions.

New year’s resolution to start presenting? Or just have something you want to talk about? Let us know!

See you all on Friday (Not Thursday! :S)
All the best