Azure SQL Managed Instance is fully managed SQL Server instance hosted in Azure cloud. Managed Instance introduces some limits such as max log write throughput that can slow down your workload. In this post you will see how to identify write log throughput issue on Managed Instance.
The post Identify log write limits on Azure SQL Managed Instance using QPI library appeared first on SQLServerCentral.

Dive deep into the powerful SQL window functions, LAG() and LEAD(). Explore their intricacies, discover real-world examples, and avoid common pitfalls.
The post SQL Window Functions Series: LAG() and LEAD() appeared first on SQLServerCentral.

This article looks at the basics of the OVER() clause and how the PARTITION section works.
The post Window Function Basics - PARTITION BY appeared first on SQLServerCentral.

The rise of cross platform databases which are both on-premises and in the cloud, alongside decreasing customer satisfaction and trust in digital channels, has increased the importance - and value - of enhanced database monitoring. Find out how using a database monitoring tool creates value for the whole organization.
The post How using a database monitoring tool helps DBAs create value for the whole organization appeared first on SQLServerCentral.

This article covers how to use the different date and time functions when working with Spark SQL.
The post Learn Spark SQL Date and Time Functions appeared first on SQLServerCentral.

Cardinality estimation (CE) is a process used by the query optimizer to estimate the number of rows returned by a query or sub-part of a query. These estimates rely on two underlying things: statistics about the data and a set of assumptions—known as the model.
The post Cardinality Estimation Feedback in SQL Server 2022 appeared first on SQLServerCentral.

Welcome to part twenty of the plansplaining series. It has been a long time since I last wrote a plansplaining post, partly because of my health, but also for a large part because I was out of ideas. But recently I decided to dig a bit deeper into a feature that was released in SQL Server 2017 and that I had so far not played with: SQL Graph.
The post Plansplaining, part 20. SQL Graph (part 1) appeared first on SQLServerCentral.

This article examines how GitHub Copilot might be used when working with T-SQL Code.
The post GitHub Copilot - Our Best Ally for T-SQL appeared first on SQLServerCentral.