PowerShell for Windows Admins:

SQL Server

1

November 27, 2013  2:35 PM

Capacity planning series finished



Posted by: Richard Siddaway
Office 2013, PowerShell, SQL Server, WMI

My capacity planning series on the Scripting Guy blog finished last week. Didn’t get chance to post about it as I was at Microsoft in Seattle. Full series and associated powertip...

November 11, 2013  12:17 PM

Capacity Planning part 2



Posted by: Richard Siddaway
PowerShell, SQL Server

My capacity planning mini series on the Scripting Guy blog continues with the second part – dealing with storing data in SQL Server - available today http://blogs.technet.com/b/heyscriptingguy/archive/2013/11/11/the-admin-s-first-steps-capacity-planning-part-2.aspx I’ll repeat the URL...


September 10, 2013  1:20 PM

Loading the SQLPS module



Posted by: Richard Siddaway
PowerShell, SQL Server

Loading the SQLPS module gives you quick access to the sql cmdlets, sql provider and the SMO assemblies. It also, infuriatingly, moves your location into the sql provider. I (really) * (lots ) hate things that assume what I want to do. You can use PowerShell to reverse this annoying, and...


September 9, 2013  12:54 PM

SMO with SQL Server 2012



Posted by: Richard Siddaway
PowerShell, SQL Server

I’ve been working quite a bit with PowerShell and SQL Server 2012 just recently. In earlier versions of SQL Server you had to load the SMO assemblies to get access to the admin functionality. In SQL Server 2012 – import-module sqlps gives you the SQL Server provider, the cmdlets and...


June 26, 2013  4:09 PM

Dropping a database



Posted by: Richard Siddaway
PowerShell, SQL Server

A question came up on the forum regarding dropping a database & I realised it was something I hadn’t done before. SMO provides a set of classes for managing SQL Server. You get SMO when you install the SQL Server management tools Import the module to load SMO...


1

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: