SQL in PE 06 September 2017 sponsored by Pragmatic Works and MIcrosoft

calendar
Wed Sep 6, 09:00 - Wed Sep 6, 16:00
location
12 Bird St, Port Elizabeth Central, Port Elizabeth, 6001
This is a one day free MS Data Platform (SQL Server/SSRS/SSIS/T-SQL/SSAS/PowerBI/Azure)training event that will be held at The Club,12 Bird St, Port Elizabeth Central, Port Elizabeth, 6001 on 06 September 2017. Speakers for the event include Microsoft Data Platform MVPs Gail Shaw, Jody Roberts, Steve Simon and Niels Berglund
schedule thumbnail

Registration

Wednesday, September 06 - Thursday, August 17
Registration
schedule thumbnail

Welcome Keynote

Wednesday, September 06 - Wednesday, September 06
Welcome and Keynote by Deveraux Joubert and Jody Roberts
schedule thumbnail

Gail Shaw - Adaptive Query Plans? What’s up with that?

Wednesday, September 06 - Thursday, August 17
One of the new features announced for SQL Server 2017 is Adaptive Query Plans, query plans that can change after the query starts executing.

This session will show why this is a radical departure from the way that things have worked until now and how it can improve the performance of some query forms. We’ll look at the places where adaptive query plans work and compare the performance of queries using adaptive query plans to see just what kind of improvement it can make.
schedule thumbnail

Niels Berglund -Real World Example of Using R in SQL Server

Wednesday, September 06 - Wednesday, September 06
In this session we look at how R in SQL Server can be used in a production environment to automatically run models against data coming into SQL Server, as well as update the model with no interference from the data scientist.
schedule thumbnail

Tea/Coffee Break

Wednesday, September 06 - Wednesday, September 06
Tea/Coffee Break
schedule thumbnail

Steve Simon-SQL Server 2016: Master Data Services and Rapid Application Development

Wednesday, September 06 - Wednesday, September 06
Master Data Services can be readily be employed for Rapid Application Development. We shall be looking at important development, data security and data maintenance aspects, all based upon a recent client implementation.
schedule thumbnail

Lunch

Wednesday, September 06 - Wednesday, September 06
Lunch
schedule thumbnail

Jody Roberts- Data without Technology

Wednesday, September 06 - Wednesday, September 06
In this session we will look at what and who to take in consideration when thinking about a data strategy
schedule thumbnail

Gail Shaw - Go, Go, QueryStore!

Wednesday, September 06 - Wednesday, September 06
One of the hardest things to do in SQL is to identify the cause of a sudden degradation in performance. The DMVs don’t persist information over a restart of the instance and, unless there was already some query benchmarking (and there almost never is), answering the question of how the queries behaved last week needs a time machine. Up until now, that is. The addition of the QueryStore to SQL Server 2016 makes identifying and resolving performance regressions a breeze. In this session we’ll take a look at what the QueryStore is and how it works, before diving into a scenario where overall performance suddenly degraded, and we’ll see why QueryStore is the best new feature in SQL Server 2016, bar none.
schedule thumbnail

Niels Berglund -The Definitive Guide to SQL Server Error Handling

Wednesday, September 06 - Wednesday, September 06
SQL Server error handling is NOT easy. There are so many ways you can be tripped up! In this session we will look at where you can go wrong, as well as what to do and not to do. Among other things we will look at why XACT_ABORT can be the devils work!
schedule thumbnail

Closing and Prize Giving

Wednesday, September 06 - Wednesday, September 06
Closing

Additional information

Refund policy Refunds allowed (view policy)

Location

SQL in PE 06 September 2017 sponsored by Pragmatic Works and MIcrosoft
12 Bird St, Port Elizabeth Central, Port Elizabeth, 6001
12 Bird St, Port Elizabeth Central, Port Elizabeth, 6001, South Africa
Get Directions Get Directions

Twitter Feed

Organiser

How can we help?