Determine Authentication Mode for MSSQL

Check the LoginMode registry key. The path for this key for each version can be found below.

If the value is 1, it's Windows Authentication. If the value is 2, it's Mixed Mode Authentication.

For 2000: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\' + @sqlpath + '\MSSQLServer\

For 2005: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\MSSQLServer\


For 2008: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQLServer\

PDF Compression Trick

Adobe doesn't offer too many options in Photoshop to reduce the size of a PDF. If you use JPEG compression and move the slider to 0 quality, you'll wind up with an ugly PDF that only saved you 1MB. I was able to cut the size of my test PDF in half (~3MB) by first printing to XPS and then using XPS2PDF. If you're on Linux, you might be able to do something similar by going to PS and then back to PDF.

Another way to compress your Photoshop PDF is to use a PDF print driver like PDF995. The same PDF which got cut to 3.5MB using the above method was cut down to 1.5MB using PDF995.