{"id":1307,"date":"2020-02-18T10:01:17","date_gmt":"2020-02-18T16:01:17","guid":{"rendered":"http:\/\/www.sqlnuggets.com\/?p=1307"},"modified":"2020-02-18T10:01:21","modified_gmt":"2020-02-18T16:01:21","slug":"disable-telemetry-on-multiple-sql-servers-with-powershell","status":"publish","type":"post","link":"https:\/\/sqlnuggets.com\/disable-telemetry-on-multiple-sql-servers-with-powershell\/","title":{"rendered":"Disable Telemetry On Multiple SQL Servers With PowerShell"},"content":{"rendered":"\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"682\" src=\"https:\/\/sqlnuggets.com\/wp-content\/uploads\/2020\/02\/binoculars-431488_1280-1024x682.jpg\" alt=\"\" class=\"wp-image-1308\" srcset=\"https:\/\/sqlnuggets.com\/wp-content\/uploads\/2020\/02\/binoculars-431488_1280-1024x682.jpg 1024w, https:\/\/sqlnuggets.com\/wp-content\/uploads\/2020\/02\/binoculars-431488_1280-300x200.jpg 300w, https:\/\/sqlnuggets.com\/wp-content\/uploads\/2020\/02\/binoculars-431488_1280-768x512.jpg 768w, https:\/\/sqlnuggets.com\/wp-content\/uploads\/2020\/02\/binoculars-431488_1280.jpg 1280w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure><\/div>\n\n\n\n<p>Starting with SQL Server 2016, when you install SQL Server it also installs the CEIP (Customer Experience Improvement Program) Services, also known at Telemetry.  In previous versions of SQL Server this was optional, but as of SQL Server 2016 it is automatically installed and enabled by default.<\/p>\n\n\n\n<p>Now whether this is good or bad is up for debate, and I encourage you read Brent Ozar&#8217;s post on <a href=\"https:\/\/www.brentozar.com\/archive\/2019\/02\/what-queries-does-microsofts-telemetry-service-run-on-your-sql-server\/\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\"What Queries Does Microsoft\u2019s Telemetry Service Run On Your SQL Server (opens in a new tab)\">What Queries Does Microsoft\u2019s Telemetry Service Run On Your SQL Server<\/a> to determine for yourself if you want this service running or not.  I personally like to turn it off, mainly for a couple of reasons.  First, many of my SQL Servers do not have access to anything outside of our internal network, so it&#8217;s pointless for them to gather this telemetry data and try to send it to Microsoft.  Second, I deal with confidential data and do not want to run the risk of anything accidentally getting shipped offsite. <\/p>\n\n\n\n<h3 class=\"wp-block-heading\">How Do I Disable Telemetry?<\/h3>\n\n\n\n<p>There are a couple of ways to turn off the CEIP Service.  If you only need to do it on a few servers, you can follow <a rel=\"noreferrer noopener\" aria-label=\"this SQL Server Central article (opens in a new tab)\" href=\"https:\/\/www.sqlservercentral.com\/blogs\/disable-or-turn-off-sql-server-telemetry-service\" target=\"_blank\">this SQL Server Central article<\/a> on using the Error and Usage Reporting Application that installs with SQL Server.  Simply uncheck a few boxes, click &#8220;OK&#8221;, and you&#8217;re done.  <\/p>\n\n\n\n<p>However, if you have multiple SQL Servers you may want to consider using PowerShell to handle this for you.  Basically you&#8217;ll need to stop\/disable the Telemetry service, as well as edit some values in the registry to turn off CEIP.  The beauty of doing this in PowerShell is that you can give it a list of servers and it will go do all of them for you. Here is the PowerShell script that I use:<\/p>\n\n\n<pre class=\"lang:ps decode:true  \">$server = 'Server01' ,'Server02','Server03','Server04'\n\n# Stop all CEIP services\ninvoke-command -computername $server {Get-Service |? name -Like \"*TELEMETRY*\" | ? status -eq \"running\" | Stop-Service}\n\n# Disable all CEIP services\ninvoke-command -computername $server {Get-Service |? name -Like \"*TELEMETRY*\" | Set-Service -StartMode Disabled}\n\n# Check service status (should see \"stopped\" and \"disabled\"\ninvoke-command -computername $server {Get-Service |? name -Like \"*TELEMETRY*\" | select -property name,starttype,status}\n\n# Disable \"Error Reporting\" and \"Customer Feedback\" Registry Values  #\ninvoke-command -computername $server {Get-ChildItem 'HKLM:\\SOFTWARE\\Microsoft\\Microsoft SQL Server' -Recurse | Where-Object -Property Property -eq 'EnableErrorReporting'| Set-ItemProperty -Name EnableErrorReporting -Value 0}\ninvoke-command -computername $server {Get-ChildItem 'HKLM:\\SOFTWARE\\Microsoft\\Microsoft SQL Server' -Recurse | Where-Object -Property Property -eq 'EnableErrorReporting'| Set-ItemProperty -Name CustomerFeedback -Value 0}\ninvoke-command -computername $server {Get-ChildItem 'HKLM:\\SOFTWARE\\Wow6432Node\\Microsoft\\Microsoft SQL Server' -Recurse | Where-Object -Property Property -eq 'EnableErrorReporting'| Set-ItemProperty -Name EnableErrorReporting -Value 0}\ninvoke-command -computername $server {Get-ChildItem 'HKLM:\\SOFTWARE\\Wow6432Node\\Microsoft\\Microsoft SQL Server' -Recurse | Where-Object -Property Property -eq 'EnableErrorReporting'| Set-ItemProperty -Name CustomerFeedback -Value 0}\n\n# Check registry values (should see 0 for \"EnableErrorReporting\" and \"CustomerFeedback\")\ninvoke-command -computername $server {Get-ChildItem 'HKLM:\\SOFTWARE\\Microsoft\\Microsoft SQL Server' -Recurse | Where-Object -Property Property -eq 'EnableErrorReporting'}\ninvoke-command -computername $server {Get-ChildItem 'HKLM:\\SOFTWARE\\Wow6432Node\\Microsoft\\Microsoft SQL Server' -Recurse | Where-Object -Property Property -eq 'EnableErrorReporting'}\n<\/pre>\n<p>\u00a0<\/p>\n\n\n<p>There are a couple of things to point out here:<\/p>\n\n\n\n<ol class=\"wp-block-list\"><li><strong>Edit the registry at your own risk!<\/strong>  To quote Brent in the above linked article, &#8220;editing the registry, much like the Wu-Tang Clan, is nothing to, uh, mess around with.&#8221;<\/li><li><strong>This only works on &#8220;Paid For&#8221; versions of SQL Server.<\/strong> You cannot disable this functionality in Developer, Enterprise Evaluation, and Express editions of SQL Server. <\/li><\/ol>\n\n\n\n<p>As always, test this in a non-production environment first.  It&#8217;s never a good idea to download some random script off of the internet and run it in production.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Starting with SQL Server 2016, when you install SQL Server it also installs the CEIP (Customer Experience Improvement Program) Services, also known at Telemetry. In previous versions of SQL Server &#8230;<\/p>\n","protected":false},"author":2,"featured_media":1308,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[68,20],"tags":[],"class_list":["post-1307","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-configurations","category-powershell"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.5 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Disable Telemetry On Multiple SQL Servers With PowerShell - SQL Nuggets<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"http:\/\/www.sqlnuggets.com\/disable-telemetry-on-multiple-sql-servers-with-powershell\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Disable Telemetry On Multiple SQL Servers With PowerShell - SQL Nuggets\" \/>\n<meta property=\"og:description\" content=\"Starting with SQL Server 2016, when you install SQL Server it also installs the CEIP (Customer Experience Improvement Program) Services, also known at Telemetry. In previous versions of SQL Server ...\" \/>\n<meta property=\"og:url\" content=\"http:\/\/www.sqlnuggets.com\/disable-telemetry-on-multiple-sql-servers-with-powershell\/\" \/>\n<meta property=\"og:site_name\" content=\"SQL Nuggets\" \/>\n<meta property=\"article:published_time\" content=\"2020-02-18T16:01:17+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-02-18T16:01:21+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.sqlnuggets.com\/wp-content\/uploads\/2020\/02\/binoculars-431488_1280.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1280\" \/>\n\t<meta property=\"og:image:height\" content=\"853\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Eric Cobb\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@cfgears\" \/>\n<meta name=\"twitter:site\" content=\"@sqlnugg\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Eric Cobb\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"http:\\\/\\\/www.sqlnuggets.com\\\/disable-telemetry-on-multiple-sql-servers-with-powershell\\\/#article\",\"isPartOf\":{\"@id\":\"http:\\\/\\\/www.sqlnuggets.com\\\/disable-telemetry-on-multiple-sql-servers-with-powershell\\\/\"},\"author\":{\"name\":\"Eric Cobb\",\"@id\":\"http:\\\/\\\/www.sqlnuggets.com\\\/#\\\/schema\\\/person\\\/210536254addbc1b9d2d95dc1448b38a\"},\"headline\":\"Disable Telemetry On Multiple SQL Servers With PowerShell\",\"datePublished\":\"2020-02-18T16:01:17+00:00\",\"dateModified\":\"2020-02-18T16:01:21+00:00\",\"mainEntityOfPage\":{\"@id\":\"http:\\\/\\\/www.sqlnuggets.com\\\/disable-telemetry-on-multiple-sql-servers-with-powershell\\\/\"},\"wordCount\":392,\"commentCount\":0,\"publisher\":{\"@id\":\"http:\\\/\\\/www.sqlnuggets.com\\\/#organization\"},\"image\":{\"@id\":\"http:\\\/\\\/www.sqlnuggets.com\\\/disable-telemetry-on-multiple-sql-servers-with-powershell\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/sqlnuggets.com\\\/wp-content\\\/uploads\\\/2020\\\/02\\\/binoculars-431488_1280.jpg\",\"articleSection\":[\"Configurations\",\"PowerShell\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"http:\\\/\\\/www.sqlnuggets.com\\\/disable-telemetry-on-multiple-sql-servers-with-powershell\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"http:\\\/\\\/www.sqlnuggets.com\\\/disable-telemetry-on-multiple-sql-servers-with-powershell\\\/\",\"url\":\"http:\\\/\\\/www.sqlnuggets.com\\\/disable-telemetry-on-multiple-sql-servers-with-powershell\\\/\",\"name\":\"Disable Telemetry On Multiple SQL Servers With PowerShell - SQL Nuggets\",\"isPartOf\":{\"@id\":\"http:\\\/\\\/www.sqlnuggets.com\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"http:\\\/\\\/www.sqlnuggets.com\\\/disable-telemetry-on-multiple-sql-servers-with-powershell\\\/#primaryimage\"},\"image\":{\"@id\":\"http:\\\/\\\/www.sqlnuggets.com\\\/disable-telemetry-on-multiple-sql-servers-with-powershell\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/sqlnuggets.com\\\/wp-content\\\/uploads\\\/2020\\\/02\\\/binoculars-431488_1280.jpg\",\"datePublished\":\"2020-02-18T16:01:17+00:00\",\"dateModified\":\"2020-02-18T16:01:21+00:00\",\"breadcrumb\":{\"@id\":\"http:\\\/\\\/www.sqlnuggets.com\\\/disable-telemetry-on-multiple-sql-servers-with-powershell\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"http:\\\/\\\/www.sqlnuggets.com\\\/disable-telemetry-on-multiple-sql-servers-with-powershell\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"http:\\\/\\\/www.sqlnuggets.com\\\/disable-telemetry-on-multiple-sql-servers-with-powershell\\\/#primaryimage\",\"url\":\"https:\\\/\\\/sqlnuggets.com\\\/wp-content\\\/uploads\\\/2020\\\/02\\\/binoculars-431488_1280.jpg\",\"contentUrl\":\"https:\\\/\\\/sqlnuggets.com\\\/wp-content\\\/uploads\\\/2020\\\/02\\\/binoculars-431488_1280.jpg\",\"width\":1280,\"height\":853},{\"@type\":\"BreadcrumbList\",\"@id\":\"http:\\\/\\\/www.sqlnuggets.com\\\/disable-telemetry-on-multiple-sql-servers-with-powershell\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"http:\\\/\\\/www.sqlnuggets.com\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Disable Telemetry On Multiple SQL Servers With PowerShell\"}]},{\"@type\":\"WebSite\",\"@id\":\"http:\\\/\\\/www.sqlnuggets.com\\\/#website\",\"url\":\"http:\\\/\\\/www.sqlnuggets.com\\\/\",\"name\":\"SQL Nuggets\",\"description\":\"Nuggets Of SQL Server Knowledge\",\"publisher\":{\"@id\":\"http:\\\/\\\/www.sqlnuggets.com\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"http:\\\/\\\/www.sqlnuggets.com\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"http:\\\/\\\/www.sqlnuggets.com\\\/#organization\",\"name\":\"SQL Nuggets\",\"url\":\"http:\\\/\\\/www.sqlnuggets.com\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"http:\\\/\\\/www.sqlnuggets.com\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/sqlnuggets.com\\\/wp-content\\\/uploads\\\/2023\\\/11\\\/website-logo.jpg\",\"contentUrl\":\"https:\\\/\\\/sqlnuggets.com\\\/wp-content\\\/uploads\\\/2023\\\/11\\\/website-logo.jpg\",\"width\":320,\"height\":54,\"caption\":\"SQL Nuggets\"},\"image\":{\"@id\":\"http:\\\/\\\/www.sqlnuggets.com\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/x.com\\\/sqlnugg\",\"https:\\\/\\\/www.linkedin.com\\\/in\\\/ericcobb\\\/\"]},{\"@type\":\"Person\",\"@id\":\"http:\\\/\\\/www.sqlnuggets.com\\\/#\\\/schema\\\/person\\\/210536254addbc1b9d2d95dc1448b38a\",\"name\":\"Eric Cobb\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/3ca1fc0c7054a668e048f09d412cd4ebf89833c4630fbbfccca78a0678a6bdc2?s=96&d=mm&r=pg\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/3ca1fc0c7054a668e048f09d412cd4ebf89833c4630fbbfccca78a0678a6bdc2?s=96&d=mm&r=pg\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/3ca1fc0c7054a668e048f09d412cd4ebf89833c4630fbbfccca78a0678a6bdc2?s=96&d=mm&r=pg\",\"caption\":\"Eric Cobb\"},\"sameAs\":[\"https:\\\/\\\/x.com\\\/cfgears\"],\"url\":\"https:\\\/\\\/sqlnuggets.com\\\/author\\\/eric-cobb\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Disable Telemetry On Multiple SQL Servers With PowerShell - SQL Nuggets","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":"http:\/\/www.sqlnuggets.com\/disable-telemetry-on-multiple-sql-servers-with-powershell\/","og_locale":"en_US","og_type":"article","og_title":"Disable Telemetry On Multiple SQL Servers With PowerShell - SQL Nuggets","og_description":"Starting with SQL Server 2016, when you install SQL Server it also installs the CEIP (Customer Experience Improvement Program) Services, also known at Telemetry. In previous versions of SQL Server ...","og_url":"http:\/\/www.sqlnuggets.com\/disable-telemetry-on-multiple-sql-servers-with-powershell\/","og_site_name":"SQL Nuggets","article_published_time":"2020-02-18T16:01:17+00:00","article_modified_time":"2020-02-18T16:01:21+00:00","og_image":[{"width":1280,"height":853,"url":"http:\/\/www.sqlnuggets.com\/wp-content\/uploads\/2020\/02\/binoculars-431488_1280.jpg","type":"image\/jpeg"}],"author":"Eric Cobb","twitter_card":"summary_large_image","twitter_creator":"@cfgears","twitter_site":"@sqlnugg","twitter_misc":{"Written by":"Eric Cobb","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"http:\/\/www.sqlnuggets.com\/disable-telemetry-on-multiple-sql-servers-with-powershell\/#article","isPartOf":{"@id":"http:\/\/www.sqlnuggets.com\/disable-telemetry-on-multiple-sql-servers-with-powershell\/"},"author":{"name":"Eric Cobb","@id":"http:\/\/www.sqlnuggets.com\/#\/schema\/person\/210536254addbc1b9d2d95dc1448b38a"},"headline":"Disable Telemetry On Multiple SQL Servers With PowerShell","datePublished":"2020-02-18T16:01:17+00:00","dateModified":"2020-02-18T16:01:21+00:00","mainEntityOfPage":{"@id":"http:\/\/www.sqlnuggets.com\/disable-telemetry-on-multiple-sql-servers-with-powershell\/"},"wordCount":392,"commentCount":0,"publisher":{"@id":"http:\/\/www.sqlnuggets.com\/#organization"},"image":{"@id":"http:\/\/www.sqlnuggets.com\/disable-telemetry-on-multiple-sql-servers-with-powershell\/#primaryimage"},"thumbnailUrl":"https:\/\/sqlnuggets.com\/wp-content\/uploads\/2020\/02\/binoculars-431488_1280.jpg","articleSection":["Configurations","PowerShell"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["http:\/\/www.sqlnuggets.com\/disable-telemetry-on-multiple-sql-servers-with-powershell\/#respond"]}]},{"@type":"WebPage","@id":"http:\/\/www.sqlnuggets.com\/disable-telemetry-on-multiple-sql-servers-with-powershell\/","url":"http:\/\/www.sqlnuggets.com\/disable-telemetry-on-multiple-sql-servers-with-powershell\/","name":"Disable Telemetry On Multiple SQL Servers With PowerShell - SQL Nuggets","isPartOf":{"@id":"http:\/\/www.sqlnuggets.com\/#website"},"primaryImageOfPage":{"@id":"http:\/\/www.sqlnuggets.com\/disable-telemetry-on-multiple-sql-servers-with-powershell\/#primaryimage"},"image":{"@id":"http:\/\/www.sqlnuggets.com\/disable-telemetry-on-multiple-sql-servers-with-powershell\/#primaryimage"},"thumbnailUrl":"https:\/\/sqlnuggets.com\/wp-content\/uploads\/2020\/02\/binoculars-431488_1280.jpg","datePublished":"2020-02-18T16:01:17+00:00","dateModified":"2020-02-18T16:01:21+00:00","breadcrumb":{"@id":"http:\/\/www.sqlnuggets.com\/disable-telemetry-on-multiple-sql-servers-with-powershell\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["http:\/\/www.sqlnuggets.com\/disable-telemetry-on-multiple-sql-servers-with-powershell\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"http:\/\/www.sqlnuggets.com\/disable-telemetry-on-multiple-sql-servers-with-powershell\/#primaryimage","url":"https:\/\/sqlnuggets.com\/wp-content\/uploads\/2020\/02\/binoculars-431488_1280.jpg","contentUrl":"https:\/\/sqlnuggets.com\/wp-content\/uploads\/2020\/02\/binoculars-431488_1280.jpg","width":1280,"height":853},{"@type":"BreadcrumbList","@id":"http:\/\/www.sqlnuggets.com\/disable-telemetry-on-multiple-sql-servers-with-powershell\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"http:\/\/www.sqlnuggets.com\/"},{"@type":"ListItem","position":2,"name":"Disable Telemetry On Multiple SQL Servers With PowerShell"}]},{"@type":"WebSite","@id":"http:\/\/www.sqlnuggets.com\/#website","url":"http:\/\/www.sqlnuggets.com\/","name":"SQL Nuggets","description":"Nuggets Of SQL Server Knowledge","publisher":{"@id":"http:\/\/www.sqlnuggets.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"http:\/\/www.sqlnuggets.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"http:\/\/www.sqlnuggets.com\/#organization","name":"SQL Nuggets","url":"http:\/\/www.sqlnuggets.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"http:\/\/www.sqlnuggets.com\/#\/schema\/logo\/image\/","url":"https:\/\/sqlnuggets.com\/wp-content\/uploads\/2023\/11\/website-logo.jpg","contentUrl":"https:\/\/sqlnuggets.com\/wp-content\/uploads\/2023\/11\/website-logo.jpg","width":320,"height":54,"caption":"SQL Nuggets"},"image":{"@id":"http:\/\/www.sqlnuggets.com\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/x.com\/sqlnugg","https:\/\/www.linkedin.com\/in\/ericcobb\/"]},{"@type":"Person","@id":"http:\/\/www.sqlnuggets.com\/#\/schema\/person\/210536254addbc1b9d2d95dc1448b38a","name":"Eric Cobb","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/3ca1fc0c7054a668e048f09d412cd4ebf89833c4630fbbfccca78a0678a6bdc2?s=96&d=mm&r=pg","url":"https:\/\/secure.gravatar.com\/avatar\/3ca1fc0c7054a668e048f09d412cd4ebf89833c4630fbbfccca78a0678a6bdc2?s=96&d=mm&r=pg","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/3ca1fc0c7054a668e048f09d412cd4ebf89833c4630fbbfccca78a0678a6bdc2?s=96&d=mm&r=pg","caption":"Eric Cobb"},"sameAs":["https:\/\/x.com\/cfgears"],"url":"https:\/\/sqlnuggets.com\/author\/eric-cobb\/"}]}},"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/sqlnuggets.com\/wp-content\/uploads\/2020\/02\/binoculars-431488_1280.jpg","jetpack_shortlink":"https:\/\/wp.me\/pdyDvE-l5","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":870,"url":"https:\/\/sqlnuggets.com\/getting-started-with-the-dbatools-powershell-module\/","url_meta":{"origin":1307,"position":0},"title":"Getting Started With The dbatools PowerShell Module","author":"Eric Cobb","date":"September 20, 2018","format":false,"excerpt":"If you are looking for a super easy way to start using PowerShell to manage your SQL Servers, then the\u00a0dbatools PowerShell module is for you!\u00a0 For those that aren't familiar, dbatools is a\u00a0free\u00a0PowerShell module with over 400 SQL Server best practice, administration, development and migration commands included. I have to\u2026","rel":"","context":"In &quot;PowerShell&quot;","block_context":{"text":"PowerShell","link":"https:\/\/sqlnuggets.com\/category\/powershell\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/sqlnuggets.com\/wp-content\/uploads\/2018\/07\/powershell4.png?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/sqlnuggets.com\/wp-content\/uploads\/2018\/07\/powershell4.png?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/sqlnuggets.com\/wp-content\/uploads\/2018\/07\/powershell4.png?resize=525%2C300&ssl=1 1.5x"},"classes":[]},{"id":1350,"url":"https:\/\/sqlnuggets.com\/setting-up-database-mail-and-sql-agent-alerts-with-powershell\/","url_meta":{"origin":1307,"position":1},"title":"Setting Up Database Mail And SQL Agent Alerts With PowerShell","author":"Eric Cobb","date":"April 21, 2020","format":false,"excerpt":"As a DBA, you need to know when there's a problem on your SQL Servers. And while I highly recommend you use a full-fledged monitoring system, there are also some things you can set up on your SQL Servers so that they will tell you when certain things go wrong.\u2026","rel":"","context":"In &quot;Configurations&quot;","block_context":{"text":"Configurations","link":"https:\/\/sqlnuggets.com\/category\/configurations\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/sqlnuggets.com\/wp-content\/uploads\/2020\/04\/banner-1165979_1280.png?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/sqlnuggets.com\/wp-content\/uploads\/2020\/04\/banner-1165979_1280.png?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/sqlnuggets.com\/wp-content\/uploads\/2020\/04\/banner-1165979_1280.png?resize=525%2C300&ssl=1 1.5x, https:\/\/i0.wp.com\/sqlnuggets.com\/wp-content\/uploads\/2020\/04\/banner-1165979_1280.png?resize=700%2C400&ssl=1 2x, https:\/\/i0.wp.com\/sqlnuggets.com\/wp-content\/uploads\/2020\/04\/banner-1165979_1280.png?resize=1050%2C600&ssl=1 3x"},"classes":[]},{"id":897,"url":"https:\/\/sqlnuggets.com\/using-dbatools-powershell-module-to-set-maxdop-and-max-memory\/","url_meta":{"origin":1307,"position":2},"title":"Using dbatools PowerShell Module To Set MAXDOP And Max Memory","author":"Eric Cobb","date":"November 27, 2018","format":false,"excerpt":"As I continue my blog series on using\u00a0the\u00a0dbatools PowerShell module, today I want to discuss using it to set MAXDOP and Max Memory on your SQL Server.\u00a0 This builds directly off of my previous post on\u00a0Using dbatools PowerShell Module To Configure SQL Server, so if you haven't seen that one\u2026","rel":"","context":"In &quot;PowerShell&quot;","block_context":{"text":"PowerShell","link":"https:\/\/sqlnuggets.com\/category\/powershell\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/sqlnuggets.com\/wp-content\/uploads\/2018\/07\/powershell4.png?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/sqlnuggets.com\/wp-content\/uploads\/2018\/07\/powershell4.png?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/sqlnuggets.com\/wp-content\/uploads\/2018\/07\/powershell4.png?resize=525%2C300&ssl=1 1.5x"},"classes":[]},{"id":887,"url":"https:\/\/sqlnuggets.com\/using-dbatools-powershell-module-to-configure-sql-server\/","url_meta":{"origin":1307,"position":3},"title":"Using dbatools PowerShell Module To Configure SQL Server","author":"Eric Cobb","date":"October 9, 2018","format":false,"excerpt":"The more I use\u00a0the\u00a0dbatools PowerShell module, the more I like it.\u00a0 It really is a solid set of scripts that allow you to easily manage your SQL Servers via PowerShell.\u00a0 If you are not familiar with dbatools, I recommend you head over to my previous post,\u00a0Getting Started With The dbatools\u2026","rel":"","context":"In &quot;PowerShell&quot;","block_context":{"text":"PowerShell","link":"https:\/\/sqlnuggets.com\/category\/powershell\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/sqlnuggets.com\/wp-content\/uploads\/2018\/07\/powershell4.png?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/sqlnuggets.com\/wp-content\/uploads\/2018\/07\/powershell4.png?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/sqlnuggets.com\/wp-content\/uploads\/2018\/07\/powershell4.png?resize=525%2C300&ssl=1 1.5x"},"classes":[]},{"id":341,"url":"https:\/\/sqlnuggets.com\/calling-powershell-from-sql-agent-gives-syntax-error\/","url_meta":{"origin":1307,"position":4},"title":"Calling PowerShell From SQL Agent Gives Syntax Error","author":"Eric Cobb","date":"March 16, 2017","format":false,"excerpt":"One cool thing that you can do in\u00a0SQL Server that a lot of people don't know about is\u00a0run PowerShell code\u00a0from a SQL Agent job. \u00a0However, I recently ran into a problem when trying to schedule a SQL Agent job to run a PowerShell script. \u00a0The script is fairly simple, it\u2026","rel":"","context":"In &quot;PowerShell&quot;","block_context":{"text":"PowerShell","link":"https:\/\/sqlnuggets.com\/category\/powershell\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1049,"url":"https:\/\/sqlnuggets.com\/patching-multiple-sql-servers-with-powershell-and-dbatools\/","url_meta":{"origin":1307,"position":5},"title":"Patching Multiple SQL Servers With Powershell and dbatools","author":"Eric Cobb","date":"July 18, 2019","format":false,"excerpt":"Patching SQL Server can sometimes be a time consuming process, especially when you have multiple servers that need to be patched. Remoting in to each box to run through the update wizard is tedious, and if you have multiple patches to apply you're going to be spending a considerable chunk\u2026","rel":"","context":"In &quot;PowerShell&quot;","block_context":{"text":"PowerShell","link":"https:\/\/sqlnuggets.com\/category\/powershell\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/sqlnuggets.com\/wp-content\/uploads\/2018\/07\/powershell4.png?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/sqlnuggets.com\/wp-content\/uploads\/2018\/07\/powershell4.png?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/sqlnuggets.com\/wp-content\/uploads\/2018\/07\/powershell4.png?resize=525%2C300&ssl=1 1.5x"},"classes":[]}],"_links":{"self":[{"href":"https:\/\/sqlnuggets.com\/wp-json\/wp\/v2\/posts\/1307","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sqlnuggets.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sqlnuggets.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sqlnuggets.com\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/sqlnuggets.com\/wp-json\/wp\/v2\/comments?post=1307"}],"version-history":[{"count":0,"href":"https:\/\/sqlnuggets.com\/wp-json\/wp\/v2\/posts\/1307\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/sqlnuggets.com\/wp-json\/wp\/v2\/media\/1308"}],"wp:attachment":[{"href":"https:\/\/sqlnuggets.com\/wp-json\/wp\/v2\/media?parent=1307"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sqlnuggets.com\/wp-json\/wp\/v2\/categories?post=1307"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sqlnuggets.com\/wp-json\/wp\/v2\/tags?post=1307"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}