SqlServer

21.1.18228

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.

For Release Notes, expand the Package Details section on this page.

For automation with SSRS & Power BI Report Server, use the ReportingServicesT
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.

For Release Notes, expand the Package Details section on this page.

For automation with SSRS & Power BI Report Server, use the ReportingServicesTools module available at https://www.powershellgallery.com/packages/ReportingServicesTools
Show more

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.1.18228

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

Install-PSResource -Name SqlServer -Version 21.1.18228

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) 2020 Microsoft. All rights reserved.

Package Details

Author(s)

  • Microsoft Corporation

Tags

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

Cmdlets

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

Functions

Invoke-SqlNotebook SQLSERVER:

Dependencies

This module has no dependencies.

Release Notes

## 21.1.18228
Updates:
* Added new -AccessToken parameter to Invoke-Sqlcmd: this will allow connecting to SQL Server
 (e.g. Azure SQL DB, Azure SQL Managed Instance) using a Service Principal or a Managed Identity.
Fixes:
* Fixed an issue where Invoke-ProcessASDatabase would throw a null reference exception when trying
 to process a multidimensional database.

FileList

  • SqlServer.nuspec
  • DataSec.Common.dll
  • DataSec.PAL.Interfaces.dll
  • DataSec.PAL.Local.dll
  • DataSec.PAL.Local.Storage.dll
  • DataSec.VA.Common.Imp.dll
  • DataSec.VA.Core.Baseline.dll
  • DataSec.VA.Core.Contract.dll
  • DataSec.VA.Core.Engine.dll
  • DataSec.VA.Core.Exporter.dll
  • DataSec.VA.Core.Model.Converter.dll
  • DataSec.VA.Core.Model.dll
  • DataSec.VA.Core.Rules.dll
  • DataSec.VA.Core.VACore.dll
  • DocumentFormat.OpenXml.dll
  • Microsoft.AnalysisServices.Core.dll
  • Microsoft.AnalysisServices.dll
  • Microsoft.AnalysisServices.PowerShell.Cmdlets.dll
  • Microsoft.AnalysisServices.PowerShell.Provider.dll
  • Microsoft.AnalysisServices.Tabular.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.InformationProtection.dll
  • Microsoft.PolyKit.dll
  • Microsoft.Rest.ClientRuntime.Azure.dll
  • Microsoft.Rest.ClientRuntime.dll
  • Microsoft.SqlServer.Assessment.Cmdlets.dll
  • Microsoft.SqlServer.Assessment.Cmdlets.Engine.dll
  • Microsoft.SqlServer.Assessment.format.ps1xml
  • Microsoft.SqlServer.Assessment.Types.dll
  • Microsoft.SqlServer.AzureStorageEnum.dll
  • Microsoft.SqlServer.BatchParser.dll
  • Microsoft.SqlServer.BatchParserClient.dll
  • Microsoft.SqlServer.ConnectionInfo.dll
  • Microsoft.SqlServer.ConnectionInfoExtended.dll
  • Microsoft.SqlServer.Dac.dll
  • Microsoft.SqlServer.Dac.Extensions.dll
  • Microsoft.SqlServer.DC.Contract.dll
  • Microsoft.SqlServer.DC.Engine.dll
  • Microsoft.SqlServer.Diagnostics.Strace.dll
  • Microsoft.SqlServer.Dmf.Common.dll
  • Microsoft.SqlServer.Dmf.dll
  • Microsoft.SqlServer.IntegrationServices.Common.ObjectModel.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.IntegrationServices.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.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.VA.Model.dll
  • Microsoft.SqlServer.WmiEnum.dll
  • Microsoft.SqlServer.XEvent.XELite.dll
  • msvcp120.dll
  • msvcr120.dll
  • Newtonsoft.Json.dll
  • sqlnotebook.psm1
  • SQLProvider.Format.ps1xml
  • SQLProvider.Types.ps1xml
  • SqlServer.psd1
  • SqlServer.psm1
  • SqlServerPostScript.ps1
  • coreclr\Microsoft.Data.Tools.Sql.BatchParser.dll
  • coreclr\Microsoft.SqlServer.Assessment.Cmdlets.dll
  • coreclr\Microsoft.SqlServer.Assessment.Cmdlets.Engine.dll
  • coreclr\Microsoft.SqlServer.Assessment.Types.dll
  • coreclr\Microsoft.SqlServer.ConnectionInfo.dll
  • coreclr\Microsoft.SqlServer.Management.Dmf.dll
  • coreclr\Microsoft.SqlServer.Management.PSProvider.dll
  • coreclr\Microsoft.SqlServer.Management.PSSnapins.dll
  • coreclr\Microsoft.SqlServer.Management.RegisteredServers.dll
  • coreclr\Microsoft.SqlServer.Management.Sdk.Sfc.dll
  • coreclr\Microsoft.SqlServer.Management.XEvent.dll
  • coreclr\Microsoft.SqlServer.Management.XEventDbScoped.dll
  • coreclr\Microsoft.SqlServer.Management.XEventDbScopedEnum.dll
  • coreclr\Microsoft.SqlServer.Management.XEventEnum.dll
  • coreclr\Microsoft.SqlServer.Smo.dll
  • coreclr\Microsoft.SqlServer.SmoExtended.dll
  • coreclr\Microsoft.SqlServer.SqlEnum.dll
  • coreclr\Microsoft.SqlServer.XEvent.XELite.dll
  • coreclr\Microsoft.SqlTools.Hosting.dll
  • coreclr\Microsoft.SqlTools.ManagedBatchParser.dll
  • coreclr\SqlServerPostScript.ps1
  • coreclr\System.Data.SqlClient.dll
  • coreclr\System.Security.SecureString.dll
  • de\Microsoft.AnalysisServices.Core.resources.dll
  • de\microsoft.analysisservices.powershell.cmdlets.dll-help.xml
  • de\Microsoft.AnalysisServices.resources.dll
  • de\Microsoft.AnalysisServices.Tabular.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.ConnectionInfoExtended.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.HadrDMF.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.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.Assessment.Cmdlets.dll-Help.xml
  • en\Microsoft.SqlServer.Management.PSProvider.dll-Help.xml
  • en\Microsoft.SqlServer.Management.PSSnapins.dll-Help.xml
  • en\SqlServer-help.xml
  • es\Microsoft.AnalysisServices.Core.resources.dll
  • es\microsoft.analysisservices.powershell.cmdlets.dll-help.xml
  • es\Microsoft.AnalysisServices.resources.dll
  • es\Microsoft.AnalysisServices.Tabular.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.ConnectionInfoExtended.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.HadrDMF.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.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.Core.resources.dll
  • fr\microsoft.analysisservices.powershell.cmdlets.dll-help.xml
  • fr\Microsoft.AnalysisServices.resources.dll
  • fr\Microsoft.AnalysisServices.Tabular.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.ConnectionInfoExtended.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.HadrDMF.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.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.Core.resources.dll
  • it\microsoft.analysisservices.powershell.cmdlets.dll-help.xml
  • it\Microsoft.AnalysisServices.resources.dll
  • it\Microsoft.AnalysisServices.Tabular.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.ConnectionInfoExtended.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.HadrDMF.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.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.Core.resources.dll
  • ja\microsoft.analysisservices.powershell.cmdlets.dll-help.xml
  • ja\Microsoft.AnalysisServices.resources.dll
  • ja\Microsoft.AnalysisServices.Tabular.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.ConnectionInfoExtended.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.HadrDMF.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.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.Core.resources.dll
  • ko\microsoft.analysisservices.powershell.cmdlets.dll-help.xml
  • ko\Microsoft.AnalysisServices.resources.dll
  • ko\Microsoft.AnalysisServices.Tabular.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.ConnectionInfoExtended.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.HadrDMF.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.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.Core.resources.dll
  • pt\microsoft.analysisservices.powershell.cmdlets.dll-help.xml
  • pt\Microsoft.AnalysisServices.resources.dll
  • pt\Microsoft.AnalysisServices.Tabular.resources.dll
  • pt\Microsoft.SqlServer.ConnectionInfo.resources.dll
  • pt\Microsoft.SqlServer.ConnectionInfoExtended.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.HadrDMF.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.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.Core.resources.dll
  • ru\microsoft.analysisservices.powershell.cmdlets.dll-help.xml
  • ru\Microsoft.AnalysisServices.resources.dll
  • ru\Microsoft.AnalysisServices.Tabular.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.ConnectionInfoExtended.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.HadrDMF.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.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.Core.resources.dll
  • zh-hans\microsoft.analysisservices.powershell.cmdlets.dll-help.xml
  • zh-hans\Microsoft.AnalysisServices.resources.dll
  • zh-hans\Microsoft.AnalysisServices.Tabular.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.ConnectionInfoExtended.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.HadrDMF.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.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.Core.resources.dll
  • zh-hant\microsoft.analysisservices.powershell.cmdlets.dll-help.xml
  • zh-hant\Microsoft.AnalysisServices.resources.dll
  • zh-hant\Microsoft.AnalysisServices.Tabular.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.ConnectionInfoExtended.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.HadrDMF.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.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 3,184,201 1/16/2024
22.1.1 9,602,674 5/25/2023
22.0.59 2,676,895 4/4/2023
22.0.49-preview 43,924 1/16/2023
22.0.30-preview 42,852 9/20/2022
22.0.20-preview 36,336 5/2/2022
21.1.18257-p... 53,939 7/14/2021
21.1.18256 23,432,924 7/14/2021
21.1.18246-p... 14,879 3/28/2021
21.1.18245 2,529,202 3/28/2021
21.1.18239-p... 2,372 2/16/2021
21.1.18235 3,777,188 1/14/2021
21.1.18230 2,220,636 11/30/2020
21.1.18229 2,122,139 10/19/2020
21.1.18228 (current version) 142,434 9/30/2020
21.1.18226 5,858,908 7/7/2020
21.1.18221 1,634,509 3/23/2020
21.1.18218 906,862 12/13/2019
21.1.18209 887,185 11/18/2019
21.1.18206 102,616 10/30/2019
21.1.18179 209,909 9/21/2019
21.1.18147 303,870 7/30/2019
21.1.18135 222,574 7/5/2019
21.1.18121 229,619 5/15/2019
21.1.18102 167,066 3/31/2019
21.1.18095-p... 1,643 3/5/2019
21.1.18080 277,548 1/31/2019
21.1.18078-p... 526 1/20/2019
21.1.18068 278,879 11/16/2018
21.1.18040-p... 934 10/5/2018
21.0.17279 415,572 6/28/2018
21.0.17262 89,003 5/11/2018
21.0.17240 44,694 4/9/2018
21.0.17224 57,503 2/14/2018
21.0.17199 540,307 10/10/2017
21.0.17178 103,379 8/24/2017
21.0.17152 139,167 7/6/2017
21.0.17099 27,412 4/25/2017
Show less