THE SQL Server Blog Spot on the Web

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

Browse by Tags

All Tags » SQL Server 2008 » PowerShell   (RSS)
Showing page 2 of 3 (25 total posts)
  • Start a SQL Server Agent Job using the SQL Server PowerShell Provider

    Whew!  That’s a mouthfull. Anyway, I thought I would share part of a script I wrote today to help automate (more) from PowerShell. This assumes a few things: that you’re doing this from the SQL Server 2008 PowerShell provider (not just good old regular PowerShell) and that you change the HAL9000 and SQL2K8 parts with your server name and your ...
    Posted to Buck Woody (Weblog) by BuckWoody on February 10, 2010
  • PowerShell Demo Prompt

    When I teach I have to set my fonts really big so that folks in the back can see. I show PowerShell from time to time, and people keep asking me about my latest prompt.  Here’s what my prompt looks like:   { univac\Buck on UNIVAC using AMD64 } --    12/23/2009 7:54:10 ...
    Posted to Buck Woody (Weblog) by BuckWoody on December 24, 2009
  • A Couple of Invoke-SQLCMD Issues

    In working on a PowerShell script to load data into SQL Server, I decided to use the Invoke-SQLCMD cmdlet included in the snapins provided with SQL Server 2008, and found a couple of issues you should know about. First, as a matter of best practices, if a stored procedure returns a scalar value, it should do so in an output parameter. The ...
    Posted to Allen White (Weblog) by AllenMWhite on August 14, 2009
  • PowerShell's "Mini-Shell" Is Not A "Mini" Shell

    I just learned about a Connect item entered on Friday: https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=475337. Here's the description in the item. Please invoke the full powershell not a ''mini-shell''. Powershell is very powerful but the mini-shell you get when invoking Powershell from the Management Studio ...
    Posted to Allen White (Weblog) by AllenMWhite on July 20, 2009
  • PowerShell Whitepaper Published

    My first whitepaper for Microsoft, Understanding and Using PowerShell Support in SQL Server 2008 has been published. It was a great honor to have been selected to write the paper, and I thank Kalen Delaney for giving me the opportunity. I hope you find it useful. Allen
    Posted to Allen White (Weblog) by AllenMWhite on June 13, 2009
  • Automating SQL Server 2005/2000 Policy Evaluation

    The Enterprise Policy Management Framework version 3.0, a new version of the framework to support policy automated policy evaluation for SQL Server 2000 and 2005, has been posted to codeplex. For those who are not familiar with the tool, the Enterprise Policy Management Framework is a reporting solution on the state of the SQL Server enterprise ...
    Posted to Lara Rubbelke (Weblog) by Lara Rubbelke on June 13, 2009
  • Enterprise Policy Management: Updates, New Whitepaper, and Upcoming Webcast

    The next version of the Enterprise Policy Management Framework has been published to CodePlex.  The new version includes error trapping and error reporting, and a few bug fixes.  Please be sure to download the documentation as well, which will help you understand how to use the PowerShell variables to scale the execution in your ...
    Posted to Lara Rubbelke (Weblog) by Lara Rubbelke on March 4, 2009
  • SMO Changes from SQL 2005 to SQL 2008

    A year ago in anticipation of publishing a book on SMO (which never came to be) I wrote a number of chapters demonstrating how to manage specific sets of objects, and I provided examples in VB.Net, C# and PowerShell. As should be expected, I thoroughly tested all of the code samples to make sure they worked. This year I've been part a couple of ...
    Posted to Allen White (Weblog) by AllenMWhite on February 20, 2009
  • Loading SMO Assemblies into PowerShell

    Microsoft included PowerShell with SQL Server 2008, and the new sqlps.exe program which includes the SQL PowerShell drivers including the PS Drives and new cmdlets for SQL Server. I prefer to work from vanilla PowerShell and load the assemblies I need, so I have code at the start of my script to load the appropriate assemblies. When I started ...
    Posted to Allen White (Weblog) by AllenMWhite on December 7, 2008
  • PASS Demonstration Errors

    Errors occur. (I'm sure that's someone's corollary to Stuff Happens.) Errors occur, and that's why we write error handling code in our applications. My least favorite time for the occurrance of errors is when I'm doing demos, and that's what happened in a presentation I did at PASS last week. I try to test everything before giving the demos, ...
    Posted to Allen White (Weblog) by AllenMWhite on November 24, 2008
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement