Showing results for databases - Scripting Blog [archived]

Summary: Guest Blogger Kevin Kline talks about using Windows PowerShell to monitor SQL Server performance.   Hey, Scripting Guy! I am wondering about using Windows PowerShell to work with SQL performance counters. Is this something that can be done? —SH   Hello SH, Microsoft Scripting Guy Ed Wilson here. We have a new guest blogger ...

Summary: Learn how to use Windows PowerShell to work with SQL Server policy-based management. Microsoft Scripting Guy, Ed Wilson, here. I am really excited about the idea I had for this week, and I hope you will be too. I asked Candace Gillhoolley at Manning Press about posting some sample works from some of the Manning Press library of books. She ...

Summary: Learn how to search SQL Server error logs to return useful information by using Windows PowerShell to do the heavy lifting.   Hey, Scripting Guy! I need to query the SQL Server error log for specific errors. But I am not real good with Windows PowerShell. What is the best way to do this? —LH Hello LH, Microsoft Scripting Guy, ...

 Summary: Microsoft Scripting Guy, Ed Wilson, talks about different ways to use Windows PowerShell to get the SQL Server error log. Hey, Scripting Guy! I have recently inherited a Microsoft SQL Server 2008 R2 box, and I am concerned about the thing. I am not a DBA, and to be honest the server sort of frightens me a bit. When I look into the A...

Summary: Learn how to use Windows PowerShell to work with Microsoft SQL Server Analysis Service database backups. Microsoft Scripting Guy, Ed Wilson, here. Our guest blogger today is Muthusamy Anantha Kumar, a.k.a. “The MAK.” Muthusamy Anantha Kumar is a Microsoft Certified IT Professional database administrator (MCITP: Database Admi...