SQLShack

Skip to content

SQL Server training

Data classification

SQL data classification – Add sensitivity classification in SQL Server 2019

October 31, 2018 by Rajendra Gupta

SQL Server 2019 offers powerful new features to help in safeguarding your data and complying with various privacy regulations, which we’ll be covering in this article

Auditing, Data classification, Security, SQL Server 2019

Follow us!

Popular

SQL PARTITION BY Clause overview
SQL Variables: Basics and usage
Different ways to SQL delete duplicate rows from a SQL Table
SQL Convert Date functions and formats
SQL WHILE loop with simple examples
Overview of SQL RANK functions
Understanding the SQL MERGE statement
SELECT INTO TEMP TABLE statement in SQL Server
How to UPDATE from a SELECT statement in SQL Server
The Table Variable in SQL Server
SQL Server functions for converting a String to a Date
SQL Server table hints – WITH (NOLOCK) best practices
SQL multiple joins for beginners with examples
SQL Server Common Table Expressions (CTE)
How to backup and restore MySQL databases using the mysqldump command
Understanding the SQL Decimal data type
How to identify and resolve SQL Server Index Fragmentation
SQL Boolean Tutorial
SQL Lag function overview and examples
Working with the SQL Server command line (sqlcmd)

Trending

SQL Server Transaction Log Backup, Truncate and Shrink Operations
Six different methods to copy tables between databases in SQL Server
How to implement error handling in SQL Server
Working with the SQL Server command line (sqlcmd)
Methods to avoid the SQL divide by zero error
Query optimization techniques in SQL Server: tips and tricks
How to create and configure a linked server in SQL Server Management Studio
SQL replace: How to replace ASCII special characters in SQL Server
How to identify slow running queries in SQL Server
SQL varchar data type deep dive
How to implement array-like functionality in SQL Server
All about locking in SQL Server
SQL Server stored procedures for beginners
Database table partitioning in SQL Server
How to drop temp tables in SQL Server
How to determine free space and file size for SQL Server databases
Using PowerShell to split a string into an array
KILL SPID command in SQL Server
How to install SQL Server Express edition
SQL Union overview, usage and examples

Solutions

Read a SQL Server transaction log
SQL Server database auditing techniques
How to recover SQL Server data from accidental UPDATE and DELETE operations
How to quickly search for SQL database data and objects
Synchronize SQL Server databases in different remote sources
Recover SQL data from a dropped table without backups
How to restore specific table(s) from a SQL Server database backup
Recover deleted SQL data from transaction logs
How to recover SQL Server data from accidental updates without backups
Automatically compare and synchronize SQL Server data
Open LDF file and view LDF file content
Quickly convert SQL code to language-specific client code
How to recover a single table from a SQL Server database backup
Recover data lost due to a TRUNCATE operation without backups
How to recover SQL Server data from accidental DELETE, TRUNCATE and DROP operations
Reverting your SQL Server database back to a specific point in time
How to create SSIS package documentation
Migrate a SQL Server database to a newer version of SQL Server
How to restore a SQL Server database backup to an older version of SQL Server

Helpers and best practices

BI performance counters
SQL code smells rules
SQL Server wait types

© Quest Software Inc. ALL RIGHTS RESERVED. | GDPR | Terms of Use | Privacy