Last days to register!
– SSWUG.ORG DBASchool – Learn What Really Matters with SQL Server
– April 19, 20 and 21, Tucson, AZ with Stephen Wynkoop [Read More]
(Very limited seating remaining)
SQL Server Reporting Tips and Tricks
Have you ever wondered how you could possibly get the reporting you need out of your SQL Server database, not to mention in an easy-to-read format? Expert Donabel Santos will help you get the most from your reporting with new tips and tricks on the Idera Secrets of SQL Server blog. Find out how to use the downloadable Report Viewer with Reporting Services and PowerShell and get the scripts you need – read our SQL reporting tip here!
Webcast: SQL Server Forensics
Have you ever received a call from one of your users asking why they received an error 3 days ago? Or maybe they want to know when a particular piece of data was deleted and who did it. Troubleshooting past events is difficult in SQL Server, but not always impossible. Learn how to set up a SQL Server to be able to respond these questions and how to use resources within SQL Server and other application logs to track down activity that otherwise might be lost.
Presented by: Sarah Barela
> Register Now
> Live date: 4/14/2010 at 12:00 Pacific
Reader Comments/Feedback On PowerShell Uses
From Ronnie – "As far as using PowerShell goes it is certainly something I am looking at using more and more to manage our SQL Estate. At present I use it to connect to multiple instance of Analysis Services and script out the Analysis Services databases to their respective XMLA format each week. There are a number of backup products out there for the Database Engine side of things that allow for compression etc however nothing really designed as such for Analysis Services databases. We don’t see the need to backup these databases fully each day / week as they can be re-created from the underlying data however it is useful to have the XMLA backup should the need ever arise"
From Bill – "I have been playing around with PowerShell since it first came out. I can see its use for scripting jobs and applications, but as far as day-to-day DBA tasks I haven’t found a need for it. For me, it is much faster to create maintenance plans, etc. using SSMS tools. If I need the same jobs on several servers, I just create one plan, script it out, and execute it on all servers via my Registered Servers page on SQL 2008."
It’s clear from the great number of emails I received that indicated people are using it extensively that PowerShell has found a great home in many, many environments. Most of the responses were of the type that just said "I use it for everything!" – automation is a huge benefit which lead the pack on best uses for it.
Here are some additional items you may want to check out:
Microsoft’s SQL Server PowerShell site: http://msdn.microsoft.com/en-us/library/cc281954.aspx
PowerShell blog: http://blogs.msdn.com/PowerShell/
PowerShell Script Center: http://technet.microsoft.com/en-us/scriptcenter/dd742419.aspx
Enjoy!