Frank Geisler
GDS Business Intelligence GmbH
Lüdinghausen, Germany
Frank Geisler is owner and CEO of GDS Business Intelligence GmbH a Microsoft Solution Provider in Data and AI. He is Data Platform MVP, MCT, Azure Solutions Architect Expert, Azure Security Engineer Associate, Azure Data Engineer Assoicate and DevOps Engineer Expert. In his Job he is building Business Intelligence Systems based on Microsoft Technology, like SQL Server, Azure Data Platform, Fabric and Power BI. He is building Azure Infrastructures and Architectures with PowerShell and Bicep too. Besides this, he is author of several bestselling books including Power BI für Dummies, Azure für Dummies, Docker für Dummies and Pro Serverless Data Handling with Microsoft Azure. He is also a frequent speaker at national and international Conferences including PASS Community Summit, SQL BITS and SQL Server Konferenz. In 2004 he was Co-Founder of PASS Deutschland e.V. where he is at the board of directors for many years and he runs the Microsoft Data Community Regional Chapter Münsterland.
Links
Awards
Area of Expertise
Topics
Low flying planes and Realtime Data Analytics
You know what the problem is these days? Some planes approaching the airport are always too low and bother the people that live near the airport by their noise. What if there only would be a technology with which we could analyze in real time which planes are too low? Because world wide aviation produces a massive amount of data this technology should be able to analyze Terrabytes of Data in the blink of an eye. Real Time Analytics in Microsoft Fabric to the rescue! Real-time Analytics in Fabric leverages top grossing Azure services like Event hub, Azure Stream Analytics and Azure Data Explorer that have been fused together into an integrated experience with Eventstream and KQL Database. This session will go behind into the KQL language and some of its unique capabilities of analyzing and joining billions of records.
Devang Shah, Fabric CAT PM at Microsoft who is focussing on Azure Data Explorer (Kusto) and long time Data Platform MVP Frank Geisler will demonstrate the capabilities of ADX in Fabric with a massive demo: As per FlightAware, there are about 9000-10000 flights in air at any given point in time. Certain countries mandate that aircraft must fly above 2500 feet in residential zones. Wondering what flights and altitude levels have go to do with Real-time Analytics in Fabric. In this session, you will see how billions of data points are stream ingested into Real-time Analytics, analysed at scale using advanced geospatial and timeseries analysis queries and then visualizing it all in Power BI in near real-time. With this setup, we are preparing a dashboard for port authorities of a town that can monitor the flights that are violating the noise control altitude that has been put in place by the city.
Living on the Edge: SQL Server Edge
In this session German Data Platform MVP Frank Geisler shows what exactly SQL Server Edge is, how to use it and how to install SQL Server Edge on an edge device like a Raspberry Pi.
Beginners Guide to Azure Data Studio
Two years ago Microsoft published a new tool that can be used for Development and Administration of SQL Server and meanwhile also for PostgreSQL. In this session German Data Platform MVP Frank Geisler will explain the differences between SSMS and Azure Data Studio and show you why it is important to learn and work with this tool now. If you heared about Azure Data Studio but don't know what it is and how it works this is the perfect session for you.
Bad habbits DIE HARD!
In this demo packed session Data Platform MVP Frank Geisler examines SQL Anti Patterns. There are so many things that can be done wrong while writing T-SQL Code. Some mistakes are made because of lazieness some are made because of lack of knowlegde. What this session will show you what SQL Anti Patterns are and why it is wise to avoid them.
Automating Power BI with PowerShell
In this Demo packed Session German Data Platform MVP Frank Geisler will show how to automate Power BI adminitstrative task with Power BI. Attendees will learn where to get the tools, what can be automated. There are several easy to follow examples, e.g. how to automatically create a Power BI Dataset via PowerShell or how to build a Power BI Inventory.
SQL Server auf Docker in Produktivumgebungen
Im Vortrag geht es um SQL Server in Containern in produktiven Umgebungen.
SQL Notebooks in Azure Data Studio
In dieser Session zeige ich was man alles mit SQL Notebooks in Azure Data Studio machen kann.
SQL auf Docker für Anfänger
Die Container Technologie Docker gewinnt immer mehr Anhänger und positioniert sich als willkommene Alternative zu klassischer Servervirtualisierung. Inzwischen gibt es auch SQL Server unter Linux und SQL Server unter Windows als Docker Container. Microsoft Data Platform MVP Frank Geisler führt in seinem eintägigen Workshop in die Grundlagen der Arbeit mit Docker Containern am Beispiel des SQL Servers ein. Zunächst wird auf die grundlegende Arbeit mit Containern eingegangen: Wie erzeugt man Container? Wie startet und stoppt man Container? Wie kann man Container wieder löschen? Nachdem die Grundlagen klar sind wird gezeigt wie man selbst eigene Docker Images erzeugen kann. Außerdem wird auf das Networking in Docker eingegangen und gezeigt wie man komplette Container Umgebungen mit docker compose bereitstellt.
Neuerungen in SQL Server 2019
Der SQL Server 2019 steht vor der Tür, wie eindrucksvoll verschiedene CTPs zeigen die in den letzten Wochen und Monaten veröffentlicht wurden. Wie immer gibt es an vielen Stellen Verbesserungen und auch ganz neue Funktionalitäten. In seinem Vortrag geht Microsoft Data Platform MVP Frank Geisler auf die Neuerungen ein und demonstriert einige der Neuheiten im Beispiel.
Neue Funktionen in Azure Data Studio
Azure Data Studio ist jetzt schon etwas länger verfügbar und wird stetig weiterentwickelt. In seiner Session zeig der deutsche Data Platform MVP Frank Geisler welche neuen Funktionen es im Azure Data Studio gibt und wie man damit noch effektiver mit dem Azure Data Studio arbeiten kann.
Living on the Edge - SQL Server auf ARM
In dieser Session geht es um Azure SQL Database on Edge, SQL Server auf ARM.
Introduction to SQL Server on Docker
In this session German Data Platform MVP Frank Geisler explains how the container technology Docker can be used to execute a SQL Server in a container environment and how this could be benificial for Development Teams using SQL Server Data Tools and TFS.
Code Your Report Environment
You too can build a development Environment for Reporting Services and SQL Server with Azure completely in PowerShell without any GUI!! Additionally, Frank Geisler will be discussing the ReportingServicesTools in PowerShell.
Introduction to the Microsoft Dataverse
Microsoft Dataverse is a cloud-based, low-code data service and app platform, which allows you to leverage the security and connectivity of Microsoft services. Dataverse connects easily to all aspects of Microsoft Power Platform so that you can fully control, automate, and strengthen your business. With standard tables and columns, as well as the ability to easily define relationships between your data, Dataverse was built for powerful, scalable solutions. In this session Microsoft Data Platform MVP will give you an introduction in the Data Layer behind the Power Platform.
Data Wranglng the PowerShell way
Data is the Oil of the 21th century as The Economist once titled. In a perfect world this data is stored in the perfect data model, either on prem or in the cloud, nicely formed and ready to use. Right? But we live in a world that is far away from this. Data is everywhere. It is in SharPoint Lists, CSV Files, Excel Files, maybe in your System, maybe in another Application, even in your Active Directory. Often there are requirements to transform this data from one Data Storage to another just to sync data between different sources or just because the boss wants some Excel file (sigh). A big Data Transformation Solution like SSIS or Azure Data Factory might not always be the best solution to accomplish these tasks. Join german Data Platform MVP Frank Geisler in a demo centric session where he demonstrates how to transform data between different data sources with PowerShel, dbatools and ImprortExcel and do all this little transformations in the blink of an eye. And remember your Boss waiting on his Excel Sheet? Even this can be archeived easily through PowerShell!
Real-time Analytics with Microsoft Fabric
Real-time Analytics in Fabric leverages top grossing Azure services like Event hub, Azure Stream Analytics and Azure Data Explorer that have been fused together into an integrated experience with Eventstream and KQL Database. This session will go behind into the KQL language and some of its unique capabilities of analyzing and joining billions of records.
Devang Shah, Fabric CAT PM at Microsoft who is focussing on Azure Data Explorer (Kusto) and long time Data Platform MVP Frank Geisler will demonstrate the capabilities of ADX in Fabric with a massive demo: As per FlightAware, there are about 9000-10000 flights in air at any given point in time. Certain countries mandate that aircraft must fly above 2500 feet in residential zones. Wondering what flights and altitude levels have go to do with Real-time Analytics in Fabric. In this session, you will see how billions of data points are stream ingested into Real-time Analytics, analysed at scale using advanced geospatial and timeseries analysis queries and then visualizing it all in Power BI in near real-time. With this setup, we are preparing a dashboard for port authorities of a town that can monitor the flights that are violating the noise control altitude that has been put in place by the city.
Data Community Austria Day 2024 Sessionize Event
SQL Saturday Oregon/SW Washington 2023 Sessionize Event
Data Relay 2023 Sessionize Event
Frank Geisler
GDS Business Intelligence GmbH
Lüdinghausen, Germany
Links
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