Brent Ozar's session for the PASS DBA Fundamentals virtual chapter.

AI Regulators

by Steve Jones

SQLServerCentral.com

Editorial

AI may help enforce the GDPR.

Generating Completely Random Sample Output from a Dataset

by Adam Aspin

SQLServerCentral.com

T-SQL

This short article shows a simple example of how to generate completely random sample output from a Dataset

Principles of Data Protection

by Additional Articles

SimpleTalk

Data Privacy and Protection

Protecting data in SQL Server is not as simple as setting a few properties. While there are great security features in SQL Server, such as Transparent Data Encryption, production data may end up in places throughout the organization. In this article, Brian Kelley talks about the best ways to secure data using the concept of least privilege.

Stairway to AlwaysOn Crossword

by Kenneth Fisher

SQLServerCentral.com

Editorial

This crossword puzzle is based on the contents of the Stairway to AlwaysOn.

Examples of using XQuery to update XML Data in SQL Server

by Additional Articles

MSSQLTips.com

What is the most efficient way to modify XML values? To allow for precise modification of XML nodes and values, the XQuery XML query language employs an extension known as the XML Data Modification Language (DML). The XML DML uses the XML modify() method, which makes use of three operational keyword sets: insert, replace value of, and delete. Seth Delconte takes a closer look.

Ensuring Each Client has a Full Set of Key-Value Pairs

by Steve Jones

SQLServerCentral.com

data integrity

In this piece, we find out about a business issue that can occur when using key value pairs in your database to describe information about other entities.