Browsed by
Category: Database Development

Connecting GitHub Copilot in SSMS using GitHub Enterprise or Business

Connecting GitHub Copilot in SSMS using GitHub Enterprise or Business

Comments 0 Comment

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

Comments 1 comment

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.

A surprised man in a light blue shirt holds his head in shock while looking at a glowing number zero. Next to him, a SQL expression “CAST('' AS INT)” and a red error sign transform into the number 0 through a lightning‑like arrow, illustrating the unexpected conversion of a blank string to zero.
Accidental Conversion: Blank converts to 0

Accidental Conversion: Blank converts to 0

Comments 0 Comment

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

Review SQL days: Poker ist kein Glücksspiel – zumindest nicht für den SQL-Server

Review SQL days: Poker ist kein Glücksspiel – zumindest nicht für den SQL-Server

Comments 0 Comment

7.10.2025 – Torsten AhlemeyerSlides/Demos: Downloads – arelium – Wir holen mehr aus Ihren Daten heraus English Version So einen Typen wie Torsten Ahlemeyer triffst du nur selten. Ein echter Algorithmen-Geek, leidenschaftlicher Datenbankentwickler und zu jeder Schandtat mit dem SQL Server bereit. Ob Trickfilme animieren, Volksfest-Taschengeld strategisch investieren oder komplexe Logikrätsel lösen – Torsten bringt nicht nur technische Finesse, sondern auch eine gehörige Portion Kreativität mit. Sein Motto? „Warum nicht?“ – und das lebt er. Schach auf dem SQL Server? Klar….

Read More Read More