Gartner released their 2018 Market Guide for Data Masking, providing an in-depth analysis of the market with recommendations and representative vendors – including Redgate. Gartner says that "Test data (or copy data) virtualization is a technology that is increasingly popular, when used in combination with SDM (Static Data Masking), to speed up the provisioning of and updates to target environments, in addition to significantly reducing the amount of storage required by these environments.”

What does Azure SQL DB Automatic Index Tuning actually do, and when?

by Additional Articles

Brent Ozar Blog

Azure

Azure SQL DB’s Automatic Tuning will create and drop indexes based on your workloads. Brent's latest blog post shows how to enable it and explains what it actually does.

Common Data Challenges

by Steve Jones

SQLServerCentral.com

Editorial

Steve wonders about the common challenges you may face.

Introducing SQL+ Dot Net

by Alan Hyneman

SQLServerCentral.com

SQL+.net is the first real innovation in data access for quite some time, and was built exclusively for SQL developers.

Back to Basics; Masking Address Data

by Additional Articles

Redgate

SQL Provision

Protecting Personable Identifiable Information is central to the compliance of numerous regulations which your organization may be subject to. In this article Grant Fritchey starts with the basics of obfuscating address data with the data masking technology in SQL Provision.

The Performance of Window Aggregates Revisited with SQL Server 2019

by Additional Articles

SimpleTalk

T-SQL

T-SQL window functions have been a fantastic addition to the T-SQL language. In this article, Kathi Kellenberger reviews how optimizations available in SQL Server 2019 can improve the performance of these functions.

Transform your SQL Server permissions

by Additional Articles

Redgate

SQL Census

SQL Census helps users understand who has access to their SQL Servers (including Active Directory groups) and simplify existing SQL Server permissions. A new feature reworks discrete user permissions into database roles, giving users the same effective rights in a more controllable structure. Download and use SQL Census (in preview) for free.