Scripting Blog

A place to learn about PowerShell and share stories of automation

SQL Server 2012 - Scripting Blog

Use PowerShell to Parse SQL Server 2012 Error Logs

October 22, 2012 Oct 22, 2012 10/22/12
Doctor Scripto
Summary: Microsoft Scripting Guy, Ed Wilson, shows how to use Windows PowerShell to parse SQL Server 2012 error logs. Microsoft Scripting Guy, Ed Wilson, is here. The Scripting Wife and I have been in a number of email threads with Mark Schill, the leader of the Atlanta Windows PowerShell User Group, and the person in charge of putting ...

Weekend Scripter: Easily Back Up All SQL Server Databases by Using PowerShell

October 21, 2012 Oct 21, 2012 10/21/12
Doctor Scripto
Summary: Microsoft Scripting Guy, Ed Wilson, shows how to use the SQL Server 2012 provider for Windows PowerShell to easily back up all databases on an instance. Microsoft Scripting Guy, Ed Wilson, is here. I am still playing around with SQL Server 2012, and, today, I want to check on my backups by using Windows PowerShell. Note  &...

Weekend Scripter: Use PowerShell to Work with SQL Server 2012 Database Objects

October 20, 2012 Oct 20, 2012 10/20/12
Doctor Scripto
Summary: Ed Wilson, the Microsoft Scripting Guy, shows you how to use the SQL Server 2012 provider for Windows PowerShell to work with database objects. Microsoft Scripting Guy, Ed Wilson, is here. Today I want to continue my series of articles that explore the SQL Server 2012 provider for Windows PowerShell. Note   This is the ...

Use PowerShell to Work with the SQL Server Object

October 19, 2012 Oct 19, 2012 10/19/12
Doctor Scripto
Summary: Microsoft Scripting Guy, Ed Wilson, talks about using Windows PowerShell to examine the SQL Server object. Microsoft Scripting Guy, Ed Wilson, is here. Today I want to continue exploring the SQL Server provider for Windows PowerShell. We will dive into the named instance node of SQL Server. Note   Yesterday I introduced...

Introduction to the SQL Server 2012 PowerShell Provider

October 18, 2012 Oct 18, 2012 10/18/12
Doctor Scripto
Summary: Microsoft Scripting Guy, Ed Wilson, provides an introduction to the SQL Server 2012 provider for Windows PowerShell. Microsoft Scripting Guy, Ed Wilson, is here. One of the really cool things about SQL Server 2012 is the SQL Server provider for Windows PowerShell. By using the SQL Server provider, you gain access to a driver...