{"id":443,"date":"2017-02-15T17:24:22","date_gmt":"2017-02-15T22:24:22","guid":{"rendered":"https:\/\/www.baronsoftware.com\/Blog\/?p=443"},"modified":"2017-02-15T17:24:22","modified_gmt":"2017-02-15T22:24:22","slug":"creating-disaster-recovery-plan-database-sql","status":"publish","type":"post","link":"https:\/\/www.baronsoftware.com\/Blog\/creating-disaster-recovery-plan-database-sql\/","title":{"rendered":"Creating a Disaster Recovery Plan for your database (SQL)"},"content":{"rendered":"<h2 style=\"text-align: center;\">Creating a Disaster Recovery Plan for your database (SQL)<\/h2>\n<p><a href=\"http:\/\/www.idera.com\"><img data-recalc-dims=\"1\" fetchpriority=\"high\" decoding=\"async\" data-attachment-id=\"250\" data-permalink=\"https:\/\/www.baronsoftware.com\/Blog\/idera-and-embarcadero-separate-business\/idera\/\" data-orig-file=\"https:\/\/i0.wp.com\/www.baronsoftware.com\/Blog\/wp-content\/uploads\/2016\/03\/Idera.png?fit=225%2C225&amp;ssl=1\" data-orig-size=\"225,225\" data-comments-opened=\"0\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"Idera\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/www.baronsoftware.com\/Blog\/wp-content\/uploads\/2016\/03\/Idera.png?fit=225%2C225&amp;ssl=1\" class=\"aligncenter size-full wp-image-250\" src=\"https:\/\/i0.wp.com\/www.baronsoftware.com\/Blog\/wp-content\/uploads\/2016\/03\/Idera.png?resize=225%2C225&#038;ssl=1\" alt=\"Idera\" width=\"225\" height=\"225\" srcset=\"https:\/\/i0.wp.com\/www.baronsoftware.com\/Blog\/wp-content\/uploads\/2016\/03\/Idera.png?w=225&amp;ssl=1 225w, https:\/\/i0.wp.com\/www.baronsoftware.com\/Blog\/wp-content\/uploads\/2016\/03\/Idera.png?resize=150%2C150&amp;ssl=1 150w\" sizes=\"(max-width: 225px) 100vw, 225px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>Idera recently had a fantastic webinar that went over the creation of a disaster recovery plan concerning your databases. \u00a0This should be a high critical piece of work usually done by DBAs within a company. \u00a0Let&#8217;s go over a simple set of plans that depending on the type of company you are dealing with, can be done either large or small.<\/p>\n<ol>\n<li>Backups. \u00a0All backups should be done with incremental or full backups of your database. \u00a0There should be a protected network folder that contains the incremental in one and the full backups (usually done once a week) in a separate folder. \u00a0An incremental is a backup that contains only a snapshot of transactions that are done during a day while a full backup contains the entire database.<\/li>\n<li>Data model. \u00a0A data model provides a visual as well as a detailed layout of each database \/ table that provides a method for someone to read and understand how the data is stored. \u00a0It can be noted as a roadmap that contains the relationships between the tables within the database as well as the keys \/ indexes that work with the tables.<\/li>\n<li>User security profiles. \u00a0Each DBA should have a listing of the usernames \/ passwords in a safe area. \u00a0In the event a fellow member leaves but they had the password on a specific database you now possibly have the way in. \u00a0There are numerous companies that tend to not have that and during the exit interviews it becomes lost.<\/li>\n<li>Contact listing of people. \u00a0The contact list contains the individuals that have to be notified if a database is corrupted and has to be repaired or restored from the backups. \u00a0You can set the priority of each person as well.<\/li>\n<li>Checklist. By having a checklist of what to do in the event of a DRP it will keep you focus on getting everything back up and running. \u00a0One missed step could push you back thus delaying the recovery.<\/li>\n<li>Backup life cycles. \u00a0Each company is different and whether the backups are taken off site for now long and when are they removed \/ erased. \u00a0You have to plan this out and the usually lifecycle is between 3 months to a year.<\/li>\n<\/ol>\n<p>These are only minor steps but at least they do enforce a DRP that any DBA needs to have in place prior to the disaster happening.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Creating a Disaster Recovery Plan for your database (SQL) &nbsp; Idera recently had a fantastic webinar that went over the creation of a disaster recovery plan concerning your databases. \u00a0This should be a high critical piece of work usually done by DBAs within a company. \u00a0Let&#8217;s go over a simple set of plans that depending [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"rop_custom_images_group":[],"rop_custom_messages_group":[],"rop_publish_now":"initial","rop_publish_now_accounts":[],"rop_publish_now_history":[],"rop_publish_now_status":"pending","_exactmetrics_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0,"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":[31,3],"tags":[21,39,7,13,35,47,40,28,15,51,54,38,37,6,36,34],"class_list":["post-443","post","type-post","status-publish","format-standard","hentry","category-software-development-concepts","category-software-events","tag-computers","tag-dbartisan","tag-development","tag-embarcadero","tag-fixinsight","tag-idera","tag-imac","tag-mac","tag-microsoft","tag-microsoft-office","tag-mysql","tag-powerstudio","tag-rapid-sql","tag-software","tag-sql-server","tag-sqlite"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.3 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Creating a Disaster Recovery Plan for your database (SQL) - Baron Software<\/title>\n<meta name=\"description\" content=\"A simple set of plans that depending on the type of company you are dealing with, can be done either large or small. Follow these simple steps.\" \/>\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.baronsoftware.com\/Blog\/creating-disaster-recovery-plan-database-sql\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Creating a Disaster Recovery Plan for your database (SQL)\" \/>\n<meta property=\"og:description\" content=\"A simple set of plans that depending on the type of company you are dealing with, can be done either large or small.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.baronsoftware.com\/Blog\/creating-disaster-recovery-plan-database-sql\/\" \/>\n<meta property=\"og:site_name\" content=\"Baron Software\" \/>\n<meta property=\"article:published_time\" content=\"2017-02-15T22:24:22+00:00\" \/>\n<meta name=\"author\" content=\"richard@baronsoftware.com\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Creating a Disaster Recovery Plan for your database (SQL)\" \/>\n<meta name=\"twitter:description\" content=\"A simple set of plans that depending on the type of company you are dealing with, can be done either large or small.\" \/>\n<meta name=\"twitter:image\" content=\"https:\/\/www.baronsoftware.com\/Blog\/wp-content\/uploads\/2014\/12\/logo.jpg\" \/>\n<meta name=\"twitter:creator\" content=\"@Rbaroniunas\" \/>\n<meta name=\"twitter:site\" content=\"@Rbaroniunas\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"richard@baronsoftware.com\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.baronsoftware.com\\\/Blog\\\/creating-disaster-recovery-plan-database-sql\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.baronsoftware.com\\\/Blog\\\/creating-disaster-recovery-plan-database-sql\\\/\"},\"author\":{\"name\":\"richard@baronsoftware.com\",\"@id\":\"https:\\\/\\\/www.baronsoftware.com\\\/Blog\\\/#\\\/schema\\\/person\\\/079d370e4230be9d5f75885bb33dd8cd\"},\"headline\":\"Creating a Disaster Recovery Plan for your database (SQL)\",\"datePublished\":\"2017-02-15T22:24:22+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.baronsoftware.com\\\/Blog\\\/creating-disaster-recovery-plan-database-sql\\\/\"},\"wordCount\":409,\"publisher\":{\"@id\":\"https:\\\/\\\/www.baronsoftware.com\\\/Blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.baronsoftware.com\\\/Blog\\\/creating-disaster-recovery-plan-database-sql\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.baronsoftware.com\\\/Blog\\\/wp-content\\\/uploads\\\/2016\\\/03\\\/Idera.png\",\"keywords\":[\"computers\",\"DBArtisan\",\"Development\",\"Embarcadero\",\"Fixinsight\",\"Idera\",\"iMac\",\"Mac\",\"Microsoft\",\"Microsoft Office\",\"MySQL\",\"Powerstudio\",\"Rapid SQL\",\"Software\",\"SQL Server\",\"SQLite\"],\"articleSection\":[\"Software development Concepts\",\"Software Events\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.baronsoftware.com\\\/Blog\\\/creating-disaster-recovery-plan-database-sql\\\/\",\"url\":\"https:\\\/\\\/www.baronsoftware.com\\\/Blog\\\/creating-disaster-recovery-plan-database-sql\\\/\",\"name\":\"Creating a Disaster Recovery Plan for your database (SQL) - Baron Software\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.baronsoftware.com\\\/Blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.baronsoftware.com\\\/Blog\\\/creating-disaster-recovery-plan-database-sql\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.baronsoftware.com\\\/Blog\\\/creating-disaster-recovery-plan-database-sql\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.baronsoftware.com\\\/Blog\\\/wp-content\\\/uploads\\\/2016\\\/03\\\/Idera.png\",\"datePublished\":\"2017-02-15T22:24:22+00:00\",\"description\":\"A simple set of plans that depending on the type of company you are dealing with, can be done either large or small. Follow these simple steps.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.baronsoftware.com\\\/Blog\\\/creating-disaster-recovery-plan-database-sql\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.baronsoftware.com\\\/Blog\\\/creating-disaster-recovery-plan-database-sql\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.baronsoftware.com\\\/Blog\\\/creating-disaster-recovery-plan-database-sql\\\/#primaryimage\",\"url\":\"https:\\\/\\\/i0.wp.com\\\/www.baronsoftware.com\\\/Blog\\\/wp-content\\\/uploads\\\/2016\\\/03\\\/Idera.png?fit=225%2C225&ssl=1\",\"contentUrl\":\"https:\\\/\\\/i0.wp.com\\\/www.baronsoftware.com\\\/Blog\\\/wp-content\\\/uploads\\\/2016\\\/03\\\/Idera.png?fit=225%2C225&ssl=1\",\"width\":225,\"height\":225,\"caption\":\"Idera\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.baronsoftware.com\\\/Blog\\\/creating-disaster-recovery-plan-database-sql\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.baronsoftware.com\\\/Blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Creating a Disaster Recovery Plan for your database (SQL)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.baronsoftware.com\\\/Blog\\\/#website\",\"url\":\"https:\\\/\\\/www.baronsoftware.com\\\/Blog\\\/\",\"name\":\"Baron Software\",\"description\":\"Highest Quality Software Developed.\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.baronsoftware.com\\\/Blog\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.baronsoftware.com\\\/Blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.baronsoftware.com\\\/Blog\\\/#organization\",\"name\":\"Baron Software\",\"url\":\"https:\\\/\\\/www.baronsoftware.com\\\/Blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.baronsoftware.com\\\/Blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/i2.wp.com\\\/www.baronsoftware.com\\\/Blog\\\/wp-content\\\/uploads\\\/2018\\\/01\\\/BaronSoftwareLogo.fw_.png?fit=1920%2C400&ssl=1\",\"contentUrl\":\"https:\\\/\\\/i2.wp.com\\\/www.baronsoftware.com\\\/Blog\\\/wp-content\\\/uploads\\\/2018\\\/01\\\/BaronSoftwareLogo.fw_.png?fit=1920%2C400&ssl=1\",\"width\":1920,\"height\":400,\"caption\":\"Baron Software\"},\"image\":{\"@id\":\"https:\\\/\\\/www.baronsoftware.com\\\/Blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/x.com\\\/Rbaroniunas\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.baronsoftware.com\\\/Blog\\\/#\\\/schema\\\/person\\\/079d370e4230be9d5f75885bb33dd8cd\",\"name\":\"richard@baronsoftware.com\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/e5a3cc457a883c420e8af899f2639359d220ae6bfed4587ca7ed17f45ca0c21c?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/e5a3cc457a883c420e8af899f2639359d220ae6bfed4587ca7ed17f45ca0c21c?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/e5a3cc457a883c420e8af899f2639359d220ae6bfed4587ca7ed17f45ca0c21c?s=96&d=mm&r=g\",\"caption\":\"richard@baronsoftware.com\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Creating a Disaster Recovery Plan for your database (SQL) - Baron Software","description":"A simple set of plans that depending on the type of company you are dealing with, can be done either large or small. Follow these simple steps.","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.baronsoftware.com\/Blog\/creating-disaster-recovery-plan-database-sql\/","og_locale":"en_US","og_type":"article","og_title":"Creating a Disaster Recovery Plan for your database (SQL)","og_description":"A simple set of plans that depending on the type of company you are dealing with, can be done either large or small.","og_url":"https:\/\/www.baronsoftware.com\/Blog\/creating-disaster-recovery-plan-database-sql\/","og_site_name":"Baron Software","article_published_time":"2017-02-15T22:24:22+00:00","author":"richard@baronsoftware.com","twitter_card":"summary_large_image","twitter_title":"Creating a Disaster Recovery Plan for your database (SQL)","twitter_description":"A simple set of plans that depending on the type of company you are dealing with, can be done either large or small.","twitter_image":"https:\/\/www.baronsoftware.com\/Blog\/wp-content\/uploads\/2014\/12\/logo.jpg","twitter_creator":"@Rbaroniunas","twitter_site":"@Rbaroniunas","twitter_misc":{"Written by":"richard@baronsoftware.com","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.baronsoftware.com\/Blog\/creating-disaster-recovery-plan-database-sql\/#article","isPartOf":{"@id":"https:\/\/www.baronsoftware.com\/Blog\/creating-disaster-recovery-plan-database-sql\/"},"author":{"name":"richard@baronsoftware.com","@id":"https:\/\/www.baronsoftware.com\/Blog\/#\/schema\/person\/079d370e4230be9d5f75885bb33dd8cd"},"headline":"Creating a Disaster Recovery Plan for your database (SQL)","datePublished":"2017-02-15T22:24:22+00:00","mainEntityOfPage":{"@id":"https:\/\/www.baronsoftware.com\/Blog\/creating-disaster-recovery-plan-database-sql\/"},"wordCount":409,"publisher":{"@id":"https:\/\/www.baronsoftware.com\/Blog\/#organization"},"image":{"@id":"https:\/\/www.baronsoftware.com\/Blog\/creating-disaster-recovery-plan-database-sql\/#primaryimage"},"thumbnailUrl":"https:\/\/www.baronsoftware.com\/Blog\/wp-content\/uploads\/2016\/03\/Idera.png","keywords":["computers","DBArtisan","Development","Embarcadero","Fixinsight","Idera","iMac","Mac","Microsoft","Microsoft Office","MySQL","Powerstudio","Rapid SQL","Software","SQL Server","SQLite"],"articleSection":["Software development Concepts","Software Events"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.baronsoftware.com\/Blog\/creating-disaster-recovery-plan-database-sql\/","url":"https:\/\/www.baronsoftware.com\/Blog\/creating-disaster-recovery-plan-database-sql\/","name":"Creating a Disaster Recovery Plan for your database (SQL) - Baron Software","isPartOf":{"@id":"https:\/\/www.baronsoftware.com\/Blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.baronsoftware.com\/Blog\/creating-disaster-recovery-plan-database-sql\/#primaryimage"},"image":{"@id":"https:\/\/www.baronsoftware.com\/Blog\/creating-disaster-recovery-plan-database-sql\/#primaryimage"},"thumbnailUrl":"https:\/\/www.baronsoftware.com\/Blog\/wp-content\/uploads\/2016\/03\/Idera.png","datePublished":"2017-02-15T22:24:22+00:00","description":"A simple set of plans that depending on the type of company you are dealing with, can be done either large or small. Follow these simple steps.","breadcrumb":{"@id":"https:\/\/www.baronsoftware.com\/Blog\/creating-disaster-recovery-plan-database-sql\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.baronsoftware.com\/Blog\/creating-disaster-recovery-plan-database-sql\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.baronsoftware.com\/Blog\/creating-disaster-recovery-plan-database-sql\/#primaryimage","url":"https:\/\/i0.wp.com\/www.baronsoftware.com\/Blog\/wp-content\/uploads\/2016\/03\/Idera.png?fit=225%2C225&ssl=1","contentUrl":"https:\/\/i0.wp.com\/www.baronsoftware.com\/Blog\/wp-content\/uploads\/2016\/03\/Idera.png?fit=225%2C225&ssl=1","width":225,"height":225,"caption":"Idera"},{"@type":"BreadcrumbList","@id":"https:\/\/www.baronsoftware.com\/Blog\/creating-disaster-recovery-plan-database-sql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.baronsoftware.com\/Blog\/"},{"@type":"ListItem","position":2,"name":"Creating a Disaster Recovery Plan for your database (SQL)"}]},{"@type":"WebSite","@id":"https:\/\/www.baronsoftware.com\/Blog\/#website","url":"https:\/\/www.baronsoftware.com\/Blog\/","name":"Baron Software","description":"Highest Quality Software Developed.","publisher":{"@id":"https:\/\/www.baronsoftware.com\/Blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.baronsoftware.com\/Blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.baronsoftware.com\/Blog\/#organization","name":"Baron Software","url":"https:\/\/www.baronsoftware.com\/Blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.baronsoftware.com\/Blog\/#\/schema\/logo\/image\/","url":"https:\/\/i2.wp.com\/www.baronsoftware.com\/Blog\/wp-content\/uploads\/2018\/01\/BaronSoftwareLogo.fw_.png?fit=1920%2C400&ssl=1","contentUrl":"https:\/\/i2.wp.com\/www.baronsoftware.com\/Blog\/wp-content\/uploads\/2018\/01\/BaronSoftwareLogo.fw_.png?fit=1920%2C400&ssl=1","width":1920,"height":400,"caption":"Baron Software"},"image":{"@id":"https:\/\/www.baronsoftware.com\/Blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/x.com\/Rbaroniunas"]},{"@type":"Person","@id":"https:\/\/www.baronsoftware.com\/Blog\/#\/schema\/person\/079d370e4230be9d5f75885bb33dd8cd","name":"richard@baronsoftware.com","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/e5a3cc457a883c420e8af899f2639359d220ae6bfed4587ca7ed17f45ca0c21c?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/e5a3cc457a883c420e8af899f2639359d220ae6bfed4587ca7ed17f45ca0c21c?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/e5a3cc457a883c420e8af899f2639359d220ae6bfed4587ca7ed17f45ca0c21c?s=96&d=mm&r=g","caption":"richard@baronsoftware.com"}}]}},"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p2e6qU-79","jetpack-related-posts":[{"id":608,"url":"https:\/\/www.baronsoftware.com\/Blog\/idera-free-tool-powershell-scripts-sql-server\/","url_meta":{"origin":443,"position":0},"title":"Idera &#8211; Free Tool &#8211; PowerShell Scripts for SQL Server","author":"richard@baronsoftware.com","date":"September 30, 2017","format":false,"excerpt":"Idera - Free Tool - PowerShell Scripts for SQL Server Idera is offering a free tool of Powershell scripts for Microsoft SQL server.\u00a0 You can simply your SQL Server Administration with 89 free Powershell scripts by simply providing some information and it is an amazing assortment of scripts.\u00a0 The scripts\u2026","rel":"","context":"In &quot;Software development Concepts&quot;","block_context":{"text":"Software development Concepts","link":"https:\/\/www.baronsoftware.com\/Blog\/category\/software-development-concepts\/"},"img":{"alt_text":"Idera","src":"https:\/\/i0.wp.com\/www.baronsoftware.com\/Blog\/wp-content\/uploads\/2016\/03\/Idera.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":249,"url":"https:\/\/www.baronsoftware.com\/Blog\/idera-and-embarcadero-separate-business\/","url_meta":{"origin":443,"position":1},"title":"Idera and Embarcadero separate target businesses","author":"richard@baronsoftware.com","date":"March 8, 2016","format":false,"excerpt":"\u00a0 Idera and Embarcadero separate target businesses \u00a0 Idera and Embarcadero have officially separated their businesses for software development Rad Studio that contains Delphi \/ C++ Builder and the Idera database tools. \u00a0This is a fantastic step in going forward and bringing both web sites with a fresh look on\u2026","rel":"","context":"In &quot;Rad Studio Delphi Development&quot;","block_context":{"text":"Rad Studio Delphi Development","link":"https:\/\/www.baronsoftware.com\/Blog\/category\/rad-studio-embarcadero-delphi-development\/"},"img":{"alt_text":"embarcadero-idera-separate","src":"https:\/\/i0.wp.com\/www.baronsoftware.com\/Blog\/wp-content\/uploads\/2016\/03\/Seattle.jpeg?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":610,"url":"https:\/\/www.baronsoftware.com\/Blog\/purge-microsoft-sql-email-items\/","url_meta":{"origin":443,"position":2},"title":"How to purge Microsoft SQL email Items","author":"richard@baronsoftware.com","date":"October 2, 2017","format":false,"excerpt":"How to purge Microsoft SQL email Items There are times that housecleaning older mail in your database needs to be done.\u00a0 A simple scheduled task can be done every month to purge what is no longer necessary.\u00a0 SQL Server stores all mails and attachments in\u00a0msdb\u00a0database. To avoid unnecessary growth of\u00a0msdb\u00a0database\u2026","rel":"","context":"In &quot;Computer PC Tips - bits and bytes&quot;","block_context":{"text":"Computer PC Tips - bits and bytes","link":"https:\/\/www.baronsoftware.com\/Blog\/category\/pc-tips-bits-bytes\/"},"img":{"alt_text":"Purge","src":"https:\/\/i0.wp.com\/www.baronsoftware.com\/Blog\/wp-content\/uploads\/2016\/10\/microsofts-logo-gets-a-makeover-300x225.jpg?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":174,"url":"https:\/\/www.baronsoftware.com\/Blog\/idera-announces-intent-to-acquire-embarcadero-expands-position-in-database-management-and-developer-tools-markets\/","url_meta":{"origin":443,"position":3},"title":"IDERA Announces Intent to Acquire Embarcadero, Expands Position in Database Management and Developer Tools Markets","author":"richard@baronsoftware.com","date":"October 13, 2015","format":false,"excerpt":"Officially Idera is about to acquire Embarcadero this week after final agreements are made. \u00a0\u00a0Idera press release\u00a0provides you with some additional information concerning the purchase. \u00a0At this moment no one really knows what this means for the Rad Studio product as well the other database packages that Embarcadero sells nor\u2026","rel":"","context":"In &quot;SQL Tips&quot;","block_context":{"text":"SQL Tips","link":"https:\/\/www.baronsoftware.com\/Blog\/category\/sql-tips\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":372,"url":"https:\/\/www.baronsoftware.com\/Blog\/baron-software-supports-db-powerstudio\/","url_meta":{"origin":443,"position":4},"title":"Baron Software Supports IDERA DB PowerStudio","author":"richard@baronsoftware.com","date":"October 28, 2016","format":false,"excerpt":"Baron Software Supports IDERA's DB PowerStudio Baron Software is a longtime user of IDERA's DB PowerStudio which assists us in dealing with our clients in maintaining thousands of mission-critical multi-platform databases that are used for data\u00a0warehouses along with highly robust data driven applications,\u201d said\u00a0Richard Baroniunas, software developer and DBA at\u2026","rel":"","context":"In &quot;Software Releases&quot;","block_context":{"text":"Software Releases","link":"https:\/\/www.baronsoftware.com\/Blog\/category\/software-releases\/"},"img":{"alt_text":"Idera Powerstudio","src":"https:\/\/i0.wp.com\/www.baronsoftware.com\/Blog\/wp-content\/uploads\/2016\/03\/Idera.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":245,"url":"https:\/\/www.baronsoftware.com\/Blog\/microsoft-bringing-sql-server-2016-linux\/","url_meta":{"origin":443,"position":5},"title":"Microsoft SQL Server 2016 is coming to Linux","author":"richard@baronsoftware.com","date":"March 8, 2016","format":false,"excerpt":"Microsoft SQL Server 2016 is coming to Linux will provide the ability for users to have the features and additional security. Click the image for more information about SQL Server Microsoft will be releasing a version of their SQL Server 2016 for Linux which is a major step in the\u2026","rel":"","context":"In &quot;Software development Concepts&quot;","block_context":{"text":"Software development Concepts","link":"https:\/\/www.baronsoftware.com\/Blog\/category\/software-development-concepts\/"},"img":{"alt_text":"Percentage","src":"https:\/\/i0.wp.com\/www.baronsoftware.com\/Blog\/wp-content\/uploads\/2016\/03\/dbs-in-house.jpg?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.baronsoftware.com\/Blog\/wp-content\/uploads\/2016\/03\/dbs-in-house.jpg?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/www.baronsoftware.com\/Blog\/wp-content\/uploads\/2016\/03\/dbs-in-house.jpg?resize=525%2C300&ssl=1 1.5x, https:\/\/i0.wp.com\/www.baronsoftware.com\/Blog\/wp-content\/uploads\/2016\/03\/dbs-in-house.jpg?resize=700%2C400&ssl=1 2x"},"classes":[]}],"_links":{"self":[{"href":"https:\/\/www.baronsoftware.com\/Blog\/wp-json\/wp\/v2\/posts\/443","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.baronsoftware.com\/Blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.baronsoftware.com\/Blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.baronsoftware.com\/Blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.baronsoftware.com\/Blog\/wp-json\/wp\/v2\/comments?post=443"}],"version-history":[{"count":1,"href":"https:\/\/www.baronsoftware.com\/Blog\/wp-json\/wp\/v2\/posts\/443\/revisions"}],"predecessor-version":[{"id":444,"href":"https:\/\/www.baronsoftware.com\/Blog\/wp-json\/wp\/v2\/posts\/443\/revisions\/444"}],"wp:attachment":[{"href":"https:\/\/www.baronsoftware.com\/Blog\/wp-json\/wp\/v2\/media?parent=443"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.baronsoftware.com\/Blog\/wp-json\/wp\/v2\/categories?post=443"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.baronsoftware.com\/Blog\/wp-json\/wp\/v2\/tags?post=443"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}