Applied Visual Studio Team System

Digging my new Zune!

I wanted a personal player, did some research, and decided to give the Zune a try.

So far I like it a lot! It has 30G of storage and a nice big screen (important for us old guys...). I'm still learning all the features, but playing music is pretty straightforward on it. I can attest Van Zant, Brad Paisley, Johnny Cash, and Waylon sound just fine on it. ;)

Now all I have to do is figure out some way to load SQL Server Compact.

:{> Andy

Technorati Tags: Zune Van Zant Brad Paisley Johnny Cash Waylon Jennings SQL Server Compact

Vista and SQL Server Mixed-Mode

I've been traveling the continent the past few months warning people of the evils of SQL Server Mixed Mode authentication. I recently (this past weekend) procured a snappy new Gateway laptop with Vista installed.

It turns out SQL Server 2005 installed on Vista does not automatically add members of the local Administrators group to the SQL Server role BUILTIN\Administrators. Rather than waste lots of time reading the readme files, I discovered this when I tried to connect to freshly-installed SQL Server instance.

So after re-installing SQL Server in Mixed Mode and logging in as sa, I was able to add myself as a sysadmin. Afterwards, I changed the instance from Mixed Mode to Windows Authentication. Windows Authentication is still more secure.

Thank you, Slammer worm...

:{> Andy

Technorati Tags: SQL Server 2005 Vista Mixed Mode Windows Authentication security Slammer