Featured Article(s)
Troubleshooting SQL Server 2008 Reporting Services
In this article, Alexander Chigrik describes some problems you can have with SQL Server 2008 Reporting Services and shows how you can resolve these problems.
Upcoming Events
– SSWUG.ORG DBASchool – Learn What Really Matters with SQL Server
– April 19, 20 and 21, Tucson, AZ with Stephen Wynkoop [Read More]
PowerShell – Experiences and Feedback
Max wrote in about the types of things he’s been doing with PowerShell. Great stuff!
"You are totally right! PowerShell is under utilized in many SQL Server installation and it only bring a few cmdlets. Ironically, with Sharepoint 2010 we are seen a lot of people jumping to learn PowerShell.
Now keeping in mind that every Microsoft Product Team will have its own implementation of PowerShell, you need to make sure to understand how PowerShell works with all the different products. Thanks to the release of Windows 7 and Windows Server 2008 R2, we can only expect to see more people adopting PowerShell.
But in my case, besides giving presentations about using SQL Server and PowerShell, I do use it at work on a day by day basis for the last 3 years.
This is what I’ve done with PowerShell:
1. Help my DBA (who doesn’t do any PowerShell) to monitor the SQL Servers.
2. For developers, run scheduled SQL Server backups and automatically restore to my local SQL server.
3. Monitor/Scan for possible bad records coming from our EDI Transmission before it gets process.
4. Script out tables properties and extended properties for both SQL Server, MySQL, and MSAccess (Yes!! MSACCESS).
5. Script out SQL Jobs.
6. Run T-SQL script in a scheduled SQL Agent job.
7. Pull email information from my Inbox related with all SQL Jobs executed the during the night.
8. I can connect and query all SQL Server(2000,2005, and 2008) on my network from my PowerShell console.
9. Convert some VBScript and C# solution to PowerShell.
10. Creating a PowerShell solution to reset password.
11. Script out all SQL statement from an MSAccess application to be save into SVN.
In reality, PowerShell has become a most needed tool in my daily work routine and loving it."