Microsoft has added a group of features called Intelligent Query Processing to SQL Server 2017 and 2019. In this article, Greg Larsen explains one of the features, Scalar UDF Inlining.

New release: Mask SQL Server data 3x faster with Data Masker 7

by Additional Articles

Redgate

data masking

In the latest version of Data Masker for SQL Server, it’s now much easier to rapidly identify sensitive data that needs masking, set up appropriate rules, see which masking rules are applied to which column, and locate what sensitive data you've yet to mask.
We’ve also improved the performance of commonly used masking rules, which lets you run masking operations 3 times faster.

Automatic Redaction of PII

by Steve Jones

SQLServerCentral

Amazon is providing automatic redaction of PII data in there transcription service.

Mean Median Mode using SQL and DAX

by gourishankar

SQLServerCentral

This article explains how to calculate the important statistical functions, MEAN, MEDIAN, and MODE, in both T-SQL and DAX.

Reviewing Your Past Efforts

by Steve Jones

SQLServerCentral

Career Growth

Today Steve starts a mid year review of his career goals and encourages you to do the same.

Enterprise Insights from the 2020 State of Database DevOps report

by Additional Articles

Redgate

DevOps and Continuous Delivery (CI/CD)

17% of Enterprise respondents in this year's State of Database DevOps survey reported that DevOps has been adopted across all projects in their organization. This year’s State of Database DevOps report gave us some great insights into the landscape of Database DevOps. Kendra Little walks us through those insights specific to Enterprise organizations.

Introduction to Azure SQL Database Auto-Failover Groups

by Additional Articles

Database Journal

Azure SQL Database offers a number of resiliency features that deliver a mix of high availability and disaster recovery capabilities

New: 2020 State of Database DevOps report

by Press Release

Redgate

DevOps and Continuous Delivery (CI/CD)

Now in it’s 4th year, the State of Database DevOps report continues to deliver valuable insights. In the report, you will learn multiple tactics to improve the quality of database code deployment, whether it is by changing the type of environment used for development, enhancing your code review practices, or your change management/approval practices.