Browse by Tags

All Tags » powershell (RSS)
Wed, Nov 11 2009 13:44

Finding the Microsoft File Transfer Manager

This is really just a reminder blog post for me. Way too often I find that I have closed the Microsoft File Transfer Manager for one reason or another, and I want to start it up again to resume some download from my MSDN Subscription. Like today, I need...
Posted by Rob Farley | with no comments
Filed under: ,
Mon, Mar 23 2009 10:10

A review – Microsoft Windows PowerShell Step By Step (Ed Wilson)

Another book review, and another giveaway for the Adelaide SQL Server User Group . This time, it’s Microsoft Windows PowerShell Step By Step . Last month I had picked up the Windows PowerShell Scripting Guide , wondering if it was going to be a good recommendation...
Posted by Rob Farley | with no comments
Filed under: , ,
Mon, Feb 23 2009 17:04

A review – Windows PowerShell Scripting Guide

As a User Group leader, I have the chance to review books for MSPress (and then give a copy away to the user group too!). So at the end of last month I got sent a copy of Windows PowerShell Scripting Guide, by Ed Wilson (I hope that link works – if it...
Posted by Rob Farley | 1 comment(s)
Filed under: ,
Tue, Nov 18 2008 21:29

Disable WiFi with PowerShell

A bit like putting your laptop into Flight Mode, I guess. I fly fairly often at the moment, but my Wireless switch on the side of my laptop is slowly wearing out. Occasionally when it's in the OFF position, it thinks it's actually in the ON position...
Posted by Rob Farley | 3 comment(s)
Filed under:
Thu, Jun 12 2008 13:48

PowerShell changes in SQL Server 2008 RC0

Regular readers of my blog will remember my post about how to get PowerShell for SQL into your regular PowerShell window . Except that if you've just installed SQL Server 2008 RC0, you may have noticed it doesn't work any more. Never fear, they've...
Posted by Rob Farley | 1 comment(s)
Filed under: ,
Tue, Mar 4 2008 9:17

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?...
Posted by Rob Farley | 18 comment(s)
Filed under: , ,
Tue, Mar 4 2008 8:53

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...
Posted by Rob Farley | 2 comment(s)
Filed under: , ,
Sat, Feb 23 2008 16:00

SQL Server 2008 CTP6 gives you PowerShell

The sixth CTP of SQL Server 2008, made available this past week at http://connect.microsoft.com/sql provides a PowerShell provider for SQL Server, which is backwards compatible with SQL Server 2005 as well. I showed it a little at the User Group in Melbourne...
Posted by Rob Farley | 3 comment(s)
Filed under: ,
Mon, Nov 26 2007 17:18

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...
Posted by Rob Farley | 3 comment(s)
Filed under: ,
Wed, Jan 17 2007 7:00

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...
Posted by Rob Farley | with no comments
Filed under: , , , ,
Mon, Jan 8 2007 16:45

The soapy frog does ASCII Art in PowerShell

Of course the idea is the same as Unix's AALib , but what's so cool is how little code it takes to do this in PowerShell . The idea is simply "Load up an image in System.Drawing, work out the brightness of each range of pixels, and from that...
Posted by Rob Farley | with no comments
Filed under:
Fri, Jan 5 2007 13:54

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...
Posted by Rob Farley | 3 comment(s)
Filed under: ,