{"id":86,"date":"2015-07-06T14:00:06","date_gmt":"2015-07-06T19:00:06","guid":{"rendered":"http:\/\/www.sqlnuggets.com\/?p=86"},"modified":"2015-07-15T15:22:15","modified_gmt":"2015-07-15T20:22:15","slug":"standalone-sql-server-management-studio","status":"publish","type":"post","link":"https:\/\/sqlnuggets.com\/standalone-sql-server-management-studio\/","title":{"rendered":"Standalone SQL Server Management Studio"},"content":{"rendered":"<p>Microsoft has released a new <a href=\"https:\/\/msdn.microsoft.com\/en-us\/library\/mt238290.aspx\" target=\"_blank\">standalone version of\u00a0SQL Server Management Studio (SSMS)<\/a>. \u00a0As with previous versions of SSMS, you still get it bundled with your SQL Server install, but\u00a0with this new release we now also have the option of downloading SSMS separately via its own lightweight installer.<\/p>\n<p>One of the great new features of this version of SSMS and the version that comes bundled with SQL Server 2016 (which I am assuming are the same SSMS 2016 product) is that it now has a built in check for updates. \u00a0While the updates do not install automatically, having the ability to update SSMS without having to download a SQL Server service pack or\u00a0cumulative update is going to be nice!<\/p>\n<p>You can download the standalone SSMS from Microsoft here:\u00a0<a href=\"https:\/\/msdn.microsoft.com\/en-us\/library\/mt238290.aspx\" target=\"_blank\">https:\/\/msdn.microsoft.com\/en-us\/library\/mt238290.aspx<\/a><\/p>\n<blockquote><p><em>This is part of a series of <a href=\"https:\/\/sqlnuggets.com\/blog\/tag\/getting-started\/\">Getting Started<\/a> posts that I&#8217;m doing in which I spotlight the tools I use in my day to day duties as a DBA. \u00a0I asked myself &#8220;What tools would I immediately install if I started a new job as a company&#8217;s first DBA?&#8221; \u00a0This series of posts are the answer to that question. \u00a0<\/em><\/p><\/blockquote>\n","protected":false},"excerpt":{"rendered":"<p>Microsoft has released a new standalone version of\u00a0SQL Server Management Studio (SSMS). \u00a0As with previous versions of SSMS, you still get it bundled with your SQL Server install, but\u00a0with this &#8230;<\/p>\n","protected":false},"author":2,"featured_media":89,"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":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[7],"tags":[9,12,8],"class_list":["post-86","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tools","tag-client-tools","tag-getting-started","tag-ssms"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.5 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Standalone SQL Server Management Studio - 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\/standalone-sql-server-management-studio\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Standalone SQL Server Management Studio - SQL Nuggets\" \/>\n<meta property=\"og:description\" content=\"Microsoft has released a new standalone version of\u00a0SQL Server Management Studio (SSMS). \u00a0As with previous versions of SSMS, you still get it bundled with your SQL Server install, but\u00a0with this ...\" \/>\n<meta property=\"og:url\" content=\"http:\/\/www.sqlnuggets.com\/standalone-sql-server-management-studio\/\" \/>\n<meta property=\"og:site_name\" content=\"SQL Nuggets\" \/>\n<meta property=\"article:published_time\" content=\"2015-07-06T19:00:06+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2015-07-15T20:22:15+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.sqlnuggets.com\/wp-content\/uploads\/2015\/07\/Microsoft-SQL-Server-e1436208354414.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"250\" \/>\n\t<meta property=\"og:image:height\" content=\"205\" \/>\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=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"http:\\\/\\\/www.sqlnuggets.com\\\/standalone-sql-server-management-studio\\\/#article\",\"isPartOf\":{\"@id\":\"http:\\\/\\\/www.sqlnuggets.com\\\/standalone-sql-server-management-studio\\\/\"},\"author\":{\"name\":\"Eric Cobb\",\"@id\":\"http:\\\/\\\/www.sqlnuggets.com\\\/#\\\/schema\\\/person\\\/210536254addbc1b9d2d95dc1448b38a\"},\"headline\":\"Standalone SQL Server Management Studio\",\"datePublished\":\"2015-07-06T19:00:06+00:00\",\"dateModified\":\"2015-07-15T20:22:15+00:00\",\"mainEntityOfPage\":{\"@id\":\"http:\\\/\\\/www.sqlnuggets.com\\\/standalone-sql-server-management-studio\\\/\"},\"wordCount\":201,\"commentCount\":0,\"publisher\":{\"@id\":\"http:\\\/\\\/www.sqlnuggets.com\\\/#organization\"},\"image\":{\"@id\":\"http:\\\/\\\/www.sqlnuggets.com\\\/standalone-sql-server-management-studio\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/sqlnuggets.com\\\/wp-content\\\/uploads\\\/2015\\\/07\\\/Microsoft-SQL-Server-e1436208354414.jpg\",\"keywords\":[\"Client Tools\",\"Getting Started\",\"SSMS\"],\"articleSection\":[\"Tools\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"http:\\\/\\\/www.sqlnuggets.com\\\/standalone-sql-server-management-studio\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"http:\\\/\\\/www.sqlnuggets.com\\\/standalone-sql-server-management-studio\\\/\",\"url\":\"http:\\\/\\\/www.sqlnuggets.com\\\/standalone-sql-server-management-studio\\\/\",\"name\":\"Standalone SQL Server Management Studio - SQL Nuggets\",\"isPartOf\":{\"@id\":\"http:\\\/\\\/www.sqlnuggets.com\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"http:\\\/\\\/www.sqlnuggets.com\\\/standalone-sql-server-management-studio\\\/#primaryimage\"},\"image\":{\"@id\":\"http:\\\/\\\/www.sqlnuggets.com\\\/standalone-sql-server-management-studio\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/sqlnuggets.com\\\/wp-content\\\/uploads\\\/2015\\\/07\\\/Microsoft-SQL-Server-e1436208354414.jpg\",\"datePublished\":\"2015-07-06T19:00:06+00:00\",\"dateModified\":\"2015-07-15T20:22:15+00:00\",\"breadcrumb\":{\"@id\":\"http:\\\/\\\/www.sqlnuggets.com\\\/standalone-sql-server-management-studio\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"http:\\\/\\\/www.sqlnuggets.com\\\/standalone-sql-server-management-studio\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"http:\\\/\\\/www.sqlnuggets.com\\\/standalone-sql-server-management-studio\\\/#primaryimage\",\"url\":\"https:\\\/\\\/sqlnuggets.com\\\/wp-content\\\/uploads\\\/2015\\\/07\\\/Microsoft-SQL-Server-e1436208354414.jpg\",\"contentUrl\":\"https:\\\/\\\/sqlnuggets.com\\\/wp-content\\\/uploads\\\/2015\\\/07\\\/Microsoft-SQL-Server-e1436208354414.jpg\",\"width\":250,\"height\":205},{\"@type\":\"BreadcrumbList\",\"@id\":\"http:\\\/\\\/www.sqlnuggets.com\\\/standalone-sql-server-management-studio\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"http:\\\/\\\/www.sqlnuggets.com\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Standalone SQL Server Management Studio\"}]},{\"@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":"Standalone SQL Server Management Studio - 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\/standalone-sql-server-management-studio\/","og_locale":"en_US","og_type":"article","og_title":"Standalone SQL Server Management Studio - SQL Nuggets","og_description":"Microsoft has released a new standalone version of\u00a0SQL Server Management Studio (SSMS). \u00a0As with previous versions of SSMS, you still get it bundled with your SQL Server install, but\u00a0with this ...","og_url":"http:\/\/www.sqlnuggets.com\/standalone-sql-server-management-studio\/","og_site_name":"SQL Nuggets","article_published_time":"2015-07-06T19:00:06+00:00","article_modified_time":"2015-07-15T20:22:15+00:00","og_image":[{"width":250,"height":205,"url":"http:\/\/www.sqlnuggets.com\/wp-content\/uploads\/2015\/07\/Microsoft-SQL-Server-e1436208354414.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":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"http:\/\/www.sqlnuggets.com\/standalone-sql-server-management-studio\/#article","isPartOf":{"@id":"http:\/\/www.sqlnuggets.com\/standalone-sql-server-management-studio\/"},"author":{"name":"Eric Cobb","@id":"http:\/\/www.sqlnuggets.com\/#\/schema\/person\/210536254addbc1b9d2d95dc1448b38a"},"headline":"Standalone SQL Server Management Studio","datePublished":"2015-07-06T19:00:06+00:00","dateModified":"2015-07-15T20:22:15+00:00","mainEntityOfPage":{"@id":"http:\/\/www.sqlnuggets.com\/standalone-sql-server-management-studio\/"},"wordCount":201,"commentCount":0,"publisher":{"@id":"http:\/\/www.sqlnuggets.com\/#organization"},"image":{"@id":"http:\/\/www.sqlnuggets.com\/standalone-sql-server-management-studio\/#primaryimage"},"thumbnailUrl":"https:\/\/sqlnuggets.com\/wp-content\/uploads\/2015\/07\/Microsoft-SQL-Server-e1436208354414.jpg","keywords":["Client Tools","Getting Started","SSMS"],"articleSection":["Tools"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["http:\/\/www.sqlnuggets.com\/standalone-sql-server-management-studio\/#respond"]}]},{"@type":"WebPage","@id":"http:\/\/www.sqlnuggets.com\/standalone-sql-server-management-studio\/","url":"http:\/\/www.sqlnuggets.com\/standalone-sql-server-management-studio\/","name":"Standalone SQL Server Management Studio - SQL Nuggets","isPartOf":{"@id":"http:\/\/www.sqlnuggets.com\/#website"},"primaryImageOfPage":{"@id":"http:\/\/www.sqlnuggets.com\/standalone-sql-server-management-studio\/#primaryimage"},"image":{"@id":"http:\/\/www.sqlnuggets.com\/standalone-sql-server-management-studio\/#primaryimage"},"thumbnailUrl":"https:\/\/sqlnuggets.com\/wp-content\/uploads\/2015\/07\/Microsoft-SQL-Server-e1436208354414.jpg","datePublished":"2015-07-06T19:00:06+00:00","dateModified":"2015-07-15T20:22:15+00:00","breadcrumb":{"@id":"http:\/\/www.sqlnuggets.com\/standalone-sql-server-management-studio\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["http:\/\/www.sqlnuggets.com\/standalone-sql-server-management-studio\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"http:\/\/www.sqlnuggets.com\/standalone-sql-server-management-studio\/#primaryimage","url":"https:\/\/sqlnuggets.com\/wp-content\/uploads\/2015\/07\/Microsoft-SQL-Server-e1436208354414.jpg","contentUrl":"https:\/\/sqlnuggets.com\/wp-content\/uploads\/2015\/07\/Microsoft-SQL-Server-e1436208354414.jpg","width":250,"height":205},{"@type":"BreadcrumbList","@id":"http:\/\/www.sqlnuggets.com\/standalone-sql-server-management-studio\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"http:\/\/www.sqlnuggets.com\/"},{"@type":"ListItem","position":2,"name":"Standalone SQL Server Management Studio"}]},{"@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\/2015\/07\/Microsoft-SQL-Server-e1436208354414.jpg","jetpack_shortlink":"https:\/\/wp.me\/pdyDvE-1o","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":189,"url":"https:\/\/sqlnuggets.com\/online-sql-formatting-service\/","url_meta":{"origin":86,"position":0},"title":"Online SQL Formatting Service","author":"Eric Cobb","date":"December 29, 2015","format":false,"excerpt":"I stumbled upon this last week and thought I would share it. \u00a0SQLFormat is a free online formatter for SQL statements. \u00a0It's pretty straight forward and easy to use. \u00a0You just\u00a0enter your SQL statements into a text area, or upload an entire file, and it will\u00a0parse and format your SQL\u2026","rel":"","context":"In &quot;Tools&quot;","block_context":{"text":"Tools","link":"https:\/\/sqlnuggets.com\/category\/tools\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":870,"url":"https:\/\/sqlnuggets.com\/getting-started-with-the-dbatools-powershell-module\/","url_meta":{"origin":86,"position":1},"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":1615,"url":"https:\/\/sqlnuggets.com\/yikes-cannot-recover-the-master-database\/","url_meta":{"origin":86,"position":2},"title":"Yikes!  Cannot recover the master database!","author":"Eric Cobb","date":"May 11, 2021","format":false,"excerpt":"Recently, during patching for a 2019 SQL Server, the SQL services refused to start after the patching. It was throwing the following heart attack inducing error: Cannot recover the master database. SQL Server is unable to run. Restore master from a full backup, repair it, or rebuild it. This is\u2026","rel":"","context":"In &quot;Corruption&quot;","block_context":{"text":"Corruption","link":"https:\/\/sqlnuggets.com\/category\/corruption\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/sqlnuggets.com\/wp-content\/uploads\/2017\/11\/corrupt-147974_1280.png?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/sqlnuggets.com\/wp-content\/uploads\/2017\/11\/corrupt-147974_1280.png?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/sqlnuggets.com\/wp-content\/uploads\/2017\/11\/corrupt-147974_1280.png?resize=525%2C300&ssl=1 1.5x, https:\/\/i0.wp.com\/sqlnuggets.com\/wp-content\/uploads\/2017\/11\/corrupt-147974_1280.png?resize=700%2C400&ssl=1 2x, https:\/\/i0.wp.com\/sqlnuggets.com\/wp-content\/uploads\/2017\/11\/corrupt-147974_1280.png?resize=1050%2C600&ssl=1 3x"},"classes":[]},{"id":1653,"url":"https:\/\/sqlnuggets.com\/the-power-of-proper-indexing\/","url_meta":{"origin":86,"position":3},"title":"The Power Of Proper Indexing","author":"Eric Cobb","date":"June 30, 2021","format":false,"excerpt":"This image is an actual screen shot of one of our production SQL Server's CPU usage, taken from our SQL Sentry monitoring system. Obviously this server was under some strain. Users were complaining that queries were taking 30+ seconds to run when they normally returned data in milliseconds. It eventually\u2026","rel":"","context":"In &quot;Indexes&quot;","block_context":{"text":"Indexes","link":"https:\/\/sqlnuggets.com\/category\/indexes\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/sqlnuggets.com\/wp-content\/uploads\/2021\/06\/image.jpeg?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":985,"url":"https:\/\/sqlnuggets.com\/announcing-sp_whoisblocking\/","url_meta":{"origin":86,"position":4},"title":"Announcing Sp_WhoIsBlocking","author":"Eric Cobb","date":"March 28, 2019","format":false,"excerpt":"This is a tongue in cheek post, basically highlighting a cool feature in sp_whoisactive, and how I created a wrapper for it to make my life easier. I am a big fan of Adam Machanic's sp_whoisactive procedure. I use it multiple times per day. I have it on all of\u2026","rel":"","context":"In &quot;Tools&quot;","block_context":{"text":"Tools","link":"https:\/\/sqlnuggets.com\/category\/tools\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/sqlnuggets.com\/wp-content\/uploads\/2019\/03\/banner-1090829_1280.jpg?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/sqlnuggets.com\/wp-content\/uploads\/2019\/03\/banner-1090829_1280.jpg?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/sqlnuggets.com\/wp-content\/uploads\/2019\/03\/banner-1090829_1280.jpg?resize=525%2C300&ssl=1 1.5x, https:\/\/i0.wp.com\/sqlnuggets.com\/wp-content\/uploads\/2019\/03\/banner-1090829_1280.jpg?resize=700%2C400&ssl=1 2x, https:\/\/i0.wp.com\/sqlnuggets.com\/wp-content\/uploads\/2019\/03\/banner-1090829_1280.jpg?resize=1050%2C600&ssl=1 3x"},"classes":[]},{"id":887,"url":"https:\/\/sqlnuggets.com\/using-dbatools-powershell-module-to-configure-sql-server\/","url_meta":{"origin":86,"position":5},"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":[]}],"_links":{"self":[{"href":"https:\/\/sqlnuggets.com\/wp-json\/wp\/v2\/posts\/86","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=86"}],"version-history":[{"count":0,"href":"https:\/\/sqlnuggets.com\/wp-json\/wp\/v2\/posts\/86\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/sqlnuggets.com\/wp-json\/wp\/v2\/media\/89"}],"wp:attachment":[{"href":"https:\/\/sqlnuggets.com\/wp-json\/wp\/v2\/media?parent=86"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sqlnuggets.com\/wp-json\/wp\/v2\/categories?post=86"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sqlnuggets.com\/wp-json\/wp\/v2\/tags?post=86"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}