The Configured Data Masks for Dynamic Data Masking - Step 3 of the Stairway to Dynamic Data Masking (2022-05-04)

SQLServerCentral Newsletter for May 4, 2022 Problems displaying this newsletter? [View online](. [SQL Server Central]( Featured Contents - [The Configured Data Masks for Dynamic Data Masking - Step 3 of the Stairway to Dynamic Data Masking]( - [Working with MySQL Stored Procedures]( - [What is the Flyway Teamwork Framework?]( - [From the SQL Server Central Blogs - Power BI Performance Features]( - [From the SQL Server Central Blogs - Storage Field Day 23 – Fungible]( Question of the Day - [Azure SQL Database Backups]( The Voice of the DBA  Daily Coping Tip Meet a friend outside for a walk and a chat 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. Project Zero for Better Security Google started [Project Zero]( to study zero-day vulnerabilities in systems. They want to improve security and safety, at least from a software and hardware standpoint. Its mission is to make it more difficult to find and exploit issues i software. They published an update recently that showed [vendors patching their software quicker](, at least according to data from the last few years. The metrics show a change in patching from an average of 80 days a few years ago to 52 days in 2021. There were also patches that missed the 90-day deadline, though only one missed the 90-day time and also a 14-day grace period. They are also trying to help with the understanding of how well vendors are adapting to new challenges. I hope this pressures and inspires smaller vendors and even individual organizations to take security more seriously. I think that security is becoming *slightly* more important to vendors, especially as competition grows in any particular space. Vendors aren't necessarily looking to spend time and energy where they don't see a problem impacting revenue, but they do worry about customers abandoning their software, and a security issue is one reason for customers to look elsewhere. In the 2020s, there are plenty of customers that would consider changing software over security issues that don't get fixed. I saw another note that showed [more and more hackers are exploiting zero-day vulnerabilities](. Even if you think you have strong security, who knows when someone will misconfigure a firewall and expose your system. It's worth staying up to date, at least within the last patch for your critical systems. I certainly consider a database a critical system, and I'd include helper databases like Redis and Elasticsearch as critical systems. It's easy to delay patching when nothing seems to be broken. However, patches are like oil changes. When the system lets you know that maintenance is overdue, it's usually a catastrophic event. I like the disclosure and openness of groups like Project Zero and hope they start to pressure more software developers (and project managers) to promote secure coding along with quick patches for vulnerabilities. Steve Jones - SSC Editor [Join the debate, and respond to today's editorial on the forums](   Featured Contents [Stairway to Dynamic Data Masking]( [The Configured Data Masks for Dynamic Data Masking - Step 3 of the Stairway to Dynamic Data Masking]( Steve Jones - SSC Editor from SQLServerCentral.com Continuing with his look at Dynamic Data Masking, Steve Jones looks at the masking patterns available besides the default mask. [External Article]( [Working with MySQL Stored Procedures]( Additional Articles from SimpleTalk MySQL stored procedures are objects containing one or more SQL statements for reuse. They often contain business logic. Robert Sheldon demonstrates how to create and call stored procedures. [External Article]( [What is the Flyway Teamwork Framework?]( Additional Articles from Redgate My FlywayTeamwork PowerShell framework is designed to help get you started quickly with developing databases, using Flyway versioned migrations. It introduces a PowerShell task library, and automation, to take care of repetitive chores. It will also help you get to grips with the practicalities of using Flyway in team-based development. This article explains the basics of its design and provides a demo how to use Flyway to migrate a PostgreSQL database, while generating a high-level narrative of the changes made between versions. [Blog Post]( From the SQL Server Central Blogs - [Power BI Performance Features]( James Serra from James Serra's Blog It’s hard to believe but Power BI has now been available for over 10 years (see history)! Over the last few years there have been a number of new... [Blog Post]( From the SQL Server Central Blogs - [Storage Field Day 23 – Fungible]( kleegeek from Technobabble by Klee from @kleegeek I live my life in the field of information technology. Most of the topics that I work with are making databases speedy and more readily available. As such, most...   Question of the Day Today's question (by Steve Jones - SSC Editor):  Azure SQL Database Backups Azure manages automated backups of Azure SQL Database and Managed Instance. Which types of backups does the Azure platform make of your Azure SQL Database? 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) Migrating to Synapse I want to migrate a database to Azure Synapse Analytics in May 2022. Can I use the SQL Server Migration Assistant (SSMA)? Answer: Yes, but for Oracle databases only Explanation: The SSMS does support Azure Synapse Analytics, but only for Oracle at this time. Azure Synapse Analytics** ** This target is supported only by SSMA for Oracle. Ref: SQL Server Migration Assistant - [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 - Development [Which command will using to delete all rows from table truncate or delete ?]( - I work on sql server 2017 i need to delete all rows from table student_course but i don't know use delete from student_course or truncate table student_course table student_course studentid pk courseid pk table student table studentid pk table courses courseid pk --------------------------------------------- student_course table have relation with courses table and student table so which […] [Query nested JSON data]( - table structure create table dbo.commodityIndex(sucess varchar(10), [timestamp] varchar(100), [date] date, base varchar(10), rates decimal(10,2), unit varchar(10) ) JSON data is as follows: How do I query the nested piece in rates? declare @json1 VARCHAR(MAX); set @json1 = '{"success": true, "timestamp": 1650998580, "date": "2022-04-26", "base": "USD", "rates": {"USD": 1, "XAG": 0.042738743354897, "XAU": 0.0005276742457391, "XPD": 0.00047847992351816, "XPT": […] SQL Server 2016 - Development and T-SQL [query execution plan differ when run as a single query vs. in a sp]( - I have a SQL statement with a single int parameter. When i run it as a query, it uses index seek from both tables in the join and took seconds to finish. But if I put the same query in a stored procedure, and pass in the same parameter value 38176, it uses index scans […] SQL Server 2012 - T-SQL [My calculation with a CASE statement isn\'t working]( - I'm scratching my head over this. I'm sure it's something simple, but I'm stumped. I have the following T-SQL: DECLARE @MAX_naam AS varchar(MAX) = (SELECT SUBSTRING(MAX(naam),LEN(MAX(naam))-1,LEN(MAX(naam))) FROM incident); -- = 22 DECLARE @maxnaam_length AS int = LEN(@MAX_naam); DECLARE @num_zeroes AS int = 5 - @maxnaam_length; DECLARE @zeroes AS varchar = CASE WHEN @num_zeroes = 0 […] SQL Server 2019 - Administration [What are the tools available to replicate an SQL server, including a third party]( - In sqlserver we have replication which basically syncs our data between two disconnected database over the internet. so pls tell me what are the other tools availabel in the market like amazon sync and azure data sync etc etc. [Regarding Heterogeneous Database Replication]( - Team - Is Heterogeneous Database Replication still supported in SQL server? I am specifically looking for Publishing data To and From SQL server and SQL Anywhere(Sybase). if you have a good references, let me know. Thanks. SQL Server 2019 - Development [Is it correct that MS SQL automatically retrieves data to optimize the "SELECT"]( - Hello, Is it correct that MS SQL automatically retrieves data to optimize the "SELECT" statements? Example: If I have a table with 1 million records and I run SELECT for the first 1000 records, then for the next 1000 records and so on.... Is it right that MS SQL recognizes the pattern and preprocesses the […] SQL Azure - Development [Is this right approach to implement nested Transaction]( - Hello Everyone, I am using Microsoft SQL Azure (RTM) - 12.0.2000.8. I have a store procedure as below. ALTER PROC [dbo].[usp_SAP_to_IC] -- exec [dbo].[usp_transfer_on_premise_project_data_to_cp_database_IC_12] AS BEGIN TRY BEGIN TRANSACTION; EXEC [dbo].[usp_transfer_on_premise_project_data_to_cp_database_IC_12] EXEC [dbo].[usp_transfer_on_premise_project_data_to_cp_database_IC_10] EXEC [dbo].[usp_transfer_on_premise_project_data_to_cp_database_IC_7] COMMIT TRANSACTION; END TRY BEGIN CATCH INSERT INTO ExceptionLog ( ErrorLine, ErrorMessage, ErrorNumber, ErrorProcedure, ErrorSeverity, ErrorState, DateErrorRaised) VALUES (Error_Line(), Error_Message(), […] [Does "Azure SQL Managed Instance" support publication distribution of transactio]( - Hi, I want to implement transactional replication on a database which should be on "Azure SQL Managed Instance", where entry will be done. And the subscriber which will be read only and will be "on premises" (that is with our site offices) SQL Azure - Administration [in Azure SQL Managed Instance do we get sql server or we have to purchase and in]( - I am using aws rds where we get a sql server we have to just restore our database and we are good to go. pls tell me the the Azure SQL Managed Instance also works same for the above case.ss Amazon AWS and other cloud vendors [does aws rds supports pulication and distribution of sqlserver replicaltion]( - hi, i wanted to implement transactional replication or mearge replication on aws rds , but one artical said they only allow subscription , is it true, that is can i make publication and distribution on aws rds in any way? like if i make publication on rds and distribution on aws windows server. q2) is […] [What is the best way to execute ~100 I/O bound scripts?]( - As the title suggests I am looking into ways of executing a lot of scripts as fast as possible. This is something I’ve never done before so not entirely sure how to approach it just yet. Originally, I thought of setting up a cloud formation template with the same number of instances as there are […] General Cloud Computing Questions [host to client redirect]( - We are running a hybrid datacenter in MS Azure and on-prem. The users connect to the session hosts by MS Remote Desktop Services. The hosts are running Windows Server 2019. We need a way to redirect requests to open some file type on the loacl client. For example links should be opend with the brwoser […] Reporting Services [Adding a table with dynamic rows]( - I have a need to have a table in SSRS based off of a field in the dataset. There is a field (fquantity) that has a numeric value say 50. but the dataset only has 3 records in it. I need to create a table with say 5 columns and 50 rows. Fquantity will change […] Integration Services [How to Cast Big Int column to datetime2 or Varchar]( - I have SSIS Package , in the source query i am using parameters to pull data greater than from that date. Process is here. step 1 - Created Variable StdDate with datatype String. Step 2 - execute sql task to get the date column with datetime2(7) datatype from control table. Sample value looks like 2022-04-26 […]   [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  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -