PIWONKA
Code, Coffee & Creative Chaos
Wer ich bin
Noch kein About-Eintrag.
Aus dem Blog
T-SQL: Cursors vs. WHILE Loops – When to Use Which?
09.06.2026
In the world of T-SQL (Microsoft SQL Server), the unwritten law is: "Think in sets, not in rows." However, there are scenarios where row-by-row processing is unavoidable. When that happens, the question arises: Cursor or WHILE loop?
T-SQL: Cursor vs. WHILE-Schleifen – Wann verwendet man was?
09.06.2026
In der Welt von T-SQL (Microsoft SQL Server) gilt das ungeschriebene Gesetz: „Denke in Mengen (Sets), nicht in Zeilen.“ Dennoch gibt es Szenarien, in denen eine zeilenweise Verarbeitung unumgänglich ist. In diesem Fall stellt sich die Frage: Cursor oder WHILE-Schleife?
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: Now with a Share Feature
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.
Was ich mache
Demnächst mehr.