SQL Server 2019 has introduced several new features that offer improved performance. The optimizer continues to evolve and get smarter.

Keeping Unique Aliases

by Steve Jones

SQLServerCentral

software development

Steve prefers having standards, and today notes that aliases should be included in your standards document.

Your First Pipeline with Azure Data Factory

by Richard Swinbank

SQLServerCentral

Azure Data Factory

Learn how to build your first Azure Data Factory Pipeline

Getting Started with CQRS – Part 3

by Additional Articles

SQLServerCentral

Diogo Souza completes his series on CQRS. He demonstrates Event Sourcing to capture the data as it flows through the system which can then be analyzed without affecting the source.

A Pattern Based Approach to Masking Errors

by Andy Warren

SQLServerCentral

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.