SQLSaturday #956 - Belgium 2020
Event Date: 03/07/2020 00:00:00
Event Location:
- SQLSaturday Belgium
- 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: Pay less, get more, a guide to SQL Server Licensing
Abstract: In this session, we will talk about how you can save money by right-licensing SQL Server. Some people consider SQL Server licensing as the “elephant in the room” while others refer to it as “something that no one wants to own, but know they need to sort out.” SQL Server licensing is a complex beast. It is not always transparent and straight forward to understand what licensing you need. In this session, we will look at how you best license your SQL Servers to get the best return on investment. We will discuss •What SQL Server editions you need to license •SQL Server and software assurance – why you might need both •How can you buy your licenses? o On-premises o Cloud •Licensing models o Core-based o Server+CAL •How to license SQL Server in a virtual environment •Licensing scenarios o High availability o Application mobility o Non-production o SQL Server on containers
Speaker(s):
- Gethyn Ellis
Track and Room: Administration - Auditorium 1
Title: An Architects Guide to Delivering Data Insights on the Microsoft Azure Data Platform
Abstract: The resources on offer in Azure are constantly changing, which means as data professionals we need to constantly change too. Updating knowledge and learning new skills. No longer can we rely on products matured over a decade to deliver all our solution requirements. Today, data platform architectures designed in Azure with best intentions and known good practices can go out of date within months. That said, is there now a set of core components we can utilise in the Microsoft cloud to ingest and deliver insights from our data? When does ETL become ELT? When is IaaS better than PaaS? Do we need to consider scaling up or scaling out? And should we start making cost the primary factor for choosing certain technologies? In this session we’ll explore the answers to all these questions and more from an architects viewpoint. Based on real world experience lets think about just how far the breadth of our knowledge now needs to reach when starting from nothing and building a complete solution.
Speaker(s):
- Paul Andrew
Track and Room: Developer - Auditorium 2
Title: Database CI/CD with Containers and Azure DevOps
Abstract: Containers are becoming ever popular but other than spinning one up to have a play around with the latest SQL Server 2019 CTP’s new features, what else can they be used for?
In this demo heavy session we will show how Containers along with Azure DevOps can work for your CI/CD pipeline.
You will leave this session with the knowledge and ability to start creating your own bespoke SQL Server on Linux development / testing environments with automated image builds and releasing to Azure Kubernetes Service (AKS) along with some of the issues / pitfalls of doing so.
Pre-Requisite: To get the most out of this session a basic understanding of what Docker/Containers are, is recommended.
Speaker(s):
- Chris Taylor
Track and Room: Administration - Auditorium 1
Title: Tips Tricks of a Power BI Implementation at a Financial Institute
Abstract: Back to September 2016: Power BI is new, shiny and hot. It is the tool of the moment, so people cannot wait to get their hands on it. Fast forward 6 months, there is more traction within the business, training is given and workshops are held. The adoption of Power BI is growing. Some departments already use Power BI very extensively and incorporate it in their day-to-day processes. Due to this quick success there is uncertainty regarding the right support team for incidents and problems. Because an app workspace creates an Office 365 group with a lot of artifacts behind the scenes, the creation workflow is controlled by IT. Unfortunately this inhibits the end users. We require more governance, not to further bother the users, but it is essential to stay in control. Responsibilities need to be better aligned between IT and the business. Throughout this session we take you along on our Power BI journey, with tips, tricks, do’s and don’ts during the implementation of Power BI (Premium).
Speaker(s):
- Nicky van Vroenhoven
Track and Room: Analytics - Classroom
Title: Azure Data Factory, your data pipeline in the cloud
Abstract: Before data can be analyzed it must first be converted and copied into a format and a location where the analysis is the easiest. ETL tools (Extract, Transform, Load) make this possible. But if the data is needed in the cloud, it’s best to run the ETL in the cloud as well. Azure Data Factory is a cloud-based ETL tool, allowing data to be copied from on-premises as well as cloud based locations. Transformations can be hand-coded, but recently Microsoft added data flows to the product, which allow you to do data transformations without the need to write custom code. In this session you will see the product in action and learn how to get started building your own flows.
Speaker(s):
- Nico Jacobs
Track and Room: Analytics - Classroom
Title: The databases in SSDT - a work with project and best practices
Abstract: A task seems to be easy. Maintenance a project of a database in the code repository, treat as master-version and do deployment evenly and frequently. Simple? Seemingly. The things become more complex as fast as a number of objects in database growing. While instead of one database, we have over a dozen. When databases have got the references to each other. And how about dictionary tables? Where to keep them and how to script? Additional issues are coming whilst we would like to control instance-level objects. All these topics I will explain in the session focused on practical aspects of work with Microsoft Visual Studio Data Tools.
Speaker(s):
- Kamil Nowinski
Track and Room: Developer - Auditorium 2
Title: Effectively Troubleshooting Latency and Failover of Always On Availability Group
Abstract: In this session, we will cover: The internals of SQL Server Always On, Identifying and detecting latency and failover issues with Always On, Artifacts and data pointers available to troubleshoot latency and failover issues, Tips and Tricks to troubleshoot Always On availability groups, New enhancements which make troubleshooting Latency and Failover issues easier
Speaker(s):
- Marcelo Fernandes
Track and Room: Administration - Auditorium 1
Title: Troubleshooting Power BI Report Performance
Abstract: So you’ve built a Power BI report with all the shinies? Good! After some usage, users have reacted that it’s a bit sluggish in usage, and they’re not keen on using it anymore.
Starting off with the new Performance Analyzer Pane, we’ll demonstrate how you can pinpoint bottlenecks in your report, and take actions on these insights.
With the myriad of root causes that are out there, an elimination approach might suit us very well. Some of the main causes will be explained, and we’ll get you going on how you can fix it for yourselves.
Be it DAX-measures, modelling issues, or an overload of visuals. Every report can be tuned to handle like a dream, and you can do it too!
Speaker(s):
- Benni De Jagere
Track and Room: Analytics - Classroom
Title: Intelligent Query Processing in SQL databases
Abstract: What if I say you can accelerate database performance automatically without any applications. Come to this session and figure out how Intelligent Query Processing (IQP) works and adapts to any type of workload with no application changes required.
Speaker(s):
- Tiago Balabuch
Track and Room: Developer - Auditorium 2
Title: Introduction into Power BI Embedded
Abstract: The session gives an overview about Microsoft Power BI Reporting Platform and how this amazing technology can be a game changer at the information delivery to the customer. The session explains what Power BI Embedded is, how to embed reports into ISV application works. Also, the session clarifies the licensing aspect and gives information about the maintenance of this architecture. After the session, the attendees will be able to create her first Power BI Embedded Application
Speaker(s):
- Philipp Lenz
Track and Room: Developer - Auditorium 2
Title: Azure databricks: brick by brick for the data engineer
Abstract: Still developing your ETL with SSIS but you’re willing to take a look to the new Azure databricks platform? This session is the first step to start developing with Azure Databricks! We’ll start by the use-cases or if you prefer “when is it smarter to switch your good old SSIS for the new tools”. Then we’ll take a look to a data preparation and a data move with Databricks and we can automate its execution. Finally, we’ll go for a few tips with the tooling.
Speaker(s):
- Cédric Charlier
Track and Room: Analytics - Classroom
Title: SQL Server Transaction Log: internals
Abstract: We will touch in depth a one of the most important component of a databases - transaction log. What is it used for? What processes is it involved. Topics to discuss: Backup, Recovery, Shrink, VLF, Replication, AlwaysOn, Best Practices.
Speaker(s):
- Andriy Pogorelov
Track and Room: Administration - Auditorium 1
Title: Be a dynamic SQL dynamo!
Abstract: This session will cover the basics of dynamic SQL; how, why and when you may wish to use it with demos of use cases and scenarios where it can really save the day (trying to perform a search with a variable number of optional search terms, anyone?). We will also cover the performance and security impacts touching on the effect on query plans, index usage and security (SQL injection!) along with some best practices.
Speaker(s):
- Joanna Wolthuis
Track and Room: Developer - Auditorium 2
Title: Azure Data Studio – The 30-day challenge
Abstract: Heard of dry January? Well, this the DBA equivalent. What is it? Why would I want to use this over Management Studio? Can I use it instead of Management Studio? Martin will answer these questions – and more – and share with you what happened when as a DBA/Database professional he tried to exclusively use this instead of SSMS. A month’s work of expertise to be shared in 60 minutes, detailing all the caveats and clever tricks needed to avoid pulling his hair out on a daily basis.
Speaker(s):
- Martin Croft
Track and Room: Administration - Auditorium 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.
Kamil Nowinski
Twitter: - @NowinskiK
LinkedIn: Kamil Nowinski
Contact: https://sqlplayer.net
Blogger, speaker, #sqlfamily member. Microsoft Data Platform MVP. Data passionate, Data engineer and Architect. Over 13 years of programming and experience with SQL Server databases, he worked both as developer and administrator big databases designing systems from the scratch. Passionate about tuning database engines, code transparency and maximising performance database engine. Currently, he is expanding new horizons as a contractor in the UK market, making troubleshooting, prototyping BI and Big Data solutions, enhancing existing processes among Microsoft stuff environments, popularizing the DevOps approach and efficient solutions in the cloud. An originator of the “Ask SQL Family” podcast and founder of SQLPlayer blog.
Philipp Lenz
Twitter: - lenz_philipp
Contact: https://www.flip-it.de
Philipp works as a Business Intelligence Senior Consultant at XXXL Digital in Coblenz, Germany. With the advent of Power Pivot for Excel and SQL Server Reporting Services, he has discovered his passion for Microsoft Business Intelligence technologies over 12 years.
Since mid-2016 he has been a founding member of the Power BI Usergroup in Cologne and is Chapter Leader of SQL PASS Mittelrhein, Germany. In 2019 he has also founded the Power Apps and Power Automate Usergroup and he was in the end of 2019 recognized as an Data Platform MVP.
Joanna Wolthuis
Twitter: - ochthenoodle
LinkedIn: Joanna Wolthuis
Joanna Wolthuis is an independent contractor specialising in T-SQL database development and reporting using SSRS and Excel based solutions for the last 8 years. She is passionate about data and learning everything about anything. Aside from SQL Joanna enjoys traveling, nice food and attempting to be an acrobat (not at the same time!).
Ken Geeraerts
Twitter: - KenGeeraerts
LinkedIn: Ken Geeraerts
Contact: https://ichinichiichizen.wordpress.com/
Ken Geeraerts has been working with SQL Server for over 15 years. His role shifted from developer to business user and back to business intelligence consultant. This career path shows the interest for business and IT and makes it easy to understand why he loves the possibilities of Power BI.
During the last 7 years he has been working at Kohera as a Business Intelligence consultant. Next to his consulting work he presents webinars, gives sessions and teaches courses about Power BI.
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,…)
Andriy Pogorelov
LinkedIn: Andriy Pogorelov
I have been dealing with database administration and development for more than 16 years. Started from SQL Server 2000
- Active member of Data Platform community
- Organizer of SQLSaturday Kharkiv
- Speaker at various Data Platform related events
- I possess Microsoft certificates: MCDBA, MCITP, MCSA.
Benni De Jagere
Twitter: - https://twitter.com/BenniDeJagere
LinkedIn: Benni De Jagere
Contact: https://bennidejagere.com
Benni De Jagere is a Senior Data Insights Consultant at Realdolmen, with a strong focus on the Microsoft (BI) Stack.
On a daily basis he turns (large amounts) of coffee into insights for customers, and references witty British comedy way too often. Overly enthusiastic about anything data related, he’s trying hard to keep up with all things new and shiny.
Rumour has it that he’s also involved with a ragtag band of data enthusiasts, enjoying themselves whilst organising cool community things. They go by the name of .. dataMinds!
Chris Taylor
Twitter: - @SQLGeordie
LinkedIn: Chris Taylor
Contact: http://www.chrisjarrintaylor.co.uk
Chris (@SQLGeordie) is a Principal Consultant working at Jarrin Consultancy providing SQL Server and Microsoft Azure consultancy to clients worldwide in a variety of industries ranging from Financial to Healthcare. He has been working with SQL Server since 2001 and during that time has become extremely strong in all areas of SQL Server but specialises in Security, System Optimisation and SQL Server Internals.
Gethyn Ellis
Twitter: - gethyn_ellis
LinkedIn: Gethyn Ellis
Contact: http://www.gethtynellis.com
Gethyn is a SQL Server consultant and trainer and has worked with SQL Server for nearly 20 years. He specialises in version mIgration, performance, security, architecture and design including Azure and virtualisation solutions. He is working with private and public sector organisations in the UK, Europe and USA.
Gethyn delivers a range of SQL Server training, including the Microsoft Official Curriculum. He is the author of three training courses and two published books on SQL Server and Azure. You can find his blog at www.gethynellis.com
Tiago Balabuch
Twitter: - https://twitter.com/balabuch
LinkedIn: Tiago Balabuch
Contact: http://tiagobalabuch.com
Tiago Balabuch is a Microsoft Premier Field Engineer on Data AI, also enthusiast, fascinated, passionate, fanatic by SQL Server and in the off-hours a Data Engineer who loves what he does. Traveling in the cloud and surfing on the wave of the moment called Azure is his new challenge! Originally from Brazil and with encouragement from family and friends, Tiago moved to Europe in 2017 where lives in Lisbon
Nicky van Vroenhoven
Twitter: - https://www.twitter.com/nickyvv
LinkedIn: Nicky van Vroenhoven
Contact: https://www.nickyvv.com
Nicky van Vroenhoven is a BI professional focused at the Microsoft stack. He mainly works with Power BI, Power Platform and T-SQL. After working 9 years in BI-consultancy jobs in several industries and companies, he is currently working as a Lead BI Developer at the DWH team at Van Lanschot Kempen in The Netherlands. Nicky has spoken at several User Groups, SQLSaturday Events, and the Power BI World Tour and is the co-founder of the Power BI Days Netherlands. In addition he enjoys tweeting and blogging about topics like Power BI and Power Platform at https://nickyvv.com.
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.
Martin Croft
Twitter: - @MartinCroft
LinkedIn: Martin Croft
Contact: https://blog.sqlserversolutions.co.uk/
Martin Croft Data consultant from SQL Server Solutions Martin Croft is a time served SQL developer / DBA contractor / consultant who has worked with SQL Server since SQL 6.5, having attending the user groups for many years he wanted to (try) and give something back for all the things he’s have picked up from the sessions he’s seen and share things people find useful (hopefully). Martin is a co-organiser of the Manchester Data platform PASS user group and SQLSaturday Manchester, SQL bits helper and regular nice all-round nice guy (his mum said).
Marcelo Fernandes
Twitter: - marcelodba
LinkedIn: Marcelo Fernandes
Contact: http://marcelodba.wordpress.com
Marcelo Fernandes is SQL Server MVP and has 12+ years experience with databases, specialized in High Availability, critical missions and very large databases. He holds the MCP / MCDBA / MCSA / MCTS / MCITP and MCT certifications, he lives and works in Berlin for an American e-commerce company that sells home goods. He share their knowledge through webcasts, presentations and articles on Microsoft technologies and can be cantacted by email fernandes_dba@hotmail.com or twitter @ marcelodba
Paul Andrew
Twitter: - mrpaulandrew
LinkedIn: Paul Andrew
Contact: https://mrpaulandrew.com/
Paul Andrew is a principal consultant and architect, specializing in big data solutions on the Microsoft Azure cloud platform. Paul’s data engineering competencies include Azure Data Factory, Data Lake, Databricks, Stream Analytics, Event Hub, IoT Hub, Functions, Automation, Logic Apps, and of course the complete SQL Server Business Intelligence stack.
He has many years’ experience working within healthcare, retail, and gaming verticals, delivering analytics using industry leading methods and technical design patterns.
Paul is a STEM ambassador and a very active member of the data platform community delivering training and technical sessions at conferences both nationally and internationally.
He is a father, husband, swimmer, cyclist, r
Sponsors
The following is a list of sponsors that helped fund the event: