Thomas Hütter
Developer of code, explorer of things, builder of stuff
Developer of code, explorer of things, builder of stuff
Brüggen, Germany
Actions
Thomas holds a degree in Business Economics, but has been a data explorer and a developer at heart ever since the days of dBase and Turbo Pascal. He touched his first SQL Server at V6.5, used covering indexes before they became a feature and joined the PASS community in 2006.
Thomas has been developing in Navision/Dynamics/Business Central systems for quite some time (since 2001, one year before MS acquired Navision), got his hands on R in 2014 (the year before MS bought Revolution Analytics), on the Power Platform from 2020 and the Arduino world from 2024 on. He has worked for ISVs as well as end-user companies, as a developer, consultant, accidental data engineer and is an author for data-related articles as well as a speaker at data events across Europe.
Thomas hat einen Abschluss als Diplom-Betriebswirt, ist aber seit den Tagen von dBase und Turbo-Pascal Datentüftler und Entwickler mit Leib und Seele. Er kam mit dem SQL Server zum ersten Mal mit V6.5 in Berührung, hat Covering Indizes eingesetzt, schon bevor sie zum Feature wurden, und ist PASS Mitglied seit 2006.
Thomas entwickelt schon ziemlich lange in Navision/Dynamics/Business Central-Systemen (seit 2001, ein Jahr bevor Microsoft Navision übernahm), und beschäftigt sich mit R seit 2014 (dem Jahr bevor Microsoft Revolution Analytics kaufte), mit der Power Platform seit 2020 und der Arduino-Welt seit 2024. Er hat für Systemhäuser und bei Endanwendern gearbeitet als Entwickler, Berater, gelegentlicher Daten-Ingenieur, ist Autor daten(bank)bezogener Artikel, aber auch als Sprecher auf Data-Events in Europa unterwegs.
Badges
Area of Expertise
Topics
IoT ... cloud ... big data - let‘s start small! en de
When I was looking for a sidekick to my day-to-day developer job, I stumbled across the Arduino ecosystem of microcomputers, which means open source software and hardware. So why not revive my electronics skills, start with some IoT, as well as get going with some cloud stuff, I thought.
So, in this session let me demonstrate to you my first IoT project that actually deserves that name.
I'll introduce you to the Arduino world (hardware and IDE), show you how to connect an Arduino class microcomputer with some sensors (i.e. temperature, air quality...) to a network, then have it transmit data to the (Arduino and even Azure-) cloud where the data can be stored, analyzed and also visualized on your own environmental data dashboard. All of this is accomplished with really low-cost hardware and free cloud offerings.
(Almost) no hardware was harmed in preparation for this session, and I'll bring some of the items that survived. ;-)
IoT, cloud, big data - fangen wir klein an! en de
Auf der Suche nach einem Ausgleich für meinen Day-to-day Job, fand ich das Ökosystem der Arduino Kleinst-Computer, wo sowohl Software als auch Hardware Open Source sind. Also dachte ich mir, warum nicht meine Elektronik-Kenntnisse reaktivieren, und gleichzeitig endlich mal mit IotT und Cloud-Zeugs starten.
In dieser Session demonstriere ich Euch also mein erstes IoT-Projekt, das diese Bezeichnung verdient.
Ich stelle Euch die Arduino-Welt vor (Hardware und IDE), und zeige Euch, wie man einen Arduino-Mikrocomputer nebst einigen Sensoren (Temperatur, Luftqualität...) mit einem Netzwerk verbindet, um Daten in die (Arduino- oder Azure-) Cloud zu übertragen, wo diese gespeichert, analysiert und sogar in Eurem eigenen Umweltdaten-Dashboard visualisiert werden können. All dies wird realisiert mit wirklich günstiger Hardware und freien Cloud-Angeboten.
Bei der Vorbereitung dieser Session kam (fast) keine Hardware zu Schaden, und ich werde einige der überlebenden Geräte dabei haben. ;-)
Window functions in SQL Server - brush up your skills en de
Window functions usually are considered "advanced SQL", and while they're part of the language standard, SQL Server does not implement all of them. Version 2022 brought at least a small feature update worth looking at and in 2025 we get a new aggregate function, so it's about time time to brush up our knowledge.
You will learn when and how how to use those OVER, PARTITION and ORDER clauses. From aggregate and ranking to statistical and offset functions, this session walks you through all that SQL Server offers, up to the new actual WINDOW clause. The demos will show real world applications, such as sliding means, running totals, string aggregates and even the popular "gaps and islands" problem.
Once you've got the hang of it (right after this session), it will become clear that window functions are not overly complicated, but ease the development of data analysis in T-SQL, and in the optimal case even bring a performance advantage over conventional methods.
Window-Funktionen im SQL Server - Aufgefrischt en de
Window-("Fenster")Funktionen werden im Allgemeinen als „fortgeschrittenes SQL“ betrachtet und obwohl sie Teil des Sprachstandards sind, werden sie vom SQL Server nicht vollständig implementiert. Die Version 2022 brachte immerhin ein kleines, sehenswertes Feature-Update mit sich, die 2025er eine neue Aggregat-Funktion, und so wird es höchste Zeit, unser Wissen aufzufrischen.
Ihr lernt, wann und wie die OVER-, PARTITION- und ORDER-Klauseln verwendet werden. Von den Aggregat- und Ranking- bis hin zu Statistik- und Offset-Funktionen führt diese Session durch alles, was SQL Server bietet, bis hin zur neuen eigentlichen WINDOW-Klausel. Die Demos zeigen Anwendungen aus der Praxis, wie etwa laufende Mittelwerte und Summen, String-Aggregation und sogar das bekannte „Lücken- und Inseln“-Problem.
Wenn Ihr den Dreh erst einmal raus habt (gleich nach dieser Session), wird klar, dass Window-Funktionen nicht übermäßig kompliziert sind, sondern die Entwicklung von Datenanalysen in T-SQL erleichtern und im optimalen Fall sogar einen Performance-Vorteil gegenüber herkömmlichen Methoden bringen.
Hunting for fraud with Benford's law in R en de
In this lightning talk I'll demonstrate how to apply the R implementation of Benford's law (which actually is not about crime or fraud) to identify possibly fraudulent invoice or other data.
Lightning talk/20 mins
Den Betrügern auf der Spur mit Benford's Gesetz in R en de
In dieser Lightning Session zeige ich Euch, wie man Benford's Gesetz (bei dem es eigentlich nicht um Kriminalität oder Betrug geht) in R anwendet, um möglicherweise betrügerische Rechnungs- oder andere Daten zu finden.
Lightning talk/20 min
Data profiling done right from the start en
This presentation gives an overview of what Data Profiling is about (spoiler: determining and possibly improving the consistency and plausibility of your data) and how it relates to terms as Data Quality and Data Governance. We'll even touch on Master Data Management and Database Normalization.
Why you need them and how you can save time and money by applying profiling techniques early in your processes, gaining benefits for the downstream use of your data. And we'll see which properties of your data to assess and learn some tools that you might or might not be aware are suitable for these tasks.
Key take-aways:
- How will your Data Quality improve by using Data Profiling techniques.
- How can the downstream processes profit from applying Data Profiling early.
- Which properties of your data to assess for optimum results.
Slides only/20 mins
SQL Bits 2026 Upcoming
Window functions in SQL Server - brush up your skills
SeaQL Saturday 2026 Upcoming
Window functions in SQL Server - brush up your skills
SQL Konferenz 2026 Upcoming
Window functions in SQL Server - brush up your skills
Techorama 2025 NL
From SQL to KQL via Azure Data Explorer
SQL Days 2025
Window-Funktionen im SQL Server - Aufgefrischt
Data Saturday Göteborg 2025
From SQL to KQL via Azure Data Explorer
Data Saturday Denmark 2025
From SQL to KQL via Azure Data Explorer
dataMinds Belgium Meetup (online)
From SQL to KQL via Azure Data Explorer
Build Stuff 2024 Lithuania
IoT ... big data ... cloud - let‘s start small!
SQL Days 2024
Von SQL zu KQL via Azure Data Explorer
IoT, Azure cloud, big data - fangen wir klein an!
Budapest BI Forum (Online)
50 ways to show your data
SQL Konferenz 2023
Von SQL zu KQL via Azure Data Explorer
Data Saturday Rheinland 2023
So, what about JSON in my database?
Data Innovation Summit 2023
Data Profiling done right from the start
PASS local group Berlin (Online)
50 ways to show your data
NDC London 2023
50 ways to show your data
Data Saturday Slovenia 2022 (Online)
What are SQL statistics and why should the developer care?
SQL Days 2022
Pimp your Power BI with R
Dataminds Connect 2022
What are SQL statistics and why should the developer care?
Techorama 2022
So, what about JSON in my database?
Data Weekender CU5 (Online)
What are SQL statistics and why should the developer care?
SQL Bits 2022
Hunting for fraud with Benford's law in R
Data Saturday Slovenia 2021 (Online)
A Journey through the Tidyverse
IT-Tage 2021 (Online)
50 ways to show your data
Update Conference 2021
So, what about JSON in my database?
Data Weekender 4.2 (Online)
An R primer for SQL folks
Data Innovation Summit 2021
50 ways to show your data – condensed edition
SQL Days 2021
What are statistics and why should the developer care?
Data Saturday Croatia 2021
A refresher on geospatial data in SQL Server
Data Saturday Malta 2021 (Online)
50 ways to show your data
Data Saturday Pordenone 2021 (Online)
Poor man's SQL Server job monitoring with R
Data Saturday Guatemala 2021 (Online)
A journey through the Tidyverse
SQL Saturday Slovenia 2020 (Online)
Poor man's SQL Server job monitoring with R
DDD Developer day 2020 (Online)
50 ways to show your data
SQL Days 2020
Poor man's SQL Server job monitoring with R
QL Tech Con '20 (Online)
50 ways to show your data
SQL Bits 2020 (Online)
A journey through the Tidyverse
Data Weekender Europe (Online)
50 ways to show your data
DDD North
50 ways to show your data
Join! Conference 2019
"Can I join you?", one table asked the other
Poor man's SQL Server job monitoring with R
SQL Days 2019
"Can I join you?", one table asked the other
Data Saturday Holland
A journey through the Tidyverse
SQL Saturday Oslo 2019
"Can I join you?", one table asked the other
SQL Saturday Rheinland 2019
A refresher on geospatial data in SQL Server
SQL Saturday Stockholm 2019
A refresher on geospatial data in SQL Server
SQL Bits 2019
An R primer for SQL folks
SQL Saturday Slovenia 2018
50 ways to show your data
Join! Conference 2018
A journey through the Tidyverse
50 ways to show your data
A refresher on geospatial data in SQL Server
SQL Days 2018
50 ways to show your data
A refresher on geospatial data in SQL Server
SQLGla 2018
Next first steps - selected applications of R
SatRday Amsterdam
50 ways to show your data
SQL Saturday Paris 2018
Next first steps - selected applications of R
SQL Grillen 2018
50 ways to show your data
SQL Saturday Rheinland 2018
Next first steps - selected applications of R
Intelligent Cloud Conference
An R primer for SQL folks
Techorama 2018
50 ways to show your data
PASS local group Rheinland
50 ways to show your data
SQL Saturday Iceland 2018
From SQL to R and beyond
SQL Konferenz 2018
A journey through the Tidyverse
SQL Bits 2018
50 ways to show your data
IT-Tage 2017
From SQL to R and beyond
SQL Days 2017
Next first steps - selected applications of R
A journey through the Tidyverse
SQL Saturday Holland 2017
Next first steps - selected applications of R
SQL Saturday Cambridge 2017
A journey through the Tidyverse
PASS local group Ruhrgebiet
A journey through the Tidyverse
SQL Saturday Rheinland 2017
A journey through the Tidyverse
SQL Grillen 2017
A journey through the Tidyverse
Join! Conference 2017
From SQL to R and beyond
Next first steps - selected applications of R
SQL Konferenz 2017
Next first steps - selected applications of R
SQL Saturday Cambridge 2016
From SQL to R and beyond
SQL Saturday Rheinland 2016
From SQL to R and beyond
Nordic SQL Nexus
From SQL to R and beyond
PASS local group Ruhrgebiet
From SQL to R and beyond
Please note that Sessionize is not responsible for the accuracy or validity of the data provided by speakers. If you suspect this profile to be fake or spam, please let us know.
Jump to top