We have an on premises MDX cube I'm trying to retire that has been 95% recreated as an Azure Analysis Services cube. But we do have some capable citizen developers...

Mr. Brian Gale,

Thank you so much for your well thought out and detailed response. I'll be sharing these ideas/suggestions back with our network/VM environment folks and see what we can...

Looking to see if a tenant has a rent increase, only bringing back the first one...

WITH PREP AS(

select

ROW_NUMBER() OVER(partition by BU.bu_id, vUnits.UnitNumber order by RS.IncreaseStartDate) as 'RowNumber',

UnitNumber,UnitSF, Lease,...

Great song! 13 songs is a great album. Waiting room is still heavy in my rotation.

I was curious as to which Fugazi song it was. They are one of my favorites.

Very cool exercise. I needed to revise the create table T-SQL to the code below in order for it to work for me.

-- Check if destination table already exists,...

I've built a few of the CREATOLOGY crafts with my five year old son, but if you want to keep your sanity, avoid the sailing ship one at all costs....

Update--I found the correct driver and installed mysql-connector-odbc-5.1.4-winx64.msi

and created the ODBC connection in the 64 bit ODBC administrator--test connection worked fine. When I went back to SQL to try...

Hello, could you please document your steps to create a linked server in 64 bit? I haven't had any luck.

My Steps

1. Download and install mysql-connector-odbc-5.1.4-win32.msi on my Windows 2003...