{"id":6018,"date":"2015-10-23T15:36:25","date_gmt":"2015-10-23T13:36:25","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-security-dynamic-data-masking-other-data-types\/"},"modified":"2015-10-23T15:36:25","modified_gmt":"2015-10-23T13:36:25","slug":"sql-server-2016-security-dynamic-data-masking-other-data-types","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-security-dynamic-data-masking-other-data-types\/","title":{"rendered":"SQL Server 2016 &#8211; Security: Dynamic Data Masking &#8211; Other Data Types"},"content":{"rendered":"<p>This blog is a part of the series &#8220;<a title=\"SQL Server 2016 - Security: dynamic Data Masking\" href=\"http:\/\/dbi-services.com\/blog\/sql-server-2016-security-dynamic-data-masking\/\" target=\"_blank\"><strong>SQL Server 2016 &#8211; Security: Dynamic Data Masking<\/strong><\/a>&#8220;.<br \/>\nI remember you my different logins used to connect to AdventureWorks:<\/p>\n<ul>\n<li>sql login <strong>u1<\/strong> with the <strong>db_owner role<\/strong> &#8211;&gt; No masking<\/li>\n<li>sql login <strong>u2<\/strong> with the <strong>db_datareader<\/strong> role &#8211;&gt; masking<\/li>\n<\/ul>\n<p>The Data Types used are:<strong> xml, date, datetime and varbinary<\/strong>.<\/p>\n<p><!--more--><\/p>\n<p>I run this query to have all columns with the tested data type in the clause <strong>WHERE<\/strong>:<\/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' and P.NAME='xml' ORDER BY T.NAME,C.NAME<\/pre>\n<h3>XML Data Type<\/h3>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/DDM06.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-4689 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/DDM06.png\" alt=\"XML Data Type for Dynamic Data Masking\" width=\"300\" height=\"106\" \/><\/a><br \/>\nIt is one column XmlEvent in the table DatabaseLog.<br \/>\nFor fun, I will test the 3 masking modes:<\/p>\n<ul>\n<li>Default:\n<ul>\n<li>Query:\n<pre class=\"brush: sql; gutter: true; first-line: 1\">ALTER TABLE [DatabaseLog] ALTER COLUMN [XmlEvent] ADD MASKED WITH (FUNCTION = 'default()')<\/pre>\n<\/li>\n<li>Result: Command(s) completed successfully.<\/li>\n<\/ul>\n<\/li>\n<li>Email:\n<ul>\n<li>Query:\n<pre class=\"brush: sql; gutter: true; first-line: 1\">ALTER TABLE [DatabaseLog] ALTER COLUMN [XmlEvent] ADD MASKED WITH (FUNCTION = 'email()')<\/pre>\n<\/li>\n<li>Result: <em>Msg 16003, Level 16, State 0, Line 13<\/em><\/li>\n<li><em>The data type of column &#8216;XmlEvent&#8217; does not support data masking function &#8217;email&#8217;.<\/em><\/li>\n<\/ul>\n<\/li>\n<li>Custom String:\n<ul>\n<li>Query:\n<pre class=\"brush: sql; gutter: true; first-line: 1\">ALTER TABLE [DatabaseLog] ALTER COLUMN [XmlEvent] ADD MASKED WITH (FUNCTION = 'partial(1,\"XXXXXX\",0)')<\/pre>\n<\/li>\n<li>Result: <em>Msg 16003, Level 16, State 0, Line 14<\/em><\/li>\n<li><em>The data type of column &#8216;XmlEvent&#8217; does not support data masking function &#8216;partial&#8217;.<\/em><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p>For the data type XML, only default mode is available.<\/p>\n<p>And the question is, what the user see insteadof the real data&#8230;<\/p>\n<p>With u1, I see all xml data and 112 rows<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/DDM07.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-4690 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/DDM07.png\" alt=\"XML Data Type without masking\" width=\"300\" height=\"215\" \/><\/a><\/p>\n<p>With u2, I see for all 112 rows but with a value &lt;masked\\&gt;<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/DDM08.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-4691 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/DDM08.png\" alt=\"XML Data Type with masking\" width=\"300\" height=\"218\" \/><\/a><\/p>\n<h3>Date and DateTime Data Types<\/h3>\n<p>With u1, I see all different values.<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/DDM19.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-4692 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/DDM19.png\" alt=\"Date and DateTime Data Types without masking\" width=\"134\" height=\"300\" \/><\/a><\/p>\n<p>With u2, I see for all rows with a value of 2000-01-01 for date and 2000-01-01 00:00:00.000 for datetime.<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/DDM20.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-4693 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/DDM20.png\" alt=\"Date and DateTime Data Types with masking\" width=\"300\" height=\"216\" \/><\/a><\/p>\n<h3>Varbinary Data Type<\/h3>\n<p>I run my SELECT:<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/DDM36.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-4694 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/DDM36.png\" alt=\"SELECT for Varbinary Data types\" width=\"300\" height=\"165\" \/><\/a><\/p>\n<p>Like Xml, I will test the 3 masking modes:<br \/>\nFor Default, no problem but for email &amp; custom String, we have the error:<br \/>\n<em>Msg 16003, Level 16, State 0, Line 106<\/em><br \/>\n<em> The data type of column &#8216;\u2026.&#8217; does not support data masking function &#8216;partial&#8217;.<\/em><br \/>\nOnly Default is available for Varbinary<\/p>\n<p>With u1, I see all different values.<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/DDM37.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-4695 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/DDM37.png\" alt=\"Varbinary Data Types without masking\" width=\"276\" height=\"300\" \/><\/a><\/p>\n<p>With u2, I see for all rows with a value of 0x30 for varbinary.<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/DDM38.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-4696 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/DDM38.png\" alt=\"Varbinary Data Types with masking\" width=\"176\" height=\"300\" \/><\/a><\/p>\n<h3>Core Message<\/h3>\n<ul>\n<li>For XML data type, only the default masking mode is enabled and the mask value is &lt;masked\\&gt;<\/li>\n<li>For date and Datetime datatype, the default masking is the only one available with the date 01.01.2000 with 00:00:00 for the time<\/li>\n<li>For varbinary data type, only the default masking mode is enabled and the mask value is 0x30<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>This blog is a part of the series &#8220;SQL Server 2016 &#8211; Security: Dynamic Data Masking&#8220;. I remember you my different logins used to connect to AdventureWorks: sql login u1 with the db_owner role &#8211;&gt; No masking sql login u2 with the db_datareader role &#8211;&gt; masking The Data Types used are: xml, date, datetime and [&hellip;]<\/p>\n","protected":false},"author":15,"featured_media":6027,"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-6018","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.2) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>SQL Server 2016 - Security: Dynamic Data Masking - Other Data Types<\/title>\n<meta name=\"description\" content=\"This blog is a part of the series &quot;SQL Server 2016 - Security: Dynamic Data masking&quot; especially to test other data types from AdventureWorks\" \/>\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-other-data-types\/\" \/>\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 - Other Data Types\" \/>\n<meta property=\"og:description\" content=\"This blog is a part of the series &quot;SQL Server 2016 - Security: Dynamic Data masking&quot; especially to test other data types from AdventureWorks\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-security-dynamic-data-masking-other-data-types\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2015-10-23T13:36:25+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/DDM06-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"748\" \/>\n\t<meta property=\"og:image:height\" content=\"264\" \/>\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=\"2 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-other-data-types\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-security-dynamic-data-masking-other-data-types\/\"},\"author\":{\"name\":\"St\u00e9phane Haby\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b\"},\"headline\":\"SQL Server 2016 &#8211; Security: Dynamic Data Masking &#8211; Other Data Types\",\"datePublished\":\"2015-10-23T13:36:25+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-security-dynamic-data-masking-other-data-types\/\"},\"wordCount\":362,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-security-dynamic-data-masking-other-data-types\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/DDM06-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-other-data-types\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-security-dynamic-data-masking-other-data-types\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-security-dynamic-data-masking-other-data-types\/\",\"name\":\"SQL Server 2016 - Security: Dynamic Data Masking - Other Data Types\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-security-dynamic-data-masking-other-data-types\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-security-dynamic-data-masking-other-data-types\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/DDM06-1.png\",\"datePublished\":\"2015-10-23T13:36:25+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b\"},\"description\":\"This blog is a part of the series \\\"SQL Server 2016 - Security: Dynamic Data masking\\\" especially to test other data types from AdventureWorks\",\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-security-dynamic-data-masking-other-data-types\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-security-dynamic-data-masking-other-data-types\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-security-dynamic-data-masking-other-data-types\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/DDM06-1.png\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/DDM06-1.png\",\"width\":748,\"height\":264},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-security-dynamic-data-masking-other-data-types\/#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 &#8211; Other Data Types\"}]},{\"@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 - Other Data Types","description":"This blog is a part of the series \"SQL Server 2016 - Security: Dynamic Data masking\" especially to test other data types from AdventureWorks","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-other-data-types\/","og_locale":"en_US","og_type":"article","og_title":"SQL Server 2016 - Security: Dynamic Data Masking - Other Data Types","og_description":"This blog is a part of the series \"SQL Server 2016 - Security: Dynamic Data masking\" especially to test other data types from AdventureWorks","og_url":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-security-dynamic-data-masking-other-data-types\/","og_site_name":"dbi Blog","article_published_time":"2015-10-23T13:36:25+00:00","og_image":[{"width":748,"height":264,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/DDM06-1.png","type":"image\/png"}],"author":"St\u00e9phane Haby","twitter_card":"summary_large_image","twitter_misc":{"Written by":"St\u00e9phane Haby","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-security-dynamic-data-masking-other-data-types\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-security-dynamic-data-masking-other-data-types\/"},"author":{"name":"St\u00e9phane Haby","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b"},"headline":"SQL Server 2016 &#8211; Security: Dynamic Data Masking &#8211; Other Data Types","datePublished":"2015-10-23T13:36:25+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-security-dynamic-data-masking-other-data-types\/"},"wordCount":362,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-security-dynamic-data-masking-other-data-types\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/DDM06-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-other-data-types\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-security-dynamic-data-masking-other-data-types\/","url":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-security-dynamic-data-masking-other-data-types\/","name":"SQL Server 2016 - Security: Dynamic Data Masking - Other Data Types","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-security-dynamic-data-masking-other-data-types\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-security-dynamic-data-masking-other-data-types\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/DDM06-1.png","datePublished":"2015-10-23T13:36:25+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b"},"description":"This blog is a part of the series \"SQL Server 2016 - Security: Dynamic Data masking\" especially to test other data types from AdventureWorks","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-security-dynamic-data-masking-other-data-types\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/sql-server-2016-security-dynamic-data-masking-other-data-types\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-security-dynamic-data-masking-other-data-types\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/DDM06-1.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/DDM06-1.png","width":748,"height":264},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-security-dynamic-data-masking-other-data-types\/#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 &#8211; Other Data Types"}]},{"@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\/6018","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=6018"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/6018\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/6027"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=6018"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=6018"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=6018"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=6018"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}