Powershell - Modify Server Name in SQL 2005 SSIS Connections
This powershell script updates the server name specified in connections within a SQL 2005 SSIS package
2011-06-24 (first published: 2011-06-22)
844 reads
This powershell script updates the server name specified in connections within a SQL 2005 SSIS package
2011-06-24 (first published: 2011-06-22)
844 reads
The purpose of this article is to demonstrate a custom scripting framework which enables the management of SQLServer databases from a Windows PowerShell session and also to extend Powershell’s flexibility by creating a set of commands customized to our needs. I will call this framework comprised of a library of modules and functions specialized to manage SQLServer the DBA profile.
2011-06-06
3,307 reads
This article takes a look at how PowerShell can speed up the process of parsing large log files.
2011-05-24
7,895 reads
Learn the easy way, and the hard way, to find the free space in each data file with Powershell expert Aaron Nelson.
2011-05-11
5,953 reads
Learn how to get setup with PowerShell and SQLPSX from MVP Aaron Nelson, one of the experts teaching us how to use Powershell for SQL Server.
2012-01-02 (first published: 2011-05-10)
15,731 reads
This article will show a way to find all SQL Servers, particularly those that have been forgotten about or lost.
2013-07-29 (first published: 2011-04-19)
15,641 reads
Powershell. I have seen the word but what is it? This article gives you a basic introduction to what PowerShell is and how you might use it.
2013-02-22 (first published: 2011-01-24)
24,842 reads
PASS is launching a new PowerShell Virtual Chapter. It's first meeting is next Wednesday at 12 pm EDT.
2010-10-15
825 reads
It was a year ago that Microsoft shipped PowerShell 2. Jonathan Medd lists the top ten reasons why PowerShell 2 should be an important tool for your work
2010-10-01
4,489 reads
Using Powershell with SMO, learn to alter or move indexes easily in this new article from Zach Mattson.
2010-09-30
4,455 reads
By Steve Jones
Next week I’m heading to the Lowry Conference Center in Denver for the RMOUG...
By Steve Jones
Today’s coping tip is to go to bed in good time and allow yourself...
By SQLBalls
Hello Dear Reader! After a weekend with a lot of activities, it was a...
Hi all! AWS has a good example of how to manipulate the requested objects...
Is the SQL Script plug-in listed here no longer available? SQL Scripts in SSMS...
Hi folks, I have a single Postgres instance on RDS that in the past...