In my day to day job, I work in corporate environment as DBA/Developer contractor with usual things like ASP.Net, Sharepoint, etc...
At "night" (...), I also work for smaller businesses, in particular for my preferred customer (aka my wife).
So far, I supplied them a (single user) BI solution made of a SQL Server back-end (2012 Express) with MS Access 2010 front-end for data maintenance and Excel 2010 Powerpivot for reporting.
The problem is that I work on "shoe string" budgets and have no server (backups???) so I would like to improve by moving the database to SQL Database (cloud).
I have played a bit and it looks like everything would still work fine with both PowerPivot and Access but I am a bit worried about the security aspect of the connection string and the fact that some of the new users are "mobile" and might not have a permanent IP address (hence SQL Database firewall configuration issue).
I wonder whether I should not shift my Access front-end for some kind of (simple) cloud based app.
My requirements are quite simple.
Have you got any suggestions? I am trying to avoid difficult learning curves.
A couple of years ago, I was writing ASP.Net / Ajax front-end but I am extremely rusty now.
Is Microsoft Light Switch the way to go?
PS: I'd rather stay in the Microsoft world (again for lurning curve reason)