{"id":366,"date":"2016-10-27T13:11:00","date_gmt":"2016-10-27T18:11:00","guid":{"rendered":"https:\/\/www.baronsoftware.com\/Blog\/?p=366"},"modified":"2016-10-27T13:11:00","modified_gmt":"2016-10-27T18:11:00","slug":"saving-sql-column-headers-results","status":"publish","type":"post","link":"https:\/\/www.baronsoftware.com\/Blog\/saving-sql-column-headers-results\/","title":{"rendered":"Saving SQL Column Headers Results"},"content":{"rendered":"<h3 style=\"text-align: center;\"><a href=\"https:\/\/www.baronsoftware.com\"><img data-recalc-dims=\"1\" decoding=\"async\" data-attachment-id=\"7\" data-permalink=\"https:\/\/www.baronsoftware.com\/Blog\/delphi-create-a-process-or-shelling-to-start-up-an-external-application\/logo\/\" data-orig-file=\"https:\/\/i0.wp.com\/www.baronsoftware.com\/Blog\/wp-content\/uploads\/2014\/12\/logo-e1515620410626.jpg?fit=200%2C36&amp;ssl=1\" data-orig-size=\"200,36\" data-comments-opened=\"1\" 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=\"logo\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/www.baronsoftware.com\/Blog\/wp-content\/uploads\/2014\/12\/logo-e1515620410626.jpg?fit=200%2C36&amp;ssl=1\" class=\"aligncenter wp-image-7 size-full\" src=\"https:\/\/i0.wp.com\/www.baronsoftware.com\/Blog\/wp-content\/uploads\/2014\/12\/logo.jpg?resize=450%2C80&#038;ssl=1\" alt=\"Baron Software\" width=\"450\" height=\"80\" \/><\/a><\/h3>\n<h3 style=\"text-align: center;\">Saving SQL Column Headers Results<\/h3>\n<p>Sometimes you can run into problems that tend to take up time and could have been solved in a minute.\u00a0 One of these strange problems is when you attempt to save a Microsoft SQL query result grid to a CSV file.<\/p>\n<h3 style=\"text-align: center;\">Using Microsoft SQL Server Management Studio (SSMS)<\/h3>\n<p>Now most of DBA or Developers tend to use the Microsoft SQL Server Management Studio (SSMS) to do the necessary general SQL work.\u00a0 As you expected when you execute a query the results grid appears displaying the results.\u00a0 I as countless others tend to copy the information and save it in an excel spreadsheet to do further analysis.\u00a0 But there are times you may need to save the information into a CSV file for the purpose of processing the information later or with a different application.<\/p>\n<p>If you use the option to save out to a CSV file you\u00a0will notice that the column headers are missing and you are pretty much baffled.<\/p>\n<h3 style=\"text-align: center;\">A simple click to solve the issue<\/h3>\n<p>It is not you but apparently Microsoft decided not to default a simple setting that saves the column headers in your CSV file.\u00a0 What you need to simply do is click on Tools &#8211; Options which will open the Options Dialog box.<\/p>\n<p>In this Dialog box you will click on Query Results &#8211; Results to Grid.\u00a0 You will see the &#8220;Include column headers when copying or saving the results&#8221;, click to enable it.\u00a0 You should see the similar as the image below.\u00a0 Click OK to close the dialog and will have to restart the Server Management Studio application for the settings to take hold.<\/p>\n<p><a href=\"https:\/\/www.baronsoftware.com\"><img data-recalc-dims=\"1\" fetchpriority=\"high\" decoding=\"async\" data-attachment-id=\"367\" data-permalink=\"https:\/\/www.baronsoftware.com\/Blog\/saving-sql-column-headers-results\/capture-3\/\" data-orig-file=\"https:\/\/i0.wp.com\/www.baronsoftware.com\/Blog\/wp-content\/uploads\/2016\/10\/Capture-2.png?fit=756%2C437&amp;ssl=1\" data-orig-size=\"756,437\" 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=\"capture\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/www.baronsoftware.com\/Blog\/wp-content\/uploads\/2016\/10\/Capture-2.png?fit=640%2C370&amp;ssl=1\" class=\"aligncenter size-full wp-image-367\" src=\"https:\/\/i0.wp.com\/www.baronsoftware.com\/Blog\/wp-content\/uploads\/2016\/10\/Capture-2.png?resize=640%2C370&#038;ssl=1\" alt=\"MS SQL Server\" width=\"640\" height=\"370\" srcset=\"https:\/\/i0.wp.com\/www.baronsoftware.com\/Blog\/wp-content\/uploads\/2016\/10\/Capture-2.png?w=756&amp;ssl=1 756w, https:\/\/i0.wp.com\/www.baronsoftware.com\/Blog\/wp-content\/uploads\/2016\/10\/Capture-2.png?resize=300%2C173&amp;ssl=1 300w\" sizes=\"(max-width: 640px) 100vw, 640px\" \/><\/a><\/p>\n<p>This is something we all take for granted and by diving into the vast amount of options you can solve it.\u00a0 So go ahead and take a look to see if you have it set or need to.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Saving SQL Column Headers Results Sometimes you can run into problems that tend to take up time and could have been solved in a minute.\u00a0 One of these strange problems is when you attempt to save a Microsoft SQL query result grid to a CSV file. Using Microsoft SQL Server Management Studio (SSMS) Now most [&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":[1],"tags":[21,39,20,7,13,15,49,37,36,67,68,24],"class_list":["post-366","post","type-post","status-publish","format-standard","hentry","category-sql-tips","tag-computers","tag-dbartisan","tag-delphi","tag-development","tag-embarcadero","tag-microsoft","tag-microsoft-access","tag-rapid-sql","tag-sql-server","tag-ssms","tag-studio-management-studio","tag-windows-10"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.3 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Saving SQL Column Headers Results - Baron Software<\/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.baronsoftware.com\/Blog\/saving-sql-column-headers-results\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Saving SQL Column Headers Results\" \/>\n<meta property=\"og:description\" content=\"How to get query results to save to a CSV with column headings\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.baronsoftware.com\/Blog\/saving-sql-column-headers-results\/\" \/>\n<meta property=\"og:site_name\" content=\"Baron Software\" \/>\n<meta property=\"article:published_time\" content=\"2016-10-27T18:11:00+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=\"Saving SQL Column Headers Results\" \/>\n<meta name=\"twitter:description\" content=\"How to get query results to save to a CSV with column headings\" \/>\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\\\/saving-sql-column-headers-results\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.baronsoftware.com\\\/Blog\\\/saving-sql-column-headers-results\\\/\"},\"author\":{\"name\":\"richard@baronsoftware.com\",\"@id\":\"https:\\\/\\\/www.baronsoftware.com\\\/Blog\\\/#\\\/schema\\\/person\\\/079d370e4230be9d5f75885bb33dd8cd\"},\"headline\":\"Saving SQL Column Headers Results\",\"datePublished\":\"2016-10-27T18:11:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.baronsoftware.com\\\/Blog\\\/saving-sql-column-headers-results\\\/\"},\"wordCount\":320,\"publisher\":{\"@id\":\"https:\\\/\\\/www.baronsoftware.com\\\/Blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.baronsoftware.com\\\/Blog\\\/saving-sql-column-headers-results\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.baronsoftware.com\\\/Blog\\\/wp-content\\\/uploads\\\/2014\\\/12\\\/logo.jpg\",\"keywords\":[\"computers\",\"DBArtisan\",\"Delphi\",\"Development\",\"Embarcadero\",\"Microsoft\",\"MIcrosoft Access\",\"Rapid SQL\",\"SQL Server\",\"SSMS\",\"Studio Management Studio\",\"Windows 10\"],\"articleSection\":[\"SQL Tips\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.baronsoftware.com\\\/Blog\\\/saving-sql-column-headers-results\\\/\",\"url\":\"https:\\\/\\\/www.baronsoftware.com\\\/Blog\\\/saving-sql-column-headers-results\\\/\",\"name\":\"Saving SQL Column Headers Results - Baron Software\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.baronsoftware.com\\\/Blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.baronsoftware.com\\\/Blog\\\/saving-sql-column-headers-results\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.baronsoftware.com\\\/Blog\\\/saving-sql-column-headers-results\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.baronsoftware.com\\\/Blog\\\/wp-content\\\/uploads\\\/2014\\\/12\\\/logo.jpg\",\"datePublished\":\"2016-10-27T18:11:00+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.baronsoftware.com\\\/Blog\\\/saving-sql-column-headers-results\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.baronsoftware.com\\\/Blog\\\/saving-sql-column-headers-results\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.baronsoftware.com\\\/Blog\\\/saving-sql-column-headers-results\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.baronsoftware.com\\\/Blog\\\/wp-content\\\/uploads\\\/2014\\\/12\\\/logo.jpg\",\"contentUrl\":\"https:\\\/\\\/www.baronsoftware.com\\\/Blog\\\/wp-content\\\/uploads\\\/2014\\\/12\\\/logo.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.baronsoftware.com\\\/Blog\\\/saving-sql-column-headers-results\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.baronsoftware.com\\\/Blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Saving SQL Column Headers Results\"}]},{\"@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":"Saving SQL Column Headers Results - Baron Software","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\/saving-sql-column-headers-results\/","og_locale":"en_US","og_type":"article","og_title":"Saving SQL Column Headers Results","og_description":"How to get query results to save to a CSV with column headings","og_url":"https:\/\/www.baronsoftware.com\/Blog\/saving-sql-column-headers-results\/","og_site_name":"Baron Software","article_published_time":"2016-10-27T18:11:00+00:00","author":"richard@baronsoftware.com","twitter_card":"summary_large_image","twitter_title":"Saving SQL Column Headers Results","twitter_description":"How to get query results to save to a CSV with column headings","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\/saving-sql-column-headers-results\/#article","isPartOf":{"@id":"https:\/\/www.baronsoftware.com\/Blog\/saving-sql-column-headers-results\/"},"author":{"name":"richard@baronsoftware.com","@id":"https:\/\/www.baronsoftware.com\/Blog\/#\/schema\/person\/079d370e4230be9d5f75885bb33dd8cd"},"headline":"Saving SQL Column Headers Results","datePublished":"2016-10-27T18:11:00+00:00","mainEntityOfPage":{"@id":"https:\/\/www.baronsoftware.com\/Blog\/saving-sql-column-headers-results\/"},"wordCount":320,"publisher":{"@id":"https:\/\/www.baronsoftware.com\/Blog\/#organization"},"image":{"@id":"https:\/\/www.baronsoftware.com\/Blog\/saving-sql-column-headers-results\/#primaryimage"},"thumbnailUrl":"https:\/\/www.baronsoftware.com\/Blog\/wp-content\/uploads\/2014\/12\/logo.jpg","keywords":["computers","DBArtisan","Delphi","Development","Embarcadero","Microsoft","MIcrosoft Access","Rapid SQL","SQL Server","SSMS","Studio Management Studio","Windows 10"],"articleSection":["SQL Tips"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.baronsoftware.com\/Blog\/saving-sql-column-headers-results\/","url":"https:\/\/www.baronsoftware.com\/Blog\/saving-sql-column-headers-results\/","name":"Saving SQL Column Headers Results - Baron Software","isPartOf":{"@id":"https:\/\/www.baronsoftware.com\/Blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.baronsoftware.com\/Blog\/saving-sql-column-headers-results\/#primaryimage"},"image":{"@id":"https:\/\/www.baronsoftware.com\/Blog\/saving-sql-column-headers-results\/#primaryimage"},"thumbnailUrl":"https:\/\/www.baronsoftware.com\/Blog\/wp-content\/uploads\/2014\/12\/logo.jpg","datePublished":"2016-10-27T18:11:00+00:00","breadcrumb":{"@id":"https:\/\/www.baronsoftware.com\/Blog\/saving-sql-column-headers-results\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.baronsoftware.com\/Blog\/saving-sql-column-headers-results\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.baronsoftware.com\/Blog\/saving-sql-column-headers-results\/#primaryimage","url":"https:\/\/www.baronsoftware.com\/Blog\/wp-content\/uploads\/2014\/12\/logo.jpg","contentUrl":"https:\/\/www.baronsoftware.com\/Blog\/wp-content\/uploads\/2014\/12\/logo.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/www.baronsoftware.com\/Blog\/saving-sql-column-headers-results\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.baronsoftware.com\/Blog\/"},{"@type":"ListItem","position":2,"name":"Saving SQL Column Headers Results"}]},{"@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-5U","jetpack-related-posts":[{"id":289,"url":"https:\/\/www.baronsoftware.com\/Blog\/expedite-sql-development-rapid-sql\/","url_meta":{"origin":366,"position":0},"title":"Expedite SQL with Idera Rapid SQL 2016","author":"richard@baronsoftware.com","date":"June 9, 2016","format":false,"excerpt":"Expedite SQL Development with Rapid SQL 2016 \u2022 Write code across different database platforms - Produce high-performing SQL code across DBMS platforms (Oracle, SQL Server, DB2, Sybase and PostgreSQL) from one user interface. \u2022 Develop SQL code quickly and efficiently - The SQL IDE is a clean, slick development environment,\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":"Idera rapid sql 2016","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":366,"position":1},"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":[]},{"id":928,"url":"https:\/\/www.baronsoftware.com\/Blog\/microsoft-sql-server-how-to-get-a-table-size\/","url_meta":{"origin":366,"position":2},"title":"Microsoft SQL Server how to get a table size","author":"richard@baronsoftware.com","date":"July 22, 2018","format":false,"excerpt":"Microsoft SQL Server how to get a table size Sometimes you need to get the size of a particular table located in a database within the Microsoft Server and the following query can provide you that.\u00a0 You can run this manually or place it in a stored procedure for numerous\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":249,"url":"https:\/\/www.baronsoftware.com\/Blog\/idera-and-embarcadero-separate-business\/","url_meta":{"origin":366,"position":3},"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":201,"url":"https:\/\/www.baronsoftware.com\/Blog\/embarcadero-and-baron-software-powerstudio-case-study-which-monitors-sql-performance\/","url_meta":{"origin":366,"position":4},"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":608,"url":"https:\/\/www.baronsoftware.com\/Blog\/idera-free-tool-powershell-scripts-sql-server\/","url_meta":{"origin":366,"position":5},"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":[]}],"_links":{"self":[{"href":"https:\/\/www.baronsoftware.com\/Blog\/wp-json\/wp\/v2\/posts\/366","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=366"}],"version-history":[{"count":1,"href":"https:\/\/www.baronsoftware.com\/Blog\/wp-json\/wp\/v2\/posts\/366\/revisions"}],"predecessor-version":[{"id":368,"href":"https:\/\/www.baronsoftware.com\/Blog\/wp-json\/wp\/v2\/posts\/366\/revisions\/368"}],"wp:attachment":[{"href":"https:\/\/www.baronsoftware.com\/Blog\/wp-json\/wp\/v2\/media?parent=366"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.baronsoftware.com\/Blog\/wp-json\/wp\/v2\/categories?post=366"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.baronsoftware.com\/Blog\/wp-json\/wp\/v2\/tags?post=366"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}