-
Article in Database Joutnal on PowerShell and SQL Server Analyssis Management Objects by Muthusamy Anantha Kumar - aka The MAK. Looks like it's the first of a series. http://www.databasejournal.com/features/mssql/article.php/3785481/Microsoft-Windows-PowerShell-and-SQL-Server-2008-AMO.htm
-
Buck Woody's PowerShell presentation materials from PASS 2008 are in his blog post here: http://chadwickmiller.spaces.live.com/blog/cns!EA42395138308430!208.entry Also includes a nice bullet point summary regarding why a DBA should use PowerShell when they already have SSIS, stored procs, batch files...
-
Jamie Thomson has written an article about data manipulation techniques by comparing and contrasting data integration features in SQL Server Integration Services and pipelining data in PowerShell. You can read more at: http://blogs.conchango.com/jamiethomson/archive/2008/12/09/talking-pipelines-ssis...
-
In this article, Vidas Matelis discusses using PowerShell to process SQL Server Analysis Services dimensions and cubes using Anaylsis Management Objects (AMO). The article can be found at: http://www.ssas-info.com/VidasMatelisBlog/125_powershell-script-to-process-database
-
In this article, Vidas Matelis discusses using PowerShell to process SQL Server Analysis Services dimensions and cubes using Anaylsis Management Objects (AMO). Read at: http://www.ssas-info.com/VidasMatelisBlog/125_powershell-script-to-process-database
-
Here is a one-liner by Buck Woody to demonstrate how to read the registered servers in SQL Server Management Studio using the SQL Server 2008 PowerShell Cmdlet ‘invoke-sqlcmd’. The output of this statement could then be used to perform actions on each registered server. Read More
-
The primary goal of SQL Server PowerShell Extensions (SQLPSX) is to provide intuitive functions around the SMO objects which are backward compatible with SQL 2000. A secondary goal is to provide an application which reports flatten/effective security settings for logins, users, roles, and permissions...
-
Hi, all I am new to powershell, and practicing to use .net object in Powershell. Now I can select/update/insert into SQL tables, but cannot get the return value, and output parameter from a store procedure. Could someone give me a sample script for these? Thanks a lot, Gary
Posted to
SQL Server
(Forum)
by
gtan
on
06-17-2009
Filed under: sql server, PowerShell, Stored Procedures, PowerShell Functions
-
We are currently setting up a control server that will carry out all our SQL Server installations. There is a table in the DBA database that server details are added to, a stored procedure then produces an ini file for each server based on the details entered. What components are installed, service accounts...
-
If you use PowerShell and SQL Server you should at the very least look at SQLPSX which is a big library of PowerShell functionality. Version 1.5 has just been released. See http://chadwickmiller.spaces.live.com/blog/cns! ... Read More