{"id":86237,"date":"2019-08-21T15:00:27","date_gmt":"2019-08-21T23:00:27","guid":{"rendered":"http:\/\/devblogs.microsoft.com\/scripting\/?p=86237"},"modified":"2019-09-06T09:23:23","modified_gmt":"2019-09-06T17:23:23","slug":"powertip-identify-if-sql-servers-are-configured-to-best-practices","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/scripting\/powertip-identify-if-sql-servers-are-configured-to-best-practices\/","title":{"rendered":"PowerTip: Identify if SQL Servers are configured to best practices"},"content":{"rendered":"<p><strong>Summary<\/strong>: Using the features of the SQLServer PowerShell module to run assessments of your servers<\/p>\n<p><img decoding=\"async\" width=\"34\" height=\"34\" class=\"wp-image-86238\" src=\"http:\/\/devblogs.microsoft.com\/scripting\/wp-content\/uploads\/sites\/29\/2019\/08\/a-picture-containing-scissors-description-automat.jpeg\" alt=\"A picture containing scissors\n\nDescription automatically generated\" \/><\/p>\n<p>How can I easily check that my SQL Servers are all configured to meet best practices?<\/p>\n<p><img decoding=\"async\" width=\"34\" height=\"34\" class=\"wp-image-86239\" src=\"http:\/\/devblogs.microsoft.com\/scripting\/wp-content\/uploads\/sites\/29\/2019\/08\/word-image.jpeg\" \/><\/p>\n<p>You can use SQL Server Assessments \u2013 the latest addition to the SQLServer PowerShell module. Just Run a best practices assessment on your SQL Server as seen below<\/p>\n<p><strong>Get-SqlInstance \u00a0&#8220;DemoSQLServer&#8221; | Invoke-SqlAssessment<\/strong><\/p>\n<p><img decoding=\"async\" width=\"96\" height=\"145\" class=\"wp-image-86240\" src=\"http:\/\/devblogs.microsoft.com\/scripting\/wp-content\/uploads\/sites\/29\/2019\/08\/word-image.png\" \/><\/p>\n<p>PowerShell, Doctor Scripto, PowerTip, Johnathan Allen, SQL Server<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Summary: Using the features of the SQLServer PowerShell module to run assessments of your servers How can I easily check that my SQL Servers are all configured to meet best practices? You can use SQL Server Assessments \u2013 the latest addition to the SQLServer PowerShell module. Just Run a best practices assessment on your SQL [&hellip;]<\/p>\n","protected":false},"author":596,"featured_media":87096,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[1739,1738,639],"tags":[1740,1854,377,356,176],"class_list":["post-86237","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-doctor-scripto","category-powershell","category-powertip","tag-doctor-scripto","tag-jonathan-allen","tag-powershell","tag-powertip","tag-sql-server"],"acf":[],"blog_post_summary":"<p>Summary: Using the features of the SQLServer PowerShell module to run assessments of your servers How can I easily check that my SQL Servers are all configured to meet best practices? You can use SQL Server Assessments \u2013 the latest addition to the SQLServer PowerShell module. Just Run a best practices assessment on your SQL [&hellip;]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts\/86237","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/users\/596"}],"replies":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/comments?post=86237"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts\/86237\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/media\/87096"}],"wp:attachment":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/media?parent=86237"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/categories?post=86237"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/tags?post=86237"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}