{"id":13772,"date":"2020-03-24T15:55:35","date_gmt":"2020-03-24T14:55:35","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/sql-server-tool-mssql-cli\/"},"modified":"2020-03-24T15:55:35","modified_gmt":"2020-03-24T14:55:35","slug":"sql-server-tool-mssql-cli","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/sql-server-tool-mssql-cli\/","title":{"rendered":"SQL Server Tool: MSSQL-CLI"},"content":{"rendered":"<p><a href=\"https:\/\/docs.microsoft.com\/fr-fr\/sql\/tools\/mssql-cli?view=sql-server-ver15\" target=\"_blank\" rel=\"noopener noreferrer\">MSSQL-CLI<\/a> is a useful new command line tool. Not so new because this tool exist since 2018 but a little bit unknow.<\/p>\n<p>You find this tool on GitHub <a href=\"https:\/\/github.com\/dbcli\/mssql-cli\" target=\"_blank\" rel=\"noopener noreferrer\">here.<\/a><\/p>\n<p>One of the big advantage is the number of platforms available, Windows of course but also macOS, Ubuntu, Debian, CentOs, Red Hat, OpenSuse, Suse Enterprise and Fedora.<br \/>\nThis interactive command-line query tool has many advantages like the full IntelliSense support, the auto-complete, the syntax highlighting, the query history, the configuration file support, the Multiline queries,..<\/p>\n<p>I test the tool on a Windows Server 2016.<br \/>\nBefore you install it on Windows, you need to install the latest version of <a href=\"https:\/\/www.python.org\/downloads\/\" target=\"_blank\" rel=\"noopener noreferrer\">Python<\/a>.<br \/>\nDuring the installation of Python, do not forget to select the &#8216;Add Python to PATH&#8217; option.<br \/>\nAfter, you can install mssql-cli with the command:<\/p>\n<pre class=\"brush: shell; gutter: true; first-line: 1\">Pip install mssql_cli-015.0-py2.py3-none-win32.whl<\/pre>\n<p>First, to see all options, you use the command:<\/p>\n<pre class=\"brush: shell; gutter: true; first-line: 1\">mssql-cli --help<\/pre>\n<p style=\"text-align: left\"><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/MSSQL_CLI01-3.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-38466 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/MSSQL_CLI01-3.png\" alt=\"\" width=\"300\" height=\"252\" \/><\/a><br \/>\nTo begin, in my test environment, I connect to my local instance INST_SQL2019. I use the option \u2013S for the server with the value .\\INST_SQL2019 and the option \u2013E to use the integrated authentication with my account:<\/p>\n<pre class=\"brush: shell; gutter: true; first-line: 1\">Mssql-cli \u2013S .\\SQL2019RTM \u2013E<\/pre>\n<p style=\"text-align: center\"><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/MSSQL_CLI02-1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-38483 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/MSSQL_CLI02-1.png\" alt=\"\" width=\"300\" height=\"271\" \/><\/a><\/p>\n<p>After that, I can begin to test the tool with some commands. When I begin to write the query, the IntelliSense propose me every time something and you can see the syntax highlighting in this screenshot:<\/p>\n<p style=\"text-align: center\"><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/MSSQL_CLI03a-1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-38484 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/MSSQL_CLI03a-1.png\" alt=\"\" width=\"300\" height=\"233\" \/><\/a><\/p>\n<p>Let\u2019s go with a first easy select:<\/p>\n<p style=\"text-align: center\"><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/MSSQL_CLI03b-1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-38485 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/MSSQL_CLI03b-1.png\" alt=\"\" width=\"300\" height=\"249\" \/><\/a><\/p>\n<p>As you can see, the result is more to read as with SQLCMD&#8230;<\/p>\n<p style=\"text-align: center\"><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/MSSQL_CLI04.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-38486\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/MSSQL_CLI04.png\" alt=\"\" width=\"292\" height=\"300\" \/><\/a><\/p>\n<p>You have also \u201cspecial Commands\u201d<br \/>\n\\lt can be helpful and show you all tables witch contain . \\ls can be also use to show schema witch contain or \\lv for views<\/p>\n<p style=\"text-align: center\"><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/MSSQL_CLI05.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-38487\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/MSSQL_CLI05.png\" alt=\"\" width=\"300\" height=\"300\" \/><\/a><\/p>\n<p>\\sn can save a with the name and after you can use \\n to run the query. \\dn delete the name and associated query.<\/p>\n<p style=\"text-align: center\"><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/MSSQL_CLI06a.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-38488\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/MSSQL_CLI06a.png\" alt=\"\" width=\"300\" height=\"148\" \/><\/a><\/p>\n<p>You can find all special commands <a href=\"https:\/\/github.com\/dbcli\/mssql-cli\/blob\/master\/doc\/usage_guide.md\" target=\"_blank\" rel=\"noopener noreferrer\">here,<\/a><\/p>\n<p>You have also some shortcut very useful like:<br \/>\nCtrl + D: exit mssql-cli<br \/>\nCtrl + K: Clear the screen<br \/>\nF3: enable the multiline mode<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/MSSQL_CLI07.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-38490 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/MSSQL_CLI07.png\" alt=\"\" width=\"300\" height=\"196\" \/><\/a><br \/>\nAs you can see, after I enable the multiline mode, you have at bottom of screen the indication.<br \/>\nTo add line, you press Enter, see the \u201c&#8230;.\u201d in the next line\u00a0 and to execute the query you need to use the \u201c;\u201d as validator<\/p>\n<p>I was very surprise to test and use it. This tool is much better that sqlcmd but not sure, that it is better than PowerShell in a Windows environment.<br \/>\nAll information how to use this tool is <a href=\"https:\/\/github.com\/dbcli\/mssql-cli\/blob\/master\/doc\/usage_guide.md\" target=\"_blank\" rel=\"noopener noreferrer\">here.<\/a><br \/>\nEnjoy using it! \ud83d\ude0e<\/p>\n","protected":false},"excerpt":{"rendered":"<p>MSSQL-CLI is a useful new command line tool. Not so new because this tool exist since 2018 but a little bit unknow. You find this tool on GitHub here. One of the big advantage is the number of platforms available, Windows of course but also macOS, Ubuntu, Debian, CentOs, Red Hat, OpenSuse, Suse Enterprise and [&hellip;]<\/p>\n","protected":false},"author":15,"featured_media":13781,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229,198,99],"tags":[49,51],"type_dbi":[],"class_list":["post-13772","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database-administration-monitoring","category-database-management","category-sql-server","tag-microsoft","tag-sql-server"],"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 Tool: MSSQL-CLI - 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-tool-mssql-cli\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Server Tool: MSSQL-CLI\" \/>\n<meta property=\"og:description\" content=\"MSSQL-CLI is a useful new command line tool. Not so new because this tool exist since 2018 but a little bit unknow. You find this tool on GitHub here. One of the big advantage is the number of platforms available, Windows of course but also macOS, Ubuntu, Debian, CentOs, Red Hat, OpenSuse, Suse Enterprise and [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/sql-server-tool-mssql-cli\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2020-03-24T14:55:35+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/MSSQL_CLI01.png\" \/>\n\t<meta property=\"og:image:width\" content=\"2199\" \/>\n\t<meta property=\"og:image:height\" content=\"1845\" \/>\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-tool-mssql-cli\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-tool-mssql-cli\/\"},\"author\":{\"name\":\"St\u00e9phane Haby\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b\"},\"headline\":\"SQL Server Tool: MSSQL-CLI\",\"datePublished\":\"2020-03-24T14:55:35+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-tool-mssql-cli\/\"},\"wordCount\":406,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-tool-mssql-cli\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/MSSQL_CLI01.png\",\"keywords\":[\"Microsoft\",\"SQL Server\"],\"articleSection\":[\"Database Administration &amp; Monitoring\",\"Database management\",\"SQL Server\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/sql-server-tool-mssql-cli\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-tool-mssql-cli\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-tool-mssql-cli\/\",\"name\":\"SQL Server Tool: MSSQL-CLI - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-tool-mssql-cli\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-tool-mssql-cli\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/MSSQL_CLI01.png\",\"datePublished\":\"2020-03-24T14:55:35+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-tool-mssql-cli\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/sql-server-tool-mssql-cli\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-tool-mssql-cli\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/MSSQL_CLI01.png\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/MSSQL_CLI01.png\",\"width\":2199,\"height\":1845},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-tool-mssql-cli\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Server Tool: MSSQL-CLI\"}]},{\"@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 Tool: MSSQL-CLI - 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-tool-mssql-cli\/","og_locale":"en_US","og_type":"article","og_title":"SQL Server Tool: MSSQL-CLI","og_description":"MSSQL-CLI is a useful new command line tool. Not so new because this tool exist since 2018 but a little bit unknow. You find this tool on GitHub here. One of the big advantage is the number of platforms available, Windows of course but also macOS, Ubuntu, Debian, CentOs, Red Hat, OpenSuse, Suse Enterprise and [&hellip;]","og_url":"https:\/\/www.dbi-services.com\/blog\/sql-server-tool-mssql-cli\/","og_site_name":"dbi Blog","article_published_time":"2020-03-24T14:55:35+00:00","og_image":[{"width":2199,"height":1845,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/MSSQL_CLI01.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-tool-mssql-cli\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-tool-mssql-cli\/"},"author":{"name":"St\u00e9phane Haby","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b"},"headline":"SQL Server Tool: MSSQL-CLI","datePublished":"2020-03-24T14:55:35+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-tool-mssql-cli\/"},"wordCount":406,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-tool-mssql-cli\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/MSSQL_CLI01.png","keywords":["Microsoft","SQL Server"],"articleSection":["Database Administration &amp; Monitoring","Database management","SQL Server"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/sql-server-tool-mssql-cli\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-tool-mssql-cli\/","url":"https:\/\/www.dbi-services.com\/blog\/sql-server-tool-mssql-cli\/","name":"SQL Server Tool: MSSQL-CLI - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-tool-mssql-cli\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-tool-mssql-cli\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/MSSQL_CLI01.png","datePublished":"2020-03-24T14:55:35+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-tool-mssql-cli\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/sql-server-tool-mssql-cli\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-tool-mssql-cli\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/MSSQL_CLI01.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/MSSQL_CLI01.png","width":2199,"height":1845},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-tool-mssql-cli\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"SQL Server Tool: MSSQL-CLI"}]},{"@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\/13772","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=13772"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/13772\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/13781"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=13772"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=13772"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=13772"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=13772"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}