{"id":16205,"date":"2016-06-30T09:00:58","date_gmt":"2016-06-30T16:00:58","guid":{"rendered":"https:\/\/blogs.technet.microsoft.com\/dataplatforminsider\/?p=16205"},"modified":"2024-01-22T22:50:31","modified_gmt":"2024-01-23T06:50:31","slug":"sql-powershell-july-2016-update","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/06\/30\/sql-powershell-july-2016-update\/","title":{"rendered":"SQL PowerShell: July 2016 update"},"content":{"rendered":"<p><em>This post was authored by Ayo Olubeko, Program Manager, Data Developer Group.<\/em><\/p>\n<p>The July update for SSMS includes the first substantial improvement in SQL PowerShell in many years. We owe a lot of thanks for this effort to the great collaboration with our community. We have several new CMDLETs to share with you, but firstly, there is a very important change we had to make to be able to ship monthly updates to the SQL PowerShell component.<\/p>\n<p>Historically, SQL Server\u2019s PowerShell components are included in both the SSMS (tools) installer as well as with the SQL Server engine install. In order to be able to ship SQL PowerShell update, we had to change the identity of the SQL PowerShell module as well as the wrapper known as SQLPS.exe. <em>This change has an impact to scripts doing Import-Module.<\/em><\/p>\n<p>This month we introduce CMDLETs for the following areas:<\/p>\n<ul>\n<li>Always Encrypted<\/li>\n<li>SQL Agent<\/li>\n<li>SQL Error Logs<\/li>\n<\/ul>\n<p>Additionally, we have made some nice improvements to Invoke-SqlCmd and the SQL provider.<\/p>\n<h2>New SQL PowerShell module<\/h2>\n<p>As alluded to above, in order to ship monthly updates, we have created a new SQL PowerShell module as well as have introduced a new wrapper EXE that SSMS uses to instantiate the SQL PowerShell environment. The SQL PowerShell module that ships with SSMS has changed from SQLPS to SqlServer (there is no change to the module used by SQL Agent). This means that if you have a PowerShell script doing <em>Import-Module SQLPS<\/em>, it will need to be changed to be <em>Import-Module SqlServer<\/em> in order to take advantage of the new provider functionality and new CMDLETs. The new module will be installed to <em>\u201c%Program Files\\WindowsPowerShell\\Modules\\SqlServer<\/em>\u201d and hence no update to $env:PSModulePath is required. Additionally, if you happen to have a script that is using a 3rd-party or community version of a module named <em>SqlServer<\/em>, you should add use of the Prefix parameter to avoid name collisions.<\/p>\n<p>The motivation for these changes is that the tooling components are being moved to be \u201capplication local\u201d and not share any components with the SQL Server engine. This is an important step to enable monthly tooling updates while not negatively impacting the components setup and updated by the SQL Server setup program.<\/p>\n<p>SSMS has been updated to integrate with SQLTOOLSPS.exe rather than SQLPS.exe. Hence, if you launch PowerShell from within SSMS, it will launch PowerShell and configure the session with the new SQL PowerShell module. It is advised to avoid using these EXE wrappers; they exist for legacy reasons within SSMS and are likely to be removed in a future monthly update.<\/p>\n<p>The new version of SQL Server PowerShell included with SSMS does not update the version of PowerShell used by SQL Server. This means that scripts executed by SQL Agent will not be able to use the new CMDLETs. Updates to SQLPS (the version used by SQL Agent) will be done through the traditional SQL Server update mechanisms; more specifically, major changes will be done as part of the next major version of SQL Server as it becomes available.<\/p>\n<h2>New CMDLETs<\/h2>\n<p>In the July SSMS update, you will find several new CMDLETs. Once again, we owe thanks to our SQL PowerShell community leaders for helping us prioritize these investments. The CMDLETs all provide help within PowerShell for detailed information. As with the majority of the features in SSMS, the SQL PowerShell CMDLETs work against all supported versions of SQL Server. In some cases, such as Always Encrypted, the CMDLETs obviously only work on versions of SQL Server that support that specific feature set.<\/p>\n<table>\n<tbody>\n<tr>\n<td width=\"0\"><strong><span style=\"color: #0000ff\">CMDLET<\/span><\/strong><\/td>\n<td width=\"0\"><strong><span style=\"color: #0000ff\">Description<\/span><\/strong><\/td>\n<\/tr>\n<tr>\n<td width=\"0\"><strong>Add-SqlAzureAuthenticationContext<\/strong><\/td>\n<td width=\"0\">Performs authentication to Azure and acquires an authentication token.<\/td>\n<\/tr>\n<tr>\n<td width=\"0\"><strong>Add-SqlColumnEncryptionKeyValue<\/strong><\/td>\n<td width=\"0\">Adds a new encrypted value for an existing column encryption key object in the database.<\/td>\n<\/tr>\n<tr>\n<td width=\"0\"><strong>Complete-SqlColumnMasterKeyRotation<\/strong><\/td>\n<td width=\"0\">Completes the rotation of a column master key.<\/td>\n<\/tr>\n<tr>\n<td width=\"0\"><strong>Get-SqlColumnEncryptionKey<\/strong><\/td>\n<td width=\"0\">Returns all column encryption key objects defined in the database, or returns one column encryption key object with the specified name.<\/td>\n<\/tr>\n<tr>\n<td width=\"0\"><strong>Get-SqlColumnMasterKey<\/strong><\/td>\n<td width=\"0\">Returns the column master key objects defined in the database, or returns one column master key object with the specified name.<\/td>\n<\/tr>\n<tr>\n<td width=\"0\"><strong>Invoke-SqlColumnMasterKeyRotation<\/strong><\/td>\n<td width=\"0\">Initiates the rotation of a column master key.<\/td>\n<\/tr>\n<tr>\n<td width=\"0\"><strong>New-SqlAzureKeyVaultColumnMasterKeySettings<\/strong><\/td>\n<td width=\"0\">Creates a SqlColumnMasterKeySettings object describing an asymmetric key stored in Azure Key Vault.<\/td>\n<\/tr>\n<tr>\n<td width=\"0\"><strong>New-SqlCertificateStoreColumnMasterKeySettings<\/strong><\/td>\n<td width=\"0\">Creates a SqlColumnMasterKeySettings object referencing the specified certificate.<\/td>\n<\/tr>\n<tr>\n<td width=\"0\"><strong>New-SqlCngColumnMasterKeySettings<\/strong><\/td>\n<td width=\"0\">Creates a SqlColumnMasterKeySettings object describing an asymmetric key stored in a key store supporting the Cryptography Next Generation (CNG) API.<\/td>\n<\/tr>\n<tr>\n<td width=\"0\"><strong>New-SqlColumnEncryptionKey<\/strong><\/td>\n<td width=\"0\">Crates a new column encryption key object in the database.<\/td>\n<\/tr>\n<tr>\n<td width=\"0\"><strong>New-SqlColumnEncryptionKeyEncryptedValue<\/strong><\/td>\n<td width=\"0\">Produces an encrypted value of a column encryption key.<\/td>\n<\/tr>\n<tr>\n<td width=\"0\"><strong>New-SqlColumnEncryptionSettings<\/strong><\/td>\n<td width=\"0\">Creates a new SqlColumnEncryptionSettings object that encapsulates information about a single column\u2019s encryption, including CEK and encryption type.<\/td>\n<\/tr>\n<tr>\n<td width=\"0\"><strong>New-SqlColumnMasterKey<\/strong><\/td>\n<td width=\"0\">Creates a new column master key object in the database.<\/td>\n<\/tr>\n<tr>\n<td width=\"0\"><strong>New-SqlCspColumnMasterKeySettings<\/strong><\/td>\n<td width=\"0\">Creates a SqlColumnMasterKeySettings object describing an asymmetric key stored in a key store with a Cryptography Service Provider (CSP) supporting Cryptography API (CAPI).<\/td>\n<\/tr>\n<tr>\n<td width=\"0\"><strong>Remove-SqlColumnEncryptionKey<\/strong><\/td>\n<td width=\"0\">Removes the column encryption key object from the database.<\/td>\n<\/tr>\n<tr>\n<td width=\"0\"><strong>Remove-SqlColumnEncryptionKeyValue<\/strong><\/td>\n<td width=\"0\">Removes an encrypted value from an existing column encryption key object in the database.<\/td>\n<\/tr>\n<tr>\n<td width=\"0\"><strong>Remove-SqlColumnMasterKey<\/strong><\/td>\n<td width=\"0\">Removes the column master key object from the database.<\/td>\n<\/tr>\n<tr>\n<td width=\"0\"><strong>Set-SqlColumnEncryption<\/strong><\/td>\n<td width=\"0\">Encrypts, decrypts or re-encrypts specified columns in the database.<\/td>\n<\/tr>\n<tr>\n<td width=\"312\"><strong>\u00a0<\/strong><\/td>\n<td width=\"312\"><\/td>\n<\/tr>\n<tr>\n<td width=\"0\"><strong>Get-SqlAgent<\/strong><\/td>\n<td width=\"0\">Returns a SQL Agent (JobServer) object that is present in the target instance of the SQL Server.<\/td>\n<\/tr>\n<tr>\n<td width=\"0\"><strong>Get-SqlAgentJob<\/strong><\/td>\n<td width=\"0\">Returns a SQL Agent Job object for each job that is present in the target instance of SQL Agent.<\/td>\n<\/tr>\n<tr>\n<td width=\"0\"><strong>Get-SqlAgentJobHistory<\/strong><\/td>\n<td width=\"0\">Returns the JobHistory present in the target instance of SQL Agent.<\/td>\n<\/tr>\n<tr>\n<td width=\"0\"><strong>Get-SqlAgentJobSchedule<\/strong><\/td>\n<td width=\"0\">Returns a JobSchedule object for each schedule that is present in the target instance of SQL Agent Job.<\/td>\n<\/tr>\n<tr>\n<td width=\"0\"><strong>Get-SqlAgentJobStep<\/strong><\/td>\n<td width=\"0\">Returns a SQL JobStep object for each step that is present in the target instance of SQL Agent Job.<\/td>\n<\/tr>\n<tr>\n<td width=\"0\"><strong>Get-SqlAgentSchedule<\/strong><\/td>\n<td width=\"0\">Returns a SQL JobSchedule object for each schedule that is present in the target instance of SQL Agent.<\/td>\n<\/tr>\n<tr>\n<td width=\"312\"><strong>\u00a0<\/strong><\/td>\n<td width=\"312\"><\/td>\n<\/tr>\n<tr>\n<td width=\"0\"><strong>Get-SqlErrorLog<\/strong><\/td>\n<td width=\"0\">Retrieves the SQL Server Logs.<\/td>\n<\/tr>\n<tr>\n<td width=\"0\"><strong>Set-SqlErrorLog<\/strong><\/td>\n<td width=\"0\">Sets or resets the maximum number of error log files before they are recycled.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h2>Invoke-SqlCmd improvements<\/h2>\n<p><em>Invoke-SqlCmd<\/em> now supports an <em>OutputAs<\/em> parameter (or its alias <em>-As<\/em>). This parameter allows you to specify <em>DataRows<\/em>, <em>DataTables<\/em> or <em>DataSet<\/em> as the object type to return. These types map to the .Net types you find in System.Data. <em>DataRows<\/em> is the default, and corresponds to the old behavior.<\/p>\n<p>Additionally, we added the <em>ConnectionString<\/em> parameter which allows the script author complete control over the connection context. This unlocks new capabilities such as connecting to SQL Azure using Azure Active Directory authentication.<\/p>\n<h2>SQL PowerShell provider enhancements<\/h2>\n<p>The SQL PowerShell provider now properly supports the <em>WhatIf<\/em> and <em>Confirm<\/em> parameters. This allows you to see the potential impact of a script operation and have the ability to confirm an operation before it is executed.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>This post was authored by Ayo Olubeko, Program Manager, Data Developer Group. The July update for SSMS includes the first substantial improvement in SQL PowerShell in many years. We owe a lot of thanks for this effort to the great collaboration with our community.<\/p>\n","protected":false},"author":1457,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"ep_exclude_from_search":false,"_classifai_error":"","_classifai_text_to_speech_error":"","footnotes":""},"post_tag":[],"product":[],"content-type":[2448],"topic":[],"coauthors":[2487],"class_list":["post-16205","post","type-post","status-publish","format-standard","hentry","content-type-updates"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>SQL PowerShell: July 2016 update - Microsoft SQL Server Blog<\/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.microsoft.com\/en-us\/sql-server\/blog\/2016\/06\/30\/sql-powershell-july-2016-update\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL PowerShell: July 2016 update - Microsoft SQL Server Blog\" \/>\n<meta property=\"og:description\" content=\"This post was authored by Ayo Olubeko, Program Manager, Data Developer Group. The July update for SSMS includes the first substantial improvement in SQL PowerShell in many years. We owe a lot of thanks for this effort to the great collaboration with our community.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/06\/30\/sql-powershell-july-2016-update\/\" \/>\n<meta property=\"og:site_name\" content=\"Microsoft SQL Server Blog\" \/>\n<meta property=\"article:publisher\" content=\"http:\/\/www.facebook.com\/sqlserver\" \/>\n<meta property=\"article:published_time\" content=\"2016-06-30T16:00:58+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-01-23T06:50:31+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/08\/cropped-microsoft_logo_element.png\" \/>\n\t<meta property=\"og:image:width\" content=\"512\" \/>\n\t<meta property=\"og:image:height\" content=\"512\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"SQL Server Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SQLServer\" \/>\n<meta name=\"twitter:site\" content=\"@SQLServer\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"SQL Server Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 min read\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/06\/30\/sql-powershell-july-2016-update\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/06\/30\/sql-powershell-july-2016-update\/\"},\"author\":[{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/sql-server-team\/\",\"@type\":\"Person\",\"@name\":\"SQL Server Team\"}],\"headline\":\"SQL PowerShell: July 2016 update\",\"datePublished\":\"2016-06-30T16:00:58+00:00\",\"dateModified\":\"2024-01-23T06:50:31+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/06\/30\/sql-powershell-july-2016-update\/\"},\"wordCount\":1108,\"commentCount\":12,\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/06\/30\/sql-powershell-july-2016-update\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/06\/30\/sql-powershell-july-2016-update\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/06\/30\/sql-powershell-july-2016-update\/\",\"name\":\"SQL PowerShell: July 2016 update - Microsoft SQL Server Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website\"},\"datePublished\":\"2016-06-30T16:00:58+00:00\",\"dateModified\":\"2024-01-23T06:50:31+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/06\/30\/sql-powershell-july-2016-update\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/06\/30\/sql-powershell-july-2016-update\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/06\/30\/sql-powershell-july-2016-update\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL PowerShell: July 2016 update\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\",\"name\":\"Microsoft SQL Server Blog\",\"description\":\"Official News from Microsoft\u2019s Information Platform\",\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\",\"name\":\"Microsoft SQL Server Blog\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png\",\"width\":259,\"height\":194,\"caption\":\"Microsoft SQL Server Blog\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"http:\/\/www.facebook.com\/sqlserver\",\"https:\/\/x.com\/SQLServer\",\"https:\/\/www.youtube.com\/user\/MSCloudOS\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SQL PowerShell: July 2016 update - Microsoft SQL Server Blog","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.microsoft.com\/en-us\/sql-server\/blog\/2016\/06\/30\/sql-powershell-july-2016-update\/","og_locale":"en_US","og_type":"article","og_title":"SQL PowerShell: July 2016 update - Microsoft SQL Server Blog","og_description":"This post was authored by Ayo Olubeko, Program Manager, Data Developer Group. The July update for SSMS includes the first substantial improvement in SQL PowerShell in many years. We owe a lot of thanks for this effort to the great collaboration with our community.","og_url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/06\/30\/sql-powershell-july-2016-update\/","og_site_name":"Microsoft SQL Server Blog","article_publisher":"http:\/\/www.facebook.com\/sqlserver","article_published_time":"2016-06-30T16:00:58+00:00","article_modified_time":"2024-01-23T06:50:31+00:00","og_image":[{"width":512,"height":512,"url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/08\/cropped-microsoft_logo_element.png","type":"image\/png"}],"author":"SQL Server Team","twitter_card":"summary_large_image","twitter_creator":"@SQLServer","twitter_site":"@SQLServer","twitter_misc":{"Written by":"SQL Server Team","Est. reading time":"4 min read"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/06\/30\/sql-powershell-july-2016-update\/#article","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/06\/30\/sql-powershell-july-2016-update\/"},"author":[{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/sql-server-team\/","@type":"Person","@name":"SQL Server Team"}],"headline":"SQL PowerShell: July 2016 update","datePublished":"2016-06-30T16:00:58+00:00","dateModified":"2024-01-23T06:50:31+00:00","mainEntityOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/06\/30\/sql-powershell-july-2016-update\/"},"wordCount":1108,"commentCount":12,"publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization"},"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/06\/30\/sql-powershell-july-2016-update\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/06\/30\/sql-powershell-july-2016-update\/","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/06\/30\/sql-powershell-july-2016-update\/","name":"SQL PowerShell: July 2016 update - Microsoft SQL Server Blog","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website"},"datePublished":"2016-06-30T16:00:58+00:00","dateModified":"2024-01-23T06:50:31+00:00","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/06\/30\/sql-powershell-july-2016-update\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/06\/30\/sql-powershell-july-2016-update\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/06\/30\/sql-powershell-july-2016-update\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/"},{"@type":"ListItem","position":2,"name":"SQL PowerShell: July 2016 update"}]},{"@type":"WebSite","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/","name":"Microsoft SQL Server Blog","description":"Official News from Microsoft\u2019s Information Platform","publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization","name":"Microsoft SQL Server Blog","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png","contentUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png","width":259,"height":194,"caption":"Microsoft SQL Server Blog"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/"},"sameAs":["http:\/\/www.facebook.com\/sqlserver","https:\/\/x.com\/SQLServer","https:\/\/www.youtube.com\/user\/MSCloudOS"]}]}},"msxcm_display_generated_audio":false,"msxcm_animated_featured_image":null,"_links":{"self":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/16205","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/users\/1457"}],"replies":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/comments?post=16205"}],"version-history":[{"count":0,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/16205\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/media?parent=16205"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/post_tag?post=16205"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/product?post=16205"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/content-type?post=16205"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/topic?post=16205"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/coauthors?post=16205"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}