Microsoft's Abdullah Mamun and Kendal Van Dyke break down how SQL's recent updates are giving database pros new ways to take control of their data. For those who are in Microsoft's SQL Server ...

Thomas LaRock: "Without a basic understanding of wait events and how the occur, you will waste a lot of time trying and guessing at how to improve the performance of a query." Optimizing SQL Server ...

Microsoft SQL Server installation is simple when system requirements and edition choices are planned.Choosing the right authentication mode, such as ...

SQL Server 2022 is a core element of the Microsoft Intelligent Data Platform and now it comes with new features. The platform seamlessly integrates operational databases, analytics, and data ...

As I described here, Power BI can send SQL queries in parallel in DirectQuery mode and you can see from the Timeline column there is some parallelism happening here – the last two SQL queries ...

The daily routine of an IT professional remains largely reactive. A lot of time and budget is spent responding to tickets, limiting the time that we spend creating systems that drive growth and ...

SQL Server 2019 has inched slowly towards an official launch, with a Release Candidate released back in August with a refreshed build pushed out a bit more than a week later. Today, Microsoft has ...

Microsoft announced the first release candidate (a.k.a. RC1) for SQL Server 2017 on Monday, July 17 th. Release candidates are not a final and finished product, but they are feature complete. No new ...