{"id":10028,"date":"2017-05-10T07:54:48","date_gmt":"2017-05-10T05:54:48","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/sql-server-2017-first-steps-with-python-service\/"},"modified":"2017-05-10T07:54:48","modified_gmt":"2017-05-10T05:54:48","slug":"sql-server-2017-first-steps-with-python-service","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/sql-server-2017-first-steps-with-python-service\/","title":{"rendered":"SQL Server 2017: first steps with Python Service"},"content":{"rendered":"<p>Last year, I written blogs about SQL Server 2016 and his integration from the R language.<br \/>\nJust for information, you can find these blogs about SQL Server 2016 R Services here:<\/p>\n<ul>\n<li><a title=\"SQL Server 2016 R services\" href=\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-r-services\/\" target=\"_blank\">SQL Server 2016: R Services<\/a><\/li>\n<li><a title=\"SQL Server 2016 \u2013 R Services Tips: How to find installed packages using T-SQL?\" href=\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-r-services-tips-how-to-find-installed-packages-using-t-sql\/http:\/\/\" target=\"_blank\">SQL Server 2016 \u2013 R Services Tips: How to find installed packages using T-SQL?<\/a><\/li>\n<\/ul>\n<p>Now, the next version of SQL Server, named officially SQL Server 2017 integrate also the language Python.<br \/>\nThe first step is to install the Python Services during the installation of SQL Server.<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Python01.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-16448 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Python01.png\" alt=\"Python01\" width=\"300\" height=\"226\" \/><\/a><br \/>\nIn the <em>Instance Features &gt; Database Engine Services<\/em>, you have a new structure named \u201c<strong>Machine Learning Services (In-Database)<\/strong>\u201d with R and Python.<br \/>\nI check the case \u201cPython\u201d and next button.<br \/>\nAfter the classical instance, server and database Engine Configurations, a window \u201c<strong>Consent to install Python<\/strong>\u201d need your acceptance to be validate and go to the next installation step.<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Python02.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-16449 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Python02.png\" alt=\"Python02\" width=\"300\" height=\"227\" \/><\/a><br \/>\nAfter that, the installation begins and failed\u2026 \ud83d\ude41<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Python03.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-16450 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Python03.png\" alt=\"Python03\" width=\"300\" height=\"224\" \/><\/a><br \/>\nThe eternal question, WHY???\u2026<br \/>\nLike a majority of peoples, I don\u2019t read the text in the window \u201cConsent to install Python\u201d.<br \/>\nThe text explains \u201c<em>By clicking Next, you will start the download and installation of these packages to your machine.<\/em>\u201d. This means that you need an access to Internet.<br \/>\nYou can also go the installation log file to see the error message:<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Python10.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-16457 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Python10.png\" alt=\"Python10\" width=\"300\" height=\"69\" \/><\/a><br \/>\nAfter activating the access to Internet to download all necessary packages to use Python, the installation was successful. \ud83d\ude00<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Python04.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-16451 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Python04.png\" alt=\"Python04\" width=\"300\" height=\"225\" \/><\/a><br \/>\nI have the curiosity to have a look in the installation file and find the feature parameter for the script installation for Python. In addition of ADVANCEDANALYTICS, to install Python the parameter is <strong>SQL_INST_MPY<\/strong>.<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Python05.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-16452 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Python05.png\" alt=\"Python05\" width=\"300\" height=\"138\" \/><\/a><br \/>\nLike for R, in the instance configuration, you need to set the \u2018<strong>external script enabled<\/strong>\u2019 to 1.<br \/>\nIf you haven\u2019t read my article on SQL Server 2016: R Services, I rewrite the method to search and configure the service:<br \/>\nScript to search the configuration:<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">SELECT * FROM sys.configurations WHERE name='external scripts enabled'<\/pre>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Python06.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-16453 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Python06.png\" alt=\"Python06\" width=\"300\" height=\"127\" \/><\/a><br \/>\nAs you can see in the result, this configuration is not dynamic and need a restart of the engine.<br \/>\nAfter a restart, the configuration is enabled.<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Python07.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-16454 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Python07.png\" alt=\"Python07\" width=\"300\" height=\"106\" \/><\/a><br \/>\nTime to test a query\u2026.<br \/>\nLike my article <a title=\"SQL Server 2016 \u2013 R Services Tips: How to find installed packages using T-SQL?\" href=\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-r-services-tips-how-to-find-installed-packages-using-t-sql\/http:\/\/\" target=\"_blank\">SQL Server 2016 \u2013 R Services Tips: How to find installed packages using T-SQL?<\/a>, I will find all installed packages.<br \/>\nI have created the Query using packages <strong>pip<\/strong> and <strong>pandas<\/strong>:<\/p>\n<ul>\n<li>pip is a package management system used to install and manage software packages<\/li>\n<li>Pandas is a library for data manipulation and analysis<\/li>\n<\/ul>\n<p>The query uses the stored procedure <strong>sp_execute_external_script<\/strong> and Python as parameter for the language:<\/p>\n<pre class=\"brush: actionscript3; gutter: true; first-line: 1\">exec sp_execute_external_script  @language =N'Python',\n@script=N'import pip\nimport pandas\ninstalled_packages = pip.get_installed_distributions()\ninstalled_packages_list = sorted([\"%s %s\" % (i.key,i.version)\n     for i in installed_packages])\nOutputDataSet = pandas.DataFrame(installed_packages_list)'\n\n<\/pre>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Python08.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-16455 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Python08.png\" alt=\"Python08\" width=\"300\" height=\"209\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>You can see that you have 125 packages installed for Python with the CPT2 of SQL Server 2017.<br \/>\nHave fun with Python on SQL Server\u2026 \ud83d\ude0e<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Last year, I written blogs about SQL Server 2016 and his integration from the R language. Just for information, you can find these blogs about SQL Server 2016 R Services here: SQL Server 2016: R Services SQL Server 2016 \u2013 R Services Tips: How to find installed packages using T-SQL? Now, the next version of [&hellip;]<\/p>\n","protected":false},"author":15,"featured_media":10029,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[368,48],"tags":[49,1089,566,1077],"type_dbi":[],"class_list":["post-10028","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-development-performance","category-technology-survey","tag-microsoft","tag-python","tag-sql-server-2016","tag-sql-server-2017"],"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 2017: first steps with Python Service - 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\/sql-server-2017-first-steps-with-python-service\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Server 2017: first steps with Python Service\" \/>\n<meta property=\"og:description\" content=\"Last year, I written blogs about SQL Server 2016 and his integration from the R language. Just for information, you can find these blogs about SQL Server 2016 R Services here: SQL Server 2016: R Services SQL Server 2016 \u2013 R Services Tips: How to find installed packages using T-SQL? Now, the next version of [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/sql-server-2017-first-steps-with-python-service\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2017-05-10T05:54:48+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Python01.png\" \/>\n\t<meta property=\"og:image:width\" content=\"814\" \/>\n\t<meta property=\"og:image:height\" content=\"614\" \/>\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-2017-first-steps-with-python-service\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2017-first-steps-with-python-service\/\"},\"author\":{\"name\":\"St\u00e9phane Haby\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b\"},\"headline\":\"SQL Server 2017: first steps with Python Service\",\"datePublished\":\"2017-05-10T05:54:48+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2017-first-steps-with-python-service\/\"},\"wordCount\":436,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2017-first-steps-with-python-service\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Python01.png\",\"keywords\":[\"Microsoft\",\"Python\",\"SQL Server 2016\",\"SQL Server 2017\"],\"articleSection\":[\"Development &amp; Performance\",\"Technology Survey\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/sql-server-2017-first-steps-with-python-service\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2017-first-steps-with-python-service\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2017-first-steps-with-python-service\/\",\"name\":\"SQL Server 2017: first steps with Python Service - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2017-first-steps-with-python-service\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2017-first-steps-with-python-service\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Python01.png\",\"datePublished\":\"2017-05-10T05:54:48+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2017-first-steps-with-python-service\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/sql-server-2017-first-steps-with-python-service\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2017-first-steps-with-python-service\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Python01.png\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Python01.png\",\"width\":814,\"height\":614},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2017-first-steps-with-python-service\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Server 2017: first steps with Python Service\"}]},{\"@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 2017: first steps with Python Service - 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\/sql-server-2017-first-steps-with-python-service\/","og_locale":"en_US","og_type":"article","og_title":"SQL Server 2017: first steps with Python Service","og_description":"Last year, I written blogs about SQL Server 2016 and his integration from the R language. Just for information, you can find these blogs about SQL Server 2016 R Services here: SQL Server 2016: R Services SQL Server 2016 \u2013 R Services Tips: How to find installed packages using T-SQL? Now, the next version of [&hellip;]","og_url":"https:\/\/www.dbi-services.com\/blog\/sql-server-2017-first-steps-with-python-service\/","og_site_name":"dbi Blog","article_published_time":"2017-05-10T05:54:48+00:00","og_image":[{"width":814,"height":614,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Python01.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-2017-first-steps-with-python-service\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2017-first-steps-with-python-service\/"},"author":{"name":"St\u00e9phane Haby","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b"},"headline":"SQL Server 2017: first steps with Python Service","datePublished":"2017-05-10T05:54:48+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2017-first-steps-with-python-service\/"},"wordCount":436,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2017-first-steps-with-python-service\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Python01.png","keywords":["Microsoft","Python","SQL Server 2016","SQL Server 2017"],"articleSection":["Development &amp; Performance","Technology Survey"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/sql-server-2017-first-steps-with-python-service\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2017-first-steps-with-python-service\/","url":"https:\/\/www.dbi-services.com\/blog\/sql-server-2017-first-steps-with-python-service\/","name":"SQL Server 2017: first steps with Python Service - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2017-first-steps-with-python-service\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2017-first-steps-with-python-service\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Python01.png","datePublished":"2017-05-10T05:54:48+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2017-first-steps-with-python-service\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/sql-server-2017-first-steps-with-python-service\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2017-first-steps-with-python-service\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Python01.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Python01.png","width":814,"height":614},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2017-first-steps-with-python-service\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"SQL Server 2017: first steps with Python Service"}]},{"@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\/10028","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=10028"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/10028\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/10029"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=10028"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=10028"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=10028"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=10028"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}