Following SQL Saturday we were happy with the number of people who attended this month’s regular meeting. Attendance has traditionally been lower than usual but we had over 20 attendees. The Meeting began with Carel demonstrating some of the cool new functionality that SQL windowing functions allow, including a cool de-dupe trick that the audience was very impressed by. This was followed by Michael Johnson who dug out an often forgotten feature in SQL server, SQL spatial. After the presentation we had an opportunity to talk to the attendees about what they would like to see out of the user group, below are some of the common themes
- More BI Focused topics
- More beginner\foundational talks
- Earlier time slot
- More communication
- More “soft skill” talks
- Specific technologies talks.
We will try to incorporate all this feedback into the user group meetings and perhaps offer a revised format for the next year.
Due to the success of last month’s user group meeting we have decided to change format. Instead of having two full presentation we will move to having one full presentation complimented by two short 10 minute presentations. If you are interested in presenting any of these please let us know and we will schedule you in. This month’s topics are:
Short talk 1: Alain Dormehl – SQL 2014 Resource Governor I/O
Short Talk 2: Greg Nicol – Getting started with BIML using BIDS Helper
Full presentation: Anish Sana – Performance tuning your tabular model
To register for this event, click here
We also have seats available for the SQL Saturday Pre-con to be held on the 29th August
SQLSaturday Precon- Understanding SSIS internals and performance tuning with David Hansen MCM
For more details
July was a great session with 7 users presenting lightning talks on a wide range of topics. Below you can find the slide decks used during the presentations.
This month is lightning talk Month
What is a lightning talk? : A lightning talk is a short 10 minute presentation in which the speaker only makes use of slides and no code demonstrations. There are 10 slots covering a wide range of topics from database engine fundamentals through to data base architecture.
Slot 1: Gail Shaw – SQL Server recovery models in high speed
Slot 2: Minette Steynburg – 5 SQL tips you may not know about.
Slot 3: Sean Pearce – Database compression with a twist
Slot 4: Gareth Henry – Inmon Vs Kimball in 10 minutes
Slot 5: Michael Johnson – What happened to my B-tree, inside the column store index
Slot 6: Alain Dormehl - Under-appreciated BCP vs Bulk Insert
Slot 7: Sifiso Ndlovu – 5 Reasons You Should Handle SQL Server Exceptions Using THROW Instead of RAISERROR
Slot 8: Luis de Sousa – TBA
Slot 9: Sandesh Nagaraj – Meet the Data Warehouse Administrator (DWA)
Slot 10: Howard Diesel – SQL skills development
May was our 4th user group of the year attendance was 28 with a few new faces. Presenting this month was Gail Shaw[T | B | L] founder of the South African SQL server user group (as we were back then) as well as MVP and MCM. Gail gave a great talk about indexing and why we would want to index is different ways along with the caveat the over index is something to be avoided. I’m sure many of use returned to work the next day to see what we were doing wrong and maybe getting the opportunity to fix it up the right way.
Also discussed was the upcoming SQL Saturday #327 I urge those of you who have not registered and do want to come to this event to go and register, possible as a volunteer or speaker too.
Next month our speakers will be Frikkie Venter and Anish Sana invites will be distributed as soon as I have confirmation on their topics.
We have officially been given the go ahead to host our next SQL Saturday. The event will be held on the 30th August 2014 at the Microsoft offices in Bryanston. To ensure that you get a seat Make sure to register early. To register go to our SQL Saturday site at http://www.sqlsaturday.com/327/eventhome.aspx
For those of you who would like to speak the call for speakers is also open until 1 July 2014. Please make sure to get your submission in early
The 4th of April 2014 was the third user group of the year and attended by 31 members. Our first presentation was by Jacques Mostert [T|B|L] who gave us a very entertaining presentation on some of the abuses databases experience at the hands of the ill informed in his presentation “Performance tuning myths and Legends”. Out next presentation was given by Henrico Bekker [T|L] who answered the call by one of our audience members the month before for a presentation on DQS. During this session Henrico showed us how to quickly get a DQL Model up and running then extend that through the use of the SSIS.
Out next meeting will be on the 13th of May, this will be a full session by Gail Shaw [T|B|L] where she will walk us through the different Index types that we have in SQL and when we should or should not be using them.
Below you can find presentation material provided by the speakers
- Performance tuning myths and legends
- DQS: is my data any good ( No material available)