Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Architecture advice for (very) small business, please? Expand / Collapse
Posted Tuesday, April 23, 2013 3:46 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, November 16, 2016 2:03 AM
Points: 1,223, Visits: 869
Dear all,

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?

Many Thanks


PS: I'd rather stay in the Microsoft world (again for lurning curve reason)
Post #1445333
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse