Welcome to MSDN Blogs Sign in | Join | Help

August 2007 - Posts

SYSK 361: On the importance of signing assemblies from the versioning perspective

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 of
Posted by irenak | 0 Comments

:) When was the color khaki first used for military uniforms?

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.
Posted by irenak | 5 Comments

SYSK 360: What’s taking up the space in my database? Also, a word about SQL reports…

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 query to
Posted by irenak | 3 Comments
Filed under:

SYSK 359: How to Purge Workflow Tracking Data Inserted By SqlTrackingService

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
Posted by irenak | 1 Comments

:) What color was named after a bloody 19th-centurey European battle?

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 after
Posted by irenak | 2 Comments

SYSK 358: Run Rules Automatically When an Event Is Triggered

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
Posted by irenak | 1 Comments

SYSK 357: SQL Server Login Problem on Fresh Installation in Vista

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 resolve
Posted by irenak | 2 Comments
Filed under:
 
Page view tracker