Showing tag results for SQL Server

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...

Summary: Learn how to use Windows PowerShell to quickly and efficiently copy a table between two SQL Server instances.   Hey, Scripting Guy! How can I copy a table between two SQL Server instances? —PY Hello PY, Microsoft Scripting Guy, Ed Wilson, is here. Today is the last day for this week’s SQL Guest Blogger series. Today our g...