PIWONKA
Code, Coffee & Creative Chaos
Wer ich bin
Noch kein About-Eintrag.
Aus dem Blog
How Typing "Ö" Teleported Me to Greenland (and Why I Want to Stay There)
29.05.2026
A "Ö" in the country field led to Greenland instead of Austria. But with the current heat, that sounded more tempting than my actual home country. Thanks, unknown programmer! ❄️ #SoftwareBug #Heatwave
SQL Plan Advice: Analysen teilen per Link
29.05.2026
Analyze SQL Server execution plans using AI and share the results with colleagues via a link — valid for 30 days. AI-powered SQL Server execution plan analysis — save results and share them via a link. Valid for 30 days.
Asynchronous email delivery via Service Broker
24.05.2026
A classic scenario: you have a stored procedure that does something (creates an order, registers a user, whatever) and at the end, an email needs to be sent out. Instead of calling sp_send_dbmail directly (which blocks the caller until SMTP has responded), you place the email request in a queue and a worker sends it in the background.
E-Mail-Versand asynchron via Service Broker
25.04.2026
Klassisches Szenario: Du hast eine Stored Procedure, die irgendwas macht (Bestellung anlegen, User registrieren, was auch immer) und am Ende soll eine Mail rausgehen. Statt sp_send_dbmail direkt aufzurufen (was den Aufrufer blockiert, bis SMTP geantwortet hat), legst du die Mail-Anforderung in eine Queue und ein Worker schickt sie im Hintergrund.
Was ich mache
Demnächst mehr.