{"id":157,"date":"2015-09-23T17:40:45","date_gmt":"2015-09-23T17:40:45","guid":{"rendered":"http:\/\/www.baronsoftware.com\/Blog\/?p=157"},"modified":"2015-09-23T17:40:45","modified_gmt":"2015-09-23T17:40:45","slug":"how-to-recognize-when-sql-windowing-functions-are-likely-to-help-improve-database-performance","status":"publish","type":"post","link":"https:\/\/www.baronsoftware.com\/Blog\/how-to-recognize-when-sql-windowing-functions-are-likely-to-help-improve-database-performance\/","title":{"rendered":"How to Recognize when SQL Windowing Functions are Likely to Help Improve Database Performance"},"content":{"rendered":"<p>Baron Software is proud to present &#8220;<strong>How to Recognize when SQL Windowing Functions are Likely to Help Improve Database Performance&#8221; <\/strong>webinar on September 24th, 2015 during the Embarcadero DataU webinar series. \u00a0Richard Baroniunas will discuss the benefits of using Rapid SQL to prepare SQL statements to use Windows Functions and increase performance.<\/p>\n<p>&nbsp;<\/p>\n<table class=\"upgradecntr_table\">\n<tbody>\n<tr>\n<td><strong><br \/>\n<\/strong>10:00am &#8211; 10:45am PDT<\/td>\n<td><strong><img data-recalc-dims=\"1\" decoding=\"async\" src=\"https:\/\/i0.wp.com\/d2s812or3jf8v2.cloudfront.net\/images\/data-u\/dbps_icon_25x25.jpg?resize=25%2C25\" alt=\"dbps icon 25x25\" width=\"25\" height=\"25\" align=\"right\" hspace=\"5\" vspace=\"5\" \/>How to Recognize when SQL Windowing Functions are Likely to Help Improve Database Performance<\/strong><br \/>\nSQL Window Functions address a wide variety of querying tasks that encompass computations, pivoting and sorting which are applied to a set of rows that is all applied by a function. Each function can be grouped into Ranking, Analytic, Aggregate thus providing multiple methods to gather what is needed from one data query.<\/p>\n<p>Level: All<\/p>\n<p><strong><a href=\"http:\/\/www.embarcadero.com\/data-u\/datau-2015-speakers#baroniunasr\"><em>Richard Baroniunas &#8211; Baron Software<\/em><\/a><\/strong><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n","protected":false},"excerpt":{"rendered":"<p>Baron Software is proud to present &#8220;How to Recognize when SQL Windowing Functions are Likely to Help Improve Database Performance&#8221; webinar on September 24th, 2015 during the Embarcadero DataU webinar series. \u00a0Richard Baroniunas will discuss the benefits of using Rapid SQL to prepare SQL statements to use Windows Functions and increase performance. &nbsp; 10:00am &#8211; [&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":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[3,1],"tags":[21,13,15,9,38,37,36],"class_list":["post-157","post","type-post","status-publish","format-standard","hentry","category-software-events","category-sql-tips","tag-computers","tag-embarcadero","tag-microsoft","tag-pascal","tag-powerstudio","tag-rapid-sql","tag-sql-server"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.3 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>How to Recognize when SQL Windowing Functions are Likely to Help Improve Database Performance<\/title>\n<meta name=\"description\" content=\"SQL Window Functions can be grouped into Ranking, Analytic, Aggregate thus providing multiple methods to gather what is needed from one data query.\" \/>\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\/how-to-recognize-when-sql-windowing-functions-are-likely-to-help-improve-database-performance\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Recognize when SQL Windowing Functions are Likely to Help Improve Database Performance\" \/>\n<meta property=\"og:description\" content=\"SQL Window Functions can be grouped into Ranking, Analytic, Aggregate thus providing multiple methods to gather what is needed from one data query.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.baronsoftware.com\/Blog\/how-to-recognize-when-sql-windowing-functions-are-likely-to-help-improve-database-performance\/\" \/>\n<meta property=\"og:site_name\" content=\"Baron Software\" \/>\n<meta property=\"article:published_time\" content=\"2015-09-23T17:40:45+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/d2s812or3jf8v2.cloudfront.net\/images\/data-u\/dbps_icon_25x25.jpg\" \/>\n<meta name=\"author\" content=\"richard@baronsoftware.com\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\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=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.baronsoftware.com\\\/Blog\\\/how-to-recognize-when-sql-windowing-functions-are-likely-to-help-improve-database-performance\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.baronsoftware.com\\\/Blog\\\/how-to-recognize-when-sql-windowing-functions-are-likely-to-help-improve-database-performance\\\/\"},\"author\":{\"name\":\"richard@baronsoftware.com\",\"@id\":\"https:\\\/\\\/www.baronsoftware.com\\\/Blog\\\/#\\\/schema\\\/person\\\/079d370e4230be9d5f75885bb33dd8cd\"},\"headline\":\"How to Recognize when SQL Windowing Functions are Likely to Help Improve Database Performance\",\"datePublished\":\"2015-09-23T17:40:45+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.baronsoftware.com\\\/Blog\\\/how-to-recognize-when-sql-windowing-functions-are-likely-to-help-improve-database-performance\\\/\"},\"wordCount\":144,\"publisher\":{\"@id\":\"https:\\\/\\\/www.baronsoftware.com\\\/Blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.baronsoftware.com\\\/Blog\\\/how-to-recognize-when-sql-windowing-functions-are-likely-to-help-improve-database-performance\\\/#primaryimage\"},\"thumbnailUrl\":\"http:\\\/\\\/d2s812or3jf8v2.cloudfront.net\\\/images\\\/data-u\\\/dbps_icon_25x25.jpg\",\"keywords\":[\"computers\",\"Embarcadero\",\"Microsoft\",\"Pascal\",\"Powerstudio\",\"Rapid SQL\",\"SQL Server\"],\"articleSection\":[\"Software Events\",\"SQL Tips\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.baronsoftware.com\\\/Blog\\\/how-to-recognize-when-sql-windowing-functions-are-likely-to-help-improve-database-performance\\\/\",\"url\":\"https:\\\/\\\/www.baronsoftware.com\\\/Blog\\\/how-to-recognize-when-sql-windowing-functions-are-likely-to-help-improve-database-performance\\\/\",\"name\":\"How to Recognize when SQL Windowing Functions are Likely to Help Improve Database Performance\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.baronsoftware.com\\\/Blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.baronsoftware.com\\\/Blog\\\/how-to-recognize-when-sql-windowing-functions-are-likely-to-help-improve-database-performance\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.baronsoftware.com\\\/Blog\\\/how-to-recognize-when-sql-windowing-functions-are-likely-to-help-improve-database-performance\\\/#primaryimage\"},\"thumbnailUrl\":\"http:\\\/\\\/d2s812or3jf8v2.cloudfront.net\\\/images\\\/data-u\\\/dbps_icon_25x25.jpg\",\"datePublished\":\"2015-09-23T17:40:45+00:00\",\"description\":\"SQL Window Functions can be grouped into Ranking, Analytic, Aggregate thus providing multiple methods to gather what is needed from one data query.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.baronsoftware.com\\\/Blog\\\/how-to-recognize-when-sql-windowing-functions-are-likely-to-help-improve-database-performance\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.baronsoftware.com\\\/Blog\\\/how-to-recognize-when-sql-windowing-functions-are-likely-to-help-improve-database-performance\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.baronsoftware.com\\\/Blog\\\/how-to-recognize-when-sql-windowing-functions-are-likely-to-help-improve-database-performance\\\/#primaryimage\",\"url\":\"http:\\\/\\\/d2s812or3jf8v2.cloudfront.net\\\/images\\\/data-u\\\/dbps_icon_25x25.jpg\",\"contentUrl\":\"http:\\\/\\\/d2s812or3jf8v2.cloudfront.net\\\/images\\\/data-u\\\/dbps_icon_25x25.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.baronsoftware.com\\\/Blog\\\/how-to-recognize-when-sql-windowing-functions-are-likely-to-help-improve-database-performance\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.baronsoftware.com\\\/Blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Recognize when SQL Windowing Functions are Likely to Help Improve Database Performance\"}]},{\"@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":"How to Recognize when SQL Windowing Functions are Likely to Help Improve Database Performance","description":"SQL Window Functions can be grouped into Ranking, Analytic, Aggregate thus providing multiple methods to gather what is needed from one data query.","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\/how-to-recognize-when-sql-windowing-functions-are-likely-to-help-improve-database-performance\/","og_locale":"en_US","og_type":"article","og_title":"How to Recognize when SQL Windowing Functions are Likely to Help Improve Database Performance","og_description":"SQL Window Functions can be grouped into Ranking, Analytic, Aggregate thus providing multiple methods to gather what is needed from one data query.","og_url":"https:\/\/www.baronsoftware.com\/Blog\/how-to-recognize-when-sql-windowing-functions-are-likely-to-help-improve-database-performance\/","og_site_name":"Baron Software","article_published_time":"2015-09-23T17:40:45+00:00","og_image":[{"url":"http:\/\/d2s812or3jf8v2.cloudfront.net\/images\/data-u\/dbps_icon_25x25.jpg","type":"","width":"","height":""}],"author":"richard@baronsoftware.com","twitter_card":"summary_large_image","twitter_creator":"@Rbaroniunas","twitter_site":"@Rbaroniunas","twitter_misc":{"Written by":"richard@baronsoftware.com","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.baronsoftware.com\/Blog\/how-to-recognize-when-sql-windowing-functions-are-likely-to-help-improve-database-performance\/#article","isPartOf":{"@id":"https:\/\/www.baronsoftware.com\/Blog\/how-to-recognize-when-sql-windowing-functions-are-likely-to-help-improve-database-performance\/"},"author":{"name":"richard@baronsoftware.com","@id":"https:\/\/www.baronsoftware.com\/Blog\/#\/schema\/person\/079d370e4230be9d5f75885bb33dd8cd"},"headline":"How to Recognize when SQL Windowing Functions are Likely to Help Improve Database Performance","datePublished":"2015-09-23T17:40:45+00:00","mainEntityOfPage":{"@id":"https:\/\/www.baronsoftware.com\/Blog\/how-to-recognize-when-sql-windowing-functions-are-likely-to-help-improve-database-performance\/"},"wordCount":144,"publisher":{"@id":"https:\/\/www.baronsoftware.com\/Blog\/#organization"},"image":{"@id":"https:\/\/www.baronsoftware.com\/Blog\/how-to-recognize-when-sql-windowing-functions-are-likely-to-help-improve-database-performance\/#primaryimage"},"thumbnailUrl":"http:\/\/d2s812or3jf8v2.cloudfront.net\/images\/data-u\/dbps_icon_25x25.jpg","keywords":["computers","Embarcadero","Microsoft","Pascal","Powerstudio","Rapid SQL","SQL Server"],"articleSection":["Software Events","SQL Tips"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.baronsoftware.com\/Blog\/how-to-recognize-when-sql-windowing-functions-are-likely-to-help-improve-database-performance\/","url":"https:\/\/www.baronsoftware.com\/Blog\/how-to-recognize-when-sql-windowing-functions-are-likely-to-help-improve-database-performance\/","name":"How to Recognize when SQL Windowing Functions are Likely to Help Improve Database Performance","isPartOf":{"@id":"https:\/\/www.baronsoftware.com\/Blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.baronsoftware.com\/Blog\/how-to-recognize-when-sql-windowing-functions-are-likely-to-help-improve-database-performance\/#primaryimage"},"image":{"@id":"https:\/\/www.baronsoftware.com\/Blog\/how-to-recognize-when-sql-windowing-functions-are-likely-to-help-improve-database-performance\/#primaryimage"},"thumbnailUrl":"http:\/\/d2s812or3jf8v2.cloudfront.net\/images\/data-u\/dbps_icon_25x25.jpg","datePublished":"2015-09-23T17:40:45+00:00","description":"SQL Window Functions can be grouped into Ranking, Analytic, Aggregate thus providing multiple methods to gather what is needed from one data query.","breadcrumb":{"@id":"https:\/\/www.baronsoftware.com\/Blog\/how-to-recognize-when-sql-windowing-functions-are-likely-to-help-improve-database-performance\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.baronsoftware.com\/Blog\/how-to-recognize-when-sql-windowing-functions-are-likely-to-help-improve-database-performance\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.baronsoftware.com\/Blog\/how-to-recognize-when-sql-windowing-functions-are-likely-to-help-improve-database-performance\/#primaryimage","url":"http:\/\/d2s812or3jf8v2.cloudfront.net\/images\/data-u\/dbps_icon_25x25.jpg","contentUrl":"http:\/\/d2s812or3jf8v2.cloudfront.net\/images\/data-u\/dbps_icon_25x25.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/www.baronsoftware.com\/Blog\/how-to-recognize-when-sql-windowing-functions-are-likely-to-help-improve-database-performance\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.baronsoftware.com\/Blog\/"},{"@type":"ListItem","position":2,"name":"How to Recognize when SQL Windowing Functions are Likely to Help Improve Database Performance"}]},{"@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-2x","jetpack-related-posts":[{"id":172,"url":"https:\/\/www.baronsoftware.com\/Blog\/how-to-recognize-when-sql-windowing-functions-are-likely-to-help-improve-database-performance-on-youtube\/","url_meta":{"origin":157,"position":0},"title":"How to Recognize when SQL Windowing Functions are Likely to Help Improve Database Performance on Youtube","author":"richard@baronsoftware.com","date":"October 12, 2015","format":false,"excerpt":"[powr-twitter-feed label=\"SQL Windowing Functions\"] You can view the free webinar \"How to Recognize when SQL Windowing Functions are Likely to Help Improve Database Performance\" on\u00a0Youtube\u00a0provided by Embarcadero.","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":249,"url":"https:\/\/www.baronsoftware.com\/Blog\/idera-and-embarcadero-separate-business\/","url_meta":{"origin":157,"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":162,"url":"https:\/\/www.baronsoftware.com\/Blog\/embacadero-releases-db-powerstudio-2016\/","url_meta":{"origin":157,"position":2},"title":"Embacadero releases DB PowerStudio\u00ae 2016","author":"richard@baronsoftware.com","date":"September 24, 2015","format":false,"excerpt":"Embarcadero has released DB PowerStudio 2016 during the DataU Webinar 2 day conference. \u00a0 Product installation is simple and quick. \u00a0The new features that provide DBAs the ability of checking SQL Server performance by using the add-on Performance IQ. Only Rapid SQL and DBArtisan 2016 have been released, not sure\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":201,"url":"https:\/\/www.baronsoftware.com\/Blog\/embarcadero-and-baron-software-powerstudio-case-study-which-monitors-sql-performance\/","url_meta":{"origin":157,"position":3},"title":"Embarcadero and Baron Software Powerstudio case study which monitors SQL Performance","author":"richard@baronsoftware.com","date":"January 7, 2016","format":false,"excerpt":"Embarcadero and Baron Software has issued a case study that demonstrates the benefits of using Microsoft SQL Powerstudio product line. \u00a0Powerstudio is a robust package that monitors SQL performance and can provide assistance for clients to update or create tables, stored procedures, etc. for various SQL servers some being Oracle,\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":"","src":"https:\/\/i0.wp.com\/www.baronsoftware.com\/Blog\/wp-content\/uploads\/2016\/01\/Case-Study.png?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.baronsoftware.com\/Blog\/wp-content\/uploads\/2016\/01\/Case-Study.png?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/www.baronsoftware.com\/Blog\/wp-content\/uploads\/2016\/01\/Case-Study.png?resize=525%2C300&ssl=1 1.5x"},"classes":[]},{"id":372,"url":"https:\/\/www.baronsoftware.com\/Blog\/baron-software-supports-db-powerstudio\/","url_meta":{"origin":157,"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":351,"url":"https:\/\/www.baronsoftware.com\/Blog\/getting-performance-statistics-cached-stored-procedures\/","url_meta":{"origin":157,"position":5},"title":"Getting performance statistics for cached stored procedures","author":"richard@baronsoftware.com","date":"October 18, 2016","format":false,"excerpt":"Getting performance statistics for cached stored procedures It is always extremely important to maintain your SQL server to the utmost efficiency.\u00a0\u00a0\u00a0 DBAs review the database structure and whether certain pieces such as stored procedures, triggers, etc. can be tuned even further.\u00a0 One of the areas that will be discussed are\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":"Baron Software","src":"https:\/\/i0.wp.com\/www.baronsoftware.com\/Blog\/wp-content\/uploads\/2014\/12\/logo.jpg?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]}],"_links":{"self":[{"href":"https:\/\/www.baronsoftware.com\/Blog\/wp-json\/wp\/v2\/posts\/157","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=157"}],"version-history":[{"count":1,"href":"https:\/\/www.baronsoftware.com\/Blog\/wp-json\/wp\/v2\/posts\/157\/revisions"}],"predecessor-version":[{"id":158,"href":"https:\/\/www.baronsoftware.com\/Blog\/wp-json\/wp\/v2\/posts\/157\/revisions\/158"}],"wp:attachment":[{"href":"https:\/\/www.baronsoftware.com\/Blog\/wp-json\/wp\/v2\/media?parent=157"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.baronsoftware.com\/Blog\/wp-json\/wp\/v2\/categories?post=157"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.baronsoftware.com\/Blog\/wp-json\/wp\/v2\/tags?post=157"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}