In this tip, I show a few pagination tricks to let users filter without killing performance.

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…

SQL Server 2025 introduced a new way to hit APIs from the engine, but is it better than all the quirky ways we've done this in the past?