SqlServer

21.1.18226

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

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

Install-PSResource -Name SqlServer -Version 21.1.18226

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) 2019 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.18226
Updates:
* Added 40 new performance-related SQL Assessment checks.
Fixes:
* Fixed an issue where PowerShell was not able to load the module
 on machines without NetFx4.7.2
* Fixed an issue in Read-SQLXEvent where the cmdlet was not working against
 older versions of SQL Server (2016 and earlier).

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.3.0 16,167,864 7/4/2024
22.2.0 7,228,294 1/16/2024
22.1.1 9,760,794 5/25/2023
22.0.59 3,210,716 4/4/2023
22.0.49-preview 44,710 1/16/2023
22.0.30-preview 47,869 9/20/2022
22.0.20-preview 37,222 5/2/2022
21.1.18257-p... 55,035 7/14/2021
21.1.18256 24,967,992 7/14/2021
21.1.18246-p... 15,435 3/28/2021
21.1.18245 2,843,784 3/28/2021
21.1.18239-p... 2,521 2/16/2021
21.1.18235 3,799,608 1/14/2021
21.1.18230 2,281,254 11/30/2020
21.1.18229 2,161,741 10/19/2020
21.1.18228 143,135 9/30/2020
21.1.18226 (current version) 5,868,802 7/7/2020
21.1.18221 1,776,375 3/23/2020
21.1.18218 939,774 12/13/2019
21.1.18209 889,125 11/18/2019
21.1.18206 103,231 10/30/2019
21.1.18179 210,632 9/21/2019
21.1.18147 326,265 7/30/2019
21.1.18135 224,189 7/5/2019
21.1.18121 231,950 5/15/2019
21.1.18102 167,630 3/31/2019
21.1.18095-p... 1,662 3/5/2019
21.1.18080 286,204 1/31/2019
21.1.18078-p... 531 1/20/2019
21.1.18068 279,570 11/16/2018
21.1.18040-p... 940 10/5/2018
21.0.17279 419,180 6/28/2018
21.0.17262 89,023 5/11/2018
21.0.17240 45,428 4/9/2018
21.0.17224 58,073 2/14/2018
21.0.17199 578,788 10/10/2017
21.0.17178 103,667 8/24/2017
21.0.17152 145,006 7/6/2017
21.0.17099 28,878 4/25/2017
Show less