{"id":182,"date":"2024-01-02T08:55:00","date_gmt":"2024-01-02T13:55:00","guid":{"rendered":"https:\/\/www.sqltabletalk.com\/?p=182"},"modified":"2023-12-30T00:12:09","modified_gmt":"2023-12-30T05:12:09","slug":"dynamic-data-masking-ddm-in-sql-server","status":"publish","type":"post","link":"https:\/\/www.sqltabletalk.com\/?p=182","title":{"rendered":"Dynamic Data Masking (DDM) in SQL Server"},"content":{"rendered":"\n<h3 class=\"wp-block-heading\">Introduction<\/h3>\n\n\n\n<p>Dynamic Data Masking (DDM) is an important security feature designed to protect sensitive information in database environments like SQL Server and Azure SQL Database. It works by masking sensitive data from non-privileged users, thus enhancing data security and compliance without altering the actual data. DDM operates by hiding sensitive data in query results, allowing only privileged users to view the unmasked data. It&#8217;s especially valuable in environments requiring data protection without compromising user experience.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">How DDM Works<\/h3>\n\n\n\n<p>DDM functions at the query result level, ensuring the actual database storage remains unchanged while sensitive data is obscured during query result viewing. Key features include:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>Query-Level Operation<\/strong>: It masks data in real time during query execution.<\/li>\n\n\n\n<li><strong>Privileged User Designation<\/strong>: It allows specific users to view unmasked data, ensuring proper access for authorized roles.<\/li>\n\n\n\n<li><strong>Versatile Masking Functions<\/strong>: Supports full, partial, and random masking for various data types.<\/li>\n\n\n\n<li><strong>Ease of Management<\/strong>: Managed through Transact-SQL commands, allowing easy implementation and maintenance.<\/li>\n\n\n\n<li><strong>Compliance Support<\/strong>: Helps in adhering to data protection standards by safeguarding personally identifiable information and other sensitive categories.<\/li>\n<\/ol>\n\n\n\n<h3 class=\"wp-block-heading\">Limitations of DDM<\/h3>\n\n\n\n<p>While powerful, DDM isn&#8217;t all-encompassing and has limitations, including:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Inapplicability to Encrypted Columns<\/strong>: Doesn&#8217;t work with Always Encrypted columns.<\/li>\n\n\n\n<li><strong>Exclusion of FILESTREAM Data<\/strong>: Can&#8217;t mask FILESTREAM data.<\/li>\n\n\n\n<li><strong>Incompatibility with Certain Column Types<\/strong>: Doesn&#8217;t support COLUMN_SET or sparse columns, certain computed columns, and full-text index keys.<\/li>\n\n\n\n<li><strong>External Table Restrictions<\/strong>: Doesn&#8217;t mask columns in PolyBase external tables.<\/li>\n<\/ul>\n\n\n\n<p>Understanding these limitations is key to effectively integrating DDM into your data protection strategy.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Best Practices for Using DDM<\/h3>\n\n\n\n<p>Implementing DDM effectively involves understanding its operational nuances and integrating it into your broader data security strategy. Key practices include:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Robust Access Control<\/strong>: Ensure you have stringent access controls beyond just masking.<\/li>\n\n\n\n<li><strong>Conscious Data Handling<\/strong>: Be aware of how data copying and exporting operations affect masked data.<\/li>\n\n\n\n<li><strong>Regular Rule Review<\/strong>: Continually update and review masking rules to align with evolving data landscapes.<\/li>\n\n\n\n<li><strong>Impact Testing<\/strong>: Test how DDM affects applications and user interactions before full-scale implementation.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Managing Permissions in DDM<\/h3>\n\n\n\n<p>Permissions play a vital role in managing and controlling DDM:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Creating and Modifying Masks<\/strong>: Requires standard table creation and alteration permissions, along with <code>ALTER ANY MASK<\/code> for modifying existing masks.<\/li>\n\n\n\n<li><strong>Viewing Data<\/strong>: Users need <code>SELECT<\/code> permission to view masked data and <code>UNMASK<\/code> permission to view the actual data.<\/li>\n\n\n\n<li><strong>Comprehensive Control<\/strong>: <code>CONTROL<\/code> permission on the database provides overarching rights, including mask alteration and unmasking capabilities.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">SQL Server 2022 Enhancements for DDM<\/h3>\n\n\n\n<p>SQL Server 2022 enhances DDM with:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Granular UNMASK Permission Control<\/strong>: More nuanced permission settings at the database, schema, table, and column levels.<\/li>\n\n\n\n<li><strong>Improved Data Security Management<\/strong>: Enhanced ability to fine-tune access to sensitive data, bolstering overall data protection strategies.<\/li>\n<\/ul>\n\n\n\n<p>By understanding and leveraging these enhancements, organizations can better protect sensitive data while maintaining essential accessibility and functionality.<\/p>\n\n\n\n<p>In summary, Dynamic Data Masking is a versatile and powerful feature for protecting sensitive information, requiring careful consideration of its capabilities, limitations, and the broader security context in which it operates. With appropriate implementation and management, DDM can significantly enhance your data security posture.<\/p>\n\n\n\n<p>For more detailed information and best practices, you can visit the official Microsoft documentation on <a href=\"https:\/\/learn.microsoft.com\/en-us\/sql\/relational-databases\/security\/dynamic-data-masking?view=sql-server-ver16\">Dynamic Data Masking<\/a> and <a href=\"https:\/\/learn.microsoft.com\/en-us\/sql\/relational-databases\/system-catalog-views\/sys-masked-columns-transact-sql?view=sql-server-ver16\">Masked Columns<\/a>.<\/p>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Dynamic Data Masking (DDM) is an important security feature designed to protect sensitive information in database environments like SQL Server and Azure SQL Database. It works by masking sensitive data from non-privileged users, thus enhancing data security and compliance without altering the actual data. DDM operates by hiding sensitive data in query results, allowing only privileged users to view the unmasked data. It&#8217;s especially valuable in environments requiring data protection without compromising user experience.<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[29,40],"tags":[71,70,30],"class_list":["post-182","post","type-post","status-publish","format-standard","hentry","category-security","category-sql-server-2022","tag-access-control","tag-data-masking","tag-security"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.1.1 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Dynamic Data Masking (DDM) in SQL Server - SQL Table Talk<\/title>\n<meta name=\"description\" content=\"Dynamic Data Masking (DDM) is a critical security feature designed to protect sensitive information in database environments like SQL Server and Azure SQL Database. It works by masking sensitive data from non-privileged users, thus enhancing data security and compliance without altering the actual data. DDM operates by hiding sensitive data in query results, allowing only privileged users to view the unmasked data. It&#039;s especially valuable in environments requiring data protection without compromising user experience.\" \/>\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.sqltabletalk.com\/?p=182\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Dynamic Data Masking (DDM) in SQL Server - SQL Table Talk\" \/>\n<meta property=\"og:description\" content=\"Dynamic Data Masking (DDM) is a critical security feature designed to protect sensitive information in database environments like SQL Server and Azure SQL Database. It works by masking sensitive data from non-privileged users, thus enhancing data security and compliance without altering the actual data. DDM operates by hiding sensitive data in query results, allowing only privileged users to view the unmasked data. It&#039;s especially valuable in environments requiring data protection without compromising user experience.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sqltabletalk.com\/?p=182\" \/>\n<meta property=\"og:site_name\" content=\"SQL Table Talk\" \/>\n<meta property=\"article:published_time\" content=\"2024-01-02T13:55:00+00:00\" \/>\n<meta name=\"author\" content=\"Yvonne Vanslageren\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Yvonne Vanslageren\" \/>\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.sqltabletalk.com\/?p=182#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.sqltabletalk.com\/?p=182\"},\"author\":{\"name\":\"Yvonne Vanslageren\",\"@id\":\"https:\/\/www.sqltabletalk.com\/#\/schema\/person\/68bb31b454bafe9e139183ed4f3e9082\"},\"headline\":\"Dynamic Data Masking (DDM) in SQL Server\",\"datePublished\":\"2024-01-02T13:55:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.sqltabletalk.com\/?p=182\"},\"wordCount\":523,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.sqltabletalk.com\/#\/schema\/person\/1947e42a9438bccd91691d8b791888e0\"},\"keywords\":[\"access control\",\"data masking\",\"security\"],\"articleSection\":[\"Security\",\"SQL Server 2022\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.sqltabletalk.com\/?p=182#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.sqltabletalk.com\/?p=182\",\"url\":\"https:\/\/www.sqltabletalk.com\/?p=182\",\"name\":\"Dynamic Data Masking (DDM) in SQL Server - SQL Table Talk\",\"isPartOf\":{\"@id\":\"https:\/\/www.sqltabletalk.com\/#website\"},\"datePublished\":\"2024-01-02T13:55:00+00:00\",\"description\":\"Dynamic Data Masking (DDM) is a critical security feature designed to protect sensitive information in database environments like SQL Server and Azure SQL Database. It works by masking sensitive data from non-privileged users, thus enhancing data security and compliance without altering the actual data. DDM operates by hiding sensitive data in query results, allowing only privileged users to view the unmasked data. It's especially valuable in environments requiring data protection without compromising user experience.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.sqltabletalk.com\/?p=182#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.sqltabletalk.com\/?p=182\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.sqltabletalk.com\/?p=182#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.sqltabletalk.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Dynamic Data Masking (DDM) in SQL Server\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.sqltabletalk.com\/#website\",\"url\":\"https:\/\/www.sqltabletalk.com\/\",\"name\":\"SQL Table Talk\",\"description\":\"Breaking Down SQL Server, One Post at a Time.\",\"publisher\":{\"@id\":\"https:\/\/www.sqltabletalk.com\/#\/schema\/person\/1947e42a9438bccd91691d8b791888e0\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.sqltabletalk.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/www.sqltabletalk.com\/#\/schema\/person\/1947e42a9438bccd91691d8b791888e0\",\"name\":\"Stephen Planck\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.sqltabletalk.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/64181114edc3de3d99072c049bcec024f025c9536dc89fc8ff1bac58976ca81e?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/64181114edc3de3d99072c049bcec024f025c9536dc89fc8ff1bac58976ca81e?s=96&d=mm&r=g\",\"caption\":\"Stephen Planck\"},\"logo\":{\"@id\":\"https:\/\/www.sqltabletalk.com\/#\/schema\/person\/image\/\"},\"sameAs\":[\"https:\/\/dexterwiki.com\",\"https:\/\/www.linkedin.com\/in\/stephen-planck-4611b692?trk=people-guest_people_search-card&challengeId=AQErf8gbBmcVMwAAAYsyIsxO-0UvU8z7cHrBpZoo_n3xt9qEKpRN5B_jd_LmAMu-OfeArkQ7GDjobJ2uRoQQV35EQdh_rR6kxA&submissionId=09de7067-c335-8e17-40b8-8dc32b60ed6c&challengeSource=AgEcUCw35zpPmAAAAYsyI4vAWhJTV7Nt4vZYKc3V1qiDBpCkKgUvtlOBgYXcE84&challegeType=AgE_wZiTT09IAQAAAYsyI4vDmNvbZIYe6XHju5V2bXVvM3IVxnJslgY&memberId=AgESFTkUShzs_gAAAYsyI4vGYk0Gic1uc5kB6cKOABA26Gw&recognizeDevice=AgHdSZyUSI5CEwAAAYsyI4vKd_koF9JgpsCJShT8QfbK1QMiv8SI\",\"https:\/\/www.youtube.com\/linuxmate\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.sqltabletalk.com\/#\/schema\/person\/68bb31b454bafe9e139183ed4f3e9082\",\"name\":\"Yvonne Vanslageren\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.sqltabletalk.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/22c274a7a354b81a0a8dc5b23e8e0be9bdd81a6bc0541474cfb6b954d6bb2089?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/22c274a7a354b81a0a8dc5b23e8e0be9bdd81a6bc0541474cfb6b954d6bb2089?s=96&d=mm&r=g\",\"caption\":\"Yvonne Vanslageren\"},\"url\":\"https:\/\/www.sqltabletalk.com\/?author=2\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Dynamic Data Masking (DDM) in SQL Server - SQL Table Talk","description":"Dynamic Data Masking (DDM) is a critical security feature designed to protect sensitive information in database environments like SQL Server and Azure SQL Database. It works by masking sensitive data from non-privileged users, thus enhancing data security and compliance without altering the actual data. DDM operates by hiding sensitive data in query results, allowing only privileged users to view the unmasked data. It's especially valuable in environments requiring data protection without compromising user experience.","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.sqltabletalk.com\/?p=182","og_locale":"en_US","og_type":"article","og_title":"Dynamic Data Masking (DDM) in SQL Server - SQL Table Talk","og_description":"Dynamic Data Masking (DDM) is a critical security feature designed to protect sensitive information in database environments like SQL Server and Azure SQL Database. It works by masking sensitive data from non-privileged users, thus enhancing data security and compliance without altering the actual data. DDM operates by hiding sensitive data in query results, allowing only privileged users to view the unmasked data. It's especially valuable in environments requiring data protection without compromising user experience.","og_url":"https:\/\/www.sqltabletalk.com\/?p=182","og_site_name":"SQL Table Talk","article_published_time":"2024-01-02T13:55:00+00:00","author":"Yvonne Vanslageren","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Yvonne Vanslageren","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.sqltabletalk.com\/?p=182#article","isPartOf":{"@id":"https:\/\/www.sqltabletalk.com\/?p=182"},"author":{"name":"Yvonne Vanslageren","@id":"https:\/\/www.sqltabletalk.com\/#\/schema\/person\/68bb31b454bafe9e139183ed4f3e9082"},"headline":"Dynamic Data Masking (DDM) in SQL Server","datePublished":"2024-01-02T13:55:00+00:00","mainEntityOfPage":{"@id":"https:\/\/www.sqltabletalk.com\/?p=182"},"wordCount":523,"commentCount":0,"publisher":{"@id":"https:\/\/www.sqltabletalk.com\/#\/schema\/person\/1947e42a9438bccd91691d8b791888e0"},"keywords":["access control","data masking","security"],"articleSection":["Security","SQL Server 2022"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.sqltabletalk.com\/?p=182#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.sqltabletalk.com\/?p=182","url":"https:\/\/www.sqltabletalk.com\/?p=182","name":"Dynamic Data Masking (DDM) in SQL Server - SQL Table Talk","isPartOf":{"@id":"https:\/\/www.sqltabletalk.com\/#website"},"datePublished":"2024-01-02T13:55:00+00:00","description":"Dynamic Data Masking (DDM) is a critical security feature designed to protect sensitive information in database environments like SQL Server and Azure SQL Database. It works by masking sensitive data from non-privileged users, thus enhancing data security and compliance without altering the actual data. DDM operates by hiding sensitive data in query results, allowing only privileged users to view the unmasked data. It's especially valuable in environments requiring data protection without compromising user experience.","breadcrumb":{"@id":"https:\/\/www.sqltabletalk.com\/?p=182#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sqltabletalk.com\/?p=182"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.sqltabletalk.com\/?p=182#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.sqltabletalk.com\/"},{"@type":"ListItem","position":2,"name":"Dynamic Data Masking (DDM) in SQL Server"}]},{"@type":"WebSite","@id":"https:\/\/www.sqltabletalk.com\/#website","url":"https:\/\/www.sqltabletalk.com\/","name":"SQL Table Talk","description":"Breaking Down SQL Server, One Post at a Time.","publisher":{"@id":"https:\/\/www.sqltabletalk.com\/#\/schema\/person\/1947e42a9438bccd91691d8b791888e0"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.sqltabletalk.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/www.sqltabletalk.com\/#\/schema\/person\/1947e42a9438bccd91691d8b791888e0","name":"Stephen Planck","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.sqltabletalk.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/64181114edc3de3d99072c049bcec024f025c9536dc89fc8ff1bac58976ca81e?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/64181114edc3de3d99072c049bcec024f025c9536dc89fc8ff1bac58976ca81e?s=96&d=mm&r=g","caption":"Stephen Planck"},"logo":{"@id":"https:\/\/www.sqltabletalk.com\/#\/schema\/person\/image\/"},"sameAs":["https:\/\/dexterwiki.com","https:\/\/www.linkedin.com\/in\/stephen-planck-4611b692?trk=people-guest_people_search-card&challengeId=AQErf8gbBmcVMwAAAYsyIsxO-0UvU8z7cHrBpZoo_n3xt9qEKpRN5B_jd_LmAMu-OfeArkQ7GDjobJ2uRoQQV35EQdh_rR6kxA&submissionId=09de7067-c335-8e17-40b8-8dc32b60ed6c&challengeSource=AgEcUCw35zpPmAAAAYsyI4vAWhJTV7Nt4vZYKc3V1qiDBpCkKgUvtlOBgYXcE84&challegeType=AgE_wZiTT09IAQAAAYsyI4vDmNvbZIYe6XHju5V2bXVvM3IVxnJslgY&memberId=AgESFTkUShzs_gAAAYsyI4vGYk0Gic1uc5kB6cKOABA26Gw&recognizeDevice=AgHdSZyUSI5CEwAAAYsyI4vKd_koF9JgpsCJShT8QfbK1QMiv8SI","https:\/\/www.youtube.com\/linuxmate"]},{"@type":"Person","@id":"https:\/\/www.sqltabletalk.com\/#\/schema\/person\/68bb31b454bafe9e139183ed4f3e9082","name":"Yvonne Vanslageren","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.sqltabletalk.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/22c274a7a354b81a0a8dc5b23e8e0be9bdd81a6bc0541474cfb6b954d6bb2089?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/22c274a7a354b81a0a8dc5b23e8e0be9bdd81a6bc0541474cfb6b954d6bb2089?s=96&d=mm&r=g","caption":"Yvonne Vanslageren"},"url":"https:\/\/www.sqltabletalk.com\/?author=2"}]}},"jetpack_featured_media_url":"","jetpack-related-posts":[],"jetpack_sharing_enabled":true,"jetpack_likes_enabled":true,"_links":{"self":[{"href":"https:\/\/www.sqltabletalk.com\/index.php?rest_route=\/wp\/v2\/posts\/182","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sqltabletalk.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sqltabletalk.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sqltabletalk.com\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sqltabletalk.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=182"}],"version-history":[{"count":2,"href":"https:\/\/www.sqltabletalk.com\/index.php?rest_route=\/wp\/v2\/posts\/182\/revisions"}],"predecessor-version":[{"id":237,"href":"https:\/\/www.sqltabletalk.com\/index.php?rest_route=\/wp\/v2\/posts\/182\/revisions\/237"}],"wp:attachment":[{"href":"https:\/\/www.sqltabletalk.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=182"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqltabletalk.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=182"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqltabletalk.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=182"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}