As I was testing the LINQ to SQL functionality in Visual Studio 2008, I found myself missing the SQL Query Builder. For the relatively simple three-table inner join SELECT queries I needed, I was ...

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 ...

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 ...

So let’s take a look at Report Builder… If you have used Report Builder in SQL Server 2005, you will know that it’s a powerful tool for quickly generating sophisticated reports from ...

A pass-through query allows you to speak to a non-SQL Server database. Traditionally, a pass-through query is written in the server’s native dialect and then passed to the server. You can often ...

Microsoft today announced the general availability of the open source Data API builder (DAB), which provides REST and ... integrated with Azure SQL, SQL Server, PostgreSQL, MySQL and Cosmos DB, gives ...

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 ...