PowerShell and SQLDatabase

-

hello experts,

 i want utilize powershell add sqldatabase entry , take data database , use c# code build website display content of it.

 basically want learn adding , getting entries , database , can knows best reference book learn this?

i searched bit on internet did not find much.

thanks,

-prashant girennavar.

mcsa|mcitp sa|microsoft exchange 2003 blog - http://prashant1987.wordpress.com disclaimer: posting provided as-is no warranties/guarantees , confers no rights.

hi,

to learn how use powershell manage sql, please start here:

how use windows powershell manage sql server

http://technet.microsoft.com/en-us/magazine/gg313741.aspx

use powershell work sql server instance-level properties

http://blogs.technet.com/b/heyscriptingguy/archive/2013/05/03/use-powershell-to-work-with-sql-server-instance-level-properties.aspx

regards,

yan li

cataleya li
technet community support



Windows Server  >  Windows PowerShell



Comments

Post a Comment

Popular posts from this blog

directory stack

-
witchcraft>> $algo -eq $null true witchcraft>> cd $algo.key # directory stack: --- ---------------- 0 c:\users\voodoomsr\valhala 1 c:\users\voodoomsr\valhala\witchcraft\expectopatronum 2 c:\users\voodoomsr\valhala\witchcraft\expectopatronum\comunidad 3 c:\users\voodoomsr\valhala\witchcraft\expectopatronum\comunidad\stack 4 c:\users\voodoomsr\valhala -> 5 c:\users\voodoomsr\valhala\witchcraft witchcraft>> hi all, found extrange thing don't understand. if execute set-location inexistence object list of directories. what that? i see it, can't reproduce it.   when enter you've got posted there, set-location error, because value of argument "path" null.     [string](0..33|%{[char][int](46+("686552495351636652556262185355647068516270555358646562655775 0645570").substring(($_*2),2))})-replace " " mistake!. after that, check alias cd , asigned function set-locationex. fu...
Read more

PowerShell List

-
hello everyone, i'm trying list vms in scvmm i'm using get-vm -vmmserver vmm01.mydomain.tld | export-csv c:\listvm.csv but returns info each vm, return properties want, way (that know) properties using: get-vm -vmmserver vmm01.mydomain.tld | format-list -property name, owner, description, operatingsystem, cpucount, memory, virtualizationplatform, hostname, status but if add get-vm -vmmserver vmm01.mydomain.tld | format-list -property name, owner, description, operatingsystem, cpucount, memory, virtualizationplatform, hostname, status | export-csv c:\listvm.csv now have mess... any way working nice , clean? thank you ok, found solution get-vm -vmmserver vmm01.mydomain.tld | select name, owner, description, operatingsystem, cpucount, memory, virtualizationplatform, hostname, status | export-csv c:\listvm.csv thank you. Windows Server  >  ...
Read more

Dns access list

-
hello i have situation following participants: mac osx server & windows 2003 dns server   problem: the mac osx server registering ip address in dns. i not want that. question: is there way control can register in windows dns? some sort of access list. know possible bind dns server regards k you have few options available in dns regarding dynamic updates.  can set zone's dynamic updates settings 1 of following: none, nonsecure , secure, , secure only. if set none, dynamic updates not allowed, nonsecure , secure allow clients update , secure only allow authenticated systems (members of domain example). if want control updates @ record level, can modify acl record once has been created.  zone can controlled via acl (properties, security tab). visit: anitkb.com , knowledge base. Windows Server  >  ...
Read more