{"id":5172,"date":"2015-05-18T05:38:37","date_gmt":"2015-05-18T03:38:37","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/get-the-main-information-from-windows-server-with-powershell\/"},"modified":"2015-05-18T05:38:37","modified_gmt":"2015-05-18T03:38:37","slug":"get-the-main-information-from-windows-server-with-powershell","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/get-the-main-information-from-windows-server-with-powershell\/","title":{"rendered":"Get the main information from Windows Server with PowerShell"},"content":{"rendered":"<p>This blog will present you a way to retrieve Windows Server main information via PowerShell. The goal is to be able to automate the extraction of information for different purposes: audit, report generation, dashboards&#8230;<\/p>\n<p>&nbsp;<\/p>\n<p>Disclaimer: I am not a developer but a SQL Server dba. If you find errors or some ways of improvement, I will be glad to read your comments!<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<h3>Computer System information<\/h3>\n<p>First, I initialize the WMI object containing the computer system information of my Windows Server:<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/wmi_computer_system.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone  wp-image-2710\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/wmi_computer_system.png\" alt=\"wmi_computer_system\" width=\"808\" height=\"36\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>This object contains a lot of information regarding your computer system. If you want to know all the information you can obtain from this object, proceed as follows:<\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/computer_system_all_information.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-2711\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/computer_system_all_information.png\" alt=\"computer_system_all_information\" width=\"1200\" height=\"841\" \/><\/a><\/p>\n<p>Here is an example of the information which can be retrieved:<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/computer_system_main_information.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-2712\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/computer_system_main_information.png\" alt=\"computer_system_main_information\" width=\"528\" height=\"264\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>The Total Physical Memory is displayed in Bytes.<\/p>\n<p>&nbsp;<\/p>\n<h3>Operating System Information<\/h3>\n<p>First, I initialize the WMI object containing the operating system information of my Windows Server:<\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/wmi_computer_system.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone  wp-image-2710\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/wmi_computer_system.png\" alt=\"wmi_computer_system\" width=\"786\" height=\"35\" \/><\/a><\/p>\n<p>As for the Computer System information, you can list all the information contained in the WMI object with:<\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/operating_system_all_information.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-2713\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/operating_system_all_information.png\" alt=\"operating_system_all_information\" width=\"1200\" height=\"718\" \/><\/a><\/p>\n<p>Here is an example of the information which can be retrieved:<\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/operating_system_main_information.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-2714\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/operating_system_main_information.png\" alt=\"operating_system_main_information\" width=\"539\" height=\"176\" \/><\/a><\/p>\n<p>The Free Physical Memory is displayed in Kilobytes.<\/p>\n<p>&nbsp;<\/p>\n<p>The Install Date property is not very intuitive by default! You need to format the value, as follows:<\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/format_date.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-2715\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/format_date.png\" alt=\"format_date\" width=\"809\" height=\"362\" \/><\/a><\/p>\n<p>The date is displayed depending on the culture. In this example, the culture is set to &#8220;fr-CH&#8221;, so the date is displayed in French.<\/p>\n<p>&nbsp;<\/p>\n<p>The OS Language is not very intuitive. The value 1033 correspond to &#8220;en-US&#8221;. It can be formatted through PowerShell, as follows:<\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/format_oslanguage.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-2716\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/format_oslanguage.png\" alt=\"format_oslanguage\" width=\"1081\" height=\"173\" \/><\/a><\/p>\n<p>By formatting the information you retrieve in the instance SMO object, you can generate reports, audit your environment or whatever!<\/p>\n<p>The following capture is an existing dashboard from our <a href=\"index.php\/products\/database-management-kit\">Database Management Kit (DMK)<\/a>.<\/p>\n<p>&nbsp;<\/p>\n<h3>\u00a0<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/dmk_server_information.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-2717\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/dmk_server_information.png\" alt=\"dmk_server_information\" width=\"1200\" height=\"307\" \/><\/a><\/h3>\n<h3>Next Steps<\/h3>\n<p>In almost all cases, you can do the same thing in T-SQL through the &#8220;sqlcmd&#8221; command. Indeed, the Windows Sever information are accessible directly in SQL Server via the DMV&#8217;s beginning with &#8220;sys.dm_os&#8221;.<\/p>\n<p>Here is an example:<\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/invoke_sqlcmd.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone  wp-image-2718\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/invoke_sqlcmd.png\" alt=\"invoke_sqlcmd\" width=\"949\" height=\"232\" \/><\/a><\/p>\n<p>I hope this blog will help you in your work!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>This blog will present you a way to retrieve Windows Server main information via PowerShell. The goal is to be able to automate the extraction of information for different purposes: audit, report generation, dashboards&#8230; &nbsp; Disclaimer: I am not a developer but a SQL Server dba. If you find errors or some ways of improvement, [&hellip;]<\/p>\n","protected":false},"author":14,"featured_media":5182,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229],"tags":[],"type_dbi":[],"class_list":["post-5172","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database-administration-monitoring"],"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>Get the main information from Windows Server with PowerShell - dbi Blog<\/title>\n<meta name=\"description\" content=\"This blog will present you a way to retrieve Windows Server main information via PowerShell.\" \/>\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\/get-the-main-information-from-windows-server-with-powershell\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Get the main information from Windows Server with PowerShell\" \/>\n<meta property=\"og:description\" content=\"This blog will present you a way to retrieve Windows Server main information via PowerShell.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/get-the-main-information-from-windows-server-with-powershell\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2015-05-18T03:38:37+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/wmi_computer_system-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"651\" \/>\n\t<meta property=\"og:image:height\" content=\"29\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\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=\"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\\\/get-the-main-information-from-windows-server-with-powershell\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/get-the-main-information-from-windows-server-with-powershell\\\/\"},\"author\":{\"name\":\"Nathan Courtine\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/38305b5ebdcdb4fb784fa31d760862d1\"},\"headline\":\"Get the main information from Windows Server with PowerShell\",\"datePublished\":\"2015-05-18T03:38:37+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/get-the-main-information-from-windows-server-with-powershell\\\/\"},\"wordCount\":354,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/get-the-main-information-from-windows-server-with-powershell\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/wmi_computer_system-1.png\",\"articleSection\":[\"Database Administration &amp; Monitoring\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/get-the-main-information-from-windows-server-with-powershell\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/get-the-main-information-from-windows-server-with-powershell\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/get-the-main-information-from-windows-server-with-powershell\\\/\",\"name\":\"Get the main information from Windows Server with PowerShell - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/get-the-main-information-from-windows-server-with-powershell\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/get-the-main-information-from-windows-server-with-powershell\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/wmi_computer_system-1.png\",\"datePublished\":\"2015-05-18T03:38:37+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/38305b5ebdcdb4fb784fa31d760862d1\"},\"description\":\"This blog will present you a way to retrieve Windows Server main information via PowerShell.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/get-the-main-information-from-windows-server-with-powershell\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/get-the-main-information-from-windows-server-with-powershell\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/get-the-main-information-from-windows-server-with-powershell\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/wmi_computer_system-1.png\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/wmi_computer_system-1.png\",\"width\":651,\"height\":29},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/get-the-main-information-from-windows-server-with-powershell\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Get the main information from Windows Server with PowerShell\"}]},{\"@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":"Get the main information from Windows Server with PowerShell - dbi Blog","description":"This blog will present you a way to retrieve Windows Server main information via PowerShell.","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\/get-the-main-information-from-windows-server-with-powershell\/","og_locale":"en_US","og_type":"article","og_title":"Get the main information from Windows Server with PowerShell","og_description":"This blog will present you a way to retrieve Windows Server main information via PowerShell.","og_url":"https:\/\/www.dbi-services.com\/blog\/get-the-main-information-from-windows-server-with-powershell\/","og_site_name":"dbi Blog","article_published_time":"2015-05-18T03:38:37+00:00","og_image":[{"width":651,"height":29,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/wmi_computer_system-1.png","type":"image\/png"}],"author":"Nathan Courtine","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Nathan Courtine","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/get-the-main-information-from-windows-server-with-powershell\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/get-the-main-information-from-windows-server-with-powershell\/"},"author":{"name":"Nathan Courtine","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/38305b5ebdcdb4fb784fa31d760862d1"},"headline":"Get the main information from Windows Server with PowerShell","datePublished":"2015-05-18T03:38:37+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/get-the-main-information-from-windows-server-with-powershell\/"},"wordCount":354,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/get-the-main-information-from-windows-server-with-powershell\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/wmi_computer_system-1.png","articleSection":["Database Administration &amp; Monitoring"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/get-the-main-information-from-windows-server-with-powershell\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/get-the-main-information-from-windows-server-with-powershell\/","url":"https:\/\/www.dbi-services.com\/blog\/get-the-main-information-from-windows-server-with-powershell\/","name":"Get the main information from Windows Server with PowerShell - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/get-the-main-information-from-windows-server-with-powershell\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/get-the-main-information-from-windows-server-with-powershell\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/wmi_computer_system-1.png","datePublished":"2015-05-18T03:38:37+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/38305b5ebdcdb4fb784fa31d760862d1"},"description":"This blog will present you a way to retrieve Windows Server main information via PowerShell.","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/get-the-main-information-from-windows-server-with-powershell\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/get-the-main-information-from-windows-server-with-powershell\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/get-the-main-information-from-windows-server-with-powershell\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/wmi_computer_system-1.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/wmi_computer_system-1.png","width":651,"height":29},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/get-the-main-information-from-windows-server-with-powershell\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Get the main information from Windows Server with PowerShell"}]},{"@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\/5172","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=5172"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/5172\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/5182"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=5172"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=5172"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=5172"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=5172"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}