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.

Pages and Extents: Stairway to SQL Server Indexes Level 4

by David Durant

SQLServerCentral.com

We've now seen how indexed and non-indexed tables perform in queries, and established "logical reads" as the metric for query performance. Now it is time to explain why logical reads are an excellent metric and also explain what is actually being read.

The Data Incident

by Steve Jones

SQLServerCentral.com

Editorial

Google and Microsoft have plans for dealing with data incidents. Steve thinks you should as well.

One-way and Two-way Tabulation Example in SQL Server - Part 2

by Additional Articles

MSSQLTips.com

tabular

In this tip we demonstrate how to use dynamic SQL and stored procedures to simplify the computation with SQL of one-way and two-way tabulations.

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.