In SQL Server 2017, automatic plan correction was added, which allows for the database engine to automatically use the "last known good plan" for a query that has suddenly regressed in performance.

SQL Server comes with a feature called Query Store, which provides some performance details, including wait information. For more deeper diagnostic information there are a handful of third-party ...

In earlier versions of SQL Server, after selecting a join algorithm, SQL Server had to process it even if a better alternative might be available. In SQL Server 2017, the query optimizer can now sense ...

Microsoft has open sourced a .NET 5 C# Language Extension for SQL Server, allowing developers to work with relational data in the company's flagship programming ... external code. While such code ...

Code execution is isolated from the core engine processes, but fully integrated with SQL Server query execution. This particular language extension enables secure execution of Java code for a range of ...