Team xTEN


SQLServerCentral Article

Better SQL Server Agent Job Failure Monitoring

SQL Server Agent has a built-in alerting process for when jobs fail, but the information it provides isn’t very useful. You’re only told which job, what time, who ran it, and which step failed. If you want to see why it failed, you have to review the job history manually. On a busy system with […]

5 (4)

You rated this post out of 5. Change rating

2020-10-29

7,538 reads

SQLServerCentral Article

Connecting to SQL Server with MuleSoft AnyPoint 3.9

I usually write about SQL Server, but I thought I'd share my experience of using SQL Server from MuleESB. If you haven't used Mule before, it's an open-source ESB (enterprise service bus), which also has a paid-for Enterprise version. I've been using it since 2015 and have been impressed with how quickly we can create […]

5 (5)

You rated this post out of 5. Change rating

2020-10-23

3,216 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

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...

Strange behavior passing a variable in XML.value

By PatLap

Hi,  anyone would know why as soon as I add a WHERE statement (even...

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