Scripting Blog

A place to learn about PowerShell and share stories of automation

SQL Server - Scripting Blog

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

Use PowerShell to Security Test SQL Server and SharePoint

July 3, 2012 Jul 3, 2012 07/3/12
Doctor Scripto
Summary: Guest blogger, Niklas Goude, talks about using Windows PowerShell to perform brute force security testing on SQL Server and SharePoint. Microsoft Scripting Guy, Ed Wilson, is here. Today we have Niklas Goude back with Part 2 of his Security Week series. Niklas Goude is a Security Consultant at TrueSec and an MVP in Windows PowerShell...