I am a technology enthusiast and software developer by profession. I am developing .Net/database based enterprise applications from past 3 years.


My skills includes C# ,ASP.NET,SQL Server 2008 and MVC . My areas of interests are database development and application software development using Microsoft Technologies.

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