All Tags » Powershell » sql (RSS)

Browse Blog Posts by Tags

Showing related tags and posts for the Blogs application. See all tags in the site

  • Upcoming book: Microsoft SQL Server 2008

    I recently wrapped up another authoring opportunity: I've contributed a chapter on the new PowerShell features in SQL Server 2008 for an upcoming book from SAMs: Microsoft SQL Server 2008 Management and Administration . It's cool to start seeing PowerShell showing up just about everywhere in...
    Posted to get-powershellblog by on Mon, Oct 6 2008
    Filed under: Filed under: , ,

  • SQL Server 2008 PowerShell SnapIn

    Installing SQL Server 2008 gives you SQLPS.exe, an application you can run which is a PowerShell including the PSDrives for SQL Server (and compatible with SQL Server 2005 as well!). But how do you make this work with your current copy of PowerShell? Well, I just worked this out. Darren Gosbell was lamenting...
    Posted to Rob Farley by Rob Farley on Mon, Mar 3 2008
    Filed under: Filed under: , ,

  • Using ScriptingOptions with SQLPS

    I've written before that SQL Server 2008 (February CTP) gives you SQLPS - a PowerShell interface to SQL Server. So I was trying to get the ScriptingOptions happening, and this is the only way I've found so far. It's ugly, and if you have a better way of doing this, please post a comment for...
    Posted to Rob Farley by Rob Farley on Mon, Mar 3 2008
    Filed under: Filed under: , ,

  • Two ways to find / drop a default constraint without knowing its name

    So suppose you've created a default constraint without specifying the name (on a SQL Server 2005 machine). You do know the table and column, of course - you just don't have the name of the default constraint. Now you want to find the name so that you can drop the constraint. A nice query against...
    Posted to Rob Farley by Rob Farley on Mon, Nov 26 2007
    Filed under: Filed under: ,

  • Powershell script from my SQL presentation

    Last week I presented at my user-group about PowerShell and why every DBA should know this. The talk went for just over an hour, and as most of the audience hadn't used PowerShell at all, I started from the top and really pushed concepts like "You pipe objects not text". The script can be downloaded...
    Posted to Rob Farley by Rob Farley on Tue, Jan 16 2007
    Filed under: Filed under: , , , ,

  • PowerShell and SQL

    Because I've been playing with PowerShell more and more recently, I'm going to do a talk at my user-group about it next week. Should be a lot of fun, and a great excuse to get deeper into the technology over the weekend. One thing that I think is really great is the ease with which you can apply things...
    Posted to Rob Farley by Rob Farley on Thu, Jan 4 2007
    Filed under: Filed under: ,
Page 1 of 1 (6 items)