SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


One System to Rule Them All


One System to Rule Them All

Author
Message
chrisn-585491
chrisn-585491
SSCommitted
SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)

Group: General Forum Members
Points: 1995 Visits: 2441
I think that's called picking the right tool for the job, which is something I'm a big proponent of as a whole.


I believe that's what the editorial was espousing. Magic bullets aren't. One size doesn't fit all. Yada, yada, yada...

Example: Many experienced folks find that SSRS isn't what they need even though it comes along with the rest of the SS tools. So they use Tableau. I may end up using ReportLab or D3.js for some clients.

We don't use much of SSIS at remote clients because it's yet another system that is to complex for them to manage. Instead they get custom executable and scheduling.
Doug Lowing-447866
Doug Lowing-447866
Forum Newbie
Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)

Group: General Forum Members
Points: 1 Visits: 63
Andrew..Peterson (8/13/2014). And some exec's like the idea of having a single company to call when it breaks.

It is never the exec that makes the call or deals with the fallout. Effective single source is a fantasy that execs are prone to believe.

The Air Force, Navy, any large company wants the single off-the shelf product that will meet all their specific needs - at off-the-shelf prices. No surprise, it suddenly needs add-ons to meet their specific needs that cause complexity and cost overruns. As one poster said, openess and offering proper imports and exports go a long way towards reducing cost.
Thomas Abraham
Thomas Abraham
SSCrazy
SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)

Group: General Forum Members
Points: 2767 Visits: 2255
When I worked at Intel In the mid-90's, we were growing so fast that a universal system couldn't handle the needs of the local groups fast enough. So, we had a lot of "smokestacks", home-grown applications and databases to solve the local need.

That, of course lead to problems with different piles of data being shared and analyzed. Our team was tasked with coming up with shared data models, and translations to them. The hope was to foster the shared usage of data from many different sources. The message was, "roll your own, but use our data definitions".

Unfortunately we saw limited results due to incomplete buy-in of the business units. Then they brought in dozens of SAP "consultants" (many newly minted college grads who had never seen a real world mess), and things got REALLY interesting.

Please don't go. The drones need you. They look up to you.
Connect to me on LinkedIn
xsevensinzx
xsevensinzx
SSCrazy
SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)

Group: General Forum Members
Points: 2107 Visits: 2719
I'm not a firm believer of one system to rule them all. But, I can see the attraction from a business standpoint.

If there was a single piece of software or solution that handled all my needs, then yes, it's the best option. Having used Outlook for some time, I would really hate having to use 2 separate programs for my email and calendar or better yet, a 3 program for task management if I actually used Outlooks tasks. I instead, would love to have all those features in one solution that's accessible together.

That means I only need to likely hire one person at the very least versus 2 hires to support both solutions.

When you get into solutions that are a rainbow of different technologies and solutions integrated into a unified solution, then you have what many of you guys run into today. Businesses requiring those one hire to rule them all. The one guy who not only is a DBA, but also a back-end developer and front-end developer who speaks 5 different languages.
Chris93147
Chris93147
SSC Veteran
SSC Veteran (212 reputation)SSC Veteran (212 reputation)SSC Veteran (212 reputation)SSC Veteran (212 reputation)SSC Veteran (212 reputation)SSC Veteran (212 reputation)SSC Veteran (212 reputation)SSC Veteran (212 reputation)

Group: General Forum Members
Points: 212 Visits: 389
I work as a DBA/support/setup/and too many things to mention for a 3rd party software vendor. We've witnessed a number of our clients leave in search of that "magic bullet" software bundle that does everything and does them all well "out of the box". And many, though not all, come back to us complaining that the software did do a lot, but lacked in many areas.

In response, we've tried to stay focused on a specific goal and be the best we can be in that area. Certainly it costs us some sales, but we feel in the end it's worth the sacrifice for our current and future clients. Time will tell if we've made the right choice.
Eric M Russell
Eric M Russell
SSChampion
SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)

Group: General Forum Members
Points: 12534 Visits: 10693
Using the MS SQL Server, MS Office, and MS VisualStudio stack, you can build practically any IT solution, and it integrates well. Often times the tools will integrate, but the missing link is the limited skillset of the developers themseleves.


"The universe is complicated and for the most part beyond your control, but your life is only as complicated as you choose it to be."
jcb
jcb
SSCrazy
SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)

Group: General Forum Members
Points: 2880 Visits: 994
Funny thing is for some view points MS SQL Server is a "rule them all" system.

(and let's not forgot that good tools integrated to it like red gate) :-D

The fact is a monolithic system ill not adehere to all different business rules from all different companies even if we are considering a small market subset.
That companies are different, work in a different way, got different process, mothods, budgets, etc
Even considering a single company the scenario changes when the company evolves year after year.

In that way I agree with the customized solution tailored for that company (in that point in time).

Off course there are good generic solutions for good generic problems.
And yes sometimes no ones wants the burden to build and maintain a dashboard application with good reasons
jrlandeen
jrlandeen
Forum Newbie
Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)

Group: General Forum Members
Points: 3 Visits: 9
I think a lot of focus has been placed on the software/solution/product/magic bullet here and not enough on the teams architecting requirements and architecting a solution. I find a lot of clients want the "off the shelf system that meets all my current requirements exactly as I see them" and in a lot of cases that means something that does what they had made their previous systems do. This leads to a lot of complexity and no one on the customer's side wants to take a step back and ask if those requirements truly are necessary.

Then if they are necessary do they need to be met exactly the way originally defined - I've had to build the "easy" button that does 4 things at once because it was too difficult for them to make someone push 4 buttons. If the client could tolerate their users using their brains and doing a small bit of work (or maybe following a process) than the system could be less complicated, require less development and be easier to maintain. Basically clients that can tolerate small tweaks to requirements or processes so as to make the actual solution less technically complicated or simpler get better results.

However as this was for large bureaucratic organization I would suspect (based on my experiences) that there were a lot of requirements that got very detailed, very complicated, just so people could cover their ***, but bloated the complexity. If those dictating the requirements can't see they're shooting themselves in the foot like that, and their consultants don't help them to pull back...well they were probably going to go over budget or have problems even before things got started.
Eric M Russell
Eric M Russell
SSChampion
SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)

Group: General Forum Members
Points: 12534 Visits: 10693
I'm not saying that the Microsoft development stack should be used for building the Air Force's mission critical systems (ie: deployed in the field in Iraq). A strong an compelling argument for open source development tools can be made in this situation, even if the tools require additional man hours and skillsets to integrate.

However, if what they're looking for is an application and database to crunch accounting numbers and a BI solution to display pretty charts and reports for Congress, then nothing beats Microsoft.


"The universe is complicated and for the most part beyond your control, but your life is only as complicated as you choose it to be."
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search