In this tip, I talk about an approach to achieve constant (O(1)) performance on every page instead of just the early pages. The approach isn't without its trade-offs, but if you're optimizing for runtime performance…

In this ongoing series on common problems in SQL Server, I explain many possible reasons for "Invalid Object Name" errors.

In the past, we've used xp_cmdshell and PowerShell to send Slack messages from the database. In SQL Server 2025, there's (arguably) a better way…