{"id":11814,"date":"2018-12-11T08:00:47","date_gmt":"2018-12-11T07:00:47","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/transparent-data-encryption-certificate-in-master-database-is-it-really-a-good-practice\/"},"modified":"2018-12-11T08:00:47","modified_gmt":"2018-12-11T07:00:47","slug":"transparent-data-encryption-certificate-in-master-database-is-it-really-a-good-practice","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/transparent-data-encryption-certificate-in-master-database-is-it-really-a-good-practice\/","title":{"rendered":"Transparent Data Encryption &#8211; Certificate in master database: is it really a good practice?"},"content":{"rendered":"<p>As encryption solution in SQL Server, Transparent Data Encryption (TDE) is simple and quick to set up. That&#8217;s why this is a common encryption mechanism.<\/p>\n<p>TDE encrypts data with a certificate at the page level, before SQL Server writes on the disk. It is supposed to protect your environment from some scenarios, where SQL Server files (backups or data) are stolen.<br \/>\nBy default the certificate used for encryption is <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/security\/encryption\/transparent-data-encryption?view=sql-server-2017\">stored in the master database<\/a>. But is it really a good practice?<\/p>\n<p><!--more--><\/p>\n<p>Let&#8217;s see with a common scenario:<br \/>\n&#8211; One MSSQL instance where TDE is enabled for one database<br \/>\n&#8211; One MSSQL instance without any certificate<\/p>\n<h3>Configuring TDE for a database<\/h3>\n<p>Create a master key:<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">USE master\nGO\nCREATE MASTER KEY ENCRYPTION BY PASSWORD = 'P@$$w0rd'\nGO\n<\/pre>\n<p>Create a certificate to use for TDE:<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">USE master\nGO\nCREATE CERTIFICATE CertinMaster\n   WITH SUBJECT = 'Self-Signed Certificate in Master',   \n   EXPIRY_DATE = '20241231';  \nGO  \n<\/pre>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Certificate.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-medium wp-image-28578\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Certificate.jpg\" alt=\"Certificate\" width=\"300\" height=\"133\" \/><\/a><\/p>\n<p>Create a database encryption key in the database you want to encrypt, protected by the certificate:<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">USE dummy\nGO\nCREATE DATABASE ENCRYPTION KEY WITH ALGORITHM = AES_256 ENCRYPTION BY SERVER CERTIFICATE CertinMaster\nGO\n<\/pre>\n<p>Enable encryption on the database:<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">USE master\nGO\nALTER DATABASE dummy SET ENCRYPTION ON\nGO\n<\/pre>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/tde.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-medium wp-image-28580\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/tde.jpg\" alt=\"tde\" width=\"300\" height=\"153\" \/><\/a><\/p>\n<p>At this step:<br \/>\n&#8211; TDE is configured for dummy database<br \/>\n&#8211; Certificate used for encryption is located in the master database<\/p>\n<h3>Restoring encrypted database to an another instance &#8211; first try<\/h3>\n<p>After backing up dummy database and copying the backup to another MSSQL instance, an error is displayed when trying to restore this database with required certificate:<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Restore_tde_witout_certificate_impossible.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Restore_tde_witout_certificate_impossible.png\" alt=\"Restore_tde_witout_certificate_impossible\" width=\"300\" height=\"65\" class=\"aligncenter size-medium wp-image-30045\" \/><\/a><\/p>\n<p>This example shows how TDE protects data from a scenario where someone has robbed your backup file.<br \/>\nA similar error appears if an attach file procedure is used.<\/p>\n<h3>Restoring encrypted database to an another instance &#8211; second try<\/h3>\n<p>After backing up master database, let&#8217;s try to restore it on the other MSSQL environment.<br \/>\nRestoring a master database is a bit more complicated than a user database, but not impossible.<\/p>\n<p>First it is mandatory to set the instance in Single User mode, by adding option &#8216;-m&#8217; at startup parameters (for example).<br \/>\nPowerShell code executed on target server:<\/p>\n<pre class=\"brush: powershell; gutter: true; first-line: 1\">\n$Path = \"HKLM:\\SOFTWARE\\Microsoft\\Microsoft SQL Server\\MSSQL13.ARCTURUS\\MSSQLServer\\Parameters\\\";\nNew-ItemProperty -Path $Path -PropertyType String -Name SQLArg3 -Value \"-m\"\n<\/pre>\n<p>Note: depending on how many startup parameters you have (default is 3), adjust accordingly the item property to SQLArgX.<\/p>\n<p>A restart of the instance is necessary to apply this option. Do not start the agent service, otherwise it will connect to the instance in single user mode.<\/p>\n<p>As only one connection to the instance is authorized in this mode, PowerShell is more suited to do the job for the restore:<\/p>\n<pre class=\"brush: powershell; gutter: true; first-line: 1\">\n$Query= \"RESTORE DATABASE master FROM DISK = 'C:\\Mountpoints\\Backup\\master.bak' WITH REPLACE\";\nInvoke-Sqlcmd -ServerInstance KERRIGAN\\ARCTURUS -Query $Query\"\n<\/pre>\n<p>The SQL Server is automatically stopped.<\/p>\n<p>First remove the Single user mode:<\/p>\n<pre class=\"brush: powershell; gutter: true; first-line: 1\">\n$Path = \"HKLM:\\SOFTWARE\\Microsoft\\Microsoft SQL Server\\MSSQL13.ARCTURUS\\MSSQLServer\\Parameters\\\";\nRemove-ItemProperty -Path $Path -Name SQLArg3\"\n<\/pre>\n<p>After disabling Single User mode, SQL Server services (Engine + Agent) can start again.<\/p>\n<p>After querying the new master, it is effectively holding the certificate:<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Certificate_Copied.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Certificate_Copied.png\" alt=\"Certificate_Copied\" width=\"300\" height=\"56\" class=\"aligncenter size-medium wp-image-30052\" \/><\/a><\/p>\n<p>Finally after trying to restore the dummy database on this instance, it works without any trouble: data are freely accessible.<\/p>\n<h3>Conclusion<\/h3>\n<p>For a complete protection, I do not recommend to use a simple form of Transparent Data Encryption. As a best practice, I do recommend to store the encryption key on a third-party system using <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/security\/encryption\/extensible-key-management-ekm\">Extensible Key Management (EKM)<\/a>.<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>As encryption solution in SQL Server, Transparent Data Encryption (TDE) is simple and quick to set up. That&#8217;s why this is a common encryption mechanism. TDE encrypts data with a certificate at the page level, before SQL Server writes on the disk. It is supposed to protect your environment from some scenarios, where SQL Server [&hellip;]<\/p>\n","protected":false},"author":14,"featured_media":11815,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229],"tags":[447,142,25,51,448,449],"type_dbi":[],"class_list":["post-11814","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database-administration-monitoring","tag-encryption","tag-microsoft-sql-server","tag-security","tag-sql-server","tag-tde","tag-transparent-data-encryption"],"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>Transparent Data Encryption - Certificate in master database: is it really a good practice? - dbi Blog<\/title>\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\/transparent-data-encryption-certificate-in-master-database-is-it-really-a-good-practice\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Transparent Data Encryption - Certificate in master database: is it really a good practice?\" \/>\n<meta property=\"og:description\" content=\"As encryption solution in SQL Server, Transparent Data Encryption (TDE) is simple and quick to set up. That&#8217;s why this is a common encryption mechanism. TDE encrypts data with a certificate at the page level, before SQL Server writes on the disk. It is supposed to protect your environment from some scenarios, where SQL Server [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/transparent-data-encryption-certificate-in-master-database-is-it-really-a-good-practice\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2018-12-11T07:00:47+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Certificate.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"610\" \/>\n\t<meta property=\"og:image:height\" content=\"270\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Nathan Courtine\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Nathan Courtine\" \/>\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\/transparent-data-encryption-certificate-in-master-database-is-it-really-a-good-practice\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/transparent-data-encryption-certificate-in-master-database-is-it-really-a-good-practice\/\"},\"author\":{\"name\":\"Nathan Courtine\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/38305b5ebdcdb4fb784fa31d760862d1\"},\"headline\":\"Transparent Data Encryption &#8211; Certificate in master database: is it really a good practice?\",\"datePublished\":\"2018-12-11T07:00:47+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/transparent-data-encryption-certificate-in-master-database-is-it-really-a-good-practice\/\"},\"wordCount\":477,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/transparent-data-encryption-certificate-in-master-database-is-it-really-a-good-practice\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Certificate.jpg\",\"keywords\":[\"encryption\",\"Microsoft SQL Server\",\"Security\",\"SQL Server\",\"TDE\",\"Transparent data encryption\"],\"articleSection\":[\"Database Administration &amp; Monitoring\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/transparent-data-encryption-certificate-in-master-database-is-it-really-a-good-practice\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/transparent-data-encryption-certificate-in-master-database-is-it-really-a-good-practice\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/transparent-data-encryption-certificate-in-master-database-is-it-really-a-good-practice\/\",\"name\":\"Transparent Data Encryption - Certificate in master database: is it really a good practice? - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/transparent-data-encryption-certificate-in-master-database-is-it-really-a-good-practice\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/transparent-data-encryption-certificate-in-master-database-is-it-really-a-good-practice\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Certificate.jpg\",\"datePublished\":\"2018-12-11T07:00:47+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/38305b5ebdcdb4fb784fa31d760862d1\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/transparent-data-encryption-certificate-in-master-database-is-it-really-a-good-practice\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/transparent-data-encryption-certificate-in-master-database-is-it-really-a-good-practice\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/transparent-data-encryption-certificate-in-master-database-is-it-really-a-good-practice\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Certificate.jpg\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Certificate.jpg\",\"width\":610,\"height\":270},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/transparent-data-encryption-certificate-in-master-database-is-it-really-a-good-practice\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Transparent Data Encryption &#8211; Certificate in master database: is it really a good practice?\"}]},{\"@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\/38305b5ebdcdb4fb784fa31d760862d1\",\"name\":\"Nathan Courtine\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/0fcc6c91bbc35c976c9d470585e48ae5d500680f1f55de5bbc5f8373b8ebb02c?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/0fcc6c91bbc35c976c9d470585e48ae5d500680f1f55de5bbc5f8373b8ebb02c?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/0fcc6c91bbc35c976c9d470585e48ae5d500680f1f55de5bbc5f8373b8ebb02c?s=96&d=mm&r=g\",\"caption\":\"Nathan Courtine\"},\"description\":\"Nathan Courtine has more than four years of experience in Microsoft solutions. He is specialized in SQL Server installation, migration, performance analysis, best practices, etc. Moreover, he has a background in Oracle Java and .NET software and web development. Nathan Courtine is Microsoft Certified in Administering SQL Server 2012 Databases. Nathan Courtine holds an Engineer\u2019s Degree in Computer Science from the ENSISA (Ecole Nationale Sup\u00e9rieure d'Ing\u00e9nieurs Sud Alsace) in Mulhouse (F). His branch-related experience covers Public Sector, Automotive, IT, Financial Services \/ Banking, etc.\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/nathan-courtine\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Transparent Data Encryption - Certificate in master database: is it really a good practice? - dbi Blog","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\/transparent-data-encryption-certificate-in-master-database-is-it-really-a-good-practice\/","og_locale":"en_US","og_type":"article","og_title":"Transparent Data Encryption - Certificate in master database: is it really a good practice?","og_description":"As encryption solution in SQL Server, Transparent Data Encryption (TDE) is simple and quick to set up. That&#8217;s why this is a common encryption mechanism. TDE encrypts data with a certificate at the page level, before SQL Server writes on the disk. It is supposed to protect your environment from some scenarios, where SQL Server [&hellip;]","og_url":"https:\/\/www.dbi-services.com\/blog\/transparent-data-encryption-certificate-in-master-database-is-it-really-a-good-practice\/","og_site_name":"dbi Blog","article_published_time":"2018-12-11T07:00:47+00:00","og_image":[{"width":610,"height":270,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Certificate.jpg","type":"image\/jpeg"}],"author":"Nathan Courtine","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Nathan Courtine","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/transparent-data-encryption-certificate-in-master-database-is-it-really-a-good-practice\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/transparent-data-encryption-certificate-in-master-database-is-it-really-a-good-practice\/"},"author":{"name":"Nathan Courtine","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/38305b5ebdcdb4fb784fa31d760862d1"},"headline":"Transparent Data Encryption &#8211; Certificate in master database: is it really a good practice?","datePublished":"2018-12-11T07:00:47+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/transparent-data-encryption-certificate-in-master-database-is-it-really-a-good-practice\/"},"wordCount":477,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/transparent-data-encryption-certificate-in-master-database-is-it-really-a-good-practice\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Certificate.jpg","keywords":["encryption","Microsoft SQL Server","Security","SQL Server","TDE","Transparent data encryption"],"articleSection":["Database Administration &amp; Monitoring"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/transparent-data-encryption-certificate-in-master-database-is-it-really-a-good-practice\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/transparent-data-encryption-certificate-in-master-database-is-it-really-a-good-practice\/","url":"https:\/\/www.dbi-services.com\/blog\/transparent-data-encryption-certificate-in-master-database-is-it-really-a-good-practice\/","name":"Transparent Data Encryption - Certificate in master database: is it really a good practice? - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/transparent-data-encryption-certificate-in-master-database-is-it-really-a-good-practice\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/transparent-data-encryption-certificate-in-master-database-is-it-really-a-good-practice\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Certificate.jpg","datePublished":"2018-12-11T07:00:47+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/38305b5ebdcdb4fb784fa31d760862d1"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/transparent-data-encryption-certificate-in-master-database-is-it-really-a-good-practice\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/transparent-data-encryption-certificate-in-master-database-is-it-really-a-good-practice\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/transparent-data-encryption-certificate-in-master-database-is-it-really-a-good-practice\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Certificate.jpg","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Certificate.jpg","width":610,"height":270},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/transparent-data-encryption-certificate-in-master-database-is-it-really-a-good-practice\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Transparent Data Encryption &#8211; Certificate in master database: is it really a good practice?"}]},{"@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\/38305b5ebdcdb4fb784fa31d760862d1","name":"Nathan Courtine","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/0fcc6c91bbc35c976c9d470585e48ae5d500680f1f55de5bbc5f8373b8ebb02c?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/0fcc6c91bbc35c976c9d470585e48ae5d500680f1f55de5bbc5f8373b8ebb02c?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/0fcc6c91bbc35c976c9d470585e48ae5d500680f1f55de5bbc5f8373b8ebb02c?s=96&d=mm&r=g","caption":"Nathan Courtine"},"description":"Nathan Courtine has more than four years of experience in Microsoft solutions. He is specialized in SQL Server installation, migration, performance analysis, best practices, etc. Moreover, he has a background in Oracle Java and .NET software and web development. Nathan Courtine is Microsoft Certified in Administering SQL Server 2012 Databases. Nathan Courtine holds an Engineer\u2019s Degree in Computer Science from the ENSISA (Ecole Nationale Sup\u00e9rieure d'Ing\u00e9nieurs Sud Alsace) in Mulhouse (F). His branch-related experience covers Public Sector, Automotive, IT, Financial Services \/ Banking, etc.","url":"https:\/\/www.dbi-services.com\/blog\/author\/nathan-courtine\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/11814","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\/14"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=11814"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/11814\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/11815"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=11814"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=11814"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=11814"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=11814"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}