#SQL Server

Databases & Backend

SqlDependency in .NET: Ditch Polling, Let SQL Server Ring the Doorbell

Your .NET app doesn't need to beg SQL Server for updates—SqlDependency makes the database shout when data changes. It's efficient, real-time, and criminally underused.

Databases & Backend

Azure SQL Cross-Database Queries: The Elastic Query Workaround Nobody Asked For

You'd think databases on the same Azure SQL server could talk via three-part names, like on-prem. Wrong. Microsoft's Elastic Query workaround is here—and it's clunky as hell.