What are good Win 8 Metro Apps for WordPress authoring?

I would prefer a Windows 8 Metro app, and not a 'traditional' app for WordPress. I host my own blog (http://desigeek.com) and need to update that.

View Question on Quora

What are some fun things to do in Amsterdam with a 2.5 yr old?

We will be travelling with a Toddler (2.5 yrs) to Amsterdam and wanted to know what suggestions one has to keep her engaged, excited, and busy?

View Question on Quora

SQL Performance and navchar(MAX)

At work we had an issue where our sql performance (SQL Server 2005) was very slow – much slower than we needed and everything looked OK but in the production environment (to which we don't have access – rightfully) things were not ticking as they should be. We had a requirement to be able to process ~200K / hour and we were barely managing ~ 44K / day! Ouch!

As it turns out, the solution in the end after a lot of digging and flapping around was changing the type of one of the columns which was defined as a nvarchar(MAX) to a nvarchar(400). The data we were storing in this column can easily fit within 400 characters and we don't need the MAX. The reason this helped is because a MAX is not indexable. The database was flagging this as warning but this was missed. Changing this increased our perf. from the measly 44K records being processed in 24 hours to processing 410.0K records in 16 minutes! Sweet!

So the lesson is, if you got a MAX column it cannot be indexable.

Reflector SQL Server 2005 Addin

Denis has an addin to Reflector for SQL Server 2005 (Yukon). that can be used to browse .NET assemblies stored in a SQL Server 2005 (Yukon) database. You can connect your local Reflector installation to a remote SQL Server instance, list the databases and its assemblies and download them directly into .NET Reflector. Once my issues with Whidbey are resolved, I will check this out.

[Listening to: Track 02 – New Artist (38) – New Title (38) (04:48)]