Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


No Handwaving Away the DBA


No Handwaving Away the DBA

Author
Message
Steve Jones
Steve Jones
SSC-Forever
SSC-Forever (42K reputation)SSC-Forever (42K reputation)SSC-Forever (42K reputation)SSC-Forever (42K reputation)SSC-Forever (42K reputation)SSC-Forever (42K reputation)SSC-Forever (42K reputation)SSC-Forever (42K reputation)

Group: Administrators
Points: 42144 Visits: 18876
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
My Blog: www.voiceofthedba.com
Gary Varga
Gary Varga
SSChampion
SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)

Group: General Forum Members
Points: 10654 Visits: 6355
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!!!
Yet Another DBA
Yet Another DBA
SSC Veteran
SSC Veteran (265 reputation)SSC Veteran (265 reputation)SSC Veteran (265 reputation)SSC Veteran (265 reputation)SSC Veteran (265 reputation)SSC Veteran (265 reputation)SSC Veteran (265 reputation)SSC Veteran (265 reputation)

Group: General Forum Members
Points: 265 Visits: 1222
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.
Eric M Russell
Eric M Russell
SSCertifiable
SSCertifiable (6.7K reputation)SSCertifiable (6.7K reputation)SSCertifiable (6.7K reputation)SSCertifiable (6.7K reputation)SSCertifiable (6.7K reputation)SSCertifiable (6.7K reputation)SSCertifiable (6.7K reputation)SSCertifiable (6.7K reputation)

Group: General Forum Members
Points: 6708 Visits: 10066
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. :-)


"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."
patrickmcginnis59 10839
patrickmcginnis59 10839
Ten Centuries
Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)

Group: General Forum Members
Points: 1100 Visits: 5249

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.

to properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
Eric M Russell
Eric M Russell
SSCertifiable
SSCertifiable (6.7K reputation)SSCertifiable (6.7K reputation)SSCertifiable (6.7K reputation)SSCertifiable (6.7K reputation)SSCertifiable (6.7K reputation)SSCertifiable (6.7K reputation)SSCertifiable (6.7K reputation)SSCertifiable (6.7K reputation)

Group: General Forum Members
Points: 6708 Visits: 10066
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.


"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."
Gary Varga
Gary Varga
SSChampion
SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)

Group: General Forum Members
Points: 10654 Visits: 6355
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 :-P

Gaz

-- Stop your grinnin' and drop your linen...they're everywhere!!!
Thomas Abraham
Thomas Abraham
SSCrazy
SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)

Group: General Forum Members
Points: 2459 Visits: 2255
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
GoofyGuy
GoofyGuy
SSC-Addicted
SSC-Addicted (453 reputation)SSC-Addicted (453 reputation)SSC-Addicted (453 reputation)SSC-Addicted (453 reputation)SSC-Addicted (453 reputation)SSC-Addicted (453 reputation)SSC-Addicted (453 reputation)SSC-Addicted (453 reputation)

Group: General Forum Members
Points: 453 Visits: 971
"...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.
lsmith1437
lsmith1437
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: 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.
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