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

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

For those of you still using SQL Server 2005, Microsoft will completely end support on April 12th 2016. You can head over here to check out upgrade guidelines, download migration tools, and read more ...

As today’s database administrators (DBAs) manage the complexity of modern database environments, particularly containerized systems, they must lean into smart automation to transform database ...

Troubleshooting your database system when it’s having problems is no longer enough. With the recent onslaught of audit requirements such as Sarbanes-Oxley, DBAs must stay on top of system and query ...

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

In an era defined by digital innovation, businesses face constant pressure to modernize, improve efficiency, cut costs and stay competitive. Amid this landscape, the strategic migration and ...