Powershell und SQL na wie geht das denn?
Powershell und SQL ¨C 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 ¨Cname sqlps
Invoke-Sqlcmd
? sqlcmd.exe auf Powershell
? Liefert Daten als Objekte zur¨¹ck
Invoke-Sqlcmd ¨Cquery ?select * from
AdventureWorks2012.Person.Address¡° ¨CServerInstance .
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
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related download
- sql server hacking on scale using powershell
- powershell und sql na wie geht das denn
- achieve more in less time by using the new sql powershell
- powershell jumpstart for sql server dbas
- groupid management shell command reference
- there s something about wmi
- powershell basic cheat sheet rambling cookie monster
Related searches
- powershell import sql module
- und emergency federal aid grant
- powershell invoke sql command
- powershell query sql table
- powershell execute sql command
- powershell list sql server instances
- powershell execute sql file
- powershell run sql script
- powershell query sql server
- powershell query sql server database
- powershell execute sql server query
- powershell execute sql query