sqlsathistory

Nr: 709

Back to Main list

SQLSaturday #709 - Belgium 2018

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

SessionID: 70296

Graphs ... graphs everywhere!

Back to calendar

Event Date: 17-03-2018 - Session time: 10:00:00 - Track: BI DEV

Speaker: Cédric Charlier

Title: Graphs ... graphs everywhere!

Abstract:

Since a few months, graphs are popping up everywhere in the Microsoft Data Platform ecosystem. SQL Server has some new features dedicated to handle and query graphs and Azure CosmosDB has a new API dedicated to query graph structures. This session is the opportunity to be in contact with both technologies and find out their use-cases and limits. We'll start by an introduction to graph then see the concept in action with SQL Server and the new MATCH syntax supported by T-SQL. Then, we'll move to Azure CosmosDB and see why this TinkerPop-enabled database is a good place to handle more complex use-cases and go further with Graphs.

SessionID: 71859

Continuous Integration Pipelines With Jenkins, Docker and SQL Server

Back to calendar

Event Date: 17-03-2018 - Session time: 10:00:00 - Track: BI DEV

Speaker: Christopher Adkin

Title: Continuous Integration Pipelines With Jenkins, Docker and SQL Server

Abstract:

SessionID: 70305

Partitioning 101

Back to calendar

Event Date: 17-03-2018 - Session time: 11:20:00 - Track: Application Database Development

Speaker: Andrew Pruski

Title: Partitioning 101

Abstract:

Partitioning has been available in SQL Server since 2005 but there can be a lot of misconceptions around it.

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

SessionID: 72086

PowerShell - Grow Your Script From Simple to Module

Back to calendar

Event Date: 17-03-2018 - Session time: 11:20:00 - Track: BI DEV

Speaker: Sander Stad

Title: PowerShell - Grow Your Script From Simple to Module

Abstract:

With todays features within PowerShell developers are able to create the most advanced functions imaginable.

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.

SessionID: 70421

SQL Server under Pressure: Can I Fix it?

Back to calendar

Event Date: 17-03-2018 - Session time: 13:20:00 - Track: DBA

Speaker: Sander van der hoeff

Title: SQL Server under Pressure: Can I Fix it?

Abstract:

SQLServer under pressure: Can I fix it?

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.

SessionID: 73187

Embedding PowerApps into a Power BI Dashboard

Back to calendar

Event Date: 17-03-2018 - Session time: 13:20:00 - Track: BI DEV

Speaker: Callum Green

Title: Embedding PowerApps into a Power BI Dashboard

Abstract:

PowerApps are a relatively new technology released within the Azure stack. Its primary focus is to empower technical or non-technical developers to create quick and simple custom apps. They can be used as standalone apps or embedded within websites/mobile apps. On the other hand, Power BI is now a mature product and needs little introduction.

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.

SessionID: 70313

Modern Data Warehousing - The Lambda Approach to Azure BI

Back to calendar

Event Date: 17-03-2018 - Session time: 14:40:00 - Track: BI DEV

Speaker: Simon Whiteley

Title: Modern Data Warehousing - The Lambda Approach to Azure BI

Abstract:

Technology changes quickly - patterns and approaches less so. As people move towards the cloud, there are clear benefits of adopting a polyglot cloud architecture employing a range of distributed components.

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.

SessionID: 70336

When the ‘bug’ turns out to be a feature

Back to calendar

Event Date: 17-03-2018 - Session time: 14:40:00 - Track: BI DEV

Speaker: Nico Jacobs

Title: When the ‘bug’ turns out to be a feature

Abstract:

You just finished a simple piece of T-SQL code, but when you run it, it turns out it does something different then what you expected… If you had this experience, hopefully you noticed it before it went into production!

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.