2024-06-17
8 reads
Articles
The CHECK() Constraint
One of the many ways a relational table differs from the file structures used by pre-relational storage systems is that the tables, rows and columns can have constraints on them. This allows you to reduce the types of bad data that can be loaded into your tables.
2024-06-17
Fine-grained Access Control for Stored Procedures
Fine-grained access control for stored procedures using a programmable database proxy
2024-06-14
1,111 reads
2024-06-14 (first published: 2018-12-20)
10,265 reads
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.
2024-06-14
Memory Grant Feedback Persistence in SQL Server 2022
By using input from real memory consumption during query execution, Memory Grant input Persistence in SQL Server 2022 is a potent feature that helps optimize query performance. In order to improve the accuracy of memory grant calculations for subsequent executions of the same or comparable queries, SQL Server gathers and stores this information.
2024-06-12
732 reads
PostgreSQL is Now Faster than Pinecone, 75% Cheaper, with New Open Source Extensions
Two new open-source extensions from Timescale make PostgreSQL even better for AI applications, unlocking large-scale, high-performance AI use cases previously only achievable with specialized vector databases like Pinecone.
2024-06-12
392 reads
Snake draft sorting in SQL Server, part 4
In the previous posts in this series (part 1, part 2, part 3), I described how I have optimized a long-running set of routines by processing databases, tables, and even subsets of tables in parallel. This leads to many separate jobs that all kick off at roughly the same time
2024-06-12
How to Set Up Microsoft Fabric Database Mirroring for Azure Cosmos DB
This article shows how to configure database mirroring from CosmosDB to Microsoft Fabric.
2024-06-10
517 reads
How to Sort String Date Values on a Power BI Slicer Visual
In this article, we look at how to build a slicer visual in Power BI and how to create a custom sort order for the slicer values.
2024-06-10
Blogs
Async stats update causing blocking
By Zikato
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
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
A couple of weeks ago, a developer came to me and wanted to know...
Forums
Working with SQL Server in Visual Studio Code
Comments posted to this topic are about the item Working with SQL Server in...
Five Years and Counting
Comments posted to this topic are about the item Five Years and Counting
A Lack of Memory Grant Feedback Persistence
Comments posted to this topic are about the item A Lack of Memory Grant...
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