{"id":5955,"date":"2015-10-23T14:56:54","date_gmt":"2015-10-23T12:56:54","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-security-dynamic-data-masking\/"},"modified":"2015-10-23T14:56:54","modified_gmt":"2015-10-23T12:56:54","slug":"sql-server-2016-security-dynamic-data-masking","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-security-dynamic-data-masking\/","title":{"rendered":"SQL Server 2016 &#8211; Security: Dynamic Data masking"},"content":{"rendered":"<p>After my first blog on Security with <a title=\"Row level security\" href=\"http:\/\/dbi-services.com\/blog\/row-level-security-rls-is-also-coming-to-ms-sql-server\/\" target=\"_blank\">Row level Security<\/a>, I test the second Security new feature in the next version of SQL Server: <a title=\"msdn Dynamic Data Masking\" href=\"https:\/\/msdn.microsoft.com\/en-us\/library\/mt130841.aspxhttp:\/\/\" target=\"_blank\"><strong>Dynamic Data Masking<\/strong><\/a>.<br \/>\nI presented this new feature to my Oracle colleagues and I&#8217;m surprised that Oracle 12c has the same option known as <strong><a title=\"Oracle - Data Redaction\" href=\"http:\/\/www.oracle.com\/technetwork\/database\/options\/advanced-security\/index-1964787.html\" target=\"_blank\">Data Redaction<\/a><\/strong>.<br \/>\n<!--more-->The principle is simple: for some users, data are masked on-the-fly&#8230;<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/DDM01.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-4619 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/DDM01.png\" alt=\"Dynamic Data Masking Principle\" width=\"300\" height=\"217\" \/><\/a><br \/>\nCombined with the Transparent Data Encryption (TDE), you\u00a0 will never permit to let sensitive data in clear form in the database.<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/DDM02.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-4620 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/DDM02.png\" alt=\"Dynamic Data Masking Principle with TDE\" width=\"300\" height=\"211\" \/><\/a><br \/>\nThe masking is done on a column level by simple rules.<br \/>\nIt is very simple:<br \/>\nAs user, I asked to have the personal phone number of our new secretary but I received 0041-79-XXX-XX-XX&#8230; The phone number is masked! \ud83d\ude25<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/DDM03.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-4621 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/DDM03.png\" alt=\"Phone number masking sample\" width=\"300\" height=\"150\" \/><\/a><\/p>\n<h3>Masking Mode<\/h3>\n<p>In Oracle, you find <strong>4 masking mode<\/strong>:<\/p>\n<ul>\n<li><strong>Full redaction<\/strong>: all content redacted with default characters\/digits<\/li>\n<li><strong>Partial redaction<\/strong>: Part of the data is redacted. For fixed size data fields<\/li>\n<li><strong>Regular expression<\/strong>: usage of regular expression to match and replace specific pattern in variable size data fields<\/li>\n<li><strong>Random redaction<\/strong>: random data displayed depending on the data type<\/li>\n<\/ul>\n<p>Thanks to my colleague <a title=\"Cyril Wasmer Home page\" href=\"https:\/\/www.dbi-services.com\/on-the-company-and-its-associates\/our-associates-and-certified-experts\/cyril-wasmer\/\" target=\"_blank\">Cyril Wasmer<\/a> for these info.<\/p>\n<p>In SQL Server, you find <strong>3 masking modes<\/strong>:<\/p>\n<ul>\n<li><strong>Default<\/strong>: Full masking according to the data types of the designated fields.<\/li>\n<li><strong>Email<\/strong>: Masking method which exposes the first letter of an email address, the &#8220;@&#8221; character and the constant suffix &#8220;.com&#8221;<\/li>\n<li><strong>Custom String<\/strong>: Masking method which exposes the first and last letters and adds a custom padding string in the middle<\/li>\n<\/ul>\n<p>Extract from msdn, <a title=\"msdn Dynamic Data Masking\" href=\"https:\/\/msdn.microsoft.com\/en-us\/library\/mt130841.aspx\" target=\"_blank\">here<\/a><\/p>\n<h3>Test<\/h3>\n<p>To test this new feature, I check rapidly columns present in the database AdventureWorks<\/p>\n<p>Query used:<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">SELECT  T.NAME AS [TABLE NAME], C.NAME AS [COLUMN NAME], P.NAME AS [DATA TYPE], P.MAX_LENGTH AS[SIZE]\nFROM SYS.OBJECTS AS T JOIN SYS.COLUMNS AS C\nON T.OBJECT_ID=C.OBJECT_ID\nJOIN SYS.TYPES AS P\nON C.SYSTEM_TYPE_ID=P.SYSTEM_TYPE_ID\nWHERE T.TYPE_DESC='USER_TABLE' and T.NAME&lt;&gt;'sysdiagrams' ORDER BY T.NAME,C.NAME;<\/pre>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/DDM04.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-4622 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/DDM04.png\" alt=\"Columns in AdventureWorks\" width=\"300\" height=\"212\" \/><\/a><br \/>\nAs you can see, we have many columns in this database.<\/p>\n<p>Before I begin a test, I will see what my data type are.<\/p>\n<p>Query used:<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">SELECT DISTINCT P.NAME AS [DATA TYPE], P.MAX_LENGTH AS[SIZE]\nFROM SYS.OBJECTS AS T JOIN SYS.COLUMNS AS C\nON T.OBJECT_ID=C.OBJECT_ID JOIN SYS.TYPES AS P\nON C.SYSTEM_TYPE_ID=P.SYSTEM_TYPE_ID\nWHERE T.TYPE_DESC='USER_TABLE' and T.NAME&lt;&gt;'sysdiagrams' order by SIZE;<\/pre>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/DDM05.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-4623 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/DDM05.png\" alt=\"List of Data Types in AdventureWorks\" width=\"252\" height=\"300\" \/><\/a><\/p>\n<p>I have 16 data types in this database (xml, bit, tinyint,smallint,int,date,datetime,float,money,sysname,char,nchar,nvarchar, varchar, varbinary and kleinString).<br \/>\nKleinString is just a custom data type in varchar. The result will be the same as varchar, then I exclude this data type from my study.<br \/>\nFor my test and in the name of the fun, I will take a column per type&#8230; Let&#8217;s go!<\/p>\n<p>I connect to AdventureWorks with a:<\/p>\n<ul>\n<li>sql login <strong>u1<\/strong> with the <strong>db_owner role<\/strong> &#8211;&gt; <strong>No masking<\/strong><\/li>\n<li>sql login <strong>u2<\/strong> with the <strong>db_datareader role<\/strong> &#8211;&gt; masking<\/li>\n<\/ul>\n<p>SQL Server version used for these test is <strong>Microsoft SQL Server 2016 (CTP2.4) &#8211; 13.0.600.65 (X64)<\/strong><br \/>\nI will split my article in three others parts. I will perform several tests against AdventureWorks, as follows:<\/p>\n<ul>\n<ul>\n<li><a title=\"SQL Server 2016 - Security: Dynamic Data Masking - Numeric Data Types\" href=\"http:\/\/dbi-services.com\/blog\/sql-server-2016-security-dynamic-data-masking-numeric-data-types\/\" target=\"_blank\">SQL Server 2016 &#8211; Security: Dynamic Data masking \u2013 Numeric Data Types<\/a>\n<ul>\n<li>bit, tinyint, smallint, int, float &amp; money<\/li>\n<\/ul>\n<\/li>\n<li><a title=\"SQL Server 2016 - Security: Dynamic Data Masking - string Data Types\" href=\"http:\/\/dbi-services.com\/blog\/sql-server-2016-security-dynamic-data-masking-string-data-types\/\" target=\"_blank\">SQL Server 2016 &#8211; Security: Dynamic Data masking \u2013 String Data Types<\/a>\n<ul>\n<li>sysname, char, nchar, nvarchar &amp; varchar<\/li>\n<\/ul>\n<\/li>\n<li><a title=\"SQL Server 2016 - Security: Dynamic Data Masking - Other Data Types\" href=\"http:\/\/dbi-services.com\/blog\/sql-server-2016-security-dynamic-data-masking-other-data-types\/\" target=\"_blank\">SQL Server 2016 &#8211; Security: Dynamic Data masking \u2013 Other Data Types<\/a>\n<ul>\n<li>xml, date, datetime &amp; varbinary<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/ul>\n<h3>Summary<\/h3>\n<p>I will write a quick summary for each tests.<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/DDM39.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-4624 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/DDM39.png\" alt=\"Result of the Dynamic Data Masking per data types \" width=\"300\" height=\"239\" \/><\/a><br \/>\nI hope this convinces you to go see this new feature.<\/p>\n<p>See you soon for a next episode! \ud83d\ude0e<\/p>\n","protected":false},"excerpt":{"rendered":"<p>After my first blog on Security with Row level Security, I test the second Security new feature in the next version of SQL Server: Dynamic Data Masking. I presented this new feature to my Oracle colleagues and I&#8217;m surprised that Oracle 12c has the same option known as Data Redaction.<\/p>\n","protected":false},"author":15,"featured_media":5962,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229,48],"tags":[49,25,51,566],"type_dbi":[],"class_list":["post-5955","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database-administration-monitoring","category-technology-survey","tag-microsoft","tag-security","tag-sql-server","tag-sql-server-2016"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.2 (Yoast SEO v27.4) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>SQL Server 2016 - Security: Dynamic Data masking<\/title>\n<meta name=\"description\" content=\"A new feature of the security in the next version of SQL Server is Dynamic Data Masking. Through this blog, learn how its works.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-security-dynamic-data-masking\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Server 2016 - Security: Dynamic Data masking\" \/>\n<meta property=\"og:description\" content=\"A new feature of the security in the next version of SQL Server is Dynamic Data Masking. Through this blog, learn how its works.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-security-dynamic-data-masking\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2015-10-23T12:56:54+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/DDM01-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"394\" \/>\n\t<meta property=\"og:image:height\" content=\"285\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"St\u00e9phane Haby\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"St\u00e9phane Haby\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2016-security-dynamic-data-masking\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2016-security-dynamic-data-masking\\\/\"},\"author\":{\"name\":\"St\u00e9phane Haby\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/d0bfb7484ae81c8980fc2b11334f803b\"},\"headline\":\"SQL Server 2016 &#8211; Security: Dynamic Data masking\",\"datePublished\":\"2015-10-23T12:56:54+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2016-security-dynamic-data-masking\\\/\"},\"wordCount\":509,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2016-security-dynamic-data-masking\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/DDM01-1.png\",\"keywords\":[\"Microsoft\",\"Security\",\"SQL Server\",\"SQL Server 2016\"],\"articleSection\":[\"Database Administration &amp; Monitoring\",\"Technology Survey\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2016-security-dynamic-data-masking\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2016-security-dynamic-data-masking\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2016-security-dynamic-data-masking\\\/\",\"name\":\"SQL Server 2016 - Security: Dynamic Data masking\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2016-security-dynamic-data-masking\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2016-security-dynamic-data-masking\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/DDM01-1.png\",\"datePublished\":\"2015-10-23T12:56:54+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/d0bfb7484ae81c8980fc2b11334f803b\"},\"description\":\"A new feature of the security in the next version of SQL Server is Dynamic Data Masking. Through this blog, learn how its works.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2016-security-dynamic-data-masking\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2016-security-dynamic-data-masking\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2016-security-dynamic-data-masking\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/DDM01-1.png\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/DDM01-1.png\",\"width\":394,\"height\":285},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2016-security-dynamic-data-masking\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Server 2016 &#8211; Security: Dynamic Data masking\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/d0bfb7484ae81c8980fc2b11334f803b\",\"name\":\"St\u00e9phane Haby\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g\",\"caption\":\"St\u00e9phane Haby\"},\"description\":\"St\u00e9phane Haby has more than ten years of experience in Microsoft solutions. He is specialized in SQL Server technologies such as installation, migration, best practices, and performance analysis etc. He is also an expert in Microsoft Business Intelligence solutions such as SharePoint, SQL Server and Office. Futhermore, he has many years of .NET development experience in the banking sector and other industries. In France, he was one of the first people to have worked with Microsoft Team System. He has written several technical articles on this subject. St\u00e9phane Haby is Microsoft Most Valuable Professional (MVP) as well as Microsoft Certified Solutions Associate (MCSA) and\u00a0Microsoft Certified Solutions Expert (MCSE) for SQL Server 2012. He is also Microsoft Certified Technology Specialist (MCTS) and Microsoft Certified IT Professional (MCITP) for SQL Server 2008 as well as ITIL Foundation V3 certified. He holds a Engineer diploma in industrial computing and automation from France. His branch-related experience covers Chemicals &amp; Pharmaceuticals, Banking \\\/ Financial Services, and many other industries.\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/author\\\/stephane-haby\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"SQL Server 2016 - Security: Dynamic Data masking","description":"A new feature of the security in the next version of SQL Server is Dynamic Data Masking. Through this blog, learn how its works.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-security-dynamic-data-masking\/","og_locale":"en_US","og_type":"article","og_title":"SQL Server 2016 - Security: Dynamic Data masking","og_description":"A new feature of the security in the next version of SQL Server is Dynamic Data Masking. Through this blog, learn how its works.","og_url":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-security-dynamic-data-masking\/","og_site_name":"dbi Blog","article_published_time":"2015-10-23T12:56:54+00:00","og_image":[{"width":394,"height":285,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/DDM01-1.png","type":"image\/png"}],"author":"St\u00e9phane Haby","twitter_card":"summary_large_image","twitter_misc":{"Written by":"St\u00e9phane Haby","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-security-dynamic-data-masking\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-security-dynamic-data-masking\/"},"author":{"name":"St\u00e9phane Haby","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b"},"headline":"SQL Server 2016 &#8211; Security: Dynamic Data masking","datePublished":"2015-10-23T12:56:54+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-security-dynamic-data-masking\/"},"wordCount":509,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-security-dynamic-data-masking\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/DDM01-1.png","keywords":["Microsoft","Security","SQL Server","SQL Server 2016"],"articleSection":["Database Administration &amp; Monitoring","Technology Survey"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/sql-server-2016-security-dynamic-data-masking\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-security-dynamic-data-masking\/","url":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-security-dynamic-data-masking\/","name":"SQL Server 2016 - Security: Dynamic Data masking","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-security-dynamic-data-masking\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-security-dynamic-data-masking\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/DDM01-1.png","datePublished":"2015-10-23T12:56:54+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b"},"description":"A new feature of the security in the next version of SQL Server is Dynamic Data Masking. Through this blog, learn how its works.","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-security-dynamic-data-masking\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/sql-server-2016-security-dynamic-data-masking\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-security-dynamic-data-masking\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/DDM01-1.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/DDM01-1.png","width":394,"height":285},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-security-dynamic-data-masking\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"SQL Server 2016 &#8211; Security: Dynamic Data masking"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b","name":"St\u00e9phane Haby","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g","caption":"St\u00e9phane Haby"},"description":"St\u00e9phane Haby has more than ten years of experience in Microsoft solutions. He is specialized in SQL Server technologies such as installation, migration, best practices, and performance analysis etc. He is also an expert in Microsoft Business Intelligence solutions such as SharePoint, SQL Server and Office. Futhermore, he has many years of .NET development experience in the banking sector and other industries. In France, he was one of the first people to have worked with Microsoft Team System. He has written several technical articles on this subject. St\u00e9phane Haby is Microsoft Most Valuable Professional (MVP) as well as Microsoft Certified Solutions Associate (MCSA) and\u00a0Microsoft Certified Solutions Expert (MCSE) for SQL Server 2012. He is also Microsoft Certified Technology Specialist (MCTS) and Microsoft Certified IT Professional (MCITP) for SQL Server 2008 as well as ITIL Foundation V3 certified. He holds a Engineer diploma in industrial computing and automation from France. His branch-related experience covers Chemicals &amp; Pharmaceuticals, Banking \/ Financial Services, and many other industries.","url":"https:\/\/www.dbi-services.com\/blog\/author\/stephane-haby\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/5955","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/15"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=5955"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/5955\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/5962"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=5955"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=5955"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=5955"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=5955"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}