There are many reasons for signing your assemblies (security being at the top of my list), but in this post I’d like to address the importance of using a key to sign your assemblies from the versioning point of view. Now, let’s assume for the sake...

It was first used by the British in India in 1845, when soldiers turned their highly visible white uniforms khaki by soaking them in mud, coffee, and curry and better blend in with the landscape. Source: The 365 amazing trivia facts calendar 2007...

So, you’ve updated usage stats on your database by running EXEC sp_spaceused @updateusage = N 'TRUE' But, you still can’t figure out why it’s reporting much more used space then the data that appears in your tables… Try running the following...

To my great surprise, after doing a search for a script that would delete the events logged by the almighty SqlTrackingService service, I didn’t find one… So, I quickly created it (see below), and it seems to do the job just fine given the current table...

Answer: Magenta. It was named for the Battle of Magenta, which was fought in 1859 near the town of Magenta in northern Italy during the Franco-Piedmontese war against Austria. The deep purplish color – on of the first dyes – was discovered soon...

Imagine this: you’re writing a custom user control and you’d like to execute a WWF ruleset when a certain event happens, e.g. a data context changes. Of course, you could create a delegate for the event and write a few lines of code to validate and execute...

I just installed SQL Server 2008 CTP (Katmai) and all the patches on my Vista laptop… However, trying to login using SQL Management Studio or osql using integrated security (and, yes, I’m an admin on my box) results in the “login failed” error. To...