using posh to get-sqldata

 Accessing SQL Server Data from PowerShell, Part 1

Accessing SQL Server Data from PowerShell, Part 2 Use ADO.NET to insert, update, and delete data



Parse SQL DataSet to variables in Windows Powershell - scrool 2 end 

Getting Powershell output into a sql table in Windows Powershell  

PowerShell Mini SQL Query Analyzer


how to connect to a SQL database, query the Employees table of the Northwind database, and write those results to the screen.  


Using Powershell to Generate Table-Creation Scripts

Create Your First SQL Server Database in 3 Quick Steps

Accessing SQL Server Data from PowerShell, Part 1



SQL Server PowerShell Overview
get-data from sql start-sql

Quick and Dirty Software Inventory with PsInfo and PowerShell


 executing SQL queries from Powershell in Windows Powershell 


Check your SQL Server using Windows PowerShell –series

If you install the SQL Server 2008 client software, you get a SQL Server
PowerShell snap-in. You can run the sqlps.exe utility that loads the snapin
into a PowerShell environment, or start PowerShell and load in the snap-in
yourself. With the snap-in, you can get a list of the instances on a
computer by:

cd SQLSERVER:\SQL\MyComputerName
dir

Running SQL Server PowerShell:
http://msdn.microsoft.com/en-us/library/cc281954.aspx
Using the SQL Server PowerShell Provider:
http://msdn.microsoft.com/en-us/library/cc281947.aspx

NOTE: the Running SQL Server PowerShell topic still uses the old names for
the snap-in. The next update to Books Online includes an update to the topic
that uses the released names: SqlServerProviderSnapin100 and
SqlServerCmdletSnapin100.
-- 


poshOUT-2-sqlIN 


parse results - scroll 2 end

database info

PowerShell and ADO.NET

PowerShell Mini SQL Query Analyzer

Comparing Python and PowerShell DBA Scr
How Can I Use Windows PowerShell to Pull Records From a Microsoft Access Database?

Managing SQL Server using PowerSMO

PowerSMO At Work Part I: DBA Scripts and Functio

db 2 html

PowerSMO at Work Part 2

how to connect to a SQL database, query the Employees table of the Northwind database

Using PowerShell and SQL Server Together

Implementing Real-World Data Input Validation using Regular Expressions

run command+

Run-Command.ps1 : Run External Commands with Power!
Import-ADUser: All I can say is WoW! Posh 55 / Vbscript 210
Accessing SQL Server data through PowerShell
vbscriptInPosh

Scripting Solutions for SQL Server buck woody

SQL Server Reference Guide Scripting Solutions for SQL Server
SQL Server Reference Guide Powershell and SQL Server - Overview
SQL Server Reference Guide PowerShell and SQL Server - Objects and Providers
SQL Server Reference Guide Powershell and SQL Server - A Script Framework

Quick and Dirty Software Inventory with PsInfo and PowerShell

Quick and Dirty Software Inventory with PsInfo and PowerShell

Microsoft Windows Power Shell and SQL Server 2005 SMO – Part 4

Microsoft Windows Power Shell and SQL Server 2005 SMO – Part 4