Permissions and Security in Dynamic Data Masking (2020-08-19)

 SQLServerCentral Newsletter for August 19, 2020 Problems displaying this newsletter? [View online](. [SQL Server Central]( Featured Contents - [Permissions and Security in Dynamic Data Masking - Step 4 of the Stairway to Dynamic Data Masking]( - [Redgate Streamed Returns]( - [A One-Slide Summary of the Differences Between TDE and Always Encrypted]( - [Free eBook: SQL Server Transaction Log Management]( - [From the SQL Server Central Blogs - My First Hand-built AWS CodePipeline]( - [From the SQL Server Central Blogs - Decoding Helm Secrets]( Question of the Day - [Finding the Average Sale in R]( The Voice of the DBA  Daily Coping Tip Contact a friend to let them know you’re thinking of them I also have [a thread at SQLServerCentral]( dealing with coping mechanisms and resources. Feel free to participate. For many of you out there working in a new way, I'm including a thought of the day on how to cope in this challenging time from [The Action for Happiness Coping Calendar](. My items will be on [my blog](, feel free to share yours. Summer Reading I love to read. Ever since I was a kid, I've almost always had books nearby. In fact, I used to go to the PASS Summit with 5-6 books in my suitcase, just in case I went on a reading spurt while I was there. Every year, I used to love to see Paul Randal's summary of his reading ([2019 here](). While I don't do the data analysis that Paul does, his post did inspire me to use GoodReads and track my own reading. Last year, I read 128 books, most of which were fiction. I lean that way, as a way to escape from the chaos of life. So far this year I'm up to 57, though most of that was my sabbatical and the early pandemic times. Now I'm busy and slowing down the reading. We're nearing the end of summer, a time when I've usually read less as I'm outdoors more. Perhaps that's the same for many of you, but it will get cold, and I assume most of you will find free time at some point in your life. Today I'm wondering if there are books you recommend for people to read in the technology area. What books have you enjoyed that are based around technology? I ran across [a post from Frank Denneman](, asking about your favorite tech novel. I've read a few he notes, and added a couple others to my list. I also listened to [Kendra's podcast on software development](, where she mentions the summer book club from IT Revolution where people are reading [The Unicorn Project](. I do recommend that one and [The Phoenix Project](. Give us a recommendation today if you have one for a novel that you think of when I write "technological thriller." I'll leave two here that I enjoyed. [Cryptonmicon]( from Neil Stephenson. It's an interesting look at encryption and technology. The other one that comes to mind when I think of technology novels is [Ready Player One](. Maybe because I grew up in the 80s, but the whole idea of learning, living, and working in a computer reality, while still using computers to do things, was very enjoyable. If you saw the movie, read the book. It's much better. Steve Jones - SSC Editor [Join the debate, and respond to today's editorial on the forums](   Featured Contents [Stairway to Dynamic Data Masking]( [Permissions and Security in Dynamic Data Masking - Step 4 of the Stairway to Dynamic Data Masking]( Steve Jones - SSC Editor from SQLServerCentral.com Learn about the permissions associated with Dynamic Data Masking as well as some of the security implications of using this feature. [Redgate Streamed Returns]( Additional Articles from Redgate Our virtual community event is back with a global feel. Featuring speakers including Donovan Brown, Abel Wang, Kendra Little & Damian Brady, we have a full day of live content & networking opportunities, spanning world-wide time zones. So, wherever you are in the world, join us live on Wednesday August 26. [A One-Slide Summary of the Differences Between TDE and Always Encrypted]( Additional Articles from Brent Ozar Unlimited Blog Read a One-Slide Summary of the Differences Between TDE and Always Encrypted from Brent Ozar. [SQL Server Transaction Log Management eBook Download]( [Free eBook: SQL Server Transaction Log Management]( Press Release from Redgate When a SQL Server database is operating smoothly and performing well, there is no need to be particularly aware of the transaction log, beyond ensuring that every database has an appropriate backup regime and restore plan in place. When things go wrong, however, a DBA's reputation depends on a deeper understanding of the transaction log, both what it does, and how it works. From the SQL Server Central Blogs - [My First Hand-built AWS CodePipeline]( Grant Fritchey from The Scary DBA I’ve just completed my first, successful, AWS CodePipeline. I’m sorry to say it took me weeks to figure out just how simple this was. Frankly, it’s embarrassing. I already... From the SQL Server Central Blogs - [Decoding Helm Secrets]( dbafromthecold@gmail.com from The DBA Who Came In From The Cold Helm is a great tool for deploying applications to Kubernetes. We can bundle up all our yaml files for deployments, services etc. and deploy them to a cluster with...   Question of the Day Today's question (by Steve Jones - SSC Editor):  Finding the Average Sale in R I have a dataframe in R, called sales, with a column that stores the revenue amount (Revenue). I want to get the mean of all rows in this dataframe. Which expression will return this? Think you know the answer? [Click here]( and find out if you are right.    Yesterday's Question of the Day (by Steve Jones - SSC Editor) Replacing sysaltfiles I have old code that queries sys.sysaltfiles, which is a holdover from SQL Server 2000. What new DMV replaces this system table?  Answer: sys.master_files Explanation: The mapping for this table is to sys.master_files to get information about database files. Ref: Mapping System Tables to System Views (Transact-SQL) - [Discuss this question and answer on the forums](    Database Pros Who Need Your Help Here's a few of the new posts today on the forums. To see more, [visit the forums](. --------------------------------------------------------------- SQL Server 2017 - Administration [SQL Script Help]( - I am looking for a script  that can return the following values for each of the databases in my instance: Object ID, Object Type, Database Name, Table Name, Schema Name, Index Name, Table Create Date, Table Modified Date, Row Count, Total Pages, Used Pages, Data Pages, Total KB, Total MB, Total GB, Used KB, Used […] SQL Server 2016 - Administration [multiplied columns from Oracle linked server]( -  Wasn't sure exactly where to put this one... We populate an Oracle data warehouse each night, and we connect to it via Linked Server connection. It works perfectly well for the most part. One weird thing though... when I want to look at the structure of a table on the Oracle side, I go […] [Delete only one record takes 20 seconds and have to delete 11000]( - Hi, i need some help. Server 2016, 96gb of ram, 24 cpus, and so. One table with about 20 columns, no special columns at all. 36 millions records and a clustered index. Deleting one record by id in the clustered index takes 20 seconds, 2 records take 40 seconds and so. The plan shows 98% […] SQL Server 2016 - Development and T-SQL [Sum function in CTE is not calculating the right balance]( - I have table with all charges and payment the charges are 'c' and payments r, f, d. The charges have positive a negative amount and the payments positive a negative amount as well. When I query the table for just one student and add the amount I have the right balance, something is wrong with […] [Improving MSOLEDBSQL Connections]( - When using the Microsoft OLE DB Driver for SQL Server (MSOLEDBSQL) in the Import Wizard, I've noticed it takes much longer to import data compared to using the Native Client. Are there any properties you can change to help speed this up? Administration - SQL Server 2014 [Change dbowner]( - Can we change the dbowner to system databses ? if yes how can we proceed? Development - SQL Server 2014 [Send me an email if this job run longer than 30 minutes]( - Hi I have a job that I need to be notified/emailed if it runs longer than 30 minutes. What is the best way to do that? SQL Server 2019 - Administration [2019 Transaction log size increase during index maintenance]( - Hi I have recently migrated our 2018 databases from 2016 servers (VMWare onsite) to 2019 servers (VMWare AWS) and added TDE Encryption to the mix. During the nightly index maintenance the log files expand as expected, however onsite (1016) the log files rarely go over 9gb however they now expand to 35gb (2019) Does TDE […] [Job that runs slow how to use more CPU]( - We have a web application job that runs from web calling to update database on a SQL server 2017 box. it is an over night job. The job runs slower after this weekend. it runs 5 hours, now goes to 9 hours. But we see the RAM and CPU utilizes only avarage 5% on the […] [SQL server SSRS 2019]( - Does SQL server 2017 reporting SSRS work with reports that has SQL server 2019 data sources?  Thanks SQL Server 2019 - Development [Getting columns for sys. tables]( - I have a data dictionary project. I can easily get the data tables and their columns, as well as Views. For Views I can get the table and column if its a user table. However some Views are based on system tables. i.e.: sys.columns, sys.objects which do not come out in the table query, and […] Azure Data Factory [COPY Activity Failing]( - Hi All I am copying from DLS to SQLMI and my COPY activity is failing. It just says as failed and i have no other information. Can someone please guide me as where to look for more info? Thanks Reporting Services [2017 change report button text]( - Hi Is there a way that I can change the "View Report" button text in SSRS 2017? At present it reads "view report" and I would like to change it to "Apply" Thanks, Derek [SSRS conditional reporting]( - Hi, I have a SSRS report and I am using Email delivery type as option for subscription. I want to send the report to different recipients based on parameter values which comes from a SQL query. I set up report parameters in the subscription page. Resource name Enter value (null ) as shown in Capture1 […] Integration Services [SSIS Oracle destination using VS 2017]( - Trying to connect oracle destination but no luck. Has anyone connecting Oracle in SSIS using VS 2017? Please advise?   [RSS Feed]([Twitter]( This email has been sent to {EMAIL}. To be removed from this list, please click [here](. If you have any problems leaving the list, please contact the webmaster@sqlservercentral.com. This newsletter was sent to you because you signed up at SQLServerCentral.com. ©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. webmaster@sqlservercentral.com  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -