| Start Time (24h) | Speaker | Track | Title |
|---|---|---|---|
| 10:00:00 | Cédric Charlier | BI DEV | Graphs ... graphs everywhere! |
| 10:00:00 | Christopher Adkin | BI DEV | Continuous Integration Pipelines With Jenkins, Docker and SQL Server |
| 11:20:00 | Andrew Pruski | Application Database Development | Partitioning 101 |
| 11:20:00 | Sander Stad | BI DEV | PowerShell - Grow Your Script From Simple to Module |
| 13:20:00 | Sander van der hoeff | DBA | SQL Server under Pressure: Can I Fix it? |
| 13:20:00 | Callum Green | BI DEV | Embedding PowerApps into a Power BI Dashboard |
| 14:40:00 | Simon Whiteley | BI DEV | Modern Data Warehousing - The Lambda Approach to Azure BI |
| 14:40:00 | Nico Jacobs | BI DEV | When the ‘bug’ turns out to be a feature |
Event Date: 17-03-2018 - Session time: 10:00:00 - Track: BI DEV
Event Date: 17-03-2018 - Session time: 10:00:00 - Track: BI DEV
Event Date: 17-03-2018 - Session time: 11:20:00 - Track: Application Database Development
This session will give attendees a refresher through partitioning concepts and the implementation of those concepts through live demos.
Topics covered will be: - Paritioning definition Potential benefits and pitfalls Overview of partitioning functions and schemes Table design considerations Splitting and merging partitions Switching data Implementing sliding windows
Event Date: 17-03-2018 - Session time: 11:20:00 - Track: BI DEV
We're talking about multiple functions interacting with each other, parameter validation, pipelines, use of the -WhatIf, modules, classes etc.
If you're someone who wants to learn more to upgrade your current scripts to advanced functions, come to my session. I'll show you in a couple of easy steps how a simple script can be turned into something beautiful.
Have you written a couple of scripts but want to get them to the next level. Than you'll want to attend this session and we'll see how far the rabbit hole goes.
Event Date: 17-03-2018 - Session time: 13:20:00 - Track: DBA
Where to start when your SQLServer is under pressure? If your server is misconfigured or strange things are happening, there are a lot of free tools and scripts available online.These tools will help you decide whether you have a problem you can fix yourself or you really need a specialized DBA to solve it.
Those scripts and tools are written by renouwned SQLServer specialists. Those tools provide you with insights of what might be wrong on your SQLServer in an quick and easy manner. You don’t need extensive knowledge of SQLServer nor do you need expensive tools to do your primary analysis of what is going wrong
And in a lot of cases these tools will tell you that you yourself can fix the problem.
Event Date: 17-03-2018 - Session time: 13:20:00 - Track: BI DEV
What if we could use PowerApps and Power BI together? Can we embed a PowerApp into a Dashboard and give the end user the ability to write back data to a visual? Come along to my session to find out.
The 1-hour session includes other technologies such as Azure SQL Database, Common Data Service (CDS) and Flow. In particular, I will demonstrate how you integrate these technologies with PowerApps and Power BI. Whilst all levels of expertise are welcome, users require prior knowledge of Power BI Dashboards and PowerApps.
Event Date: 17-03-2018 - Session time: 14:40:00 - Track: BI DEV
This session will take you through the pattern known as the Lambda architecture, a reference pattern for building data analytics systems that can handle any combination of data velocity, variety and volume. The session will outline the set of tools and integration points that can underpin the approach. Do you design real-time reporting systems? Or crunch petabytes of data? Perhaps you are adopting a cloud architecture and just want to handle anything the future throws at you? This session is for you.
We will follow the movement of data through batch and speed layers via Azure Data Lake Store Analytics and Streaming Analytics before considering the serving layer with Azure SQL DataWarehouse and downstream reporting tools.
Event Date: 17-03-2018 - Session time: 14:40:00 - Track: BI DEV
In this very interactive session you will learn about common T-SQL mistakes, why the code executes that way, and how to avoid making these mistakes in the future.