{"id":6520,"date":"2015-12-14T14:49:22","date_gmt":"2015-12-14T13:49:22","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-new-t-sql-commands-compress-and-decompress\/"},"modified":"2015-12-14T14:49:22","modified_gmt":"2015-12-14T13:49:22","slug":"sql-server-2016-new-t-sql-commands-compress-and-decompress","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-new-t-sql-commands-compress-and-decompress\/","title":{"rendered":"SQL Server 2016: new T-SQL commands COMPRESS and DECOMPRESS"},"content":{"rendered":"<p>In live from the <a title=\"Site GUSS\" href=\"http:\/\/guss.pro\/\" target=\"_blank\">JSS2015 <\/a>(Journ\u00e9e SQL Server 2015) in Paris, we saw that the CTP3.1 has been available in the night of these 2 days.<\/p>\n<p>One new feature available for this release in the T-SQL domain is <strong>COMPRESS<\/strong> and <strong>DECOMPRESS<\/strong>.<\/p>\n<p><!--more--><\/p>\n<p>Through a GZIP algorithm, you can compress and decompress an argument for nvarchar, varchar, varbinary, char and binary data types.<br \/>\nI create a table to test these new feature. The source table is a workload of the ErrorLog with three columns:<\/p>\n<ul>\n<li>LogDate (datetime)<\/li>\n<li>Process (varchar(20))<\/li>\n<li>Text(varchar(MAX))<\/li>\n<\/ul>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Compress01.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-6046 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Compress01.png\" alt=\"Compress01\" width=\"300\" height=\"203\" \/><\/a><br \/>\nThe goal is to copy all rows from ErrorLog Table and compress the Column &#8220;Text&#8221; with a data type varchar(max) in a second ErrorLog table: ErrorLog2<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Compress02.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-6047 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Compress02.png\" alt=\"Compress02\" width=\"300\" height=\"125\" \/><\/a><br \/>\nIn the execution plan, the compression has an implicit conversion in a &#8220;compute scalar&#8221; operation.<br \/>\nThe result of a compression on a column is a varbinary<br \/>\nIf I do a simple select on these tables, the compressed column appears with some unreadable characters.<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Compress04.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-6049 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Compress04.png\" alt=\"Compress04\" width=\"300\" height=\"243\" \/><\/a><br \/>\nI try to read the line with the DECOMPRESS option.<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Compress05.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-6050 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Compress05.png\" alt=\"Compress05\" width=\"300\" height=\"127\" \/><\/a><br \/>\nIn this case, you have not an implicit conversion like in the insert.<br \/>\nYou can see that an error message 8116 appears with an invalid argument of the decompression function.<br \/>\nTo have a varbinary, I used the CAST function<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Compress07.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-6052 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Compress07.png\" alt=\"Compress07\" width=\"300\" height=\"116\" \/><\/a><br \/>\nWith the CAST, the Column Text cannot be read correctly and I need to use a second time a CAST to have a varchar.<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">SELECT TOP 5 [LogDate] ,[ProcessInfo], CAST(DECOMPRESS(CAST(Text AS VARBINARY(MAX))) AS VARCHAR(MAX)) FROM [ErrorLog2]<\/pre>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Compress08.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-6053 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Compress08.png\" alt=\"Compress08\" width=\"300\" height=\"149\" \/><\/a><br \/>\n2 CAST to have the information is very awful! \ud83d\ude15<br \/>\nIn a second time, I create a new table like ErrorLog but with a column Text in Varbinary(max): ErroLog3<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Compress03.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-6048 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Compress03.png\" alt=\"Compress03\" width=\"300\" height=\"116\" \/><\/a><br \/>\nYou can notice that no implicit conversion is done during an insert.<br \/>\nAs before, I try to read the line with the DECOMPRESS option.<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Compress09.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-6054 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Compress09.png\" alt=\"Compress09\" width=\"276\" height=\"300\" \/><\/a><br \/>\nI have no error message in this case but the Column Text cannot be read.<br \/>\nI must reuse a CAST to have a readable column<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">SELECT TOP 5 [LogDate] ,[ProcessInfo], CAST (DECOMPRESS(Text) as varchar(max)) FROM [ErrorLog3]<\/pre>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Compress10.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-6055 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Compress10.png\" alt=\"Compress10\" width=\"300\" height=\"123\" \/><\/a><br \/>\nEt Voila! I finish this test with a little tips: instead of decompressing with varchar I have to use nvarchar.<br \/>\nI let you see the result.<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Compress11.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-6056 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Compress11.png\" alt=\"Compress11\" width=\"300\" height=\"183\" \/><\/a><br \/>\nMsdn reference for <a title=\"COMPRESS T-SQL Command\" href=\"https:\/\/msdn.microsoft.com\/en-us\/library\/mt622775.aspx\" target=\"_blank\">COMPRESS <\/a><br \/>\nMsdn reference for <a title=\"DECOMPRESS T-SQL Command\" href=\"https:\/\/msdn.microsoft.com\/en-us\/library\/mt622776.aspx\" target=\"_blank\">DECOMPRESS<\/a><\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In live from the JSS2015 (Journ\u00e9e SQL Server 2015) in Paris, we saw that the CTP3.1 has been available in the night of these 2 days. One new feature available for this release in the T-SQL domain is COMPRESS and DECOMPRESS.<\/p>\n","protected":false},"author":15,"featured_media":6531,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[48],"tags":[49,98,51,566],"type_dbi":[],"class_list":["post-6520","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-technology-survey","tag-microsoft","tag-sql","tag-sql-server","tag-sql-server-2016"],"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 2016: new T-SQL commands COMPRESS and DECOMPRESS<\/title>\n<meta name=\"description\" content=\"New features available for SQL Server 2016 are COMPRESS and DECOMPRESS T-SQL command.\" \/>\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-2016-new-t-sql-commands-compress-and-decompress\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Server 2016: new T-SQL commands COMPRESS and DECOMPRESS\" \/>\n<meta property=\"og:description\" content=\"New features available for SQL Server 2016 are COMPRESS and DECOMPRESS T-SQL command.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-new-t-sql-commands-compress-and-decompress\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2015-12-14T13:49:22+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Compress01-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"881\" \/>\n\t<meta property=\"og:image:height\" content=\"595\" \/>\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-2016-new-t-sql-commands-compress-and-decompress\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-new-t-sql-commands-compress-and-decompress\/\"},\"author\":{\"name\":\"St\u00e9phane Haby\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b\"},\"headline\":\"SQL Server 2016: new T-SQL commands COMPRESS and DECOMPRESS\",\"datePublished\":\"2015-12-14T13:49:22+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-new-t-sql-commands-compress-and-decompress\/\"},\"wordCount\":351,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-new-t-sql-commands-compress-and-decompress\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Compress01-1.png\",\"keywords\":[\"Microsoft\",\"SQL\",\"SQL Server\",\"SQL Server 2016\"],\"articleSection\":[\"Technology Survey\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-new-t-sql-commands-compress-and-decompress\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-new-t-sql-commands-compress-and-decompress\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-new-t-sql-commands-compress-and-decompress\/\",\"name\":\"SQL Server 2016: new T-SQL commands COMPRESS and DECOMPRESS\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-new-t-sql-commands-compress-and-decompress\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-new-t-sql-commands-compress-and-decompress\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Compress01-1.png\",\"datePublished\":\"2015-12-14T13:49:22+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b\"},\"description\":\"New features available for SQL Server 2016 are COMPRESS and DECOMPRESS T-SQL command.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-new-t-sql-commands-compress-and-decompress\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-new-t-sql-commands-compress-and-decompress\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-new-t-sql-commands-compress-and-decompress\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Compress01-1.png\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Compress01-1.png\",\"width\":881,\"height\":595},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-new-t-sql-commands-compress-and-decompress\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Server 2016: new T-SQL commands COMPRESS and DECOMPRESS\"}]},{\"@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 2016: new T-SQL commands COMPRESS and DECOMPRESS","description":"New features available for SQL Server 2016 are COMPRESS and DECOMPRESS T-SQL command.","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-2016-new-t-sql-commands-compress-and-decompress\/","og_locale":"en_US","og_type":"article","og_title":"SQL Server 2016: new T-SQL commands COMPRESS and DECOMPRESS","og_description":"New features available for SQL Server 2016 are COMPRESS and DECOMPRESS T-SQL command.","og_url":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-new-t-sql-commands-compress-and-decompress\/","og_site_name":"dbi Blog","article_published_time":"2015-12-14T13:49:22+00:00","og_image":[{"width":881,"height":595,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Compress01-1.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-2016-new-t-sql-commands-compress-and-decompress\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-new-t-sql-commands-compress-and-decompress\/"},"author":{"name":"St\u00e9phane Haby","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b"},"headline":"SQL Server 2016: new T-SQL commands COMPRESS and DECOMPRESS","datePublished":"2015-12-14T13:49:22+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-new-t-sql-commands-compress-and-decompress\/"},"wordCount":351,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-new-t-sql-commands-compress-and-decompress\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Compress01-1.png","keywords":["Microsoft","SQL","SQL Server","SQL Server 2016"],"articleSection":["Technology Survey"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/sql-server-2016-new-t-sql-commands-compress-and-decompress\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-new-t-sql-commands-compress-and-decompress\/","url":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-new-t-sql-commands-compress-and-decompress\/","name":"SQL Server 2016: new T-SQL commands COMPRESS and DECOMPRESS","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-new-t-sql-commands-compress-and-decompress\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-new-t-sql-commands-compress-and-decompress\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Compress01-1.png","datePublished":"2015-12-14T13:49:22+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b"},"description":"New features available for SQL Server 2016 are COMPRESS and DECOMPRESS T-SQL command.","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-new-t-sql-commands-compress-and-decompress\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/sql-server-2016-new-t-sql-commands-compress-and-decompress\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-new-t-sql-commands-compress-and-decompress\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Compress01-1.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Compress01-1.png","width":881,"height":595},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-new-t-sql-commands-compress-and-decompress\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"SQL Server 2016: new T-SQL commands COMPRESS and DECOMPRESS"}]},{"@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\/6520","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=6520"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/6520\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/6531"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=6520"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=6520"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=6520"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=6520"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}