More often than not a site build is deployed with little focus on analytics or any kind of measurement in mind- or, if it was; it was built against a moving target which is now little help to the current Read More
EASILY Bulk Load files into a table with different columns
with NO FORMAT FILE! I consider this a gem just hiding on the MSDN docs : Using BULK IMPORT on a View The following example creates the v_myTestSkipCol on the myTestSkipCol table. This view skips the second table column, Col2. Read More
Get Value from XMLA result file in NAnt with xmlpeek
If I got paid for every hour spent wrangling with XML… Oh wait, I do Problem: Read a scalar-result out of an XMLA response file from an MDX query run against a cube. Store it in a NAnt property. Jiest Read More
Get current domain from NAnt
I use NAnt for a build and deployment tool for databases and OLAP. I wanted to be able to add only the accounts needed per-environment to certain objects on the fly through the script, as they are run on whatever Read More
Analysis Services Add role members programmatically in C#
First, I don’t know why; but it seems like as soon as you add in the word OLAP or Analysis Services to your problem things just stop working as you would normally expect. Problem: I’m using NAnt as a deployment Read More
SimpleDB: non printable charachters
“this is my sweet string” == “dGhpcyBpcyBteSBzd2VldCBzdHJpbmcZ”? Those two are actually equivalent, as proven by Amazon SimpleDB. We started seeing these mysterious strings in our SimpleDB data which is supposed to be a direct upload of SQL data for use Read More