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 12»»

The Challenger Expand / Collapse
Author
Message
Posted Tuesday, May 14, 2013 11:13 PM


SSC-Dedicated

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

Group: Administrators
Last Login: Yesterday @ 3:06 PM
Points: 33,169, Visits: 15,304
Comments posted to this topic are about the item The Challenger






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1452915
Posted Wednesday, May 15, 2013 1:42 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 1:34 PM
Points: 2,899, Visits: 1,797
NuoDB used to be NimbusDB. As far as I can tell NuoDB release one was in January this year.

The NewSQL arena seems to have had quite a few products that have come and gone in a very short timespan.

Some of the so-called NewSQL offerings are niche engines for MySQL or offer some form of sharding for MySQL. For some reason MySQL Cluster gets lumped into the NewSQL bucket.

There are some interesting developments out there for the MySQL engines, notably TokuDB with its fractal indexes.

So far the NewSQL DB that seems to crop up most often and appears to have been around the longest is VoltDB. There are lots of positive stories surrounding that particular product as opposed to no stories for the others.


LinkedIn Profile
Newbie on www.simple-talk.com
Post #1452955
Posted Wednesday, May 15, 2013 6:19 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, June 6, 2014 6:35 AM
Points: 304, Visits: 106
Steve, I think you "hit the nail on the head" when you said that SQL Server includes a lot of features beyond the database engine. If you're coding to ANSI standards, then moving the actual database code shouldn't be too much of an issue. However, it's all the goodies, that make the whole SQL Server ecosystem, that make SQL Server such a compelling platform to work on.

I've looked at a few other database engines. And they all seemed reasonable. But, then you look at the extra tools, and it's like, "Um... I'll stick to SQL Server." I can do in a few clicks, what will take a good deal of programming to do in some other product. Or, worse yet, can't be done in other products. Yes, the ecosystem is a very compelling argument for staying with SQL Server.


Thanks,
MKE Data Guy
Post #1453042
Posted Wednesday, May 15, 2013 7:01 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Yesterday @ 8:24 AM
Points: 404, Visits: 2,386
Postgresql looks awesome. It builds easily from source, and has a nice featureset given the cost. "Redgres" looked to be a pilot project, and given their link leading to a parked domain and the only link provided pointed an "alpha" release. Nobody is going to run production on an alpha version, so obviously we can't judge the popularity of T-SQL compatibility based on what looked to be a pilot experiment from a crew who probably couldn't follow through beyond an initial alpha release.


Post #1453070
Posted Wednesday, May 15, 2013 7:06 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 1:46 PM
Points: 1,649, Visits: 4,697
Ultimately I think it's easier to stick to as few platforms as possible to allow your staff to build expertise in optimizing their code and configurations for a platform.

It is so true that the development / maintenance costs, reliability, and performance of a database has much more to do with the level of expertise of the staff than the platform itself.
Just the other day, there was a high profile crisis which got escalated to executive management. The runtime of a legacy ETL process increased from a daily average of 2 hours to over 9 hours after the record volume coming from the client doubled. There was some smack talk about SQL Server limitations and prattle that Oracle could handle the data loads more efficiently. So, I was called in to take a look at the process and put out the fire before it got out of hand. I reduced the runtime duration from 9 hours to 17 seconds simply by analyzing the cost of each query and modifying a single line of SQL code.

As for cost of licensing, the only scalability limitation of SQL Server Standard edition is 16 cores. There are many OLTP databases currently running on Enterprise edition that just as well be run under Standard edition for half or 1/3 the cost using per core licensing.
Post #1453075
Posted Wednesday, May 15, 2013 7:30 AM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 11:09 AM
Points: 211, Visits: 1,111
Knowledge Draftsman (5/15/2013)
.... Yes, the ecosystem is a very compelling argument for staying with SQL Server.


Vote +1
Post #1453090
Posted Wednesday, May 15, 2013 9:40 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Yesterday @ 12:14 PM
Points: 576, Visits: 3,523
We are currently evaluating NuoDb for a couple of possible uses.
So far the platform seems sound enough but we have only just started.
I can't wait to see how it handles load.
Post #1453189
Posted Wednesday, May 15, 2013 10:15 AM


SSC-Dedicated

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

Group: Administrators
Last Login: Yesterday @ 3:06 PM
Points: 33,169, Visits: 15,304
j.a.c (5/15/2013)
We are currently evaluating NuoDb for a couple of possible uses.
So far the platform seems sound enough but we have only just started.
I can't wait to see how it handles load.


If you want to write up your experiences or what you're using it for, we'd love to see an article.







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1453214
Posted Thursday, May 16, 2013 2:34 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 5:13 PM
Points: 2,290, Visits: 1,343
Most Pick one, Learn One, and keep one. Others pick a few, learn some about each, and keep what they can afford, and spend lots.

To replace the entire back end? Way too much time, effort, and money!

M.


Not all gray hairs are Dinosaurs!
Post #1453781
Posted Monday, May 20, 2013 5:25 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 6:18 AM
Points: 2,869, Visits: 3,210
Microsoft have made a problem for themselves with the Virtualisation Tax (aka Software Assurance) you have to pay when running SQL Server in the Cloud.

I must stress this is not a technology issue. It is a financial issue. If you compare Enterprise Edition features with (for example) Redshift for a new server, Redshift can give what you need for a fraction of EE costs.

DB staff do have some influence over what technology is used, but so do the bean counters. It is very hard to make a case for a new EE instance in AWS when the competition is Redshift. Add to this that AWS product managers are tasked to reduce product costs twice a year then the business case for SQL Server becomes weaker as time goes by.

SQL Server is a great product, but current licensing costs have pushed it into the high-end price bracket, opening up the same sort of price/feature hole in SQL Server that Microsoft used in the past to attack the other major players.


Original author: SQL Server FineBuild 1-click install and best practice configuration of SQL Server 2014, 2012, 2008 R2, 2008 and 2005. 28 July 2014: now over 30,000 downloads.
Disclaimer: All information provided is a personal opinion that may not match reality.
Concept: "Pizza Apartheid" - the discrimination that separates those who earn enough in one day to buy a pizza if they want one, from those who can not.
Post #1454491
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse