SqlServer

21.0.17178

This module allows SQL Server developers, administrators and business intelligence professionals to automate database development and server administration, as well as both multidimensional and tabular cube processing.

Minimum PowerShell version

5.0

There is a newer prerelease version of this module available.
See the version list below for details.

Installation Options

Copy and Paste the following command to install this package using PowerShellGet More Info

Install-Module -Name SqlServer -RequiredVersion 21.0.17178

Copy and Paste the following command to install this package using Microsoft.PowerShell.PSResourceGet More Info

Install-PSResource -Name SqlServer -Version 21.0.17178

You can deploy this package directly to Azure Automation. Note that deploying packages with dependencies will deploy all the dependencies to Azure Automation. Learn More

Manually download the .nupkg file to your system's default download location. Note that the file won't be unpacked, and won't include any dependencies. Learn More

Owners

Copyright

Copyright (c) 2017 Microsoft. All rights reserved.

Package Details

Author(s)

  • Microsoft Corporation

Tags

SQL SqlServer SQLPS Databases SqlAgent Jobs SSAS AnalysisServices Tabular Cubes SSIS ExtendedEvents xEvents

Cmdlets

Add-SqlColumnEncryptionKeyValue Complete-SqlColumnMasterKeyRotation Get-SqlColumnEncryptionKey Get-SqlColumnMasterKey Add-SqlAzureAuthenticationContext New-SqlColumnEncryptionKeyEncryptedValue New-SqlColumnEncryptionSettings New-SqlColumnMasterKeySettings New-SqlCspColumnMasterKeySettings New-SqlCngColumnMasterKeySettings Remove-SqlColumnEncryptionKey Remove-SqlColumnEncryptionKeyValue Remove-SqlColumnMasterKey Invoke-SqlColumnMasterKeyRotation Set-SqlColumnEncryption New-SqlAzureKeyVaultColumnMasterKeySettings New-SqlColumnEncryptionKey New-SqlColumnMasterKey New-SqlCertificateStoreColumnMasterKeySettings Backup-SqlDatabase Get-SqlErrorLog Set-SqlErrorLog Add-SqlAvailabilityDatabase Add-SqlAvailabilityGroupListenerStaticIp Disable-SqlAlwaysOn Enable-SqlAlwaysOn Switch-SqlAvailabilityGroup Revoke-SqlAvailabilityGroupCreateAnyDatabase Set-SqlAvailabilityReplicaRoleToSecondary Grant-SqlAvailabilityGroupCreateAnyDatabase Join-SqlAvailabilityGroup New-SqlAvailabilityGroup New-SqlAvailabilityGroupListener New-SqlAvailabilityReplica New-SqlHADREndpoint Remove-SqlAvailabilityGroup Remove-SqlAvailabilityDatabase Remove-SqlAvailabilityReplica Resume-SqlAvailabilityDatabase Set-SqlAvailabilityGroup Set-SqlAvailabilityGroupListener Set-SqlAvailabilityReplica Set-SqlHADREndpoint Suspend-SqlAvailabilityDatabase Test-SqlAvailabilityGroup Test-SqlAvailabilityReplica Test-SqlDatabaseReplicaState Add-SqlFirewallRule Get-SqlDatabase Get-SqlInstance Remove-SqlFirewallRule Set-SqlAuthenticationMode Set-SqlNetworkConfiguration Start-SqlInstance Stop-SqlInstance Invoke-PolicyEvaluation Get-SqlAgent Get-SqlAgentJob Get-SqlAgentJobHistory Get-SqlAgentJobStep Get-SqlAgentJobSchedule Get-SqlAgentSchedule Save-SqlMigrationReport Read-SqlTableData Read-SqlViewData Write-SqlTableData Restore-SqlDatabase Invoke-Sqlcmd Add-SqlLogin Get-SqlLogin Remove-SqlLogin Get-SqlSmartAdmin Set-SqlSmartAdmin Test-SqlSmartAdmin Get-SqlCredential New-SqlBackupEncryptionOption New-SqlCredential Remove-SqlCredential Set-SqlCredential Convert-UrnToPath ConvertTo-EncodedSqlName ConvertFrom-EncodedSqlName Add-RoleMember Backup-ASDatabase Invoke-ASCmd Invoke-ProcessCube Invoke-ProcessDimension Invoke-ProcessASDatabase Invoke-ProcessTable Invoke-ProcessPartition Remove-RoleMember Restore-ASDatabase New-RestoreFolder New-RestoreLocation Merge-Partition

Dependencies

This module has no dependencies.

Release Notes

## 21.0.17178
Bug Fixes:

Updates:
* Updated AnalysisService Cmdlet to use cached login token from Login-AzureAsAccount for Azure Analysis Services.
* Update Backup-ASDatabase and Restore-ASDatabase to support Azure Analysis Services.

## 21.0.17152
Bug Fixes:
* Fixed issue where Invoke-SqlCmd was throwing an error due to
 missing MSVCR120.dll (now included with the module).
* Fixed issue where 'Deploy to Azure Automation' was not working.
* Fixed issue where the SQL Provider was unable to enumerate some containers
 (e.g. Databases) when the module was loaded by passing Import-Module any
 of the -Version/-MinimumVersion/-MaximumVersion parameters.
* Fixed issue in Set-SqlColumnEncryption where the -LogFileDirectory option
 was not dumping DacFx logs.
* Updated Tags and Description in the manifest file.
* Updated link to License.

Updates:
* Added new parameter '-CertificateThumbprint' to Add-SqlAzureAuthenticationContext
 cmdlet.

## 21.0.17099
First version of SQL PowerShell Module on PSGallery.

FileList

  • SqlServer.nuspec
  • Microsoft.AnalysisServices.AppLocal.Core.dll
  • Microsoft.AnalysisServices.AppLocal.dll
  • Microsoft.AnalysisServices.AppLocal.Tabular.dll
  • Microsoft.AnalysisServices.PowerShell.Cmdlets.dll
  • Microsoft.AnalysisServices.PowerShell.Provider.dll
  • Microsoft.Azure.KeyVault.dll
  • Microsoft.Azure.KeyVault.WebKey.dll
  • Microsoft.Data.Tools.Schema.Sql.dll
  • Microsoft.Data.Tools.Utilities.dll
  • Microsoft.IdentityModel.Clients.ActiveDirectory.dll
  • Microsoft.IdentityModel.Clients.ActiveDirectory.Platform.dll
  • Microsoft.Rest.ClientRuntime.Azure.dll
  • Microsoft.Rest.ClientRuntime.dll
  • Microsoft.SqlServer.AzureStorageEnum.dll
  • Microsoft.SqlServer.BatchParser.dll
  • Microsoft.SqlServer.BatchParserClient.dll
  • Microsoft.SqlServer.ConnectionInfo.dll
  • Microsoft.SqlServer.Dac.dll
  • Microsoft.SqlServer.Dac.Extensions.dll
  • Microsoft.SqlServer.Diagnostics.Strace.dll
  • Microsoft.SqlServer.Dmf.Common.dll
  • Microsoft.SqlServer.Dmf.dll
  • Microsoft.SqlServer.Management.AlwaysEncrypted.AzureKeyVaultProvider.dll
  • Microsoft.SqlServer.Management.AlwaysEncrypted.Management.dll
  • Microsoft.SqlServer.Management.AlwaysEncrypted.Types.dll
  • Microsoft.SqlServer.Management.AzureAuthenticationManagement.dll
  • Microsoft.SqlServer.Management.CloudAdapter.Client.dll
  • Microsoft.SqlServer.Management.CloudAdapter.Data.dll
  • Microsoft.SqlServer.Management.Collector.dll
  • Microsoft.SqlServer.Management.CollectorEnum.dll
  • Microsoft.SqlServer.Management.Dac.UniversalAuthProvider.dll
  • Microsoft.SqlServer.Management.HadrDmf.dll
  • Microsoft.SqlServer.Management.InMemoryOLTPMigrationAdvisor.dll
  • Microsoft.SqlServer.Management.IntegrationServicesEnum.dll
  • Microsoft.SqlServer.Management.PSProvider.dll
  • Microsoft.SqlServer.Management.PSSnapins.dll
  • Microsoft.SqlServer.Management.RegisteredServers.dll
  • Microsoft.SqlServer.Management.Sdk.Scripting.dll
  • Microsoft.SqlServer.Management.Sdk.Sfc.dll
  • Microsoft.SqlServer.Management.SDK.SqlStudio.dll
  • Microsoft.SqlServer.Management.SmartAdminPolicies.dll
  • Microsoft.SqlServer.Management.Utility.dll
  • Microsoft.SqlServer.Management.UtilityEnum.dll
  • Microsoft.SqlServer.Management.XEvent.dll
  • Microsoft.SqlServer.Management.XEventDbScoped.dll
  • Microsoft.SqlServer.Management.XEventDbScopedEnum.dll
  • Microsoft.SqlServer.Management.XEventEnum.dll
  • Microsoft.SqlServer.OlapEnum.dll
  • Microsoft.SqlServer.PolicyEnum.dll
  • Microsoft.SqlServer.RegSvrEnum.dll
  • Microsoft.SqlServer.ReplEnum.dll
  • Microsoft.SqlServer.ServiceBrokerEnum.dll
  • Microsoft.SqlServer.Smo.dll
  • Microsoft.SqlServer.SmoExtended.dll
  • Microsoft.SqlServer.SqlClrProvider.dll
  • Microsoft.SqlServer.SqlEnum.dll
  • Microsoft.SqlServer.SqlTDiagm.dll
  • Microsoft.SqlServer.SqlWmiManagement.dll
  • Microsoft.SqlServer.SString.dll
  • Microsoft.SqlServer.TransactSql.ScriptDom.dll
  • Microsoft.SqlServer.Types.dll
  • Microsoft.SqlServer.WmiEnum.dll
  • msvcp120.dll
  • msvcr120.dll
  • Newtonsoft.Json.dll
  • SQLProvider.Format.ps1xml
  • SQLProvider.Types.ps1xml
  • SqlServer.psd1
  • SqlServerPostScript.ps1
  • de\Microsoft.AnalysisServices.AppLocal.Core.resources.dll
  • de\Microsoft.AnalysisServices.AppLocal.resources.dll
  • de\Microsoft.AnalysisServices.AppLocal.Tabular.resources.dll
  • de\microsoft.analysisservices.powershell.cmdlets.dll-help.xml
  • de\Microsoft.AnalysisServices.PowerShell.Cmdlets.resources.dll
  • de\Microsoft.AnalysisServices.PowerShell.Provider.resources.dll
  • de\Microsoft.Data.Tools.Schema.Sql.resources.dll
  • de\Microsoft.Data.Tools.Utilities.resources.dll
  • de\Microsoft.SqlServer.ConnectionInfo.resources.dll
  • de\Microsoft.SqlServer.Dac.Extensions.resources.dll
  • de\Microsoft.SqlServer.Dac.resources.dll
  • de\Microsoft.SqlServer.Dmf.Common.resources.dll
  • de\Microsoft.SqlServer.Dmf.resources.dll
  • de\Microsoft.SqlServer.Management.AlwaysEncrypted.AzureKeyVaultProvider.resources.dll
  • de\Microsoft.SqlServer.Management.AlwaysEncrypted.Management.resources.dll
  • de\Microsoft.SqlServer.Management.AlwaysEncrypted.Types.resources.dll
  • de\Microsoft.SqlServer.Management.Collector.resources.dll
  • de\Microsoft.SqlServer.Management.CollectorEnum.resources.dll
  • de\Microsoft.SqlServer.Management.InMemoryOLTPMigrationAdvisor.resources.dll
  • de\Microsoft.SqlServer.Management.PSProvider.dll-Help.xml
  • de\Microsoft.SqlServer.Management.PSProvider.resources.dll
  • de\Microsoft.SqlServer.Management.PSSnapins.dll-Help.xml
  • de\Microsoft.SqlServer.Management.PSSnapins.resources.dll
  • de\Microsoft.SqlServer.Management.RegisteredServers.resources.dll
  • de\Microsoft.SqlServer.Management.Sdk.Scripting.resources.dll
  • de\Microsoft.SqlServer.Management.Sdk.Sfc.resources.dll
  • de\Microsoft.SqlServer.Management.SDK.SqlStudio.resources.dll
  • de\Microsoft.SqlServer.Management.SmartAdminPolicies.resources.dll
  • de\Microsoft.SqlServer.Management.Utility.resources.dll
  • de\Microsoft.SqlServer.Management.XEvent.resources.dll
  • de\Microsoft.SqlServer.Management.XEventDbScoped.resources.dll
  • de\Microsoft.SqlServer.Management.XEventDbScopedEnum.resources.dll
  • de\Microsoft.SqlServer.OlapEnum.resources.dll
  • de\Microsoft.SqlServer.RegSvrEnum.resources.dll
  • de\Microsoft.SqlServer.ServiceBrokerEnum.resources.dll
  • de\Microsoft.SqlServer.Smo.resources.dll
  • de\Microsoft.SqlServer.SmoExtended.resources.dll
  • de\Microsoft.SqlServer.SqlEnum.resources.dll
  • de\Microsoft.SqlServer.SqlWmiManagement.resources.dll
  • de\Microsoft.SqlServer.Types.resources.dll
  • de\Microsoft.SqlServer.WmiEnum.resources.dll
  • en\Microsoft.AnalysisServices.PowerShell.Cmdlets.dll-Help.xml
  • en\Microsoft.SqlServer.Management.PSProvider.dll-Help.xml
  • en\Microsoft.SqlServer.Management.PSSnapins.dll-Help.xml
  • es\Microsoft.AnalysisServices.AppLocal.Core.resources.dll
  • es\Microsoft.AnalysisServices.AppLocal.resources.dll
  • es\Microsoft.AnalysisServices.AppLocal.Tabular.resources.dll
  • es\microsoft.analysisservices.powershell.cmdlets.dll-help.xml
  • es\Microsoft.AnalysisServices.PowerShell.Cmdlets.resources.dll
  • es\Microsoft.AnalysisServices.PowerShell.Provider.resources.dll
  • es\Microsoft.Data.Tools.Schema.Sql.resources.dll
  • es\Microsoft.Data.Tools.Utilities.resources.dll
  • es\Microsoft.SqlServer.ConnectionInfo.resources.dll
  • es\Microsoft.SqlServer.Dac.Extensions.resources.dll
  • es\Microsoft.SqlServer.Dac.resources.dll
  • es\Microsoft.SqlServer.Dmf.Common.resources.dll
  • es\Microsoft.SqlServer.Dmf.resources.dll
  • es\Microsoft.SqlServer.Management.AlwaysEncrypted.AzureKeyVaultProvider.resources.dll
  • es\Microsoft.SqlServer.Management.AlwaysEncrypted.Management.resources.dll
  • es\Microsoft.SqlServer.Management.AlwaysEncrypted.Types.resources.dll
  • es\Microsoft.SqlServer.Management.Collector.resources.dll
  • es\Microsoft.SqlServer.Management.CollectorEnum.resources.dll
  • es\Microsoft.SqlServer.Management.InMemoryOLTPMigrationAdvisor.resources.dll
  • es\Microsoft.SqlServer.Management.PSProvider.dll-Help.xml
  • es\Microsoft.SqlServer.Management.PSProvider.resources.dll
  • es\Microsoft.SqlServer.Management.PSSnapins.dll-Help.xml
  • es\Microsoft.SqlServer.Management.PSSnapins.resources.dll
  • es\Microsoft.SqlServer.Management.RegisteredServers.resources.dll
  • es\Microsoft.SqlServer.Management.Sdk.Scripting.resources.dll
  • es\Microsoft.SqlServer.Management.Sdk.Sfc.resources.dll
  • es\Microsoft.SqlServer.Management.SDK.SqlStudio.resources.dll
  • es\Microsoft.SqlServer.Management.SmartAdminPolicies.resources.dll
  • es\Microsoft.SqlServer.Management.Utility.resources.dll
  • es\Microsoft.SqlServer.Management.XEvent.resources.dll
  • es\Microsoft.SqlServer.Management.XEventDbScoped.resources.dll
  • es\Microsoft.SqlServer.Management.XEventDbScopedEnum.resources.dll
  • es\Microsoft.SqlServer.OlapEnum.resources.dll
  • es\Microsoft.SqlServer.RegSvrEnum.resources.dll
  • es\Microsoft.SqlServer.ServiceBrokerEnum.resources.dll
  • es\Microsoft.SqlServer.Smo.resources.dll
  • es\Microsoft.SqlServer.SmoExtended.resources.dll
  • es\Microsoft.SqlServer.SqlEnum.resources.dll
  • es\Microsoft.SqlServer.SqlWmiManagement.resources.dll
  • es\Microsoft.SqlServer.Types.resources.dll
  • es\Microsoft.SqlServer.WmiEnum.resources.dll
  • fr\Microsoft.AnalysisServices.AppLocal.Core.resources.dll
  • fr\Microsoft.AnalysisServices.AppLocal.resources.dll
  • fr\Microsoft.AnalysisServices.AppLocal.Tabular.resources.dll
  • fr\microsoft.analysisservices.powershell.cmdlets.dll-help.xml
  • fr\Microsoft.AnalysisServices.PowerShell.Cmdlets.resources.dll
  • fr\Microsoft.AnalysisServices.PowerShell.Provider.resources.dll
  • fr\Microsoft.Data.Tools.Schema.Sql.resources.dll
  • fr\Microsoft.Data.Tools.Utilities.resources.dll
  • fr\Microsoft.SqlServer.ConnectionInfo.resources.dll
  • fr\Microsoft.SqlServer.Dac.Extensions.resources.dll
  • fr\Microsoft.SqlServer.Dac.resources.dll
  • fr\Microsoft.SqlServer.Dmf.Common.resources.dll
  • fr\Microsoft.SqlServer.Dmf.resources.dll
  • fr\Microsoft.SqlServer.Management.AlwaysEncrypted.AzureKeyVaultProvider.resources.dll
  • fr\Microsoft.SqlServer.Management.AlwaysEncrypted.Management.resources.dll
  • fr\Microsoft.SqlServer.Management.AlwaysEncrypted.Types.resources.dll
  • fr\Microsoft.SqlServer.Management.Collector.resources.dll
  • fr\Microsoft.SqlServer.Management.CollectorEnum.resources.dll
  • fr\Microsoft.SqlServer.Management.InMemoryOLTPMigrationAdvisor.resources.dll
  • fr\Microsoft.SqlServer.Management.PSProvider.dll-Help.xml
  • fr\Microsoft.SqlServer.Management.PSProvider.resources.dll
  • fr\Microsoft.SqlServer.Management.PSSnapins.dll-Help.xml
  • fr\Microsoft.SqlServer.Management.PSSnapins.resources.dll
  • fr\Microsoft.SqlServer.Management.RegisteredServers.resources.dll
  • fr\Microsoft.SqlServer.Management.Sdk.Scripting.resources.dll
  • fr\Microsoft.SqlServer.Management.Sdk.Sfc.resources.dll
  • fr\Microsoft.SqlServer.Management.SDK.SqlStudio.resources.dll
  • fr\Microsoft.SqlServer.Management.SmartAdminPolicies.resources.dll
  • fr\Microsoft.SqlServer.Management.Utility.resources.dll
  • fr\Microsoft.SqlServer.Management.XEvent.resources.dll
  • fr\Microsoft.SqlServer.Management.XEventDbScoped.resources.dll
  • fr\Microsoft.SqlServer.Management.XEventDbScopedEnum.resources.dll
  • fr\Microsoft.SqlServer.OlapEnum.resources.dll
  • fr\Microsoft.SqlServer.RegSvrEnum.resources.dll
  • fr\Microsoft.SqlServer.ServiceBrokerEnum.resources.dll
  • fr\Microsoft.SqlServer.Smo.resources.dll
  • fr\Microsoft.SqlServer.SmoExtended.resources.dll
  • fr\Microsoft.SqlServer.SqlEnum.resources.dll
  • fr\Microsoft.SqlServer.SqlWmiManagement.resources.dll
  • fr\Microsoft.SqlServer.Types.resources.dll
  • fr\Microsoft.SqlServer.WmiEnum.resources.dll
  • it\Microsoft.AnalysisServices.AppLocal.Core.resources.dll
  • it\Microsoft.AnalysisServices.AppLocal.resources.dll
  • it\Microsoft.AnalysisServices.AppLocal.Tabular.resources.dll
  • it\microsoft.analysisservices.powershell.cmdlets.dll-help.xml
  • it\Microsoft.AnalysisServices.PowerShell.Cmdlets.resources.dll
  • it\Microsoft.AnalysisServices.PowerShell.Provider.resources.dll
  • it\Microsoft.Data.Tools.Schema.Sql.resources.dll
  • it\Microsoft.Data.Tools.Utilities.resources.dll
  • it\Microsoft.SqlServer.ConnectionInfo.resources.dll
  • it\Microsoft.SqlServer.Dac.Extensions.resources.dll
  • it\Microsoft.SqlServer.Dac.resources.dll
  • it\Microsoft.SqlServer.Dmf.Common.resources.dll
  • it\Microsoft.SqlServer.Dmf.resources.dll
  • it\Microsoft.SqlServer.Management.AlwaysEncrypted.AzureKeyVaultProvider.resources.dll
  • it\Microsoft.SqlServer.Management.AlwaysEncrypted.Management.resources.dll
  • it\Microsoft.SqlServer.Management.AlwaysEncrypted.Types.resources.dll
  • it\Microsoft.SqlServer.Management.Collector.resources.dll
  • it\Microsoft.SqlServer.Management.CollectorEnum.resources.dll
  • it\Microsoft.SqlServer.Management.InMemoryOLTPMigrationAdvisor.resources.dll
  • it\Microsoft.SqlServer.Management.PSProvider.dll-Help.xml
  • it\Microsoft.SqlServer.Management.PSProvider.resources.dll
  • it\Microsoft.SqlServer.Management.PSSnapins.dll-Help.xml
  • it\Microsoft.SqlServer.Management.PSSnapins.resources.dll
  • it\Microsoft.SqlServer.Management.RegisteredServers.resources.dll
  • it\Microsoft.SqlServer.Management.Sdk.Scripting.resources.dll
  • it\Microsoft.SqlServer.Management.Sdk.Sfc.resources.dll
  • it\Microsoft.SqlServer.Management.SDK.SqlStudio.resources.dll
  • it\Microsoft.SqlServer.Management.SmartAdminPolicies.resources.dll
  • it\Microsoft.SqlServer.Management.Utility.resources.dll
  • it\Microsoft.SqlServer.Management.XEvent.resources.dll
  • it\Microsoft.SqlServer.Management.XEventDbScoped.resources.dll
  • it\Microsoft.SqlServer.Management.XEventDbScopedEnum.resources.dll
  • it\Microsoft.SqlServer.OlapEnum.resources.dll
  • it\Microsoft.SqlServer.RegSvrEnum.resources.dll
  • it\Microsoft.SqlServer.ServiceBrokerEnum.resources.dll
  • it\Microsoft.SqlServer.Smo.resources.dll
  • it\Microsoft.SqlServer.SmoExtended.resources.dll
  • it\Microsoft.SqlServer.SqlEnum.resources.dll
  • it\Microsoft.SqlServer.SqlWmiManagement.resources.dll
  • it\Microsoft.SqlServer.Types.resources.dll
  • it\Microsoft.SqlServer.WmiEnum.resources.dll
  • ja\Microsoft.AnalysisServices.AppLocal.Core.resources.dll
  • ja\Microsoft.AnalysisServices.AppLocal.resources.dll
  • ja\Microsoft.AnalysisServices.AppLocal.Tabular.resources.dll
  • ja\microsoft.analysisservices.powershell.cmdlets.dll-help.xml
  • ja\Microsoft.AnalysisServices.PowerShell.Cmdlets.resources.dll
  • ja\Microsoft.AnalysisServices.PowerShell.Provider.resources.dll
  • ja\Microsoft.Data.Tools.Schema.Sql.resources.dll
  • ja\Microsoft.Data.Tools.Utilities.resources.dll
  • ja\Microsoft.SqlServer.ConnectionInfo.resources.dll
  • ja\Microsoft.SqlServer.Dac.Extensions.resources.dll
  • ja\Microsoft.SqlServer.Dac.resources.dll
  • ja\Microsoft.SqlServer.Dmf.Common.resources.dll
  • ja\Microsoft.SqlServer.Dmf.resources.dll
  • ja\Microsoft.SqlServer.Management.AlwaysEncrypted.AzureKeyVaultProvider.resources.dll
  • ja\Microsoft.SqlServer.Management.AlwaysEncrypted.Management.resources.dll
  • ja\Microsoft.SqlServer.Management.AlwaysEncrypted.Types.resources.dll
  • ja\Microsoft.SqlServer.Management.Collector.resources.dll
  • ja\Microsoft.SqlServer.Management.CollectorEnum.resources.dll
  • ja\Microsoft.SqlServer.Management.InMemoryOLTPMigrationAdvisor.resources.dll
  • ja\Microsoft.SqlServer.Management.PSProvider.dll-Help.xml
  • ja\Microsoft.SqlServer.Management.PSProvider.resources.dll
  • ja\Microsoft.SqlServer.Management.PSSnapins.dll-Help.xml
  • ja\Microsoft.SqlServer.Management.PSSnapins.resources.dll
  • ja\Microsoft.SqlServer.Management.RegisteredServers.resources.dll
  • ja\Microsoft.SqlServer.Management.Sdk.Scripting.resources.dll
  • ja\Microsoft.SqlServer.Management.Sdk.Sfc.resources.dll
  • ja\Microsoft.SqlServer.Management.SDK.SqlStudio.resources.dll
  • ja\Microsoft.SqlServer.Management.SmartAdminPolicies.resources.dll
  • ja\Microsoft.SqlServer.Management.Utility.resources.dll
  • ja\Microsoft.SqlServer.Management.XEvent.resources.dll
  • ja\Microsoft.SqlServer.Management.XEventDbScoped.resources.dll
  • ja\Microsoft.SqlServer.Management.XEventDbScopedEnum.resources.dll
  • ja\Microsoft.SqlServer.OlapEnum.resources.dll
  • ja\Microsoft.SqlServer.RegSvrEnum.resources.dll
  • ja\Microsoft.SqlServer.ServiceBrokerEnum.resources.dll
  • ja\Microsoft.SqlServer.Smo.resources.dll
  • ja\Microsoft.SqlServer.SmoExtended.resources.dll
  • ja\Microsoft.SqlServer.SqlEnum.resources.dll
  • ja\Microsoft.SqlServer.SqlWmiManagement.resources.dll
  • ja\Microsoft.SqlServer.Types.resources.dll
  • ja\Microsoft.SqlServer.WmiEnum.resources.dll
  • ko\Microsoft.AnalysisServices.AppLocal.Core.resources.dll
  • ko\Microsoft.AnalysisServices.AppLocal.resources.dll
  • ko\Microsoft.AnalysisServices.AppLocal.Tabular.resources.dll
  • ko\microsoft.analysisservices.powershell.cmdlets.dll-help.xml
  • ko\Microsoft.AnalysisServices.PowerShell.Cmdlets.resources.dll
  • ko\Microsoft.AnalysisServices.PowerShell.Provider.resources.dll
  • ko\Microsoft.Data.Tools.Schema.Sql.resources.dll
  • ko\Microsoft.Data.Tools.Utilities.resources.dll
  • ko\Microsoft.SqlServer.ConnectionInfo.resources.dll
  • ko\Microsoft.SqlServer.Dac.Extensions.resources.dll
  • ko\Microsoft.SqlServer.Dac.resources.dll
  • ko\Microsoft.SqlServer.Dmf.Common.resources.dll
  • ko\Microsoft.SqlServer.Dmf.resources.dll
  • ko\Microsoft.SqlServer.Management.AlwaysEncrypted.AzureKeyVaultProvider.resources.dll
  • ko\Microsoft.SqlServer.Management.AlwaysEncrypted.Management.resources.dll
  • ko\Microsoft.SqlServer.Management.AlwaysEncrypted.Types.resources.dll
  • ko\Microsoft.SqlServer.Management.Collector.resources.dll
  • ko\Microsoft.SqlServer.Management.CollectorEnum.resources.dll
  • ko\Microsoft.SqlServer.Management.InMemoryOLTPMigrationAdvisor.resources.dll
  • ko\Microsoft.SqlServer.Management.PSProvider.dll-Help.xml
  • ko\Microsoft.SqlServer.Management.PSProvider.resources.dll
  • ko\Microsoft.SqlServer.Management.PSSnapins.dll-Help.xml
  • ko\Microsoft.SqlServer.Management.PSSnapins.resources.dll
  • ko\Microsoft.SqlServer.Management.RegisteredServers.resources.dll
  • ko\Microsoft.SqlServer.Management.Sdk.Scripting.resources.dll
  • ko\Microsoft.SqlServer.Management.Sdk.Sfc.resources.dll
  • ko\Microsoft.SqlServer.Management.SDK.SqlStudio.resources.dll
  • ko\Microsoft.SqlServer.Management.SmartAdminPolicies.resources.dll
  • ko\Microsoft.SqlServer.Management.Utility.resources.dll
  • ko\Microsoft.SqlServer.Management.XEvent.resources.dll
  • ko\Microsoft.SqlServer.Management.XEventDbScoped.resources.dll
  • ko\Microsoft.SqlServer.Management.XEventDbScopedEnum.resources.dll
  • ko\Microsoft.SqlServer.OlapEnum.resources.dll
  • ko\Microsoft.SqlServer.RegSvrEnum.resources.dll
  • ko\Microsoft.SqlServer.ServiceBrokerEnum.resources.dll
  • ko\Microsoft.SqlServer.Smo.resources.dll
  • ko\Microsoft.SqlServer.SmoExtended.resources.dll
  • ko\Microsoft.SqlServer.SqlEnum.resources.dll
  • ko\Microsoft.SqlServer.SqlWmiManagement.resources.dll
  • ko\Microsoft.SqlServer.Types.resources.dll
  • ko\Microsoft.SqlServer.WmiEnum.resources.dll
  • pt\Microsoft.AnalysisServices.AppLocal.Core.resources.dll
  • pt\Microsoft.AnalysisServices.AppLocal.resources.dll
  • pt\Microsoft.AnalysisServices.AppLocal.Tabular.resources.dll
  • pt\microsoft.analysisservices.powershell.cmdlets.dll-help.xml
  • pt\Microsoft.AnalysisServices.PowerShell.Cmdlets.resources.dll
  • pt\Microsoft.AnalysisServices.PowerShell.Provider.resources.dll
  • pt\Microsoft.Data.Tools.Schema.Sql.resources.dll
  • pt\Microsoft.Data.Tools.Utilities.resources.dll
  • pt\Microsoft.SqlServer.ConnectionInfo.resources.dll
  • pt\Microsoft.SqlServer.Dac.Extensions.resources.dll
  • pt\Microsoft.SqlServer.Dac.resources.dll
  • pt\Microsoft.SqlServer.Dmf.Common.resources.dll
  • pt\Microsoft.SqlServer.Dmf.resources.dll
  • pt\Microsoft.SqlServer.Management.AlwaysEncrypted.AzureKeyVaultProvider.resources.dll
  • pt\Microsoft.SqlServer.Management.AlwaysEncrypted.Management.resources.dll
  • pt\Microsoft.SqlServer.Management.AlwaysEncrypted.Types.resources.dll
  • pt\Microsoft.SqlServer.Management.Collector.resources.dll
  • pt\Microsoft.SqlServer.Management.CollectorEnum.resources.dll
  • pt\Microsoft.SqlServer.Management.InMemoryOLTPMigrationAdvisor.resources.dll
  • pt\Microsoft.SqlServer.Management.PSProvider.dll-Help.xml
  • pt\Microsoft.SqlServer.Management.PSProvider.resources.dll
  • pt\Microsoft.SqlServer.Management.PSSnapins.dll-Help.xml
  • pt\Microsoft.SqlServer.Management.PSSnapins.resources.dll
  • pt\Microsoft.SqlServer.Management.RegisteredServers.resources.dll
  • pt\Microsoft.SqlServer.Management.Sdk.Scripting.resources.dll
  • pt\Microsoft.SqlServer.Management.Sdk.Sfc.resources.dll
  • pt\Microsoft.SqlServer.Management.SDK.SqlStudio.resources.dll
  • pt\Microsoft.SqlServer.Management.SmartAdminPolicies.resources.dll
  • pt\Microsoft.SqlServer.Management.Utility.resources.dll
  • pt\Microsoft.SqlServer.Management.XEvent.resources.dll
  • pt\Microsoft.SqlServer.Management.XEventDbScoped.resources.dll
  • pt\Microsoft.SqlServer.Management.XEventDbScopedEnum.resources.dll
  • pt\Microsoft.SqlServer.OlapEnum.resources.dll
  • pt\Microsoft.SqlServer.RegSvrEnum.resources.dll
  • pt\Microsoft.SqlServer.ServiceBrokerEnum.resources.dll
  • pt\Microsoft.SqlServer.Smo.resources.dll
  • pt\Microsoft.SqlServer.SmoExtended.resources.dll
  • pt\Microsoft.SqlServer.SqlEnum.resources.dll
  • pt\Microsoft.SqlServer.SqlWmiManagement.resources.dll
  • pt\Microsoft.SqlServer.Types.resources.dll
  • pt\Microsoft.SqlServer.WmiEnum.resources.dll
  • ru\Microsoft.AnalysisServices.AppLocal.Core.resources.dll
  • ru\Microsoft.AnalysisServices.AppLocal.resources.dll
  • ru\Microsoft.AnalysisServices.AppLocal.Tabular.resources.dll
  • ru\microsoft.analysisservices.powershell.cmdlets.dll-help.xml
  • ru\Microsoft.AnalysisServices.PowerShell.Cmdlets.resources.dll
  • ru\Microsoft.AnalysisServices.PowerShell.Provider.resources.dll
  • ru\Microsoft.Data.Tools.Schema.Sql.resources.dll
  • ru\Microsoft.Data.Tools.Utilities.resources.dll
  • ru\Microsoft.SqlServer.ConnectionInfo.resources.dll
  • ru\Microsoft.SqlServer.Dac.Extensions.resources.dll
  • ru\Microsoft.SqlServer.Dac.resources.dll
  • ru\Microsoft.SqlServer.Dmf.Common.resources.dll
  • ru\Microsoft.SqlServer.Dmf.resources.dll
  • ru\Microsoft.SqlServer.Management.AlwaysEncrypted.AzureKeyVaultProvider.resources.dll
  • ru\Microsoft.SqlServer.Management.AlwaysEncrypted.Management.resources.dll
  • ru\Microsoft.SqlServer.Management.AlwaysEncrypted.Types.resources.dll
  • ru\Microsoft.SqlServer.Management.Collector.resources.dll
  • ru\Microsoft.SqlServer.Management.CollectorEnum.resources.dll
  • ru\Microsoft.SqlServer.Management.InMemoryOLTPMigrationAdvisor.resources.dll
  • ru\Microsoft.SqlServer.Management.PSProvider.dll-Help.xml
  • ru\Microsoft.SqlServer.Management.PSProvider.resources.dll
  • ru\Microsoft.SqlServer.Management.PSSnapins.dll-Help.xml
  • ru\Microsoft.SqlServer.Management.PSSnapins.resources.dll
  • ru\Microsoft.SqlServer.Management.RegisteredServers.resources.dll
  • ru\Microsoft.SqlServer.Management.Sdk.Scripting.resources.dll
  • ru\Microsoft.SqlServer.Management.Sdk.Sfc.resources.dll
  • ru\Microsoft.SqlServer.Management.SDK.SqlStudio.resources.dll
  • ru\Microsoft.SqlServer.Management.SmartAdminPolicies.resources.dll
  • ru\Microsoft.SqlServer.Management.Utility.resources.dll
  • ru\Microsoft.SqlServer.Management.XEvent.resources.dll
  • ru\Microsoft.SqlServer.Management.XEventDbScoped.resources.dll
  • ru\Microsoft.SqlServer.Management.XEventDbScopedEnum.resources.dll
  • ru\Microsoft.SqlServer.OlapEnum.resources.dll
  • ru\Microsoft.SqlServer.RegSvrEnum.resources.dll
  • ru\Microsoft.SqlServer.ServiceBrokerEnum.resources.dll
  • ru\Microsoft.SqlServer.Smo.resources.dll
  • ru\Microsoft.SqlServer.SmoExtended.resources.dll
  • ru\Microsoft.SqlServer.SqlEnum.resources.dll
  • ru\Microsoft.SqlServer.SqlWmiManagement.resources.dll
  • ru\Microsoft.SqlServer.Types.resources.dll
  • ru\Microsoft.SqlServer.WmiEnum.resources.dll
  • zh-hans\Microsoft.AnalysisServices.AppLocal.Core.resources.dll
  • zh-hans\Microsoft.AnalysisServices.AppLocal.resources.dll
  • zh-hans\Microsoft.AnalysisServices.AppLocal.Tabular.resources.dll
  • zh-hans\microsoft.analysisservices.powershell.cmdlets.dll-help.xml
  • zh-hans\Microsoft.AnalysisServices.PowerShell.Cmdlets.resources.dll
  • zh-hans\Microsoft.AnalysisServices.PowerShell.Provider.resources.dll
  • zh-hans\Microsoft.Data.Tools.Schema.Sql.resources.dll
  • zh-hans\Microsoft.Data.Tools.Utilities.resources.dll
  • zh-hans\Microsoft.SqlServer.ConnectionInfo.resources.dll
  • zh-hans\Microsoft.SqlServer.Dac.Extensions.resources.dll
  • zh-hans\Microsoft.SqlServer.Dac.resources.dll
  • zh-hans\Microsoft.SqlServer.Dmf.Common.resources.dll
  • zh-hans\Microsoft.SqlServer.Dmf.resources.dll
  • zh-hans\Microsoft.SqlServer.Management.AlwaysEncrypted.AzureKeyVaultProvider.resources.dll
  • zh-hans\Microsoft.SqlServer.Management.AlwaysEncrypted.Management.resources.dll
  • zh-hans\Microsoft.SqlServer.Management.AlwaysEncrypted.Types.resources.dll
  • zh-hans\Microsoft.SqlServer.Management.Collector.resources.dll
  • zh-hans\Microsoft.SqlServer.Management.CollectorEnum.resources.dll
  • zh-hans\Microsoft.SqlServer.Management.InMemoryOLTPMigrationAdvisor.resources.dll
  • zh-hans\Microsoft.SqlServer.Management.PSProvider.dll-Help.xml
  • zh-hans\Microsoft.SqlServer.Management.PSProvider.resources.dll
  • zh-hans\Microsoft.SqlServer.Management.PSSnapins.dll-Help.xml
  • zh-hans\Microsoft.SqlServer.Management.PSSnapins.resources.dll
  • zh-hans\Microsoft.SqlServer.Management.RegisteredServers.resources.dll
  • zh-hans\Microsoft.SqlServer.Management.Sdk.Scripting.resources.dll
  • zh-hans\Microsoft.SqlServer.Management.Sdk.Sfc.resources.dll
  • zh-hans\Microsoft.SqlServer.Management.SDK.SqlStudio.resources.dll
  • zh-hans\Microsoft.SqlServer.Management.SmartAdminPolicies.resources.dll
  • zh-hans\Microsoft.SqlServer.Management.Utility.resources.dll
  • zh-hans\Microsoft.SqlServer.Management.XEvent.resources.dll
  • zh-hans\Microsoft.SqlServer.Management.XEventDbScoped.resources.dll
  • zh-hans\Microsoft.SqlServer.Management.XEventDbScopedEnum.resources.dll
  • zh-hans\Microsoft.SqlServer.OlapEnum.resources.dll
  • zh-hans\Microsoft.SqlServer.RegSvrEnum.resources.dll
  • zh-hans\Microsoft.SqlServer.ServiceBrokerEnum.resources.dll
  • zh-hans\Microsoft.SqlServer.Smo.resources.dll
  • zh-hans\Microsoft.SqlServer.SmoExtended.resources.dll
  • zh-hans\Microsoft.SqlServer.SqlEnum.resources.dll
  • zh-hans\Microsoft.SqlServer.SqlWmiManagement.resources.dll
  • zh-hans\Microsoft.SqlServer.Types.resources.dll
  • zh-hans\Microsoft.SqlServer.WmiEnum.resources.dll
  • zh-hant\Microsoft.AnalysisServices.AppLocal.Core.resources.dll
  • zh-hant\Microsoft.AnalysisServices.AppLocal.resources.dll
  • zh-hant\Microsoft.AnalysisServices.AppLocal.Tabular.resources.dll
  • zh-hant\microsoft.analysisservices.powershell.cmdlets.dll-help.xml
  • zh-hant\Microsoft.AnalysisServices.PowerShell.Cmdlets.resources.dll
  • zh-hant\Microsoft.AnalysisServices.PowerShell.Provider.resources.dll
  • zh-hant\Microsoft.Data.Tools.Schema.Sql.resources.dll
  • zh-hant\Microsoft.Data.Tools.Utilities.resources.dll
  • zh-hant\Microsoft.SqlServer.ConnectionInfo.resources.dll
  • zh-hant\Microsoft.SqlServer.Dac.Extensions.resources.dll
  • zh-hant\Microsoft.SqlServer.Dac.resources.dll
  • zh-hant\Microsoft.SqlServer.Dmf.Common.resources.dll
  • zh-hant\Microsoft.SqlServer.Dmf.resources.dll
  • zh-hant\Microsoft.SqlServer.Management.AlwaysEncrypted.AzureKeyVaultProvider.resources.dll
  • zh-hant\Microsoft.SqlServer.Management.AlwaysEncrypted.Management.resources.dll
  • zh-hant\Microsoft.SqlServer.Management.AlwaysEncrypted.Types.resources.dll
  • zh-hant\Microsoft.SqlServer.Management.Collector.resources.dll
  • zh-hant\Microsoft.SqlServer.Management.CollectorEnum.resources.dll
  • zh-hant\Microsoft.SqlServer.Management.InMemoryOLTPMigrationAdvisor.resources.dll
  • zh-hant\Microsoft.SqlServer.Management.PSProvider.dll-Help.xml
  • zh-hant\Microsoft.SqlServer.Management.PSProvider.resources.dll
  • zh-hant\Microsoft.SqlServer.Management.PSSnapins.dll-Help.xml
  • zh-hant\Microsoft.SqlServer.Management.PSSnapins.resources.dll
  • zh-hant\Microsoft.SqlServer.Management.RegisteredServers.resources.dll
  • zh-hant\Microsoft.SqlServer.Management.Sdk.Scripting.resources.dll
  • zh-hant\Microsoft.SqlServer.Management.Sdk.Sfc.resources.dll
  • zh-hant\Microsoft.SqlServer.Management.SDK.SqlStudio.resources.dll
  • zh-hant\Microsoft.SqlServer.Management.SmartAdminPolicies.resources.dll
  • zh-hant\Microsoft.SqlServer.Management.Utility.resources.dll
  • zh-hant\Microsoft.SqlServer.Management.XEvent.resources.dll
  • zh-hant\Microsoft.SqlServer.Management.XEventDbScoped.resources.dll
  • zh-hant\Microsoft.SqlServer.Management.XEventDbScopedEnum.resources.dll
  • zh-hant\Microsoft.SqlServer.OlapEnum.resources.dll
  • zh-hant\Microsoft.SqlServer.RegSvrEnum.resources.dll
  • zh-hant\Microsoft.SqlServer.ServiceBrokerEnum.resources.dll
  • zh-hant\Microsoft.SqlServer.Smo.resources.dll
  • zh-hant\Microsoft.SqlServer.SmoExtended.resources.dll
  • zh-hant\Microsoft.SqlServer.SqlEnum.resources.dll
  • zh-hant\Microsoft.SqlServer.SqlWmiManagement.resources.dll
  • zh-hant\Microsoft.SqlServer.Types.resources.dll
  • zh-hant\Microsoft.SqlServer.WmiEnum.resources.dll

Version History

Version Downloads Last updated
22.2.0 6,468,413 1/16/2024
22.1.1 9,659,110 5/25/2023
22.0.59 2,699,567 4/4/2023
22.0.49-preview 44,051 1/16/2023
22.0.30-preview 43,953 9/20/2022
22.0.20-preview 36,676 5/2/2022
21.1.18257-p... 54,197 7/14/2021
21.1.18256 23,876,675 7/14/2021
21.1.18246-p... 14,947 3/28/2021
21.1.18245 2,599,060 3/28/2021
21.1.18239-p... 2,406 2/16/2021
21.1.18235 3,780,086 1/14/2021
21.1.18230 2,229,833 11/30/2020
21.1.18229 2,132,388 10/19/2020
21.1.18228 142,619 9/30/2020
21.1.18226 5,861,826 7/7/2020
21.1.18221 1,636,558 3/23/2020
21.1.18218 911,821 12/13/2019
21.1.18209 887,996 11/18/2019
21.1.18206 102,628 10/30/2019
21.1.18179 210,048 9/21/2019
21.1.18147 309,405 7/30/2019
21.1.18135 222,998 7/5/2019
21.1.18121 230,035 5/15/2019
21.1.18102 167,200 3/31/2019
21.1.18095-p... 1,651 3/5/2019
21.1.18080 279,621 1/31/2019
21.1.18078-p... 526 1/20/2019
21.1.18068 279,174 11/16/2018
21.1.18040-p... 934 10/5/2018
21.0.17279 417,935 6/28/2018
21.0.17262 89,006 5/11/2018
21.0.17240 44,813 4/9/2018
21.0.17224 57,754 2/14/2018
21.0.17199 542,217 10/10/2017
21.0.17178 (current version) 103,441 8/24/2017
21.0.17152 141,482 7/6/2017
21.0.17099 27,707 4/25/2017
Show less