Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 123»»»

No Handwaving Away the DBA Expand / Collapse
Author
Message
Posted Wednesday, May 7, 2014 8:30 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 8:53 AM
Points: 31,040, Visits: 15,468
Comments posted to this topic are about the item No Handwaving Away the DBA






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1568748
Posted Thursday, May 8, 2014 2:10 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 9:06 AM
Points: 5,438, Visits: 3,188
At the moment there appears to be a number of schools of thought that are being misappropriated and misapplied in ways which are suggesting that important roles and duties are not going to be performed properly. Along with NoSQL, agile is one of these.

Steve, you highlighted the NoSQL movement encouraging a "no DBA" duties/roles and agile can be misapplied to remove architecting, documentation, all testing but unit testing etc as well as attempting to circumvent DBAs.

I know that the leaders of these movements believe that this not the right way to go but that many of the implementers on the ground have conveniently forgotten or avoided reading the small print. It is up to all of us to remain strong and speak up.


Gaz

-- Stop your grinnin' and drop your linen...they're everywhere!!!
Post #1568793
Posted Thursday, May 8, 2014 5:31 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Today @ 12:17 AM
Points: 50, Visits: 344
Gary Varga (5/8/2014)
....but that many of the implementers on the ground have conveniently forgotten or avoided reading the small print. .....


Remember when companies were downsizing because a guru said so. Apparently, that guru said "Some companies need to downsize". Cant see the industry based on logic falling for the same style of mistake....

There are also a number of people who will jump onto a NOSql bandwagon thinking that it means NoSQL ( Not Only SQL vs No SQL ). There will be enough companies out there that will go through the pain, until the next greatest thing is suggested.
Post #1568835
Posted Thursday, May 8, 2014 7:37 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 7:58 AM
Points: 1,660, Visits: 4,753
In some sense the DevOps movement is built around merging these two frames of reference into the minds of all those involved. I hope that movement continues to grow and mature, and we learn that developers and operational staff are both necessary, and both need to function in a symbiotic, harmonious fashion.

Oh, I'm sure that for many of us, development and operations are of the same mind and have a very symbiotic relationship to each other. The developer side of my mind has a conversation with operations while driving into work, and then operations has plenty to say back and the end of the day. Now if only I keep both sides in harmony.
Post #1568888
Posted Thursday, May 8, 2014 7:55 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Today @ 7:21 AM
Points: 341, Visits: 2,454

I do think NoSQL has a place in the world. There are domains of problems that I'm sure Riak, MongoDB, and others, solve in a more efficient way than SQL Server, Oracle, MySQL, and other relational systems. I'm not sure what they are, and to some extent, I haven't seen good guidance on where particular platforms excel.


This might be a nice start:

http://readwrite.com/2011/02/03/the-big-list-of-nosql-use-case

One case I personally like that calls for a non-sql solution is a need for fast RBAR. With SQL Server, you either get pokey single row selects, inserts and updates, or nice and fast set oriented operations. What about fast RBAR?

I do hold out hope that SQL Server 2014 might address this.
Post #1568898
Posted Thursday, May 8, 2014 8:12 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 7:58 AM
Points: 1,660, Visits: 4,753
Obviously running ad-hoc queries against unstructured data is a use case for a NoSQL database, and MongoDB is good for that. This would include things like ecommerce shopping carts and other memcache type data. However, once the user clicks the final purchase button, then you want your order entry and fullfillment system running SQL Server.

There are also cases where very large raw files are injested from external sources, but only some columns and a much smaller subset of records are operationally useful and worthy for ETL into a normalized relational database. However, there may still be a need to retain a complete history of all these files in some online queryable fashion for archival or exploratory purposes. The DBA would prefer not to use SQL Server as a dumping ground for that type of thing. So, Hadoop to the rescue.

So, yes, are occasions where it's very useful to dump things on NoSQL. Find space for it on the rack and put it to work.
Post #1568912
Posted Thursday, May 8, 2014 8:14 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 9:06 AM
Points: 5,438, Visits: 3,188
Eric M Russell (5/8/2014)
In some sense the DevOps movement is built around merging these two frames of reference into the minds of all those involved. I hope that movement continues to grow and mature, and we learn that developers and operational staff are both necessary, and both need to function in a symbiotic, harmonious fashion.

Oh, I'm sure that for many of us, development and operations are of the same mind and have a very symbiotic relationship to each other. The developer side of my mind has a conversation with operations while driving into work, and then operations has plenty to say back and the end of the day. Now if only I keep both sides in harmony.


I found that list to be a load of hot air e.g. Easier maintainability, administration and operations.

Try maintaining a NoSQL database for a bitcoins exchange


Gaz

-- Stop your grinnin' and drop your linen...they're everywhere!!!
Post #1568914
Posted Thursday, May 8, 2014 9:11 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Thursday, September 18, 2014 10:35 AM
Points: 1,825, Visits: 2,175
I remember when fellow grad students (in 1993) looked down at me because I was focusing on RDBMS's, while they were all gaga for Object-Oriented DBMS's. Relational systems were so old school. The future was all OO, and I was wasting my time, they said.

Still waiting for something that is truly better. Meanwhile, I'm very happy to work in a relational, SQL world.


Please don't go. The drones need you. They look up to you.
Connect to me on LinkedIn
Post #1568966
Posted Thursday, May 8, 2014 9:38 AM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, September 16, 2014 4:28 PM
Points: 214, Visits: 619
"...if you think that switching to NoSQL will just let you hand-wave away all of the challenges of running a database, you are terribly misguided."

But it seems increasingly there is the effect (if not necessarily the conscious effort) to 'hand-wave away the DBA' -- by moving to cloud-based SaaS, and by consuming web services (rather than making direct database calls) within Ajax-type applications.

Without a doubt, competent DBAs will always be needed -- but the direct exposure developers have to them will likely decrease because of the evolution of application design and infrastructure.
Post #1568988
Posted Thursday, May 8, 2014 11:05 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, May 8, 2014 10:59 AM
Points: 1, Visits: 5
It seems to me that Microsoft's increasingly aggressive licensing costs for SQL Server 2012 and, worse, 2014, are hastening the impetus to look at alternatives even among relational db vendors.

It seems that the price was too good, the performance too predictable, and the operational support far too mature for too long. Now company executives are balking with sticker shock and looking for a place to hide while mourning their budgets.

As a data architect, I feel Microsoft is nudging the bayonet in the backs of companies who walk the plank towards Open Source relational and non-relational stores. Good, bad, or indifferent, they will turn this migration into a stampede.

Post #1569028
« Prev Topic | Next Topic »

Add to briefcase 123»»»

Permissions Expand / Collapse