FREE OPTIONS

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

Wed Sep 6, 09:00 - Wed Sep 6, 16:00

12 Bird St, Port Elizabeth Central, Port Elizabeth, 6001

ABOUT

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

SQL IN PE SCHEDULE

schedule thumbnail

Registration

Wed, 06 Sep 08:00 AM - Thu, 17 Aug 08:30 AM
Registration
schedule thumbnail

Welcome Keynote

Wed, 06 Sep 08:35 AM - Wed, 06 Sep 08:55 AM
Welcome and Keynote by Deveraux Joubert and Jody Roberts
schedule thumbnail

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

Wed, 06 Sep 09:00 AM - Thu, 17 Aug 09:50 AM
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

Wed, 06 Sep 10:00 AM - Wed, 06 Sep 10:55 AM
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

Wed, 06 Sep 10:50 AM - Wed, 06 Sep 11:10 AM
Tea/Coffee Break
schedule thumbnail

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

Wed, 06 Sep 11:10 AM - Wed, 06 Sep 12:00 PM
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

Wed, 06 Sep 12:00 PM - Wed, 06 Sep 12:55 PM
Lunch
schedule thumbnail

Jody Roberts- Data without Technology

Wed, 06 Sep 01:00 PM - Wed, 06 Sep 01:50 PM
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!

Wed, 06 Sep 02:00 PM - Wed, 06 Sep 02:50 PM
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

Wed, 06 Sep 03:00 PM - Wed, 06 Sep 03:55 PM
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

Wed, 06 Sep 04:00 PM - Wed, 06 Sep 04:30 PM
Closing

DIRECTIONS

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