This article looks at using triggers to audit and to prevent the performing of unintended actions.

Finding & Fixing Statistics Without Histograms

by Additional Articles

Brent Ozar Blog

statistics

Men Without Hats were awesome. Statistics without histograms are terrible, but now they're easy to find and fix.

HTTP Requests Using SQLCLR

by Eilert Hjelmeseth

SQLServerCentral.com

SQLCLR

Query web APIs directly in SQL Server with its CLR integration

Self-Healing ETL

by Steve Jones

SQLServerCentral.com

Editorial

AI might be coming to the ETL work near you.

Collecting Data with Elastic Database Jobs in SQL Azure

by Additional Articles

MSSQLTips.com

Azure

In this tip we look at how to collect data for Elastic Database Jobs and easily store the data in a central location for analysis and review.

Fifty Different Ways to Enact Data Privacy Laws?

by Additional Articles

SimpleTalk

GDPR

Now that the GDPR has gone into effect, many are wondering what will happen in the United States. California is the first state to enact similar legislation, called the California Consumer Privacy Act of 2018 (CCPA). In this article, William Brewer explains the history of the law, what it means for companies doing business with California residents, and how it compares to the GDPR.

Free Encryption

by Michael Coles

SQLServerCentral.com

Security

Free SQL Server 2000 Encryption for your data!!! Author Michael Coles has put together a tolljit and some XPs that you can use to encrypt your data with the Blowfish algorithm. It is hard to write good applications that encrpyt data and manage the keys and security. This will give you a great headstart on protecting your data.