For those of you living in the Bay Area, SuperHappyDevHouse is going on today. I'll likely make a late arrival after I pick up my broken server in San Jose.
WTF is SHDH, you ask? "DevHouse is not a marketing event. It's a non-exclusive event intended for passionate and creative technical people that want to have …
Read More- Recently, I contemplated getting a Vespa again but decided, instead, to stick with my pretty but slow bicycle. My commute is about 2 miles but using San Francisco's public transportation, generally takes 26 minutes from door to door. Too long! I can get there on my bike in 16 minutes but I have to drive in traffic, …
Read More - 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 …
Read More 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 …
Read MoreThis 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 …
Read More- 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 …
Read More 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 …
Read More- While researching for a paper I have to write in class about hierarchical data in relational databases, I was reading Joe Celko's book Trees and Hierarchies in SQL for Smarties. In the intro, he mentions a really useful website for validating SQL-92, SQL-99 and SQL-2003. The site is nice enough but could really benefit …
Read More Looking for the T-SQL (somewhat) equivalent to VBScript's FormatDateTime function? I've been too, for years. I finally found it within the CONVERT() function. As stated in SQL Server Books Online:
In CONVERT ( data_type [ ( length ) ] , expression [ , style ] ), style is the style of the date format used to convert …
Read More- For my final project in my database class at USF, I chose to create a database for a small record label looking to sell albums online as well as provide artist bios, tour information and news. The database, which was scaled down version of a project I worked on in the past, looked something like this: …
Read More