{"id":10620,"date":"2017-11-07T15:17:49","date_gmt":"2017-11-07T14:17:49","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/sql-server-tips-deactivate-the-customer-experience-improvement-program-ceip\/"},"modified":"2017-11-07T15:17:49","modified_gmt":"2017-11-07T14:17:49","slug":"sql-server-tips-deactivate-the-customer-experience-improvement-program-ceip","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/sql-server-tips-deactivate-the-customer-experience-improvement-program-ceip\/","title":{"rendered":"SQL Server Tips: Deactivate the Customer Experience Improvement Program (CEIP)"},"content":{"rendered":"<p>Before SQL Server 2016, you had the possibility to check the case \u201cSend Windows and SQL Server Error Reports\u2026.\u201d during the installation if you want to be a part of the Customer Experience Improvement Program (CEIP).<br \/>\nIn SQL Server 2016, after the installation, all of the CEIP are automatically turned on.<\/p>\n<h2>Why?<\/h2>\n<p>SQL Server and SQL Azure share the same code now. On Azure, this service existed since a long time. It collects a large amount of data to automate various tasks and keeps the system functional including support for the following:<\/p>\n<ul>\n<li>Incident Management (CRIs, LSIs)<\/li>\n<li>Alert management (proactive approach)<\/li>\n<li>Automated management via bots (based on alerts)<\/li>\n<li>Machine learning \/ data science<\/li>\n<li>Investigating potential new features that can benefit a maximum of clients<\/li>\n<\/ul>\n<p>As you can see, the idea of integrating the CEIP service with SQL 2016 is to be able to extend this ability to collect &#8220;useful&#8221; data to Microsoft in order to maximize the impact on future developments.<\/p>\n<h2>My Thinking<\/h2>\n<p><strong><span style=\"color: red\">In this article, I do not want to start a discussion whether to leave this service active or not.<\/span><\/strong><br \/>\nWith the guarantees given by Microsoft on the information collected, it is also not a question of security.<br \/>\nThe SQL Server Team has published an explicit policy that spells out what and when data is collected:<a href=\"\/\/www.microsoft.com\/EN-US\/privacystatement\/SQLServer\/Default.aspx\" target=\"_blank\"> https:\/\/www.microsoft.com\/EN-US\/privacystatement\/SQLServer\/Default.aspx<\/a><br \/>\nAs a lot of servers have no internet access, this service is often useless (as data cannot be sent).<br \/>\nIn previous versions, I did not install the CEIP on Production environment. So in the same logic, I deactivated this service.<\/p>\n<h2>How to Deactivate the CEIP<\/h2>\n<p>To disable this service, we need 2 steps. I use PowerShell commands for both.<br \/>\n<strong>The first step is to deactivate all CEIP services<\/strong>.<\/p>\n<h3>Deactivate all CEIP services<\/h3>\n<p>CEIP is present for 3 SQL server services:<\/p>\n<ul>\n<li>For SQL Server Engine, you have a SQL Server CEIP service<\/li>\n<li>For SQL Server Analysis Service (SSAS), you have a SQL Analysis Services CEIP<\/li>\n<li>For SQL Server Integration Service (SSIS), you have a SQL Server Integration Services CEIP service 13.0<\/li>\n<\/ul>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CEIP01.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-19504 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CEIP01.jpg\" alt=\"CEIP01\" width=\"300\" height=\"190\" \/><\/a><br \/>\nAs you can see on this picture, we have one CEIP service per instance per service. For the Engine &amp; SSAS and one just for SSIS(shared component).<br \/>\nIf you have a look on each service, the patterns for the name are the same:<\/p>\n<ul>\n<li>For SQL Server CEIP service, you have a SQLTELEMETRY$&lt;InstanceName&gt;<\/li>\n<li>For SQL Analysis Services CEIP, you have a SSASTELEMETRY$&lt;InstanceName&gt;<\/li>\n<li>For SQL Server Integration Services CEIP service 13.0 CEIP, you have just SSISTELEMETRY130<\/li>\n<\/ul>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CEIP02.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-19505 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CEIP02.jpg\" alt=\"CEIP02\" width=\"300\" height=\"246\" \/><\/a> I run PowerShell as Administrator and run these following command to have a status of these services:<\/p>\n<pre class=\"brush: powershell; gutter: true; first-line: 1\">Get-Service |? name -Like \"SQLTELEMETRY*\" | select -property name,starttype,status\nGet-Service |? name -Like \"SSASTELEMETRY*\" | select -property name,starttype,status\nGet-Service |? name -Like \"SSISTELEMETRY*\" | select -property name,starttype,status<\/pre>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CEIP03.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-19506 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CEIP03.jpg\" alt=\"CEIP03\" width=\"300\" height=\"123\" \/><\/a><br \/>\nWe can also be more generic and use this command:<\/p>\n<pre class=\"brush: powershell; gutter: true; first-line: 1\">Get-Service |? name -Like \"*TELEMETRY*\" | select -property name,starttype,status<\/pre>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CEIP04.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-19507 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CEIP04.jpg\" alt=\"CEIP04\" width=\"300\" height=\"62\" \/><\/a><br \/>\nTo disable these services, I do it in 2 steps. The first step is to stop the service and the second step is to disable the service:<\/p>\n<ul>\n<li>Stop services\n<pre class=\"brush: powershell; gutter: true; first-line: 1\">Get-Service |? name -Like \"*TELEMETRY*\" | ? status -eq \"running\" | Stop-Service<\/pre>\n<\/li>\n<li>Disable services\n<pre class=\"brush: powershell; gutter: true; first-line: 1\">Get-Service |? name -Like \"*TELEMETRY*\" | Set-Service -StartMode Disabled<\/pre>\n<\/li>\n<\/ul>\n<p>Here you find the \u201cstep by step\u201d script:<\/p>\n<pre class=\"brush: powershell; gutter: true; first-line: 1\">##################################################\n# Disable CEIP services\u00a0 #\n##################################################\nGet-Service |? name -Like \"*TELEMETRY*\" | select -property name,starttype,status\n# Stop all CEIP services\nGet-Service |? name -Like \"*TELEMETRY*\" | ? status -eq \"running\" | Stop-Service\nGet-Service |? name -Like \"*TELEMETRY*\" | select -property name,starttype,status\n# Disable all CEIP services\nGet-Service |? name -Like \"*TELEMETRY*\" | Set-Service -StartMode Disabled\nGet-Service |? name -Like \"*TELEMETRY*\" | select -property name,starttype,status\n##################################################\n<\/pre>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CEIP05.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-19508 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CEIP05.jpg\" alt=\"CEIP05\" width=\"300\" height=\"171\" \/><\/a><\/p>\n<p>My colleague David, send me a &#8220;optimize&#8221; script to do all-in-one:<\/p>\n<pre class=\"brush: powershell; gutter: true; first-line: 1\">##################################################\n# Disable CEIP services  #\n##################################################\nGet-Service |? name -Like \"*TELEMETRY*\" | select -property name,starttype,status\nGet-Service -name \"*TELEMETRY*\" | Stop-Service -passthru | Set-Service -startmode disabled\nGet-Service |? name -Like \"*TELEMETRY*\" | select -property name,starttype,status\n##################################################<\/pre>\n<p>All CEIP services are now stopped and disabled. Good job, St\u00e9phane \ud83d\ude0e , but it\u2019s not finished, we have a second step to do\u2026<br \/>\n<strong>The second step is to set all CEIP registry keys to 0.<\/strong><\/p>\n<h3>Set all CEIP registry keys to 0<\/h3>\n<p>This step is more complex because we have a lot of registry keys. Two parameters have to be set to 0:<\/p>\n<ul>\n<li>CustomerFeedback<\/li>\n<li>EnableErrorReporting<\/li>\n<\/ul>\n<p>The first registry key is <em>HKEY_LOCAL_MACHINE\\Software\\Microsoft\\Microsoft SQL Server\\130\\<\/em><br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CEIP06.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-19509 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CEIP06.jpg\" alt=\"CEIP06\" width=\"300\" height=\"159\" \/><\/a><br \/>\nThe second registry key is<em> HKEY_LOCAL_MACHINE\\Software\\<strong>Wow6432Node<\/strong>\\Microsoft\\Microsoft SQL Server\\130\\<\/em><br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CEIP07.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-19510 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CEIP07.jpg\" alt=\"CEIP07\" width=\"300\" height=\"217\" \/><\/a><br \/>\nThe other registry keys are per instance and per services(Engine, SSAS and SSRS):<br \/>\n<em>HKEY_LOCAL_MACHINE\\Software\\Microsoft\\Microsoft SQL Server\\MSSQL**.&lt;instance&gt;\\CPE\\<\/em><br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CEIP08.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-19511 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CEIP08.jpg\" alt=\"CEIP08\" width=\"300\" height=\"209\" \/><\/a><br \/>\n<em>HKEY_LOCAL_MACHINE\\Software\\Microsoft\\Microsoft SQL Server\\MSAS**.&lt;instance&gt;\\CPE\\<\/em><br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CEIP09.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-19512 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CEIP09.jpg\" alt=\"CEIP09\" width=\"300\" height=\"211\" \/><\/a><br \/>\n<em>HKEY_LOCAL_MACHINE\\Software\\Microsoft\\Microsoft SQL Server\\MSRS**.&lt;instance&gt;\\CPE\\<\/em><br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CEIP10.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-19513 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CEIP10.jpg\" alt=\"CEIP10\" width=\"300\" height=\"215\" \/><\/a><br \/>\nTo set all these keys to 0, I use \u201csimply\u201d PowerShell Commands:<\/p>\n<pre class=\"brush: powershell; gutter: true; first-line: 1\">##################################################\n#\u00a0 Deactivate CEIP registry keys #\n##################################################\n# Set all CustomerFeedback &amp; EnableErrorReporting in the key directory HKLM:\\SOFTWARE\\Microsoft\\Microsoft SQL Server to 0\n# Set HKEY_LOCAL_MACHINE\\Software\\Microsoft\\Microsoft SQL Server\\***\\CustomerFeedback=0\n# Set HKEY_LOCAL_MACHINE\\Software\\Microsoft\\Microsoft SQL Server\\***\\EnableErrorReporting=0\n# *** --&gt; Version of SQL Server (100,110,120,130,140,...)\n# For the Engine\n# Set HKEY_LOCAL_MACHINE\\Software\\Microsoft\\Microsoft SQL Server\\MSSQL**.&lt;instance&gt;\\CPE\\CustomerFeedback=0\n# Set HKEY_LOCAL_MACHINE\\Software\\Microsoft\\Microsoft SQL Server\\MSSQL**.&lt;instance&gt;\\CPE\\EnableErrorReporting=0\n# For SQL Server Analysis Server (SSAS)\n# Set HKEY_LOCAL_MACHINE\\Software\\Microsoft\\Microsoft SQL Server\\MSAS**.&lt;instance&gt;\\CPE\\CustomerFeedback=0\n# Set HKEY_LOCAL_MACHINE\\Software\\Microsoft\\Microsoft SQL Server\\MSAS**.&lt;instance&gt;\\CPE\\EnableErrorReporting=0\n# For Server Reporting Server (SSRS)\n# Set HKEY_LOCAL_MACHINE\\Software\\Microsoft\\Microsoft SQL Server\\MSRS**.&lt;instance&gt;\\CPE\\CustomerFeedback=0\n# Set HKEY_LOCAL_MACHINE\\Software\\Microsoft\\Microsoft SQL Server\\MSRS**.&lt;instance&gt;\\CPE\\EnableErrorReporting=0\n# ** --&gt; Version of SQL Server (10,11,12,13,14,...)\n##################################################\n$Key = 'HKLM:\\SOFTWARE\\Microsoft\\Microsoft SQL Server'\n$FoundKeys = Get-ChildItem $Key -Recurse | Where-Object -Property Property -eq 'EnableErrorReporting'\nforeach ($Sqlfoundkey in $FoundKeys)\n{\n$SqlFoundkey | Set-ItemProperty -Name EnableErrorReporting -Value 0\n$SqlFoundkey | Set-ItemProperty -Name CustomerFeedback -Value 0\n}\n##################################################\n# Set HKEY_LOCAL_MACHINE\\Software\\Wow6432Node\\Microsoft\\Microsoft SQL Server\\***\\CustomerFeedback=0\n# Set HKEY_LOCAL_MACHINE\\Software\\Wow6432Node\\Microsoft\\Microsoft SQL Server\\***\\EnableErrorReporting=0\n# *** --&gt; Version of SQL Server(100,110,120,130,140,...)\n##################################################\n$WowKey = \"HKLM:\\SOFTWARE\\Wow6432Node\\Microsoft\\Microsoft SQL Server\"\n$FoundWowKeys = Get-ChildItem $WowKey | Where-Object -Property Property -eq 'EnableErrorReporting'\nforeach ($SqlFoundWowKey in $FoundWowKeys)\n{\n$SqlFoundWowKey | Set-ItemProperty -Name EnableErrorReporting -Value 0\n$SqlFoundWowKey | Set-ItemProperty -Name CustomerFeedback -Value 0\n}<\/pre>\n<p>As you can see, I use only the EnableErrorReporting key in the Where-Object clause to find the impacted keys. After running this script you have all CEIP registry key set to 0\u2026<br \/>\nEt voila, CEIP is totally deactivated!<\/p>\n<p>To finish, I will thanks all my SQL Server colleagues for their help to have a good vision of this tricky subject. It was also a good discussion internally in our SQL Server Expert Team to define what to do by customer!\u00a0\u00a0 \ud83d\ude42<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Before SQL Server 2016, you had the possibility to check the case \u201cSend Windows and SQL Server Error Reports\u2026.\u201d during the installation if you want to be a part of the Customer Experience Improvement Program (CEIP). In SQL Server 2016, after the installation, all of the CEIP are automatically turned on. Why? SQL Server and [&hellip;]<\/p>\n","protected":false},"author":15,"featured_media":10621,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229,198,99],"tags":[49,51,54,52,566],"type_dbi":[],"class_list":["post-10620","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","tag-sql-server-2012","tag-sql-server-2014","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 Tips: Deactivate the Customer Experience Improvement Program (CEIP) - 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-tips-deactivate-the-customer-experience-improvement-program-ceip\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Server Tips: Deactivate the Customer Experience Improvement Program (CEIP)\" \/>\n<meta property=\"og:description\" content=\"Before SQL Server 2016, you had the possibility to check the case \u201cSend Windows and SQL Server Error Reports\u2026.\u201d during the installation if you want to be a part of the Customer Experience Improvement Program (CEIP). In SQL Server 2016, after the installation, all of the CEIP are automatically turned on. Why? SQL Server and [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/sql-server-tips-deactivate-the-customer-experience-improvement-program-ceip\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2017-11-07T14:17:49+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CEIP01.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"950\" \/>\n\t<meta property=\"og:image:height\" content=\"601\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\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=\"6 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-tips-deactivate-the-customer-experience-improvement-program-ceip\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-tips-deactivate-the-customer-experience-improvement-program-ceip\/\"},\"author\":{\"name\":\"St\u00e9phane Haby\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b\"},\"headline\":\"SQL Server Tips: Deactivate the Customer Experience Improvement Program (CEIP)\",\"datePublished\":\"2017-11-07T14:17:49+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-tips-deactivate-the-customer-experience-improvement-program-ceip\/\"},\"wordCount\":741,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-tips-deactivate-the-customer-experience-improvement-program-ceip\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CEIP01.jpg\",\"keywords\":[\"Microsoft\",\"SQL Server\",\"SQL Server 2012\",\"SQL Server 2014\",\"SQL Server 2016\"],\"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-tips-deactivate-the-customer-experience-improvement-program-ceip\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-tips-deactivate-the-customer-experience-improvement-program-ceip\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-tips-deactivate-the-customer-experience-improvement-program-ceip\/\",\"name\":\"SQL Server Tips: Deactivate the Customer Experience Improvement Program (CEIP) - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-tips-deactivate-the-customer-experience-improvement-program-ceip\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-tips-deactivate-the-customer-experience-improvement-program-ceip\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CEIP01.jpg\",\"datePublished\":\"2017-11-07T14:17:49+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-tips-deactivate-the-customer-experience-improvement-program-ceip\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/sql-server-tips-deactivate-the-customer-experience-improvement-program-ceip\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-tips-deactivate-the-customer-experience-improvement-program-ceip\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CEIP01.jpg\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CEIP01.jpg\",\"width\":950,\"height\":601},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-tips-deactivate-the-customer-experience-improvement-program-ceip\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Server Tips: Deactivate the Customer Experience Improvement Program (CEIP)\"}]},{\"@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 Tips: Deactivate the Customer Experience Improvement Program (CEIP) - 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-tips-deactivate-the-customer-experience-improvement-program-ceip\/","og_locale":"en_US","og_type":"article","og_title":"SQL Server Tips: Deactivate the Customer Experience Improvement Program (CEIP)","og_description":"Before SQL Server 2016, you had the possibility to check the case \u201cSend Windows and SQL Server Error Reports\u2026.\u201d during the installation if you want to be a part of the Customer Experience Improvement Program (CEIP). In SQL Server 2016, after the installation, all of the CEIP are automatically turned on. Why? SQL Server and [&hellip;]","og_url":"https:\/\/www.dbi-services.com\/blog\/sql-server-tips-deactivate-the-customer-experience-improvement-program-ceip\/","og_site_name":"dbi Blog","article_published_time":"2017-11-07T14:17:49+00:00","og_image":[{"width":950,"height":601,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CEIP01.jpg","type":"image\/jpeg"}],"author":"St\u00e9phane Haby","twitter_card":"summary_large_image","twitter_misc":{"Written by":"St\u00e9phane Haby","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-tips-deactivate-the-customer-experience-improvement-program-ceip\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-tips-deactivate-the-customer-experience-improvement-program-ceip\/"},"author":{"name":"St\u00e9phane Haby","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b"},"headline":"SQL Server Tips: Deactivate the Customer Experience Improvement Program (CEIP)","datePublished":"2017-11-07T14:17:49+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-tips-deactivate-the-customer-experience-improvement-program-ceip\/"},"wordCount":741,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-tips-deactivate-the-customer-experience-improvement-program-ceip\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CEIP01.jpg","keywords":["Microsoft","SQL Server","SQL Server 2012","SQL Server 2014","SQL Server 2016"],"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-tips-deactivate-the-customer-experience-improvement-program-ceip\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-tips-deactivate-the-customer-experience-improvement-program-ceip\/","url":"https:\/\/www.dbi-services.com\/blog\/sql-server-tips-deactivate-the-customer-experience-improvement-program-ceip\/","name":"SQL Server Tips: Deactivate the Customer Experience Improvement Program (CEIP) - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-tips-deactivate-the-customer-experience-improvement-program-ceip\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-tips-deactivate-the-customer-experience-improvement-program-ceip\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CEIP01.jpg","datePublished":"2017-11-07T14:17:49+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-tips-deactivate-the-customer-experience-improvement-program-ceip\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/sql-server-tips-deactivate-the-customer-experience-improvement-program-ceip\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-tips-deactivate-the-customer-experience-improvement-program-ceip\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CEIP01.jpg","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CEIP01.jpg","width":950,"height":601},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-tips-deactivate-the-customer-experience-improvement-program-ceip\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"SQL Server Tips: Deactivate the Customer Experience Improvement Program (CEIP)"}]},{"@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\/10620","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=10620"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/10620\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/10621"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=10620"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=10620"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=10620"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=10620"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}