Browsed by
Month: July 2026

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.