Browse Forum Posts by Tags

Showing related tags and posts for the Forums application. See all tags in the site
  • Intersting article in Database Journal - using PowerShell and SQL Server AMO

    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
    Posted to Using SQL Server (Forum) by rjp on 11-19-2008
    Filed under: sql server, AMO
  • Buck Woody's PowerShell presentation materials from PASS 2008

    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...
    Posted to Using SQL Server (Forum) by rjp on 11-24-2008
    Filed under: sql server
  • Comparing SSIS and PowerShell

    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...
    Posted to Using SQL Server (Forum) by ps2 on 12-12-2008
    Filed under: sql server, PowerShell
  • Powershell script to process SSAS database objects

    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
    Posted to Using SQL Server (Forum) by ps2 on 12-21-2008
    Filed under: sql server, PowerShell
  • Powershell script to process SSAS database objects

    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
    Posted to SQL Server (Forum) by ps2 on 12-22-2008
    Filed under: PowerShell, SQL Server
  • Using PowerShell And SSMS Registered Servers

    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
    Posted to SQL Server (Forum) by ps2 on 01-05-2009
    Filed under: sql server, PowerShell
  • SQL Server PowerShell Extensions

    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...
    Posted to SQL Server (Forum) by ps2 on 01-23-2009
    Filed under: sql server
  • How to get return value from a SQL store procedure

    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
  • Remote Installation of SQL Server 2008

    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...
    Posted to SQL Server (Forum) by statistical on 02-25-2010
    Filed under: sql server, SQL, SQL Server 2008
  • SQLPSX 1.5 - Windows Live

    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
    Posted to Announcements/Events (Forum) by ps2 on 04-02-2009
    Filed under: PowerShell Library, SQL Server, SQLPSX
Page 1 of 2 (18 items) 1 2 Next >
Copyright 2012 PowerShell.com. All rights reserved.