My technical partner-in-crime, Brandon, created this PowerShell script last year in an effort to help him understand PowerShell a bit more. He noted that while it may not all be best practices SQL-wise, he tried his best to use as much PowerShell as possible.

#Powershell to backup and restore a SQL database from …

Not even one-handed typing with a gimp shoulder in a rotator cuff cast can stop me from blogging this... PowerShell 2.0 CTP is now available!

I won't get to play for weeks, sadly. So...on an unrelated note; anyone know what's the best dictation software out there? Thanks.

If you've ever dealt with NTFS permissions in VBScript, you will no doubt appreciate just how easy PowerShell now makes it to manage access control lists. Basic examples in PowerShell books and around the 'net look something like this:

$directory = "Test" $acl = Get-Acl $directory $accessrule = New-Object …

This code has been in my drafts box for 2 years. I figured I'd just go ahead and publish it, though I'm unsure of the context now.

 1$dom = [System.DirectoryServices.ActiveDirectory.Domain]::GetCurrentDomain()
 2$root = $dom.GetDirectoryEntry()
 3$search = [System.DirectoryServices.DirectorySearcher]$root
 4 …