Sunday, January 24, 2010

Silverlight SSAS analyzer

Awesome project on google code... all that's missing right now is graphing  :

would post a review once I use it ... right now still "mastering" silverlight .... i like to read lots of books before I start coding on something new (after an initial dip ofcourse!).

PS: Here are some commercial Silverlight SSAS tools I found:
And the VERY promising :

Right now I am reading:

Pro silverlight 3 in c# 2008
Foundation of expression blend 3 with silverlight

so it may be some time.

Saturday, January 23, 2010

Silverlight physics library

Continuing my research into all the available useful tools and libraries for silverlight programming I came across this:

Seems highly promising!

Thursday, January 14, 2010

Colors for Thematic Maps

Colors play a vital role in the effectiveness of thematic maps. Get the colors wrong and the thematic is pointless. Fortunately colorbrew makes it easy for upto 12 data values:
and now a version 2:

Friday, January 8, 2010

Noob Misinformation upon migration from Access to SQL Server

In access using a single table for getting complicated queries , it is not uncommon to see loads of temporary queries.
However in SQL server you have the feature of "Derived tables" which are basically SQL Selects embedded / named and reused in a larger query. You can still use views ( Stored queries in SQL Server) for performance benefits but to keep things clean don't make too many views if they are just going to be a part of some cooler query and you think that views help understand better. They don't (generally they just get cluttered) and derived tables are so much cooler :).

Sql query inside an sql query for peace of mind :)  and you know immediately how its being used.

Read more here :


Unable to modify table. Timeout expired.

If you add a column to huge table using ssms you may get this error:

"Unable to modify table.   Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding."

Simple solution : Tools > Options -> Designers

Set the time out to some large value in seconds (default is 30 which is half a minute) .I like 600 (6 minutes) for the sizes of data that I deal with.

Do note that you will not be notified of any errors till the end of this duration (e.g. sudden network drops). SSMS will also hang for the entire duration. Be patient and don't over do the value unless you intend to leave it working overnight :)