A few years ago I had a requirement to allow both developers and customers to see rows from a table used to store error information while making sure that any PII, PCI or similar sensitive data was not displayed. The tolerance for “oops” was low! This article presents one way to solve the challenge by […]

Encryption Gets Broken All the Time

by Steve Jones

SQLServerCentral

Encryption

There are contests to break encryption algorithms taking place all the time. Another one was completed recently.

SQL Monitor Roadtrip: Preparation

by Additional Articles

Redgate

Setting up SQL Monitor without a bit of preparation work is a bit like embarking on a road trip without first learning to drive. Phil Factor show the essential kit and route maps you need for the journey.

Tracking Underlying Object Changes in Views

by Additional Articles

SimpleTalk

Views in SQL Server are used to simplify writing queries and managing security, but’s it’s easy for views to eventually get out of sync with the underlying tables. In this article, Edward Pollack shows how to overcome this problem.

Is Now the Time to Learn?

by Steve Jones

SQLServerCentral

With many of us locked down, is now the time you want to learn something?

A Remote Work Guide

by Steve Jones

SQLServerCentral

Telecommuting

This week Steve talks a bit about working remotely, which is something more of us are doing these days.

Representing XML data in SQL Server

by Diogo Castro

SQLServerCentral.com

SQL Server

In this article, we will see how to use the FOR XML statement in SQL Server to represent the result of queries in XML format.

Creating or Altering an Objects with a Single Statement

by Additional Articles

Database Journal

Do you get tired of having your CREATE PROCEDURE statement failing if the stored procedure already exists? If you are like me then you probably hate this as much as I do.