AI Amazes Me Most Where I Need It Least

AI Amazes Me Most Where I Need It Least

I’m still in the crawl phase of AI adoption, and I’m increasingly unsure why AI feels so different across my skill areas. GitHub Copilot feels almost magical when I work in technologies I barely know, because it helps me build things I wouldn’t normally attempt. In C# or Java, the acceleration is real and noticeable. In T SQL, however, AI often feels less impressive, and I keep wondering whether that’s due to my higher expectations or simply how I work. I see every inefficiency immediately, which makes the output feel more like review work than acceleration. That contrast makes me question how I can use AI more effectively in the areas where I’m already an expert. I’m still trying to understand why the gap feels so large and how to close it. Even so, AI already enables projects outside my comfort zone that I wouldn’t have tackled before.

Connecting GitHub Copilot in SSMS using GitHub Enterprise or Business

Connecting GitHub Copilot in SSMS using GitHub Enterprise or Business

If your organization uses GitHub Enterprise Cloud or GitHub Enterprise Server, there is one important step before signing in: SSMS must be configured to allow Enterprise GitHub accounts. By default, many users only see the standard GitHub sign-in option, which is typically used for personal GitHub accounts. Here’s the complete setup process. Step 1: Enable GitHub Enterprise Accounts in SSMS Open: Tools → Options → Environment → Accounts Enable the following option: Include GitHub Enterprise Cloud and GitHub Enterprise Server…

Read More Read More

#tsql2sday: When the Optimizer Runs Out of Time

#tsql2sday: When the Optimizer Runs Out of Time

When I review a query, one of the warning signs that immediately catches my attention is an EarlyAbortReason of TimeOut. While the query may still produce an acceptable execution plan, it often indicates that the SQL Server optimizer encountered a search space too large to explore completely. In this post, I examine how Early Abort events and the Optimizer Quantum can help identify overly complex queries, large join graphs, and optimization challenges before they become obvious performance problems.

Two Servers, One Script, Zero Surprises: Updating Power BI Report Server Safely

Two Servers, One Script, Zero Surprises: Updating Power BI Report Server Safely

Updating Power BI Report Server directly in production can be risky and painful to roll back. This post introduces a safer workflow using a dedicated test server and an automated sync script that mirrors your reports and data sources before any upgrade. Learn how this setup prevents downtime, simplifies testing, and makes Report Server updates predictable instead of stressful.

Accidental Conversion: Blank converts to 0

Accidental Conversion: Blank converts to 0

I write this blog post currently sweating in South Vietnam: Even the tap water is too warm here 🤣. There has been a lot of debate lately on LinkedIn whether AI should assist to write posts or not. For me as a non-native speaker it helps a lot. I also profit from restructuring my sometimes unwieldy thoughts 😉. Nevertheless this post is authentic and “hand written”. This is a story of an accidental conversion in a Data Warehouse load process…

Read More Read More

Mit Damon und Daphne ins Datenabenteuer: Data Literacy für Vorschulkinder

Mit Damon und Daphne ins Datenabenteuer: Data Literacy für Vorschulkinder

English version Manchmal führt einen das Leben an völlig neue Orte. Nach Vorträgen auf Konferenzen rund um Datenverarbeitung, Workshops für Code First Girls und Unterrichtseinheiten für Schüler*innen motivierte mich meine Frau, noch weiterzugehen und sogar Fünfjährige für Daten zu begeistern. Eine Herausforderung, die mich sofort gepackt hat. Kurz gesagt: Ja, es funktioniert. Und wie! Für meinen Kurs „Data Literacy for Kids – Mit Datenkompetenz ins KI‑Zeitalter“ beim Haus der Familie Heilbronn (18. & 19. April 2026) habe ich sogar mein…

Read More Read More

Power BI Reportserver Feature Showdown: Standard vs. Enterprise Edition

Power BI Reportserver Feature Showdown: Standard vs. Enterprise Edition

Power BI Report Server (PBIRS) is an important product — especially for organizations that need analytics on‑premises. From SQL Server 2025 onward, PBIRS is officially supported on SQL Server Standard Edition, making it accessible to a much wider range of deployments. It’s stable, reliable, and follows in the footsteps of SQL Server Reporting Services (SSRS). But it also comes with… quirks. If you want to jump straight to the feature comparison, click here:👉 Skip to the Feature Comparison If you’re…

Read More Read More

Making Paginated Reports Less Annoying: Excel Subscriptions and Semicolon CSV

Making Paginated Reports Less Annoying: Excel Subscriptions and Semicolon CSV

Every now and then I run into one of those long‑standing defaults in Power BI Report Server that feel like they’ve survived unchanged since the early SSRS days.A perfect example: email subscriptions for paginated reports still default to MHTML. Not exactly the format anyone is excited to receive in 2026. And yes — everything described in this post applies only to paginated reports, the report type formerly known from SQL Server Reporting Services (SSRS). Power BI reports (.pbix) are not…

Read More Read More

Local AI Adventures: I Came, I Saw, I Gave Up

Local AI Adventures: I Came, I Saw, I Gave Up

Often I scroll through LinkedIn, it feels like walking through an AI‑themed amusement park.There’s always someone proudly posting a glossy screenshot: “I built my entire Power BI dashboard with MCP servers and AI!”“Paginated reports? Done in minutes thanks to AI!”“My ticketing system now has a chatbot that basically runs the company!” It all looks so smooth, so elegant, so… suspiciously effortless. And of course, I wanted that too. In my head, the dream was clear: an AI apprentice sitting right…

Read More Read More

Erste Schritte mit der IMDb-Beispieldatenbank und DBeaver

Erste Schritte mit der IMDb-Beispieldatenbank und DBeaver

Manchmal braucht man einfach eine kleine Spielwiese, um SQL-Abfragen auszuprobieren. Genau dafür eignet sich eine Beispieldatenbank – und was wäre cooler als eine Mini-Version der IMDb? Erstellen der Datenbank Es gibt zwei Möglichkeiten: Nach dem Entpacken findet ihr darin die Datei imdb.db, die wir gleich brauchen werden. Das richtige Werkzeug: DBeaver Zum Arbeiten mit der Datenbank empfehle ich DBeaver. Das Programm ist kostenlos, läuft auf Windows und lässt sich bequem als Zip-Version herunterladen. Erste Schritte in DBeaver Fazit Mit wenigen…

Read More Read More