| Start Time (24h) | Speaker | Track | Title |
|---|---|---|---|
| 09:00:00 | Steve Simon | BI Information Delivery | An introduction to Data Mining with SQL Server 2016 |
| 09:00:00 | Rory Bolle | Application Database Development | What is a Database? |
| 09:00:00 | Michael Johnson | Advanced Analysis Techniques | Getting started with Power BI |
| 10:15:00 | Jeanne Combrinck | Analytics and Visualization | Exploring Twitter Campaigns, Facebook and Google Analytics data in PowerBI |
| 10:15:00 | Niels Berglund | Application Database Development | A Lap Around New Developer Features in SQL Server 2017 |
| 10:15:00 | Ruben Meyer | Application Database Development | Jump Start Into SQL Development |
| 11:30:00 | Gail Shaw | Application Database Development | Adaptive Query Plans? What’s up with that? |
| 11:30:00 | Jonathan Pillay | Application Database Development | Transactions...because ACID can save you |
| 11:30:00 | Luis de Sousa | Advanced Analysis Techniques | Get started with R |
| 13:30:00 | Sean Cremer | Application Database Development | Introduction to Database Design |
| 13:30:00 | Niels Berglund | Advanced Analysis Techniques | Real World Example of Using R in SQL Server |
| 13:30:00 | James McGillivray | Information Delivery | Shedding some light on Windowing Functions |
| 14:45:00 | Steve Simon | Information Delivery | Efficient and Effective coding of Stored Procedures |
| 14:45:00 | Clinton van Blommestein | Application Database Development | Docker => Containers => Service Fabric => SQL |
| 14:45:00 | Gail Shaw | Application Database Development | Parameter sniffing and other cases of the confused optimiser |
| 14:45:00 | Jody Roberts | Application Database Development | Data without technology |
Event Date: 16-09-2017 - Session time: 09:00:00 - Track: BI Information Delivery
In this hands on BEGINNERS presentation we shall be looking at Microsoft SQL Server’s Data Mining capabilities and we shall be discussing:
Defining what questions we want answered and how to go about this in an effective and efficient manner.
Creating the data model.
How to gather the necessary data, discussing the training and testing aspect.
Processing the model.
Extracting information from our finished model, discussing the implications of this information.
Event Date: 16-09-2017 - Session time: 09:00:00 - Track: Application Database Development
This session is designed to give a respectful nod to all the things you "Get for free" when working on a Database.
Event Date: 16-09-2017 - Session time: 09:00:00 - Track: Advanced Analysis Techniques
You will learn how PowerBI can connect to data that exists on-premise as well as in the cloud. that data can then be cleansed, transformed and then modelled to allow the discovery of powerful new insights that can then easily be shared with colleagues and clients. Finally, we will discuss the licencing model behind PowerBI which ranges from the free Desktop tool through to Premium licencing options.
Event Date: 16-09-2017 - Session time: 10:15:00 - Track: Analytics and Visualization
Event Date: 16-09-2017 - Session time: 10:15:00 - Track: Application Database Development
Event Date: 16-09-2017 - Session time: 10:15:00 - Track: Application Database Development
We will be taking you through a few key concepts along with practical examples:
Event Date: 16-09-2017 - Session time: 11:30:00 - Track: Application Database Development
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.
Event Date: 16-09-2017 - Session time: 11:30:00 - Track: Application Database Development
Let's take a dive into the details and see how we can use Transactions to code defensively and efficiently, and look at gotchas like what does a nested transaction actually mean.
Event Date: 16-09-2017 - Session time: 11:30:00 - Track: Advanced Analysis Techniques
We'll cover reading data into R, accessing R packages, writing R functions, and organizing and commenting R code.
Event Date: 16-09-2017 - Session time: 13:30:00 - Track: Application Database Development
Event Date: 16-09-2017 - Session time: 13:30:00 - Track: Advanced Analysis Techniques
Event Date: 16-09-2017 - Session time: 13:30:00 - Track: Information Delivery
Songs by The Beatles spent a combined 585 weeks on the Top 100 Billboard Chart.
In this session, we'll combine these unlikely bedfellows, by using The Beatles' chart data to gain an in-depth knowledge of Windowing Functions in T-SQL. Learn the theory behind each clause in the Windowing Functions and immediately see it applied in both an abstract, and concrete, way. Learn how Windowing Functions can help you enhance your queries, and solve complex problems quickly and easily. From running totals, to lag and lead queries, Windowing Functions will help you deliver high quality information in no time. Once you've seen the power of these functions, you'll wonder how you ever lived without them. Understanding Windowing Functions may seem like a "Long and Winding Road", but "Come Together" and walk away with a skill that you'll use "Here, There and Everywhere".
Event Date: 16-09-2017 - Session time: 14:45:00 - Track: Information Delivery
In this hands-on presentation, we shall be looking at best practices with regards to creating and tuning stored procedures. We shall also be discussing parameter sniffing and other gotcha’s that affect us in our daily lives.
Event Date: 16-09-2017 - Session time: 14:45:00 - Track: Application Database Development
In this session we will look at what these various pieces of software are, what they are are good at and how work really well with SQL Server v.Next (2017) to give you exceptional availability for your data store.
Event Date: 16-09-2017 - Session time: 14:45:00 - Track: Application Database Development
But it’s not perfect, and there are query patterns that will send the optimiser for a complete loop and the query execution times through the roof.
We’re going to look at the more common of those query patterns and see exactly what it is about them that causes problems. We’ll spend some time on ways of identifying such queries in production and we’ll look at a variety of ways to write the queries so that they work with the optimiser, not against it.
Along the way you’ll learn enough about the behaviour of the optimiser to be able to identify other problematic query forms before they cause problems.
Event Date: 16-09-2017 - Session time: 14:45:00 - Track: Application Database Development