Dive deep into the details of part 2 in this series of creating a solution so Developers can start a restore of Production to test.

The Death of the GDPR

by Steve Jones

SQLServerCentral

The GDPR is struggling with enforcement against some of the larger tech companies. Steve thinks this is a problem, but it might not matter for smaller companies.

Power BI and The Matrix: A Challenge

by Additional Articles

SimpleTalk

The Matrix is one of the many built-in visualizations found in Power BI. While the Matrix is easy to populate, filtering it is not so straightforward. In this article, Dennes Torres explains how to add a slicer that does the job.

Default Backups and Feature Awareness

by Steve Jones

SQLServerCentral

Default backup schemes for databases would be a nice enhancement.

Stairway to T-SQL: Beyond The Basics Level 3: Building a Correlated Subquery

by Gregory Larsen

SQLServerCentral.com

This stairway level will expand on the subquery topic by discussing a type of subquery known as a correlated subquery, and explores what a correlated subquery is and how it is different from a normal subquery.

How to Build an Efficient Request Process for SQL Server DBAs

by Additional Articles

MSSQLTips.com

Take a look at some of these DBA request examples and things you could do to improve your request process.

A tour of the Execute Package Task

by Gavin Campbell

SQLServerCentral.com

Integration Services (SSIS)

Introduces modular programming with the Execute Package task, and shows bi-directional parameter passing.

MDX (MultiDimensional Expressions) in 148 minutes

by arthur

SQLServerCentral

OLAP

If you want to understand the fundamentals of MDX in less than 3 hours - this article can be helpful.

Using Azure Data Studio with TFVC

by Steve Jones

SQLServerCentral

Azure Data Studio (ADS) is a lightweight IDE built on Visual Studio Code. I've written a few articles on how ADS works, shown here: Getting Started with Azure Data Studio Getting Comfortable Writing Code in Azure Data Studio Using Notebooks in Azure Data Studio Using Azure Data Studio with TFVC Using Azure Data Studio with […]