With SQL Server there are a variety of ways we have available to secure data within the databases, however if an attacker can gain access to the underlying data files we may be vulnerable to having that data interrogated. Similarly when we backup our databases these flat files could also be intercepted and restored elsewhere […]
Month: Jul 2022
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 […]
Andy Brownsword 