{"id":93,"date":"2015-07-09T06:30:26","date_gmt":"2015-07-09T11:30:26","guid":{"rendered":"http:\/\/www.sqlnuggets.com\/?p=93"},"modified":"2015-07-15T15:21:29","modified_gmt":"2015-07-15T20:21:29","slug":"sql-server-maintenance-scripts","status":"publish","type":"post","link":"https:\/\/sqlnuggets.com\/sql-server-maintenance-scripts\/","title":{"rendered":"SQL Server Maintenance Scripts"},"content":{"rendered":"

When it comes to everyday routine maintenance of your SQL Server databases, you can’t beat Ola Hallengren’s\u00a0SQL Server Maintenance Solution<\/a>. \u00a0Focusing on\u00a0SQL Server Backups,\u00a0SQL Server Integrity Checks, and SQL Server Index and Statistics Maintenance, it\u00a0has pretty much become the go-to\u00a0maintenance solution for many SQL Server database administrators. \u00a0We have it on all of our SQL Servers, it is part of our standard installation process.<\/p>\n

My favorite thing about Ola’s solution is that it is actively maintained and updated. \u00a0He continues to push out updates and add\u00a0new features, while\u00a0also maintaining backward compatibility with previous versions of SQL Server. \u00a0He also makes sure it takes advantage of some of the latest SQL Sever features. \u00a0It even has the ability to back up\u00a0databases to Azure Blob Storage.<\/p>\n

If you’re not currently using\u00a0Ola Hallengren’s SQL Server Maintenance Solution, I highly encourage you to check it out. \u00a0Using it is as easy as calling a stored procedure.\u00a0 In fact, you can even use it with Express Edition<\/a>.<\/p>\n

This is part of a series of Getting Started<\/a> posts that I’m doing in which I spotlight the tools I use in my day to day duties as a DBA. \u00a0I asked myself “What tools would I immediately install if I started a new job as a company’s first DBA?” \u00a0This series of posts are the answer to that question. \u00a0<\/em><\/p><\/blockquote>\n","protected":false},"excerpt":{"rendered":"

When it comes to everyday routine maintenance of your SQL Server databases, you can’t beat Ola Hallengren’s\u00a0SQL Server Maintenance Solution. \u00a0Focusing on\u00a0SQL Server Backups,\u00a0SQL Server Integrity Checks, and SQL Server …<\/p>\n","protected":false},"author":2,"featured_media":0,"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":[11,10,12],"class_list":["post-93","post","type-post","status-publish","format-standard","hentry","category-tools","tag-backups","tag-database-maintenance","tag-getting-started"],"yoast_head":"\nSQL Server Maintenance Scripts - 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=\"https:\/\/www.sqlnuggets.com\/sql-server-maintenance-scripts\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Server Maintenance Scripts - SQL Nuggets\" \/>\n<meta property=\"og:description\" content=\"When it comes to everyday routine maintenance of your SQL Server databases, you can’t beat Ola Hallengren’s\u00a0SQL Server Maintenance Solution. \u00a0Focusing on\u00a0SQL Server Backups,\u00a0SQL Server Integrity Checks, and SQL Server ...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sqlnuggets.com\/sql-server-maintenance-scripts\/\" \/>\n<meta property=\"og:site_name\" content=\"SQL Nuggets\" \/>\n<meta property=\"article:published_time\" content=\"2015-07-09T11:30:26+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2015-07-15T20:21:29+00:00\" \/>\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\":\"https:\\\/\\\/www.sqlnuggets.com\\\/sql-server-maintenance-scripts\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.sqlnuggets.com\\\/sql-server-maintenance-scripts\\\/\"},\"author\":{\"name\":\"Eric Cobb\",\"@id\":\"http:\\\/\\\/www.sqlnuggets.com\\\/#\\\/schema\\\/person\\\/210536254addbc1b9d2d95dc1448b38a\"},\"headline\":\"SQL Server Maintenance Scripts\",\"datePublished\":\"2015-07-09T11:30:26+00:00\",\"dateModified\":\"2015-07-15T20:21:29+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.sqlnuggets.com\\\/sql-server-maintenance-scripts\\\/\"},\"wordCount\":235,\"commentCount\":1,\"publisher\":{\"@id\":\"http:\\\/\\\/www.sqlnuggets.com\\\/#organization\"},\"keywords\":[\"Backups\",\"Database Maintenance\",\"Getting Started\"],\"articleSection\":[\"Tools\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.sqlnuggets.com\\\/sql-server-maintenance-scripts\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.sqlnuggets.com\\\/sql-server-maintenance-scripts\\\/\",\"url\":\"https:\\\/\\\/www.sqlnuggets.com\\\/sql-server-maintenance-scripts\\\/\",\"name\":\"SQL Server Maintenance Scripts - SQL Nuggets\",\"isPartOf\":{\"@id\":\"http:\\\/\\\/www.sqlnuggets.com\\\/#website\"},\"datePublished\":\"2015-07-09T11:30:26+00:00\",\"dateModified\":\"2015-07-15T20:21:29+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.sqlnuggets.com\\\/sql-server-maintenance-scripts\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.sqlnuggets.com\\\/sql-server-maintenance-scripts\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.sqlnuggets.com\\\/sql-server-maintenance-scripts\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"http:\\\/\\\/www.sqlnuggets.com\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Server Maintenance Scripts\"}]},{\"@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":"SQL Server Maintenance Scripts - 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":"https:\/\/www.sqlnuggets.com\/sql-server-maintenance-scripts\/","og_locale":"en_US","og_type":"article","og_title":"SQL Server Maintenance Scripts - SQL Nuggets","og_description":"When it comes to everyday routine maintenance of your SQL Server databases, you can’t beat Ola Hallengren’s\u00a0SQL Server Maintenance Solution. \u00a0Focusing on\u00a0SQL Server Backups,\u00a0SQL Server Integrity Checks, and SQL Server ...","og_url":"https:\/\/www.sqlnuggets.com\/sql-server-maintenance-scripts\/","og_site_name":"SQL Nuggets","article_published_time":"2015-07-09T11:30:26+00:00","article_modified_time":"2015-07-15T20:21:29+00:00","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":"https:\/\/www.sqlnuggets.com\/sql-server-maintenance-scripts\/#article","isPartOf":{"@id":"https:\/\/www.sqlnuggets.com\/sql-server-maintenance-scripts\/"},"author":{"name":"Eric Cobb","@id":"http:\/\/www.sqlnuggets.com\/#\/schema\/person\/210536254addbc1b9d2d95dc1448b38a"},"headline":"SQL Server Maintenance Scripts","datePublished":"2015-07-09T11:30:26+00:00","dateModified":"2015-07-15T20:21:29+00:00","mainEntityOfPage":{"@id":"https:\/\/www.sqlnuggets.com\/sql-server-maintenance-scripts\/"},"wordCount":235,"commentCount":1,"publisher":{"@id":"http:\/\/www.sqlnuggets.com\/#organization"},"keywords":["Backups","Database Maintenance","Getting Started"],"articleSection":["Tools"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.sqlnuggets.com\/sql-server-maintenance-scripts\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.sqlnuggets.com\/sql-server-maintenance-scripts\/","url":"https:\/\/www.sqlnuggets.com\/sql-server-maintenance-scripts\/","name":"SQL Server Maintenance Scripts - SQL Nuggets","isPartOf":{"@id":"http:\/\/www.sqlnuggets.com\/#website"},"datePublished":"2015-07-09T11:30:26+00:00","dateModified":"2015-07-15T20:21:29+00:00","breadcrumb":{"@id":"https:\/\/www.sqlnuggets.com\/sql-server-maintenance-scripts\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sqlnuggets.com\/sql-server-maintenance-scripts\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.sqlnuggets.com\/sql-server-maintenance-scripts\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"http:\/\/www.sqlnuggets.com\/"},{"@type":"ListItem","position":2,"name":"SQL Server Maintenance Scripts"}]},{"@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":"","jetpack_shortlink":"https:\/\/wp.me\/pdyDvE-1v","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":100,"url":"https:\/\/sqlnuggets.com\/using-ola-hallengrens-sql-server-maintenance-solution-with-sql-server-express-edition\/","url_meta":{"origin":93,"position":0},"title":"Using Ola Hallengren’s SQL Server Maintenance Solution with SQL Server Express Edition","author":"Eric Cobb","date":"July 7, 2015","format":false,"excerpt":"This post is just a quick extension of my earlier post on Automating backups for SQL Server 2008 R2 Express Edition.\u00a0 If you'd rather use Ola Hallengren's SQL Server Maintenance Solution (and you should!), then follow the steps below to replace the first step listed in my previous post.\u00a0 After\u2026","rel":"","context":"In "Backups"","block_context":{"text":"Backups","link":"https:\/\/sqlnuggets.com\/category\/backups\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":27,"url":"https:\/\/sqlnuggets.com\/automating-backups-for-sql-server-2008-r2-express-edition\/","url_meta":{"origin":93,"position":1},"title":"Automating backups for SQL Server 2008 R2 Express Edition","author":"Eric Cobb","date":"June 9, 2015","format":false,"excerpt":"One of the limitations of SQL Server Express is that you can't automate backups in it via the SQL Server Agent like you can the other versions of SQL Server. You have to manually write the backup scripts and then schedule them to run in Windows Scheduled Tasks. This really\u2026","rel":"","context":"In "Backups"","block_context":{"text":"Backups","link":"https:\/\/sqlnuggets.com\/category\/backups\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":690,"url":"https:\/\/sqlnuggets.com\/corruption-backup-compression-tde-sql-2017\/","url_meta":{"origin":93,"position":2},"title":"Corruption With Backup Compression And TDE In SQL 2017","author":"Eric Cobb","date":"January 16, 2018","format":false,"excerpt":"Last week I spent a good bit of time dealing with a corruption issue, and as it turns out I may actually have found a bug in SQL Server 2017.\u00a0 I say \"may\" because even though I have been working a Microsoft SQL Server PFE (Premier Field Engineer) and providing\u2026","rel":"","context":"In "Backups"","block_context":{"text":"Backups","link":"https:\/\/sqlnuggets.com\/category\/backups\/"},"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":1593,"url":"https:\/\/sqlnuggets.com\/upcoming-idera-geek-sync-march-17th-2021\/","url_meta":{"origin":93,"position":3},"title":"Upcoming IDERA Geek Sync – March 17th, 2021","author":"Eric Cobb","date":"March 15, 2021","format":false,"excerpt":"Don't miss my upcoming IDERA Geek Sync, How To Be The DBA When You Don\u2019t Have A DBA, this Wednesday, March 17, 2021. This webinar is for the \"Accidental DBA\": the developer, sysadmin, or other IT professional that got stuck managing SQL Servers because their company doesn't have a Database\u2026","rel":"","context":"In "Configurations"","block_context":{"text":"Configurations","link":"https:\/\/sqlnuggets.com\/category\/configurations\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/sqlnuggets.com\/wp-content\/uploads\/2021\/03\/EwDY1KZXAAMve9Q.jpeg?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/sqlnuggets.com\/wp-content\/uploads\/2021\/03\/EwDY1KZXAAMve9Q.jpeg?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/sqlnuggets.com\/wp-content\/uploads\/2021\/03\/EwDY1KZXAAMve9Q.jpeg?resize=525%2C300&ssl=1 1.5x, https:\/\/i0.wp.com\/sqlnuggets.com\/wp-content\/uploads\/2021\/03\/EwDY1KZXAAMve9Q.jpeg?resize=700%2C400&ssl=1 2x, https:\/\/i0.wp.com\/sqlnuggets.com\/wp-content\/uploads\/2021\/03\/EwDY1KZXAAMve9Q.jpeg?resize=1050%2C600&ssl=1 3x, https:\/\/i0.wp.com\/sqlnuggets.com\/wp-content\/uploads\/2021\/03\/EwDY1KZXAAMve9Q.jpeg?resize=1400%2C800&ssl=1 4x"},"classes":[]},{"id":214,"url":"https:\/\/sqlnuggets.com\/what-features-are-disabled-between-compatibility-levels-in-sql-server\/","url_meta":{"origin":93,"position":4},"title":"What Features Are Disabled Between Compatibility Levels In SQL Server?","author":"Eric Cobb","date":"March 16, 2016","format":false,"excerpt":"Have you ever wondered what features may or may not be available when your database is running in a different compatibility level than your SQL Server version? I recently came across a situation where a database was on SQL Server 2014 (compatibility level 120), but the database compatibility level was\u2026","rel":"","context":"In "DB Engine"","block_context":{"text":"DB Engine","link":"https:\/\/sqlnuggets.com\/category\/db-engine\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":775,"url":"https:\/\/sqlnuggets.com\/sql-scripts-how-to-find-a-databases-compatibility-level\/","url_meta":{"origin":93,"position":5},"title":"SQL Scripts: How To Find A Database\u2019s Compatibility Level","author":"Eric Cobb","date":"April 17, 2018","format":false,"excerpt":"One thing that a lot of DBAs, especially Accidental DBAs such as myself, don't seem to realize is that just because a database is sitting on a specific version of SQL Server does not mean that database has all of the features of that SQL Server version enabled.\u00a0 To put\u2026","rel":"","context":"In "DB Engine"","block_context":{"text":"DB Engine","link":"https:\/\/sqlnuggets.com\/category\/db-engine\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/sqlnuggets.com\/wp-content\/uploads\/2018\/04\/black-and-white-blank-challenge-262488-e1523887336460.jpg?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/sqlnuggets.com\/wp-content\/uploads\/2018\/04\/black-and-white-blank-challenge-262488-e1523887336460.jpg?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/sqlnuggets.com\/wp-content\/uploads\/2018\/04\/black-and-white-blank-challenge-262488-e1523887336460.jpg?resize=525%2C300&ssl=1 1.5x, https:\/\/i0.wp.com\/sqlnuggets.com\/wp-content\/uploads\/2018\/04\/black-and-white-blank-challenge-262488-e1523887336460.jpg?resize=700%2C400&ssl=1 2x, https:\/\/i0.wp.com\/sqlnuggets.com\/wp-content\/uploads\/2018\/04\/black-and-white-blank-challenge-262488-e1523887336460.jpg?resize=1050%2C600&ssl=1 3x, https:\/\/i0.wp.com\/sqlnuggets.com\/wp-content\/uploads\/2018\/04\/black-and-white-blank-challenge-262488-e1523887336460.jpg?resize=1400%2C800&ssl=1 4x"},"classes":[]}],"_links":{"self":[{"href":"https:\/\/sqlnuggets.com\/wp-json\/wp\/v2\/posts\/93","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=93"}],"version-history":[{"count":0,"href":"https:\/\/sqlnuggets.com\/wp-json\/wp\/v2\/posts\/93\/revisions"}],"wp:attachment":[{"href":"https:\/\/sqlnuggets.com\/wp-json\/wp\/v2\/media?parent=93"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sqlnuggets.com\/wp-json\/wp\/v2\/categories?post=93"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sqlnuggets.com\/wp-json\/wp\/v2\/tags?post=93"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}