Powershell und SQL na wie geht das denn?

[Pages:15]Powershell und SQL ? na wie geht das denn?

Holger Voges

CCA,MCSE, MCDBA, MCT, MCITP DB Administrator / DB Developer, MCTIP Enterprise Administrator, MCSE Windows Server 2012

Netz-Weise Freundallee 13a 30173 Hannover z-weise.de

SQL-Server Powershell Modul

? Microsoft Feature Pack:

? SQLSysClrTypes.msi ? ShareManagementObjects.msi ? PowerShellTools.msi

PS:> Import-Module ?name sqlps

Invoke-Sqlcmd

? sqlcmd.exe auf Powershell ? Liefert Daten als Objekte zur?ck

Invoke-Sqlcmd ?query ,,select * from AdventureWorks2012.Person.Address" ?ServerInstance .

Neu, nicht mit Perwoll geschaffen

Add-SqlFirewallRule Get-SqlDatabase Get-SqlInstance Get-SqlSmartAdmin New-SqlBackupEncryptionOption Remove-SqlFirewallRule Set-SqlAuthenticationMode Set-SqlNetworkConfiguration Set-SqlSmartAdmin Start-SqlInstance Stop-SqlInstance Test-SqlSmartAdmin

Commandlets f?r Always on

CommandType ----------Cmdlet Cmdlet Cmdlet Cmdlet Cmdlet Cmdlet Cmdlet Cmdlet Cmdlet Cmdlet Cmdlet Cmdlet Cmdlet Cmdlet Cmdlet Cmdlet Cmdlet Cmdlet Cmdlet

Name ---Add-SqlAvailabilityDatabase Add-SqlAvailabilityGroupListenerStaticIp Join-SqlAvailabilityGroup New-SqlAvailabilityGroup New-SqlAvailabilityGroupListener New-SqlAvailabilityReplica Remove-SqlAvailabilityDatabase Remove-SqlAvailabilityGroup Remove-SqlAvailabilityReplica Resume-SqlAvailabilityDatabase Set-SqlAvailabilityGroup Set-SqlAvailabilityGroupListener Set-SqlAvailabilityReplica Suspend-SqlAvailabilityDatabase Switch-SqlAvailabilityGroup Test-SqlAvailabilityGroup Test-SqlAvailabilityReplica Disable-SqlAlwaysOn Enable-SqlAlwaysOn

ModuleName ---------sqlps sqlps sqlps sqlps sqlps sqlps sqlps sqlps sqlps sqlps sqlps sqlps sqlps sqlps sqlps sqlps sqlps sqlps sqlps

Weitere Commandlets

CommandType ----------Cmdlet Cmdlet Cmdlet cmdlet Cmdlet Cmdlet Cmdlet Cmdlet Cmdlet Cmdlet Cmdlet Cmdlet Cmdlet Cmdlet

Name ---Add-SqlFirewallRule Backup-SqlDatabase Convert-UrnToPath Decode-SqlName Encode-SqlName Get-SqlCredential Get-SqlDatabase Get-SqlInstance Get-SqlSmartAdmin Invoke-PolicyEvaluation Invoke-Sqlcmd New-SqlBackupEncryptionOption New-SqlCredential New-SqlHADREndpoint

CommandType ----------Cmdlet Cmdlet Cmdlet Cmdlet Cmdlet Cmdlet Cmdlet Cmdlet Cmdlet Cmdlet Cmdlet Cmdlet

Name ---Remove-SqlCredential Remove-SqlFirewallRule Restore-SqlDatabase Set-SqlAuthenticationMode Set-SqlCredential Set-SqlHADREndpoint Set-SqlNetworkConfiguration Set-SqlSmartAdmin Start-SqlInstance Stop-SqlInstance Test-SqlDatabaseReplicaState Test-SqlSmartAdmin

Sql Server Managed Backup f?r Azure

cd SQLSERVER:\SQL\Computer\MyInstance $encryptionOption = New-SqlBackupEncryptionOption -EncryptionAlgorithm Aes128 -EncryptorType ServerCertificate -EncryptorName "MyBackupCert" Get-SqlSmartAdmin | Set-SqlSmartAdmin ?BackupEnabled $True ?BackupRetentionPeriodInDays 10 EncryptionOption $encryptionOption

 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download