Angela

I started out as a software developer back in 1996 in Denver, CO, doing Client/Server development in PowerBuilder. I am now a Data Architect, living in High Point, NC and I love what I do. I’ve worked with all versions of SQL Server since the infamous split from the Sybase code (a.k.a. version 4.21a). I’ve worn all the hats that come with dealing with SQL Server, developer to data architect and everything in between. Mastodon handle: @SQLSwimmer

Blog Post

Bits Buddies

SQLBits is fast approaching, in fact, Training Days start 2 weeks from today, on March 8, 2022. I’ve attended SQLBits before, as well as other large conferences, but I...

2022-02-22

20 reads

Blog Post

I Still Can’t Believe It!

I received my MVP award letter from Microsoft today. This will make the fourth time I’ve been awarded and I still can’t believe it.  I just wanted to help...

2021-07-01

20 reads

Blog Post

Data Weekender v3.1

I am super excited about this new version of Data Weekender, coming up on Saturday, May 15, 2021.  This will be the third time I have been selected to...

2021-05-08

15 reads

Blog Post

I’m Speaking at #DataWeekender

With all our in-person events cancelled for the foreseeable future, I was so excited to find that some community folks are not sitting back and waiting for the social...

2020-04-25

20 reads

Blogs

MSSQL Database Property LastGoodCheckDbTime to Get the Last Successful DBCC CHECKDB on a Database

By

Database Property LastGoodCheckDbTime to Get the Last Successful DBCC CHECKDB on a Database As one...

Dynamic Warehouse & Lakehouse Connections in Microsoft Fabric Data Pipelines

By

When you develop data pipelines in Microsoft Fabric (the Azure Data Factory equivalent in...

New Pluralsight Course - Certified Kubernetes Administrator - Performing Cluster Version Upgrades

By

We’re working through the major refresh of my Certified Kubernetes Administrator series at Pluralsight! The...

Read the latest Blogs

Forums

sp_whoisactive filtering

By Abhishek

I am experiencing difficulty filtering the results in the sp_whoisactive stored procedure when attempting...

Sensitivity Ranks

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Sensitivity Ranks

Fine-grained Access Control for Stored Procedures

By maxtardiveau

Comments posted to this topic are about the item Fine-grained Access Control for Stored...

Visit the forum

Question of the Day

Sensitivity Ranks

I want to use the ADD SENSITIVITY CLASSIFICATION DDL to mark some columns in my SQL Server 2022 database as PII. Can I use this code?

ADD SENSITIVITY CLASSIFICATION TO dbo.sales.price,
    dbo.sales.discount
WITH (
    LABEL = 'Highly Confidential',
    INFORMATION_TYPE = 'Financial',
    RANK = 'INTERNAL ONLY'
);

See possible answers