{"id":608,"date":"2017-09-30T17:17:01","date_gmt":"2017-09-30T22:17:01","guid":{"rendered":"https:\/\/www.baronsoftware.com\/Blog\/?p=608"},"modified":"2017-09-30T17:17:01","modified_gmt":"2017-09-30T22:17:01","slug":"idera-free-tool-powershell-scripts-sql-server","status":"publish","type":"post","link":"https:\/\/www.baronsoftware.com\/Blog\/idera-free-tool-powershell-scripts-sql-server\/","title":{"rendered":"Idera &#8211; Free Tool &#8211; PowerShell Scripts for SQL Server"},"content":{"rendered":"<h2 style=\"text-align: center;\">Idera &#8211; Free Tool &#8211; PowerShell Scripts for SQL Server<\/h2>\n<p><a href=\"https:\/\/www.idera.com\/productssolutions\/freetools\/sqlpowershellscripts?utm_source=dgeb&amp;utm_medium=email&amp;utm_campaign=sqlscripts&amp;utm_content=170929-cs-sqltodg-ft-sqlscripts\" target=\"_blank\" rel=\"noopener\"><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 wp-image-250 size-full\" 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>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 will allow you to work on your server providing you with some outstanding quick pieces that will enhance what you do on a daily basis.<\/p>\n<ul>\n<li>89 example scripts for managing SQL Server objects<\/li>\n<li>Initialize PowerShell SQLPS module and work with databases<\/li>\n<li>Scripts for Analysis, Integration, and Reporting services<\/li>\n<li>Experimental support for SQL Server 2016<\/li>\n<li>New scripts for exploring In-Memory databases and query store features<\/li>\n<\/ul>\n<h2 style=\"text-align: center;\">Powershell script break down<\/h2>\n<h3>Database Engine<\/h3>\n<ul>\n<li>Connect to a server instance, manage databases and publish scripts<\/li>\n<li>Work with policies and SQL Server logs<\/li>\n<li>Manage security and backups<\/li>\n<li>Create and manage SQL Server jobs<\/li>\n<li>Get extended event information<\/li>\n<\/ul>\n<h3>Analysis Services<\/h3>\n<ul>\n<li>Connect to an Analysis Services instance<\/li>\n<li>Get connection information<\/li>\n<li>Get a list of databases<\/li>\n<li>Backup databases and remove old backups<\/li>\n<li>Restore a database<\/li>\n<\/ul>\n<h3>Integration Services<\/h3>\n<ul>\n<li>Start and stop services<\/li>\n<li>Get package information<\/li>\n<li>Provision a catalog<\/li>\n<li>Publish a project<\/li>\n<li>Modify catalog settings<\/li>\n<\/ul>\n<h3>Reporting Services<\/h3>\n<ul>\n<li>Start or stop services<\/li>\n<li>Get instance information<\/li>\n<li>Backup and restore encryption keys<\/li>\n<li>Get configuration information<\/li>\n<li>Get event log information<\/li>\n<\/ul>\n<h3>***NEW Scripts***<br \/>\nIn-Memory Databases (SQL2014 and SQL2016)<\/h3>\n<ul>\n<li>Get overall utilization<\/li>\n<li>Get size on disk<\/li>\n<li>Get detailed utilization by table<\/li>\n<li>Get checkpoint size<\/li>\n<\/ul>\n<h3>Query Plan (SQL2016)<\/h3>\n<ul>\n<li>Set Query Plan desired state<\/li>\n<li>Set Query Plan data retention maximum size<\/li>\n<li>Get Query Plan information<\/li>\n<li>Get Query Store status<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Idera &#8211; Free Tool &#8211; 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 will allow you to work [&hellip;]<\/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_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,32],"tags":[20,7,13,47,9,38,37,24],"class_list":["post-608","post","type-post","status-publish","format-standard","hentry","category-software-development-concepts","category-software-events","category-software-releases","tag-delphi","tag-development","tag-embarcadero","tag-idera","tag-pascal","tag-powerstudio","tag-rapid-sql","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>Idera - Free Tool - PowerShell Scripts for SQL Server - Baron Software<\/title>\n<meta name=\"description\" content=\"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\" \/>\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\/idera-free-tool-powershell-scripts-sql-server\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Idera - Free Tool - PowerShell Scripts for SQL Server\" \/>\n<meta property=\"og:description\" content=\"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 will allow you to work on your server providing you with some outstanding quick pieces that will enhance what you do on a daily basis.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.baronsoftware.com\/Blog\/idera-free-tool-powershell-scripts-sql-server\/\" \/>\n<meta property=\"og:site_name\" content=\"Baron Software\" \/>\n<meta property=\"article:published_time\" content=\"2017-09-30T22:17:01+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=\"Idera - Free Tool - PowerShell Scripts for SQL Server\" \/>\n<meta name=\"twitter:description\" content=\"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 will allow you to work on your server providing you with some outstanding quick pieces that will enhance what you do on a daily basis.\" \/>\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=\"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\\\/idera-free-tool-powershell-scripts-sql-server\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.baronsoftware.com\\\/Blog\\\/idera-free-tool-powershell-scripts-sql-server\\\/\"},\"author\":{\"name\":\"richard@baronsoftware.com\",\"@id\":\"https:\\\/\\\/www.baronsoftware.com\\\/Blog\\\/#\\\/schema\\\/person\\\/079d370e4230be9d5f75885bb33dd8cd\"},\"headline\":\"Idera &#8211; Free Tool &#8211; PowerShell Scripts for SQL Server\",\"datePublished\":\"2017-09-30T22:17:01+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.baronsoftware.com\\\/Blog\\\/idera-free-tool-powershell-scripts-sql-server\\\/\"},\"wordCount\":268,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.baronsoftware.com\\\/Blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.baronsoftware.com\\\/Blog\\\/idera-free-tool-powershell-scripts-sql-server\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.baronsoftware.com\\\/Blog\\\/wp-content\\\/uploads\\\/2016\\\/03\\\/Idera.png\",\"keywords\":[\"Delphi\",\"Development\",\"Embarcadero\",\"Idera\",\"Pascal\",\"Powerstudio\",\"Rapid SQL\",\"Windows 10\"],\"articleSection\":[\"Software development Concepts\",\"Software Events\",\"Software Releases\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.baronsoftware.com\\\/Blog\\\/idera-free-tool-powershell-scripts-sql-server\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.baronsoftware.com\\\/Blog\\\/idera-free-tool-powershell-scripts-sql-server\\\/\",\"url\":\"https:\\\/\\\/www.baronsoftware.com\\\/Blog\\\/idera-free-tool-powershell-scripts-sql-server\\\/\",\"name\":\"Idera - Free Tool - PowerShell Scripts for SQL Server - Baron Software\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.baronsoftware.com\\\/Blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.baronsoftware.com\\\/Blog\\\/idera-free-tool-powershell-scripts-sql-server\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.baronsoftware.com\\\/Blog\\\/idera-free-tool-powershell-scripts-sql-server\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.baronsoftware.com\\\/Blog\\\/wp-content\\\/uploads\\\/2016\\\/03\\\/Idera.png\",\"datePublished\":\"2017-09-30T22:17:01+00:00\",\"description\":\"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\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.baronsoftware.com\\\/Blog\\\/idera-free-tool-powershell-scripts-sql-server\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.baronsoftware.com\\\/Blog\\\/idera-free-tool-powershell-scripts-sql-server\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.baronsoftware.com\\\/Blog\\\/idera-free-tool-powershell-scripts-sql-server\\\/#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\\\/idera-free-tool-powershell-scripts-sql-server\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.baronsoftware.com\\\/Blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Idera &#8211; Free Tool &#8211; PowerShell Scripts for SQL Server\"}]},{\"@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":"Idera - Free Tool - PowerShell Scripts for SQL Server - Baron Software","description":"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","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\/idera-free-tool-powershell-scripts-sql-server\/","og_locale":"en_US","og_type":"article","og_title":"Idera - Free Tool - PowerShell Scripts for SQL Server","og_description":"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 will allow you to work on your server providing you with some outstanding quick pieces that will enhance what you do on a daily basis.","og_url":"https:\/\/www.baronsoftware.com\/Blog\/idera-free-tool-powershell-scripts-sql-server\/","og_site_name":"Baron Software","article_published_time":"2017-09-30T22:17:01+00:00","author":"richard@baronsoftware.com","twitter_card":"summary_large_image","twitter_title":"Idera - Free Tool - PowerShell Scripts for SQL Server","twitter_description":"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 will allow you to work on your server providing you with some outstanding quick pieces that will enhance what you do on a daily basis.","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":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.baronsoftware.com\/Blog\/idera-free-tool-powershell-scripts-sql-server\/#article","isPartOf":{"@id":"https:\/\/www.baronsoftware.com\/Blog\/idera-free-tool-powershell-scripts-sql-server\/"},"author":{"name":"richard@baronsoftware.com","@id":"https:\/\/www.baronsoftware.com\/Blog\/#\/schema\/person\/079d370e4230be9d5f75885bb33dd8cd"},"headline":"Idera &#8211; Free Tool &#8211; PowerShell Scripts for SQL Server","datePublished":"2017-09-30T22:17:01+00:00","mainEntityOfPage":{"@id":"https:\/\/www.baronsoftware.com\/Blog\/idera-free-tool-powershell-scripts-sql-server\/"},"wordCount":268,"commentCount":0,"publisher":{"@id":"https:\/\/www.baronsoftware.com\/Blog\/#organization"},"image":{"@id":"https:\/\/www.baronsoftware.com\/Blog\/idera-free-tool-powershell-scripts-sql-server\/#primaryimage"},"thumbnailUrl":"https:\/\/www.baronsoftware.com\/Blog\/wp-content\/uploads\/2016\/03\/Idera.png","keywords":["Delphi","Development","Embarcadero","Idera","Pascal","Powerstudio","Rapid SQL","Windows 10"],"articleSection":["Software development Concepts","Software Events","Software Releases"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.baronsoftware.com\/Blog\/idera-free-tool-powershell-scripts-sql-server\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.baronsoftware.com\/Blog\/idera-free-tool-powershell-scripts-sql-server\/","url":"https:\/\/www.baronsoftware.com\/Blog\/idera-free-tool-powershell-scripts-sql-server\/","name":"Idera - Free Tool - PowerShell Scripts for SQL Server - Baron Software","isPartOf":{"@id":"https:\/\/www.baronsoftware.com\/Blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.baronsoftware.com\/Blog\/idera-free-tool-powershell-scripts-sql-server\/#primaryimage"},"image":{"@id":"https:\/\/www.baronsoftware.com\/Blog\/idera-free-tool-powershell-scripts-sql-server\/#primaryimage"},"thumbnailUrl":"https:\/\/www.baronsoftware.com\/Blog\/wp-content\/uploads\/2016\/03\/Idera.png","datePublished":"2017-09-30T22:17:01+00:00","description":"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","breadcrumb":{"@id":"https:\/\/www.baronsoftware.com\/Blog\/idera-free-tool-powershell-scripts-sql-server\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.baronsoftware.com\/Blog\/idera-free-tool-powershell-scripts-sql-server\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.baronsoftware.com\/Blog\/idera-free-tool-powershell-scripts-sql-server\/#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\/idera-free-tool-powershell-scripts-sql-server\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.baronsoftware.com\/Blog\/"},{"@type":"ListItem","position":2,"name":"Idera &#8211; Free Tool &#8211; PowerShell Scripts for SQL Server"}]},{"@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-9O","jetpack-related-posts":[{"id":249,"url":"https:\/\/www.baronsoftware.com\/Blog\/idera-and-embarcadero-separate-business\/","url_meta":{"origin":608,"position":0},"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":372,"url":"https:\/\/www.baronsoftware.com\/Blog\/baron-software-supports-db-powerstudio\/","url_meta":{"origin":608,"position":1},"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":289,"url":"https:\/\/www.baronsoftware.com\/Blog\/expedite-sql-development-rapid-sql\/","url_meta":{"origin":608,"position":2},"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":565,"url":"https:\/\/www.baronsoftware.com\/Blog\/new-build-4-now-available-version-2-26-elevatedb\/","url_meta":{"origin":608,"position":3},"title":"New Build 4 Now Available for Version 2.26 of ElevateDB from Elevate Software","author":"richard@baronsoftware.com","date":"September 13, 2017","format":false,"excerpt":"New Build 4 Now Available for Version 2.26 of ElevateDB from Elevate Software Elevate Software is \u00a0pleased to announce that build 4 for version 2.26 of ElevateDB is now available. The software release provides the following: Altering a Table in a Database with Dependent Views Can Result in a Table\u2026","rel":"","context":"In &quot;Software Events&quot;","block_context":{"text":"Software Events","link":"https:\/\/www.baronsoftware.com\/Blog\/category\/software-events\/"},"img":{"alt_text":"ElevateDB","src":"https:\/\/i0.wp.com\/www.baronsoftware.com\/Blog\/wp-content\/uploads\/2017\/09\/edbproduct.png?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":608,"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":820,"url":"https:\/\/www.baronsoftware.com\/Blog\/idera-offers-free-webinar-data-modeling-cloud\/","url_meta":{"origin":608,"position":5},"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 &quot;Idera&quot;","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":[]}],"_links":{"self":[{"href":"https:\/\/www.baronsoftware.com\/Blog\/wp-json\/wp\/v2\/posts\/608","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=608"}],"version-history":[{"count":1,"href":"https:\/\/www.baronsoftware.com\/Blog\/wp-json\/wp\/v2\/posts\/608\/revisions"}],"predecessor-version":[{"id":609,"href":"https:\/\/www.baronsoftware.com\/Blog\/wp-json\/wp\/v2\/posts\/608\/revisions\/609"}],"wp:attachment":[{"href":"https:\/\/www.baronsoftware.com\/Blog\/wp-json\/wp\/v2\/media?parent=608"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.baronsoftware.com\/Blog\/wp-json\/wp\/v2\/categories?post=608"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.baronsoftware.com\/Blog\/wp-json\/wp\/v2\/tags?post=608"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}