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)
831 reads
PowerShell
Using PowerShell to Manage SQL Server
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
Parsing Log Files and Summarizing Results with PowerShell
This article takes a look at how PowerShell can speed up the process of parsing large log files.
2011-05-24
7,655 reads
Finding Free Space per Data File with PowerShell
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,834 reads
Day Zero with PowerShell
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,688 reads
Finding lost or forgotten SQL Servers
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,637 reads
PowerShell Basics
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,794 reads
Announcing the New PowerShell Virtual Chapter of PASS!
PASS is launching a new PowerShell Virtual Chapter. It's first meeting is next Wednesday at 12 pm EDT.
2010-10-15
825 reads
PowerShell Version 2: What is new and why is it important?
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
Moving Indexes with Powershell and SMO
Using Powershell with SMO, learn to alter or move indexes easily in this new article from Zach Mattson.
2010-09-30
4,400 reads
Blogs
Real-World SQL Mastery: Your Hands-On, Mess-Free Sandbox
Are you ready to take your SQL skills from theoretical to tactical? If you've...
Set a Runtime Variable in an Azure DevOps Pipeline
By Steve Jones
Note: I DO NOT recommend this. Any changes to a pipeline should be in...
A New Word: Symptomania
By Steve Jones
symptomania – n. the fantasy that there’s some elaborate diagnosis out there that neatly...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers