SQLSaturday #709 - Belgium 2018
Event Date: 03/17/2018 00:00:00
Event Location:
- Thomas More Campus De Vest
- Zandpoortvest 60, 2800 Mechelen
- Mechelen, Antwerp, Belgium
This event has completed. All data shown below is from the historical XML public data available.
If there are any data quality issues or corrections needed, please contact the webmaster for this site or submit a pull request for the appropriate file(s).
Sessions
This is a list of sessions from the event, based on the schedule in the XML files.
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.
Speaker(s):
- Simon Whiteley
Track and Room: BI DEV - ROOM 1
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.
Speaker(s):
- Sander van der hoeff
Track and Room: DBA - ROOM 2
Title: Continuous Integration Pipelines With Jenkins, Docker and SQL Server
Abstract: Docker has taken the world of IT by storm and looks to be ushering in the greatest platform paradigm shift since virtualisation and the public cloud. The transient nature of Docker containers makes them the perfect fit for spinning up and then tearing down SQL Server instances as part of continuous integration pipelines. Jenkins is the most popular build automation engine in the open source community, it has phenomenal plugin support, it is used by the likes of Netflix and eBay and excels in its ability to handle build pipelines as code. In this session you will learn how a simple build pipeline that takes a SQL Server data tools project checked out from source code control, built into a DACPAC which is then deployed to a SQL Server instance can be extended to use containers, multi-branch build pipelines, tSQt testing and much much more.
Speaker(s):
- Christopher Adkin
Track and Room: BI DEV - ROOM 2
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.
Speaker(s):
- Callum Green
Track and Room: BI DEV - ROOM 1
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.
Speaker(s):
- Sander Stad
Track and Room: BI DEV - ROOM 1
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.
Speaker(s):
- Nico Jacobs
Track and Room: BI DEV - ROOM 2
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
Speaker(s):
- Andrew Pruski
Track and Room: Application Database Development - ROOM 2
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.
Speaker(s):
- Cédric Charlier
Track and Room: BI DEV - ROOM 1
Speakers
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
Callum Green
Twitter: - https://twitter.com/CallumGAdatis
LinkedIn: Callum Green
Contact: http://blogs.adatis.co.uk/callumgreen/
Callum is a Senior BI Consultant with Adatis Consulting, passionate about improving presentation layer architecture and finding new ways to exploit traditional warehouse structures. He has worked on many BI projects over a 9 year period, deviating from the typical Microsoft Stack and more into the Azure domain. Callum has written a number of blogs on subjects like Power BI, Power Query and the M programming language.
Christopher Adkin
Twitter: - ChrisAdkin8
LinkedIn: Christopher Adkin
Contact: http://www.chrisadkin.io
Chris is a freelance SQL consultant who has been working with SQL Server since 2000, his passion is for squeezing every last drop of performance out of SQL Server and understanding the database engine at a level which conventional tools cannot provide any insights on.
Nico Jacobs
Twitter: - sqlwaldorf
LinkedIn: Nico Jacobs
Contact: http://blogs.u2u.be/u2u/author/Nico-Jacobs.aspx
Dr. Nico Jacobs is a Microsoft Business Intelligence and SQL Server trainer at the U2U training center since 2004. Before that, he was a machine learning researcher at the university of Leuven, Belgium. At U2U, Nico creates and delivers courses on the SQL Server business intelligence stack (Integration Services, Analysis Services, Reporting Services …), Power BI, the traditional relational database environment (database development and administration) and the Azure AI and Big Data stack (Azure Data Factory, Machine Learning, Synapse Analytics,…)
Sander Stad
Twitter: - @SQLStad
LinkedIn: Sander Stad
Contact: http://www.sqlstad.nl
Sander is a SQL Server DBA with over 15 years of experience in IT. He has worked with SQL Server since version 2000 and is a PowerShell enthusiast.
Cédric Charlier
Twitter: - @Seddryck
LinkedIn: Cédric Charlier
Contact: http://seddryck.wordpress.com
Cédric is a talented architect and Data Platform MVP active in the domain of Business Intelligence and Data warehousing. He has more than 10 years of successful experiences with SQL Server in European industrial groups and services companies. Driven by quality and reliability, he is the main developer of an open-source solution for testing BI solutions (cubes, etl, reports) named NBi (www.nbi.io). Cedric also advocates for the introduction and general usage of agile practices in BI’s world.
Andrew Pruski
Twitter: - https://twitter.com/DBAFromTheCold
LinkedIn: Andrew Pruski
Contact: https://dbafromthecold.com/
SQL Server DBA with over 10 year’s experience. Originally from Wales but now living in Ireland
Simon Whiteley
Twitter: - MrSiWhiteley
LinkedIn: Simon Whiteley
Contact: http://blogs.adatis.co.uk/blogs/simonwhiteley/
Simon Whiteley is the Director of Engineering for Advancing Analytics Ltd and a Microsoft Data Platform MVP. Simon is a seasoned solution architect and technical lead with well over a decade of Microsoft Analytics experience. A deep techie with a focus on emerging cloud technologies and applying “big data” thinking to traditional analytics problems, Simon also has a passion for bringing it back to the high level and making sense of the bigger picture. When not tinkering with tech, Simon is a death-dodging London cyclist, a sampler of craft beers, an avid chef, and a generally nerdy person.
Sander van der hoeff
Twitter: - shoeff
LinkedIn: Sander van der hoeff
Contact: http://www.du-sabot.nl
With over 20 years of experience in automation Sander van der Hoeff knows his way around in the ICT business. Since 2000 Sander is Specialized in business intelligence and data warehousing using the full SQLServer Stack. In 2012 Sander founded his own BI-company: Du Sabot. Nowadays Sander spends his time on several BI- and DWH-projects as an independent professional. Sander combines deep technical knowledge with the capability to explain difficult BI- and DWH-concepts to the non-technical people
Sponsors
The following is a list of sponsors that helped fund the event: