SqlServer

21.1.18230

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

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

Install-PSResource -Name SqlServer -Version 21.1.18230

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

Author(s)

Microsoft Corporation

Copyright

Copyright (c) 2020 Microsoft. All rights reserved.

Package Details

Owners

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.18230
Updates:
* Introduced support of sensitivity rank when classifying database columns, or when reading
 columns classifications or recommendations.
* Updated VulnerabilityAssessment Cmdlets to match the functionality of SSMS VulnerabilityAssessment scan
* Adding support for Power BI Premium Gen2 workspaces
Fixes:
* Fixed an issue in Read-SqlXEvent where the -FileName parameter was not working
 when using relative paths.

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.1.1 7,754,644 5/25/2023
22.0.59 2,659,864 4/4/2023
22.0.49-preview 43,707 1/16/2023
22.0.30-preview 41,015 9/20/2022
22.0.20-preview 35,816 5/2/2022
21.1.18257-p... 53,459 7/14/2021
21.1.18256 22,905,864 7/14/2021
21.1.18246-p... 14,644 3/28/2021
21.1.18245 2,425,285 3/28/2021
21.1.18239-p... 2,327 2/16/2021
21.1.18235 3,767,011 1/14/2021
21.1.18230 (current version) 2,205,869 11/30/2020
21.1.18229 2,112,368 10/19/2020
21.1.18228 142,296 9/30/2020
21.1.18226 5,854,990 7/7/2020
21.1.18221 1,630,943 3/23/2020
21.1.18218 900,326 12/13/2019
21.1.18209 885,379 11/18/2019
21.1.18206 102,595 10/30/2019
21.1.18179 209,636 9/21/2019
21.1.18147 298,158 7/30/2019
21.1.18135 221,846 7/5/2019
21.1.18121 229,214 5/15/2019
21.1.18102 166,864 3/31/2019
21.1.18095-p... 1,634 3/5/2019
21.1.18080 274,679 1/31/2019
21.1.18078-p... 524 1/20/2019
21.1.18068 278,803 11/16/2018
21.1.18040-p... 931 10/5/2018
21.0.17279 415,208 6/28/2018
21.0.17262 88,986 5/11/2018
21.0.17240 44,529 4/9/2018
21.0.17224 57,085 2/14/2018
21.0.17199 538,321 10/10/2017
21.0.17178 103,240 8/24/2017
21.0.17152 136,044 7/6/2017
21.0.17099 27,224 4/25/2017
Show less