{"id":645,"date":"2018-01-02T17:49:20","date_gmt":"2018-01-02T22:49:20","guid":{"rendered":"https:\/\/www.baronsoftware.com\/Blog\/?p=645"},"modified":"2018-01-03T08:40:07","modified_gmt":"2018-01-03T13:40:07","slug":"database-seems-slow","status":"publish","type":"post","link":"https:\/\/www.baronsoftware.com\/Blog\/database-seems-slow\/","title":{"rendered":"What to do if your database seems slow"},"content":{"rendered":"

What to do if your database seems slow<\/h2>\n

Quite a few times during a business day or even after hours, you have noticed that your database requests or queries tend to be slow with the results.\u00a0 This could be that your database has become bloated with constant usage.\u00a0 There are a few things that the IT \/ DBA or you, can do to resolve these possible serious issues.<\/p>\n

Databases work almost like people, they tend to keep inactive data that uses disk space, poor design and even the over-indexing of tables which could be some of the reasons for poor performance to outright collapse.<\/p>\n

Step one – inactive data to archives.<\/h2>\n

The first step is to research whether there is too much inactive data.\u00a0 This is data that is no longer part of the active processing that takes place such as medical records from several years ago.\u00a0 You need to keep them but should something from 2001 be kept in the current production database.\u00a0 \u00a0That data can easily be placed in a separate archive database that can be used for historical matters.\u00a0 It can be accessed at any time as well as cutting the backup time for the production database.\u00a0 In the long term this information can either be purged or put into archive backups saved off line.<\/p>\n

Step two – Indexing<\/h2>\n

 <\/p>\n

The second step is to research whether you have way too many indexes on tables that are not used, or on columns no longer important.\u00a0 Indexes\u00a0slow down write operations, lead to frequent deadlocks or other different issues that occur.\u00a0 There are multiple websites that provide scripts to check on index performances, you can click here to view one of them. <\/a><\/p>\n

Any sort of performance testing has to be done over time and cannot be concluded in minutes (naturally a bad index or query can be noticed by the time it took to completion).\u00a0 For instance performance might decrease if the indexes are heavily fragmented.\u00a0 For the Microsoft SQL server you can use the\u00a0sys.dm_db_index_physical_stats<\/span>\u00a0system function to detect the index fragmentation especially if it is over 30 percent.<\/p>\n

Final Step – Poor Design<\/h2>\n

Finally\u00a0poor database design will always be the main culprit in any database package.\u00a0 Regardless of the testing you cannot make a bad structured layout look like a swan unless a major overhaul occurs.\u00a0 You can also simply have memory issues that affect the overall performance or older servers that need to be replaced.<\/p>\n

The best thing for any developer to make sure that they lay out the design before going to work and this will cut down 60 to 70 percent of trouble.\u00a0 The leftover 30 percent is just good old data that needs to be dealt with loving care.<\/p>\n

 <\/p>\n","protected":false},"excerpt":{"rendered":"

What to do if your database seems slow Quite a few times during a business day or even after hours, you have noticed that your database requests or queries tend to be slow with the results.\u00a0 This could be that your database has become bloated with constant usage.\u00a0 There are a few things that the […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","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_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},"jetpack_post_was_ever_published":false},"categories":[31,1],"tags":[],"class_list":["post-645","post","type-post","status-publish","format-standard","hentry","category-software-development-concepts","category-sql-tips"],"yoast_head":"\nWhat to do if your database seems slow - Baron Software<\/title>\n<meta name=\"description\" content=\"Databases work almost like people, they tend to keep inactive data that uses disk space, poor design and even the over-indexing of tables which could be some of the reasons for poor performance to outright collapse.\" \/>\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\/database-seems-slow\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"What to do if your database seems slow.\" \/>\n<meta property=\"og:description\" content=\"Databases work almost like people, they tend to keep inactive data that uses disk space, poor design and even the over-indexing of tables which could be some of the reasons for poor performance to outright collapse.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.baronsoftware.com\/Blog\/database-seems-slow\/\" \/>\n<meta property=\"og:site_name\" content=\"Baron Software\" \/>\n<meta property=\"article:published_time\" content=\"2018-01-02T22:49:20+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2018-01-03T13:40:07+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=\"What to do if your database seems slow.\" \/>\n<meta name=\"twitter:description\" content=\"Databases work almost like people, they tend to keep inactive data that uses disk space, poor design and even the over-indexing of tables which could be some of the reasons for poor performance to outright collapse.\" \/>\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\\\/database-seems-slow\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.baronsoftware.com\\\/Blog\\\/database-seems-slow\\\/\"},\"author\":{\"name\":\"richard@baronsoftware.com\",\"@id\":\"https:\\\/\\\/www.baronsoftware.com\\\/Blog\\\/#\\\/schema\\\/person\\\/079d370e4230be9d5f75885bb33dd8cd\"},\"headline\":\"What to do if your database seems slow\",\"datePublished\":\"2018-01-02T22:49:20+00:00\",\"dateModified\":\"2018-01-03T13:40:07+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.baronsoftware.com\\\/Blog\\\/database-seems-slow\\\/\"},\"wordCount\":466,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.baronsoftware.com\\\/Blog\\\/#organization\"},\"articleSection\":[\"Software development Concepts\",\"SQL Tips\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.baronsoftware.com\\\/Blog\\\/database-seems-slow\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.baronsoftware.com\\\/Blog\\\/database-seems-slow\\\/\",\"url\":\"https:\\\/\\\/www.baronsoftware.com\\\/Blog\\\/database-seems-slow\\\/\",\"name\":\"What to do if your database seems slow - Baron Software\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.baronsoftware.com\\\/Blog\\\/#website\"},\"datePublished\":\"2018-01-02T22:49:20+00:00\",\"dateModified\":\"2018-01-03T13:40:07+00:00\",\"description\":\"Databases work almost like people, they tend to keep inactive data that uses disk space, poor design and even the over-indexing of tables which could be some of the reasons for poor performance to outright collapse.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.baronsoftware.com\\\/Blog\\\/database-seems-slow\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.baronsoftware.com\\\/Blog\\\/database-seems-slow\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.baronsoftware.com\\\/Blog\\\/database-seems-slow\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.baronsoftware.com\\\/Blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"data-\"}]},{\"@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":"What to do if your database seems slow - Baron Software","description":"Databases work almost like people, they tend to keep inactive data that uses disk space, poor design and even the over-indexing of tables which could be some of the reasons for poor performance to outright collapse.","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\/database-seems-slow\/","og_locale":"en_US","og_type":"article","og_title":"What to do if your database seems slow.","og_description":"Databases work almost like people, they tend to keep inactive data that uses disk space, poor design and even the over-indexing of tables which could be some of the reasons for poor performance to outright collapse.","og_url":"https:\/\/www.baronsoftware.com\/Blog\/database-seems-slow\/","og_site_name":"Baron Software","article_published_time":"2018-01-02T22:49:20+00:00","article_modified_time":"2018-01-03T13:40:07+00:00","author":"richard@baronsoftware.com","twitter_card":"summary_large_image","twitter_title":"What to do if your database seems slow.","twitter_description":"Databases work almost like people, they tend to keep inactive data that uses disk space, poor design and even the over-indexing of tables which could be some of the reasons for poor performance to outright collapse.","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\/database-seems-slow\/#article","isPartOf":{"@id":"https:\/\/www.baronsoftware.com\/Blog\/database-seems-slow\/"},"author":{"name":"richard@baronsoftware.com","@id":"https:\/\/www.baronsoftware.com\/Blog\/#\/schema\/person\/079d370e4230be9d5f75885bb33dd8cd"},"headline":"What to do if your database seems slow","datePublished":"2018-01-02T22:49:20+00:00","dateModified":"2018-01-03T13:40:07+00:00","mainEntityOfPage":{"@id":"https:\/\/www.baronsoftware.com\/Blog\/database-seems-slow\/"},"wordCount":466,"commentCount":0,"publisher":{"@id":"https:\/\/www.baronsoftware.com\/Blog\/#organization"},"articleSection":["Software development Concepts","SQL Tips"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.baronsoftware.com\/Blog\/database-seems-slow\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.baronsoftware.com\/Blog\/database-seems-slow\/","url":"https:\/\/www.baronsoftware.com\/Blog\/database-seems-slow\/","name":"What to do if your database seems slow - Baron Software","isPartOf":{"@id":"https:\/\/www.baronsoftware.com\/Blog\/#website"},"datePublished":"2018-01-02T22:49:20+00:00","dateModified":"2018-01-03T13:40:07+00:00","description":"Databases work almost like people, they tend to keep inactive data that uses disk space, poor design and even the over-indexing of tables which could be some of the reasons for poor performance to outright collapse.","breadcrumb":{"@id":"https:\/\/www.baronsoftware.com\/Blog\/database-seems-slow\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.baronsoftware.com\/Blog\/database-seems-slow\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.baronsoftware.com\/Blog\/database-seems-slow\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.baronsoftware.com\/Blog\/"},{"@type":"ListItem","position":2,"name":"data-"}]},{"@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-ap","jetpack-related-posts":[{"id":443,"url":"https:\/\/www.baronsoftware.com\/Blog\/creating-disaster-recovery-plan-database-sql\/","url_meta":{"origin":645,"position":0},"title":"Creating a Disaster Recovery Plan for your database (SQL)","author":"richard@baronsoftware.com","date":"February 15, 2017","format":false,"excerpt":"Creating a Disaster Recovery Plan for your database (SQL) \u00a0 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's go over a simple\u2026","rel":"","context":"In "Software development Concepts"","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":645,"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 "Rad Studio Delphi Development"","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":998,"url":"https:\/\/www.baronsoftware.com\/Blog\/using-delphi-firedac-to-compact-and-repair-a-ms-access-database\/","url_meta":{"origin":645,"position":2},"title":"Using Delphi Firedac to compact and repair a MS Access Database.","author":"richard@baronsoftware.com","date":"February 4, 2020","format":false,"excerpt":"Over the years Delphi Firedac continues to grow as a robust programming language. Delphi Firedac provides a new way to compact and repair a database. The tools provide developers with components or services that create superb applications. Delphi Firedac provides a unique set of Universal Data Access Components for developing\u2026","rel":"","context":"In "Rad Studio Delphi Development"","block_context":{"text":"Rad Studio Delphi Development","link":"https:\/\/www.baronsoftware.com\/Blog\/category\/rad-studio-embarcadero-delphi-development\/"},"img":{"alt_text":"Baron Software","src":"https:\/\/i0.wp.com\/www.baronsoftware.com\/Blog\/wp-content\/uploads\/2019\/08\/BaronSoftwareLogo_2020.fw_.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":893,"url":"https:\/\/www.baronsoftware.com\/Blog\/one-third-of-internal-user-accounts-are-ghost-users\/","url_meta":{"origin":645,"position":3},"title":"One-Third of Internal User Accounts Are ‘Ghost Users’","author":"richard@baronsoftware.com","date":"April 10, 2018","format":false,"excerpt":"One-Third of Internal User Accounts Are 'Ghost Users' Due to inadequate access controls on various systems attackers and malware can easily move laterally through an organization destroying content. \u00a0Meager access controls on folders and file systems are leaving organizations wide open to the lateral movement of attackers and malware, according\u2026","rel":"","context":"In "News Items"","block_context":{"text":"News Items","link":"https:\/\/www.baronsoftware.com\/Blog\/category\/news-items\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.baronsoftware.com\/Blog\/wp-content\/uploads\/2018\/02\/BaronSoftwareLogo_2018.fw_-1-300x60.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":820,"url":"https:\/\/www.baronsoftware.com\/Blog\/idera-offers-free-webinar-data-modeling-cloud\/","url_meta":{"origin":645,"position":4},"title":"Idera offers free webinar on data modeling in the cloud","author":"richard@baronsoftware.com","date":"March 5, 2018","format":false,"excerpt":"Idera offers free webinar on data modeling in the cloud Data modeling is the process of documenting a complex software system design as an easily understood diagram, using text and symbols to represent the way\u00a0data\u00a0needs to flow. The diagram can be used as a blueprint for the construction of new\u2026","rel":"","context":"In "Idera"","block_context":{"text":"Idera","link":"https:\/\/www.baronsoftware.com\/Blog\/category\/idera\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.baronsoftware.com\/Blog\/wp-content\/uploads\/2018\/02\/cropped-BaronSoftwareLogo_2018.fw_-1-300x62.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":1211,"url":"https:\/\/www.baronsoftware.com\/Blog\/why-the-hate-for-microsoft-access\/","url_meta":{"origin":645,"position":5},"title":"Why is there the hate for Microsoft Access and Excel ?","author":"richard@baronsoftware.com","date":"January 20, 2025","format":false,"excerpt":"During a recent question that was published by a developer. they were requesting how to convert and import Paradox tables into Microsoft Access. When all of a sudden there was a huge amount of hate towards Microsoft Access and Excel. The responses were overwhelming about the evils from these two\u2026","rel":"","context":"In "Rad Studio Delphi Development"","block_context":{"text":"Rad Studio Delphi Development","link":"https:\/\/www.baronsoftware.com\/Blog\/category\/rad-studio-embarcadero-delphi-development\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.baronsoftware.com\/Blog\/wp-content\/uploads\/2025\/01\/database-management-1.jpg?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.baronsoftware.com\/Blog\/wp-content\/uploads\/2025\/01\/database-management-1.jpg?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/www.baronsoftware.com\/Blog\/wp-content\/uploads\/2025\/01\/database-management-1.jpg?resize=525%2C300&ssl=1 1.5x, https:\/\/i0.wp.com\/www.baronsoftware.com\/Blog\/wp-content\/uploads\/2025\/01\/database-management-1.jpg?resize=700%2C400&ssl=1 2x, https:\/\/i0.wp.com\/www.baronsoftware.com\/Blog\/wp-content\/uploads\/2025\/01\/database-management-1.jpg?resize=1050%2C600&ssl=1 3x"},"classes":[]}],"_links":{"self":[{"href":"https:\/\/www.baronsoftware.com\/Blog\/wp-json\/wp\/v2\/posts\/645","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=645"}],"version-history":[{"count":3,"href":"https:\/\/www.baronsoftware.com\/Blog\/wp-json\/wp\/v2\/posts\/645\/revisions"}],"predecessor-version":[{"id":650,"href":"https:\/\/www.baronsoftware.com\/Blog\/wp-json\/wp\/v2\/posts\/645\/revisions\/650"}],"wp:attachment":[{"href":"https:\/\/www.baronsoftware.com\/Blog\/wp-json\/wp\/v2\/media?parent=645"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.baronsoftware.com\/Blog\/wp-json\/wp\/v2\/categories?post=645"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.baronsoftware.com\/Blog\/wp-json\/wp\/v2\/tags?post=645"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}