SQLServerCentral Editorial

Baseball Everywhere

Last week was supposed to be my turn to curate Database Weekly and write an editorial to go along with it. Graciously, Mr. Louis Davidson (@drsql) offered to switch weeks while I was in Cambridge, England with most of the Redgate Marketing team for our yearly global gathering at HQ. As a remote worker on […]

External Article

Power BI Treemap Chart Step-by-Step Tutorial

Microsoft Power BI Desktop provides a wide variety of visuals to its users. Sometimes, one wants to conduct a comparative analysis, a simple way to explore the relationship between the data categories within a set hierarchy. Hence, when a decision revolves around understanding the relationship of each element, this visual can provide an insightful analysis. This article will highlight all the steps to create a treemap chart in Power BI Desktop.

Blogs

Async stats update causing blocking

By

I recently encountered an issue where an index rebuild set to wait_at_low_priority ended up...

Level Up Your SQL Skills: The Best Intermediate to Advanced Courses

By

In the data-driven landscape of 2024, advanced SQL isn't just a nice-to-have, it's a...

Query deadlock info in Azure SQL DB

By

A couple of weeks ago, a developer came to me and wanted to know...

Read the latest Blogs

Forums

“user_scans” of table “sys.dm_db_index_usage_stats”

By Meera

I am trying to find answer to the below. What exactly the scan means...

how to assign studentid from one table to other one? please

By Zond Sita

Good Morning,   how to assign query one results to query 2 student id,...

Working with SQL Server in Visual Studio Code

By Daniel Calbimonte

Comments posted to this topic are about the item Working with SQL Server in...

Visit the forum

Question of the Day

A Lack of Memory Grant Feedback Persistence

SQL Server has added an Intelligent Query Processing feature called Memory Grant Feedback. In SQL Server 2022, this can be persisted across queries to improve the performance of future executions. In SQL Server 2022, when is memory grant feedback not persisted if the plan is evicted from cache? (choose 2)

See possible answers