THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Allen White

Speaking about SQL Server and PowerShell

I'll be presenting my session on Use PowerShell to Get the Most out of SQL Server twice today. This session is a one-hour intro to PowerShell and how to use it to connect with and manage SQL Server. Here's the full abstract:

PowerShell is the new scripting environment from Microsoft for managing server environments. Because PowerShell supports the .Net Framework, accessing SQL Server in a scripting environment is easier than ever before. Whether you need to access data or manage SQL Server, PowerShell makes it possible. This session will give an introduction to PowerShell, explain the basic ADO.Net objects required to connect with SQL Server, and demonstrate accessing SQL Server from PowerShell scripts, both from a data and a management perspective.

At 2pm Eastern Daylight Time, I'll be presenting it for the PASS DBA Virtual Chapter. You can sign up for it here: http://dba.sqlpass.org/.

At 9:45pm Eastern Daylight Time, I'll be presenting it for the Oregon SQL -developers group in Portland. You can sign up for this one here: http://osql-d.sqlpass.org/.

So, you've got two chances to get started with PowerShell today. If this whets your appetite for more, please consider signing up for my full-day pre-conference session at PASS, where I'll start with the basics of PowerShell, and then spend the day showing you how to effectively manage SQL Server with PowerShell. Check out the details here: PASS Summit PowerShell Pre-Con.

Allen

Published Wednesday, October 13, 2010 9:39 AM by AllenMWhite

Attachment(s): UsingPowerShellSQLServer.zip

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

 

AllenMWhite said:

I just posted the slides and demo scripts. Thanks everyone for attending my sessions.

October 14, 2010 10:33 AM
 

Rick Winney said:

Allen,

I have a Powershell script written in 1.0 and now i'm trying to use it with powershell 2.0.  The problem is the script, which returns a list of database names and sizes now returns the names but all of the database sizes are the same.  It ran on my old WinXP machine just fine (still does), but on the new win7, I get the same size for every database.  The new machine has .Net 4.0 framwork in addition to 1.0, 1.1, 2.0, 3.0, and 3.5.  The WinXP machine has the same set less the 4.0 framwork.

Is there a fix?

October 18, 2010 4:02 PM
 

AllenMWhite said:

Rick, not seeing your script I don't know where to start to help diagnose the problem, but you'd be better served posting the question here: http://social.msdn.microsoft.com/Forums/en-US/sqlkjmanageability/threads

October 18, 2010 4:16 PM

Leave a Comment

(required) 
(required) 
Submit

About AllenMWhite

Allen White is a consultant and mentor for Upsearch Technology Services in Northeast Ohio. He has worked as a Database Administrator, Architect and Developer for over 30 years, supporting both the Sybase and Microsoft SQL Server platforms over that period.

This Blog

Syndication

Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement