SQL User Group meeting – 9 December 2014

Posted on Updated on

SQL User Group 2014 year end

As this is our final event of the year we want to make it a bit of a fun one. There will be no technical presentations this time, instead we will have two event where the audience can take part and win prizes.

# I also have a number of Pluralsight subscriptions that we will be giving to anyone who brings a first timer along with them.

SQL Panel

This month we will be hosting our first ever panel discussion. During this discussion attendees will have the opportunity to ask our panel of speakers a variety of questions ranging from SQL specific questions to general thought on where they think the data world is going. Our panel of speaker’s consists of:

If you have any questions that you would lie to ask please send them to me at this address or ask then from the floor on the night.

SQL Quiz

Our audience will also have to opportunity to take part. We will also be hosting a SQL Trivia Quiz, the quiz will consist of a number of general knowledge SQL questions. The top 5 participants will each get to pick a prize from the following items

  • Microsoft arc mouse
  • Signed SQL Books
  • Microsoft azure branded Kit bag
  • more

2015 Schedule

With 2014 coming to a close we will be opening the schedule to speakers in 2015. If you would like to speak or if there are any topics that you would like to hear about then let us know.

SQL User Group meeting – 14 October 2014

Posted on Updated on

Meet Microsoft South Africa’s GM Zoaid Hoosen.

Microsoft South Africa’s general manager Zoaid Hoosen is planning to host a session at the next community night to get you know you. He will have a short session and also take your questions between 18:00 and 18:20 so come by a little earlier than usual. If you would like specific questions asked send us your questions and we will forward then on to Microsoft.

Presentations.

This month Gail Shaw will be presenting her PASS session to the user group so if you are keen to see what a PASS level talk looks like make sure you are there. We will also be introducing a new “Beginners” series, this will be a short 10 minute talk where a presenter will talk about a beginner level topic to help our new attendees the opportunity to upskill themselves.

Meeting Agenda:

Short talk 1:

Jan Potgieter – Basics of SQL Server Execution Plans

Short Talk 2:

Howard Diesel – Dynamic Access Control for SSAS

Full presentation:

Gail Shaw – Guessing Games: Statistics, Heuristics, and Row Estimations

Eventbrite - SQL User Group meeting - 14 October 2014

JHB SQL User Group – September 2014

Posted on

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.

Slide from the user group meeting

JHB SQL User Group Schedule – 12 August 2014

Posted on Updated on

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

Eventbrite - SQLSaturday Precon- Understanding SSIS internals and performance tuning with David Hansen MCM

SQL User Group meeting – 08 July 2014

Posted on Updated on

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.

Participants 

Slot 1: Gail ShawSQL 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 2014 User group meeting

Posted on

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.