SQL Server Profiler has always been a great tool for tracing activity “under the hood” on a SQL Server and assessing its performance. One feature that helps us quickly set up a trace on our current ...

The much-used Microsoft SQL Profiler is a tool headed toward obsolescence. What options are available once the tool is deprecated? We examine SQL Server Extended Events as a possibility. The ...

In an earlier blog I talked about the difference in mentality between the typical developer and the typical DBA. One of the characteristics of the DBA is the distrust of the Microsoft Wizards. “Give ...

SQL Server 2025 gives developers new ways to work with text, JSON, real-time data changes and AI-ready vector data. Microsoft MVP Leonard Lobel explains why he considers it the most significant SQL ...