The next release of Microsoft SQL Server, announced as SQL Server 2017, is available for download in CTP2 at http://tinyurl.com/SQLvNextLinux and offers many cool new ...

In this two-part series, I'll tell you about some improvements Microsoft is making in SQL Server 2022 to improve cardinality estimates and deal with another common query optimization concern ...

Announcing SQL Server 2025—empowering customers to develop modern AI applications securely using their data, complete with ...

Simply join two SELECT statements with the UNION keyword to combine the results of two queries into a new table. When working with databases other than Microsoft's SQL Server, check the manual to ...

Effectively, those methods can become just thin wrappers around SQL queries. If you want to play with SQL Server’s JSON support (or the other big new feature in SQL Server 2016, temporal tables), you ...

In part 1 of my SQL Server 2022 features series, you learned about the improvements to the cardinality estimator component of query optimization. In this installment, you will learn about another ...