Once you’ve got a healthy collections of reports hosted in Reporting Services there’s usually a requirement to deliver these out to end users via different methods such as via email, or in our example to a file share. Delivering to a file share requires account credentials which would have permissions to the specified share. We […]
Categories
T-SQL Tuesday #152 – It Depends
As Deborah’s invitation opens this month she quite rightly points out that there are a lot of professionals out there who have a few (passionate) opinions about what they do or the way they do it. This month we’re invited to … well, have a rant – a rant about those experiences which have shaped […]
Following on from previous posts where we looked at Dynamic Data Masking, how to use it, and the challenges we may encounter, there’s one last area I wanted to touch on. With the arrival of SQL Server 2022 the masking functionality has been extended so we have an additional masking function and more granular permissions […]
Categories
Challenges with Dynamic Data Masking
Recently we’ve been looking at Dynamic Data Masking and what it can achieve for us. With that said however, there are some drawbacks to how it works which its worth being aware of before you consider implementing it. Even in the official documentation it states that the feature “limits” exposure, can be used to “simplify” design, and […]
Categories
Dynamic Data Masking Patterns
When we initially looked at Dynamic Data Masking we used the default function to mask our data so it showed xxxx. With the masking however there are a few functions available to allow us to mask data in particular ways which may be of use depending on our use case. We’ll create a record to apply these masks against so […]
This month’s invitation comes from Mala who asks us about the T-SQL coding rules relevant for where we work. There’s certainly a lot of scope in this question and Mala links to a great set of posts from Robert Sheldon which cover quite a number of these points. Whilst larger businesses may well have matured standards in […]
Categories
Introduction to Dynamic Data Masking
Given the abundance of data we deal with day to day its increasingly likely that we’ll find ourselves storing items of a more sensitive nature. We may only deal with details sensitive about our business such as suppliers or profitability, but when that increases – for example customer details – then we want to ensure […]
Categories
Testing Permissions with EXECUTE AS
When you’re developing a new database solution you’ll inevitably want to apply some security to that data. If you have complex security requirements with users being members of multiple groups or implementing multiple roles within the database it can become tricky to ensure that everything is working exactly as you like. It’s certainly a hassle […]
Categories
Additional Temporal Table Features
We’ve recently been looking at temporal tables, how they work, we query them and how to modify them. All of these are consistent since the feature was added in SQL Server 2016. There are however a couple of extra features which were added in 2017 to make these even more usable. Let’s use our previous […]
Categories
Modifying Temporal Tables
Recently we’ve been looking at temporal tables including the basics for using them and options for querying them. Continuing with this theme – and given that tables rarely remain static – we’ll look at what we might need to consider when modifying their structure. As with the previous posts we’ll start our with our sample […]
Andy Brownsword 