I've started listening to the SQL Down Under Podcast from Episode 01 onwards and it has been boggling my mind the amazing grip on SQL Server these MVPs had a decade ago… sometimes even more than me today! Plus they sure seemed to revere SQL Server 7 a lot!

But I've also been putting together a list of old books to review out of curiosity and to fill in some holes in my knowledge. As far back as I'll go is the SQL Server 2000 Resource Kit which is available for download to MSDN subscribers, but it comes with a bunch of PostScript files (and other useless formats) instead of PDF.

But I came up with a way to convert it all over on Mac, with a little help. First some PowerShell.

$fileList = "a02T612668.ps
a03L612668.ps
A04D612668.cbn
A05T612668.cbn
P01612668.cbn
C01612668.cbn
C02612668.cbn
P02612668.cbn
C03612668.cbn
C04612668.cbn
C05612668.cbn
C06612668.cbn
C07612668.cbn
P03612668.cbn
C08612668.cbn
C09612668.cbn
C10612668.cbn
C11612668.cbn
P04612668.cbn
C12612668.cbn
C13612668.cbn
C14612668.cbn
C15612668.cbn
C16612668.cbn
P05612668.cbn
C17612668.cbn
C18612668.cbn
C19612668.cbn
C20612668.cbn
C21612668.cbn
P06612668.cbn
C22612668.cbn
C23612668.cbn
C24612668.cbn
C25612668.cbn
C26612668.cbn
P07612668.cbn
C27612668.cbn
C28612668.cbn
P08612668.cbn
C29612668.cbn
C30612668.cbn
P09612668.cbn
C31612668.cbn
C32612668.cbn
P10612668.cbn
C33612668.cbn
C34612668.cbn
C35612668.cbn
C36612668.cbn
C37612668.cbn
C38612668.cbn
P11612668.cbn
C39612668.cbn
Z01B612668.cbn
Z02I612668.cbn
zlic612668.ps
zsysreq612668.ps" -Split [Environment]::NewLine

Set-Location PSFILES
if (!(Test-Path Output)) {
	New-Item -ItemType Directory Output
}

$i = 1
foreach ($file in $fileList) {
    $fileName = "$($i.ToString().PadLeft(2, "0")).ps"
    Copy-Item $file "Output\$fileName"
    Write-Host "pstopdf $filename"
    $i++
}
Write-Host "`"/System/Library/Automator/Combine PDF Pages.action/Contents/Resources/join.py`" -o Final.pdf *.pdf"

This basically just numbers the files according to a pre-flight document that I found elsewhere on the CD download and puts them into an Output directory which you need to move to your Mac. Then open up a Mac Terminal session and run the output of the script, which will be:

pstopdf 01.ps
pstopdf 02.ps
pstopdf 03.ps
pstopdf 04.ps
pstopdf 05.ps
pstopdf 06.ps
pstopdf 07.ps
pstopdf 08.ps
pstopdf 09.ps
pstopdf 10.ps
pstopdf 11.ps
pstopdf 12.ps
pstopdf 13.ps
pstopdf 14.ps
pstopdf 15.ps
pstopdf 16.ps
pstopdf 17.ps
pstopdf 18.ps
pstopdf 19.ps
pstopdf 20.ps
pstopdf 21.ps
pstopdf 22.ps
pstopdf 23.ps
pstopdf 24.ps
pstopdf 25.ps
pstopdf 26.ps
pstopdf 27.ps
pstopdf 28.ps
pstopdf 29.ps
pstopdf 30.ps
pstopdf 31.ps
pstopdf 32.ps
pstopdf 33.ps
pstopdf 34.ps
pstopdf 35.ps
pstopdf 36.ps
pstopdf 37.ps
pstopdf 38.ps
pstopdf 39.ps
pstopdf 40.ps
pstopdf 41.ps
pstopdf 42.ps
pstopdf 43.ps
pstopdf 44.ps
pstopdf 45.ps
pstopdf 46.ps
pstopdf 47.ps
pstopdf 48.ps
pstopdf 49.ps
pstopdf 50.ps
pstopdf 51.ps
pstopdf 52.ps
pstopdf 53.ps
pstopdf 54.ps
pstopdf 55.ps
pstopdf 56.ps
pstopdf 57.ps
pstopdf 58.ps
"/System/Library/Automator/Combine PDF Pages.action/Contents/Resources/join.py" -o Final.pdf *.pdf

You end up with a Final.pdf which has the complete book - sans a front cover, which you can add manually using Mac's Preview.app from the X0804969CD\STARTCD\COVER.BMP file.

Weird, I know, but I wanted the PDF to complete my library.