| Start Time (24h) | Speaker | Track | Title |
|---|---|---|---|
| 09:00:00 | Steve Simon | Application Database Development | SQL Server 2016: Master Data Services and Rapid Application Development |
| 09:00:00 | Sean Cremer | Application Database Development | Introduction to Database Design |
| 09:00:00 | Denny Cherry | DBA | SQL Server Database Administration for the non-DBA |
| 09:00:00 | Michael Johnson | Analytics and Visualization | Getting started with PowerBI |
| 09:00:00 | Mladen Prajdić | Application Database Development | SQL Server and Application Security for Developers |
| 10:00:00 | Desmond Norton | Application Database Development | T-SQL Anti-Patterns |
| 10:00:00 | Jeanne Combrinck | Analytics and Visualization | Exploring Twitter Campaigns, Facebook and Google Analytics data in PowerBI |
| 10:00:00 | Jonathan Stewart | BI Platform Architecture, Development Administration | An introduction to the magical world of BIML! |
| 10:00:00 | Laerte Junior | DBA | PowerShell for SQL Server DBA - From Zero to Hero |
| 10:00:00 | Luis de Sousa | Advanced Analysis Techniques | Get started with R |
| 13:00:00 | Steve Simon | BI Platform Architecture, Development Administration | Efficient and Effective coding of Stored Procedures |
| 13:00:00 | Clinton van Blommestein | Application Database Development | Docker => Containers => Service Fabric => SQL |
| 13:00:00 | Hugo Kornelis | Application Database Development | Normalization Beyond Third Normal Form |
| 13:00:00 | Michael Johnson | Advanced Analysis Techniques | Real-time analytics with Azure Stream Analytics |
| 13:00:00 | Gail Shaw | Advanced Analysis Techniques | Why are there pirates and snakes in my SQL Server? |
| 14:00:00 | Niels Berglund | Advanced Analysis Techniques | Real World Example of Using R in SQL Server |
| 14:00:00 | Gail Shaw | Application Database Development | Adaptive Query Plans? What’s up with that? |
| 14:00:00 | James McGillivray | BI Platform Architecture, Development Administration | Who Needs Numbers? Patterns for Non-Numeric Measures in DAX |
| 14:00:00 | Nolan Schoonraad | DBA | Extended events – say goodbye SQL Profiler |
| 14:00:00 | Heinrich Smit | DBA | Running and interacting with SQL Server 2017 in Windows and Linux Containers |
| 15:00:00 | Arohan Naidoo | BI Platform Architecture, Development Administration | Zero to Pi to 10 on Cloud,Intro to Windows 10 IoT Core on a Raspberry Pi and BI using Azure IoT Hub |
| 15:00:00 | Denny Cherry | Application Database Development | How to Maintain the Same Level of utilities in Cloud Deployments |
| 15:00:00 | Mladen Prajdić | Application Database Development | Optimizing Database Access And Diving Into .Net SqlClient |
| 15:00:00 | Deji Akomolafe | Cloud Services | Successfully Virtualizing SQL Server on vSphere - Straight from the Source |
| 15:00:00 | Cornelus Dannhauser | BI Platform Architecture, Development Administration | Data Platform - Azure Data Warehouse, Fast Track Reference Architecture Analytics Platform System |
| 15:00:00 | Adnan Hendricks | Cloud Services | Working with Azure Data, Services and Azure SQL for your Applications |
Event Date: 09-09-2017 - Session time: 09:00:00 - Track: Application Database Development
Event Date: 09-09-2017 - Session time: 09:00:00 - Track: Application Database Development
This session will go through the fundamentals of database design. Topics such as normalization, Understanding Data Relationships as well as the Language of Data Modeling and Design will be discussed. The Database Design Sequence Phases of Conceptual, Logical and Physical will be introduced as well.
Event Date: 09-09-2017 - Session time: 09:00:00 - Track: DBA
While this session won't teach you everything you need to know, it will give you some insights into the SQL Server database engine and give you the ability to better know what to look for.
Event Date: 09-09-2017 - Session time: 09:00:00 - Track: Analytics and Visualization
In this session, you will see how easily great looking reports can be created using multiple data sources and easily shared within your organisation. We will also discuss licensing options available ranging from free through to Premium licencing.
Event Date: 09-09-2017 - Session time: 09:00:00 - Track: Application Database Development
In this session we'll look at a few attack vectors that can be used against your company, and what you as a developer can and should do to protect against them. It will involve a good mix of security conscious SQL Server and application development, because you care about your work and nobody messes with you.
Event Date: 09-09-2017 - Session time: 10:00:00 - Track: Application Database Development
This session will cover a few T-SQL anti-patterns, explaining the problem being solved, and better alternatives.
Event Date: 09-09-2017 - Session time: 10:00:00 - Track: Analytics and Visualization
Event Date: 09-09-2017 - Session time: 10:00:00 - Track: BI Platform Architecture, Development Administration
Event Date: 09-09-2017 - Session time: 10:00:00 - Track: DBA
How would you improve a PowerShell script in order to make it more versatile? How can you ensure that it is adaptable to the many similar tasks for which you are likely to need a script? In a nutshell, you turn into functions those common component tasks that you’ve written as scripts, and from these simple functions develop advanced functions. In doing so, you make the leap from PowerShell Zero to PowerShell Hero. In this session , I’ll walk you through a practical example and demonstrate the steps along the way.
Event Date: 09-09-2017 - Session time: 10:00: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: 09-09-2017 - Session time: 13:00:00 - Track: BI Platform Architecture, Development Administration
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: 09-09-2017 - Session time: 13:00: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: 09-09-2017 - Session time: 13:00:00 - Track: Application Database Development
Do you believe the people who claim that these statements are myths? Or do you prefer to form your own opinion? If you take database design seriously, you cannot afford to miss this session. You will get a clear and easy to understand overview of all the higher Normal Forms: what they are, how to check if they are met, and what consequences their violations can have. This will arm you with the knowledge to reject the myths about higher Normal Forms. But, more important: it will make you a better designer!
Event Date: 09-09-2017 - Session time: 13:00:00 - Track: Advanced Analysis Techniques
Event Date: 09-09-2017 - Session time: 13:00:00 - Track: Advanced Analysis Techniques
In this session, we’ll look at why these languages are now available in SQL Server and the capabilities that they offer. We’ll also try and answer some questions as to what the whole ‘data science’ thing is in the first place, and why you should be interested in it.
Event Date: 09-09-2017 - Session time: 14:00:00 - Track: Advanced Analysis Techniques
Event Date: 09-09-2017 - Session time: 14:00: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: 09-09-2017 - Session time: 14:00:00 - Track: BI Platform Architecture, Development Administration
We'll start the session by understanding what a Non-Numeric Measure is, and identifying situations in which they can be applied. Once we have that in place, we'll learn patterns for creating various Non-Numeric Measures and then we'll put our new knowledge to use by seeing Non-Numeric Measures in action, both in SSAS Tabular, and Power BI.
Event Date: 09-09-2017 - Session time: 14:00:00 - Track: DBA
Event Date: 09-09-2017 - Session time: 14:00:00 - Track: DBA
Event Date: 09-09-2017 - Session time: 15:00:00 - Track: BI Platform Architecture, Development Administration
Event Date: 09-09-2017 - Session time: 15:00:00 - Track: Application Database Development
We'll review the common mistakes which people make when deploying SQL Server Virtual Machines to Azure which can lead to security problems including data breaches.
We'll review the common performance problems which people encounter, and how to resolve them.
We'll review the common scalability misunderstandings of Azure and SQL Server Virtual Machines.
Join us for this fun session and learn how to improve the security, reliability and scalability of your Azure deployments of SQL Server 2016.
Event Date: 09-09-2017 - Session time: 15:00:00 - Track: Application Database Development
Event Date: 09-09-2017 - Session time: 15:00:00 - Track: Cloud Services
Event Date: 09-09-2017 - Session time: 15:00:00 - Track: BI Platform Architecture, Development Administration
Event Date: 09-09-2017 - Session time: 15:00:00 - Track: Cloud Services
We’ll take a look at the different options available for your SQL applications to see how to create and manage SQL databases in the Cloud. By the end of this talk you will be ready to get straight into Azure and start taking advantage of what it has to offer