Welcome to Salvo(z)

Converting from Word Press to Static Content Site

Monday, January 1, 2018
by asalvo

My salvoz.com blog site went through numerous iterations over the years, both in hosting and blogging platform. It initially was self-hosted on DasBlog, then moved to GoDaddy, and finally to WordPress and MediaTemple for hosting.

read more...

Detecting Device Idiom on Xamarin UITest

Tuesday, August 23, 2016
by asalvo

When writing UI Tests with Xamarin UITest, you may want to take a different action when testing on a tablet form factor (idiom) or phone. There is some built in support in Xamarin UITest for detecting this on the iOS side, but nothing on the Android side. The solution I came up with was to use a backdoor method to give me the information I needed.

read more...

SSMS run as different user

Sunday, April 19, 2015
by jsalvo

Run SSMS as user specified by <username>:

read more...

Rolling X month / X week calculations in MDX using NonEmpty

Sunday, April 12, 2015
by jsalvo

Implementing a rolling x month or x week calculation in MDX is relatively straightforward if you have a calendar hierarchy in the multi-dimensional cube.  In some cases, you may only want to include dates where a measure is non-empty.  For example, if a user selects the current month, you may not want to include any future weeks that are empty in the rolling calculation.

read more...

Rolling X months / X weeks calculations in DAX

Sunday, April 12, 2015
by jsalvo

I recently implemented rolling 12 month and rolling 6 week measures in a SSAS tabular cube for product registration counts.

read more...