Recently, I noticed errors occuring daily at 2:00AM on my SQL Cluster. The errors showed Windows logins being routed to the wrong named instances, along with errors from SQL Browser not being able to service client requests. I noticed that all of the instances being affected were SQL Server 2008, but never any of my …

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.

I'm so excited -- my best friend and tech partner-in-crime, Brandon, recently picked up PowerShell after I gave him a copy of Wrox's Professional PowerShell. He totally loves it and has already created a few new PowerShell scripts and converted other ASP.NET/VBScript scripts. One of his favorite scripts checks the …

While my firm explores using WebDAV and SharePoint 2007 for exchanging large amounts of files, we're temporarily using FTP dropboxes to fill the void. Last Monday, I setup 11 new accounts and it took a total of one hour to complete the same 15 step process (give or take) for each account. By the time I was finished, I …

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$search.Filter …

So I'm making the move to PowerShell. It's painful learning such alien (to me) concepts but books like Lee Holmes' PowerShell: The Definitive Guide help a ton. I was fortunate enough to be the editor for Chapters 1-5 and got a sneak preview. It's a fantastic book and can't wait to receive the title, complete with …

When creating a new Active Directory user from the command line in PowerShell, you will likely find yourself using Read-Hosts's asSecureString switch when entering the password. $password = Read-Host "Enter password" -AsSecureString Next, you'll probably look around the Internets for a few hours or so trying …