Functionality, Ramen Noodles, and MS Access
I have an interesting meeting tomorrow with one of the Server Jockeys in our organization.
Our Server Administration Team, like many others, has an assortment of databases they wish to aggregate and query against in the fashion of a typical dashboard. There is no issue with doing so per-se; I encourage my colleagues to better-acquaint themselves with the data, meta-data, and mega-meta-mondo-data that they rely on constantly, but usually in a passive (or even dismissive) state. The issue I have comes with their tool of choice in developing this functionality: Microsoft Access.
I really would like to orchestrate a move towards SQL Server Reporting Services. To my knowledge there is no ancillary (lookup table) data that will need to be created and stored into MS Access tables – the data is complete across the five databases they are planning on querying against.
Functional, surely, but if SQL Server is hauling this around it is going to slow down a bit.
MS Access is like that package of chicken ramen noodles that has taken up residence in your desk drawer. It is there when all better options are exhausted. Not that there is anything wrong with ramen noodles, it’s the food that fuels the developing minds of our future scientists, economists, engineers, exotic dancers (every one you meet is working her way through college it seems), and all other university students at one point or another. It indeed satisfies the immediate hunger or qualms the hangover, mission accomplished style. Ramen as your core dietary source of nutrition? Not recommended. The same goes for MS Access. It’s fine here and there when you perhaps need a quick fix when all else fails or when the means to better accomplish the task at hand is unavailable, but as the long-term solution to dashboarding against Tier-1 applications for an enterprise of 15,000 users? No thank you. I’ve seen this in play before. Someone begins using MS Access for a simple solution to a small issue they’re confronting. One, two, or even five years later they’ve cobbled together something functional, but monstrous at the same time.
How have others overcome this dilema and introduced SQL Server Reporting Services to an audience that has not been exposed to it and don’t have technical knowlege to quickly embrace its functionality? Be so kind to please share your experiences here. Not just for me, but for others to learn from as well.
first off, you have a lovely summer home. that must be the type of home Kid Rock was thinking about when he sang about Northern Michigan in “Summertime”.
Second, i snickered when you said ‘Access’. is that wrong?
I will have to agree with @SQLRockstar the additions to your home have turned out beautiful. I like that you chose to go with no steps, always thinking about fitness.
I agree with the point that MS Access can quench an immediate need but the problem is like the story about giving a mouse a cookie. I have to support an Access database that someone created and they keep wanting additional functionality without rewriting it as a full SQL app, even when it is necessary.
The point is be careful what you give to end users because it can cause you lots of heartburn and grey hair later on.
We are facing a similar situation, so I’m very curious to hear the response you’ll get. The majority of our organization’s data is in Access databases, most undocumented. There is a push from management for centralized data collection, but it’s a struggle first off when most of the data is not documented. Staff are reluctant to hand off their data because they lose control of it. And once it’s centralized, how do they access it?
A few ideas like SQL Reporting Services have been tossed around, but to me, it seems like a nightmare to configure SSRS to enable access to multitudes of small datasets. And then we have the added issue of writing back to the databases with updates.
So the easy out is to continue to use Access and give more Access training, instead of what I think is more important, teaching people how to query data, regardless of the tool.
great pic… i may have skimmed and scanned had you not had the lol pic.
motivated individuals seem to like 2008 r2 rs. The upgrade wasn’t a problem and they enjoyed the expanded learning curve.
I don’t think i would consider access a crutch as you explain it… more of a phase-out piece of software since sql express is free.