Database Weekly

SQLServerCentral Editorial

Personal Power

  • Editorial

Because of my job with Redgate (which I love and will never leave even after I’m dead), I spend a lot of time learning about compliance and all the new laws and regulations coming out of things like the GDPR and the CCPA (they changed the name evidently). However, I’m a nerd. I’m not a […]

5 (3)

You rated this post out of 5. Change rating

2020-02-08

144 reads

SQLServerCentral Editorial

Why Getting Data Right Matters

  • Editorial

An InfoWorld article from 2017 suggests that 80 percent of a data scientist’s job is cleaning and transforming data, and I believe this is probably only true for organizations that spend at least an average effort in designing and implementing their data storage. These persons who have trained to analyze data using complex math formulas […]

You rated this post out of 5. Change rating

2020-02-01

174 reads

SQLServerCentral Editorial

The New Year: A Chance to Start Over

  • Editorial

January 1st is the beginning of a new year thanks to Julius Caesar and Pope Gregory XIII. This date is somewhat arbitrary, and many religions and cultures celebrate their own beginning of a new year at different times. Even though these celebrations don’t fall at the same time, I think the sentiment is similar. The […]

5 (1)

You rated this post out of 5. Change rating

2019-12-28

109 reads

SQLServerCentral Editorial

How SQL Server Can Just Go Faster

  • Editorial

It’s rare to get a call from a customer telling you that the application is fast today and thanks for taking such good care of the database. Instead, you are more likely to hear complaints when things go wrong like slow running queries and timeouts. There is a lot to consider when trying to figure […]

5 (1)

You rated this post out of 5. Change rating

2019-11-30

561 reads

SQLServerCentral Editorial

A Faster tempdb

  • Editorial

I like to call tempdb the “workhorse” of SQL Server. I’ve heard some other people call it other terms that were not so flattering, but since I like to keep things positive, I’ll stick with workhorse. SQL Server uses tempdb for many things. The obvious uses are temp tables and table variables, but tempdb is […]

5 (3)

You rated this post out of 5. Change rating

2019-11-02

1,095 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

Strange behavior passing a variable in XML.value

By PatLap

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

What happened to my SSMS shortcuts in 20.1?

By Eric Mamet

I installed SSMS 20.1 and all my trusted keyboard shortcuts don't work anymore... <Ctrl>E...

logshipping is out of synch need to debug

By anoop.mig29

Hi We have logshipping which get out of synch in night due to purging...

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