2024-06-17
2,812 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,452 reads
2024-06-14 (first published: 2018-12-20)
10,364 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
938 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
462 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
653 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
Data Technology Learning Resources
Hey all! Quick one here. Tracy Boggiano, awesome person that she is, has put...
How to use a Script Activity in ADF as a Lookup
In Azure Data Factory (ADF, but also Synapse Pipelines and Fabric Pipelines), you have...
Create a copy of an Azure SQL DB
Where I work, we will be migrating data from one set of databases into...
Forums
What Metrics Do You Collect?
Comments posted to this topic are about the item What Metrics Do You Collect?
Updating Sensitivity Classifications
Comments posted to this topic are about the item Updating Sensitivity Classifications
Set up a Windows Server Fail-over Clusters (As a Precursor to High Availability in Standard Edition)
By Stewart "Arturius" Campbell
Comments posted to this topic are about the item Set up a Windows Server...
Question of the Day
Updating Sensitivity Classifications
I ran this code on a column in my SQL Server 2022 database:
ADD SENSITIVITY CLASSIFICATION TO dbo.Customer.ContactEmail
WITH (
LABEL = 'Highly Confidential',
INFORMATION_TYPE = 'Contact',
RANK = CRITICAL
);
GO
I then realize I've made a mistake and run this:
ADD SENSITIVITY CLASSIFICATION TO dbo.Customer.ContactEmail
WITH (
LABEL = 'Highly Confidential',
INFORMATION_TYPE = 'Contact',
RANK = HIGH
);
GO
What happens? See possible answers