Posted by
michael
on from the mysql-available-now dept.
Strudelkugel writes "CRN reports SQL Server 'Yukon' will slip to 2005, complicating plans for ISVs and creating opportunities for OSS and other competitors."
Once SQL server 2005 (now) is out, noone will even remember things like MySQL
no way! MySQL will always have it's place: it's an open source alternative and i'd also guess it would have a predominantly different market.
Re:That's okay
by
Shakrai
·
· Score: 3, Insightful
The trouble with MySQL is that you really do get what you pay for..
Then buy a support contract. Then you will get what you paid for. I'm using MySQL and MS SQL 2000 in an Enterprise environment and MySQL (on second-hand hardware mind you -- our primary database runs on MS because that's what our vendor supports -- bah) is ten times easier to manage and work with then SQL Server 2000.
I'm not even using a support contract and I still prefer MySQL. Saying "you get what you pay for" without even acknowledging that they offer support (and the fact that it's open source and you can fix bugs/add your own features without paying thousands of dollars of licensing fees) is a fairly stupid statement to make.
-- I want peace on earth and goodwill toward man. We are the United States Government! We don't do that sort of thing.
I agree, you can bash Microsoft all you want just because that's who they are, but don't bring up MySQL as an alternative to any real database, be it oracle, postgres or mssql.
Re:That's okay
by
BoomerSooner
·
· Score: 5, Insightful
SQL Server 2005? is going to be great. However, if I had to choose the *best* database I would go with Oracle without a doubt. Every tool other database manufacturers are trying to mirror generally come from Oracle. Plus they support Linux which makes buying very expensive hardware a problem of the past. Hell you can get a license for standard for $799.
Unfortunately my job runs SQL Server 2000. Having cut my teeth on PL/SQL, Transact is a nightmare because it is so limiting.
I'm actually looking forward to Yukon because the marketing ad sheet shows some really cool features. The only question is will they deliver and when will it be?
Re:That's okay
by
bucknuggets
·
· Score: 2, Informative
> SQL Server 2005? is going to be great. However, if I had to choose the *best* database I would go with
> Oracle without a doubt. Every tool other database manufacturers are trying to mirror
> generally come from Oracle.
Ah, no. Most of the BI functionality being implemented in RDBMS' over the last 4-8 years was first implemented in teradata & then informix.
And "Best" makes no sense without context. Oracle is very powerful, but relies heavily on experienced and available dbas, and is the most expensive product out there. Best for some folks might be a less expensive product or simpler product to manage. And as far as performance is concerned both teradata & db2 beat it out at the extreme top end.
Re:That's okay
by
Anonymous Coward
·
· Score: 3, Funny
Because SQL Server 2000 is pretty much the best database around...
I especially like that feature where every SQL Server communicates with each other... what's it called? Oh yeah, SQL SLAMMER.;)
Re:That's okay
by
dasmegabyte
·
· Score: 5, Insightful
MySQL...is ten times easier to manage and work with then SQL Server 2000.
I'm sorry, but what the hell are you talking about? I've used both these servers extensively (as well as Sybase ASA, PostgreSQL and Oracle), and as much as I respect MySQL, it's certainly no easier to use than SQL Server. It's at best about the same, with SQL Server being much easier to pick up from 0 knowledge due to a surprisingly good set of help docs. Enterprise Manager and Query Analyzer are really good tools, as well...in fact, until we discovered mssqlXpress, Query Analyzer was bar none my favorite IDE for making new statements. (sqlXpress adds sourcesafe integration, versioning, and historical reporting to a clone of Q.A. with autocomplete and automatic proc generation, it is a pretty clutch tool)
MySQL is very good, but ten times better? Not really. In fact, if I had to beg for any SQL Server regardless of price, I'd take SQL Server because it's the easiest to develop for and easiest to port FROM. This gives you an app that will run on almost any other server with a little effort. I rewrote a massive app to run on Sybase in three weeks and Postgres in a month (most of which was testing the DB core of our app).
Re:That's okay
by
Anonymous Coward
·
· Score: 2, Insightful
and the fact that it's open source and you can fix bugs/add your own features without paying thousands of dollars of licensing fees
no, you'll have to pay thousands of dollars in development time. And, do you really want joe-open-source off the street "fixing bugs" in your database software? It may not quite be rocket science, but the bar for that sort of work is pretty high. I sure wouldn't bet my business(es) on it.
Re:That's okay
by
kannibal_klown
·
· Score: 5, Insightful
As technically inferior MySQL is to Postgres, MySQL has a few major things going for it that ensure it's niche.
1. Easy to install on Windows. The average coder at a Windows-only farm can easily run the executable and have the latest version running on their developer box. Not all companies allow you to have multiple boxes, and many force you (via draconion security measures) to only run windows with certain software installed. Postgres NEEDS a user-friendly Win32 installer, perhaps with a similar info-item like MySQL has. This is a MUST for companies to start to take notice. Then, a PHB can even play with it and like it.
2. Marketing. While open-source, MySQL has a nice marketing engine behind it. A beautiful webpage, online and PRINT adds, and magazine and newspaper articles CONSTANTLY writing about the "little database that could" every few week / months. Postgres needs to start getting the word out, and hype it a little. Just because a product is superior, doesn't mean it will thrive. There are tons of examples out there: Beta vs VHS, Windows vs OS X, etc. For a database to be used, it must be allowed and "signed off" by a manager of some sort. Most will take reputation + support + "ooh, nice webpage" over a product that might be better, but they know nothing about it.
3. More management tools. MySQL has a couple out there that look and run great; very professional looking. This earns respect from PHB's, as they are easily misled by such niceties.
Don't get me wrong. MySQL is nice, but doesn't have what I need most (Views, triggers, etc). Postgres may not be perfect, but I think it is superior. We just need to get the word out to those "not in the know".
Re:That's okay
by
110010001000
·
· Score: 2, Insightful
I wouldn't bet it. The idea of "heavy peer review" and "many eyes" doesn't play out in the real world. There are less qualified people looking at the MySQL code than any of the closed source products. The idea that a user of product is going to browse through the source code looking for bugs ia laughable. No user has the time for that.
Re:That's okay
by
cayenne8
·
· Score: 2, Interesting
Well, it seems SQL Server is pricing itself close to Oracle these days...and if they are on par costwise...I'd go Oracle.
For open source..I'm still looking into it, but, I like PostgreSQL the best at this point..good data integrity...very oracle like....
-- Light travels faster than sound. This is why some people appear bright until you hear them speak.........
Yukon's promised features
by
BigHungryJoe
·
· Score: 4, Interesting
Not good for MS. A lot of people have been waiting on Yukon. Yukon is finally going to deliver online restoration, database mirroring with automatic failover, and support for mirrored backup sets.
Disappointing. SQL Server had really come a long way, too. Maybe 2005 won't be too late.
Re:Yukon's promised features
by
Florian+Weimer
·
· Score: 3, Insightful
Yukon is finally going to deliver online restoration, database mirroring with automatic failover, and support for mirrored backup sets.
Let's face it, these features isn't something most users need. If Microsoft sees real trouble, they will simply slash the per-processor license cost by a factor of 50 or 100, and switching suddenly becomes a non-issue for most users.
Per-client licenses and awfully high per-processor licensing costs are the most important factor which motivates most users to attempt other solutions. Of course, the proprietary databases have important features which look very good on paper, but I've seen quite a few installations which use a multi-thousand dollar database as if it were MySQL (not even using online backup). You can get away with that if you only need a workgroup server license, but if you need 20,000 client access licenses (or multiple per-processor licenses), licensing becomes a problem and you'll certainly consider other options.
Re:Yukon's promised features
by
dasmegabyte
·
· Score: 2, Interesting
Word. Licensing costs are a big issue with any database. A few months ago I had to devote about three weeks porting our app to Sybase. We wrote it originally for the MSDE (Microsoft SQL Desktop Engine) for our customers who couldn't afford a SQL server. MSDE is a really nice idea, but it only works with up to 5 connections before it tanks quality bigtime. And it seems our customers always needed 6 computers, which made the cost to add that last computer about $3000. Sybase ASA has a much nicer per-connection pricing.
Why couldn't I use MySQL? Well, we'd already written the procs in T-SQL for ADO.NET. Using Sybase ASA allowed us to write a single set of procs that would work on both servers (after quite a bit of wrangling). Using MySQL would have required either using MySQL everywhere (which would have been no good for our clients who already have SQL Server and just want us to put our app on there) or maintaining two distinct sets of procs, which would have not flown with our QA team (already upset about testing the SAME procs on two servers).
Re:Yukon's promised features
by
dasmegabyte
·
· Score: 2, Insightful
"Standard SQL" can't be relied on to do all that much, and what it does is slowwww. From server to server, you can't rely on syntaxes being the same for things like subqueries, LIKE statements or even cross-database selects (which some servers allow and others don't). So while yes, you CAN write cross-database compatible script, your best bet for performance is to optimize for one.
And much of the speed boost you see in using SQL instead of a flat file is in the compilation of stored procedures. Which is why MySQL is so much faster than SQL Server in some tests. If you "SELECT date, article FROM Table1", MySQL is great. But if you "SELECT t1.article, min(t2.date) FROM Table1 t1 CROSS JOIN Table2 t2 on t1.table1id = t2.table2id WHERE table1.tableenum IN (2,3,1) GROUP BY t1.article", your best bet is to compile that into a stored procedure and use MS SQL or one of its companions.
See, cross-platform, cross-product methodologies are a good practice in theory. But if you know that none of your clients is likely to use an alternative platform or alternative server, you may as well write them the best software you can. You can't do that without breaking compatibility.
... they postponed yet another piece of software?? See me not being amazed here, I mean, it seems to be the trend at MS currently to announce new software and then postponing it due to "problems"... I wonder why. Would it be because the want to see what OSS has to offer first so they can steal the ideas and then sell 'em off?
On the other side, if developers start saying this "slip" is becoming "a credibility issue", then maybe certain OSS apps will finally be accepted in full as being grown-up pieces of software. At best this will cause MS to loose a few points in goodwill with a large group of people that still (foolishly) place their trust in them.
-- Veni, Vidi, Velcro!
Re:What ...
by
Saint+Stephen
·
· Score: 5, Interesting
I saw a couple of Alpha builds of Yukon and the Planning papers (blue badge), but I didn't see much, but I bet I know what's taking so long:
Yukon will allow structs as column types, and will do mapping between.NET types and SQL types automatically, and allow you to run C# SQLDataAdapter-type code natively within Stored procedures. Plus with the trend starting in SQL 2000, it'll be XML, XML, XML. I know XML will be a native type and some of the "indexed xml" (red/blue fast-search vs. DOM-search) that they started in the aborted Hailstorm project will be in there.
Longhorn replaces Win32 with.NET; Yukon replaces the SQL you knew with new stuff. They'll eventually get it right and it will rock, but don't expect to use all this until 2007 (it'll be out before then, but you won't finish your first REAL project till then).
I think they are delaying not due to stealing OSS software ideas, but honestly trying to make their software better. For the first time in many years MS has real competition. They can't release another insecure trashbag OS or database server. If they release before it is actually ready, then they will get tons of bad press and their lunch ate by OSS software.
Lets just hope OSS developers don't sit on their laurels during these delays. If they do they will be playing major catch up come 2005/2006. This is the time for OSS to take the lead. The boys at Redmond may be evil, but they are no fools.
MS SQL Server's "corporate" competitor is Oracle 9i. Oracle will beat a SQL Server hands down in any scenario unless it is a small database system, if that's the case there's no point using SQL Server, you can use MSDE or any freeware product. Postgres (last time when I had a look at it under Windows) runs on top of Cygwin and horrendously slow unlike its Unix-compatible brother. MySQL can be used but what's the point if you have already decided to use a toy database, you shouldn't use SQL Server, go and use MSDE instead, or Access. Most used MySQL is 3.x family and it used to not support lots of features (all changed in 4.x but are we being adventorous today?).
Unfortunately, as far as I can see (and my idea will be readily disputed by others) no OSS database is ready for "enterprise" systems (whatever that means, I work in a company who writes software and the backend can be any RDMBS as long as they have a decend JDBC driver). SQL Server 2k has lots of missing features which makes our life very hard and I'm not a fan but at the moment I can't go to any of our customers and say use postgres or mySQL etc.
Another big player is DB2 by IBM which claims it has the fastest database on the world but DB2 is cumbersome, hard to manage compared to Oracle and MS SQL2k but it works almost under any platform under the sun.
Database world is quite interesting, I can't say any RDMS system out there is perfect.
Re:What ...
by
Crashmarik
·
· Score: 5, Insightful
Oh Joy
Just what you need a new microsoft database that makes refactoring and porting your DB to another platform near impossible.
Larry Elison is probably chuckling like a demented monkey over this. I can see his sales people going at this. Microsoft Software assurance = Pay them to take their time to devise ways to achieve complete customer lock in. Or, the ever popular why run your business using techniques with 50 years of validation behind them when you can do things microsofts way.
I can allready see the security problems popping up. Run C# code directly, the same code being ever more integrated into yukon. Well seems we will be able to expect worms that make slammer look like a joke. Heck you could have them replicate throughout the entire system and hold entire enterprises data hostage.
The sad thing is that the large group of IT director/ Sysadmin lemmings will go along with no one ever got fired for choosing microsoft. After all, look at how they have embraced the ever popular and ever more dangerous office/exchange combo.
Run C# code directly, the same code being ever more integrated into yukon.
Same code, but different security model/sandbox. The CLR in yukon does not have access to the file system, sockets, winforms, services, the registry or anything else a virus is going to need. It's limited to communicating with the SQL process and manipulating data within a database. Nothing more.
OSS Opportunity
by
benjiboo
·
· Score: 4, Interesting
I'd be surprised if any company of size would change something as mission critical as their DBMS due to this delay. To me, it says that they're going to get it right first time around.
It's also worth the effort on Microsofts' part to get this right. After all, WinFS is going to be built on the same technology.
-- Vacancy for signature. Apply within.
Re:OSS Opportunity
by
spells
·
· Score: 3, Interesting
I'd be surprised if any company of size would change something as mission critical as their DBMS due to this delay. To me, it says that they're going to get it right first time around
I agree with you about large company decisions remaining unchanged. But I have not ever seen a significant correlation between slipping release dates and improved quality - in fact, my experience says the opposite. Maybe SQL Server will be the exception, but I doubt it.
Has any one contemplated the concept that Microsoft might actually be taking the time to make better products? I realise its taboo on slashdot to show any support to Microsoft, but the fact is that they are not stupid! Do you honestly believe they would just decide, hey, lets let linux + competitors get a foothold in our markets whilst we jack about! WRONG!
One thing anyone in the IT business should learn is to never ever under estimate microsoft.
One thing anyone in the IT business should learn is to never ever under estimate microsoft.
A few years ago, I would have agreed with you. Now my response is:
Ooooh Microsoft is mad at me, I'm so scared! Microsoft is coming to get me! Oh no, don't let Microsoft come after me! They're so big and strong! Oh, protect me from Microsoft!
Get off your high horses people (not just you, all the posters along this vein).
Look, what are you waiting for in the next release of SQLServer? Anything? Nope...didn't think so. You HAVE a rock-solid DB solution from MS right now, so who cares if the next release from MS is late, especially when it represents a fundamental change, and thus nothing you're doing _right now_ will suffer if it's not out next week will it?
Damned, the only thing I know of that's being worked on that requires this to be released is WinFS, which will be released in Longhorn when? A couple more years you say?
Besides, when was the last time your OSS project of choice went gold on time? And no, not having release deadlines doesn't count.
-- No Comment.
Like what?
by
Sla$hd0tSux0r
·
· Score: 3, Interesting
What OSS opportunities does this create? Doesn't OSS need to close the gap with SQL 2000 before taking advantage of any slippage?
How about ANSI '92 compliance for MySQL... that would be a good start!
Re:Like what?
by
Anonymous Coward
·
· Score: 5, Insightful
How about ANSI '92 compliance for MySQL... that would be a good start!
No, a good start would be to flush MySQL down the toilet where it belongs and use a real database engine such as PostgreSQL or Firebird.
Seriously! Why wait for MySQL to add all those missing features when such superior alternatives already exist, and, furthermore, MySQL has a more restrictive license?
No, a good start would be to flush MySQL down the toilet where it belongs and use a real database engine such as PostgreSQL or Firebird.
As long as you can accept the limitations of MySQL, it's perfectly usable. MySQL is faster and lighter weight than PostgreSQL in my experience. I haven't tried Firebird yet.
Honestly, I wouldn't want to run a site like Slashdot on MySQL, but for smaller projects it seems useful.
RDBMSes don't implement Codd's 12 rules anyway, so maybe none of them are "real". Personally I think it's good to have a range of database options. At the high end, Oracle and DB2 have loads of features, and are presumably "real" by your definition, but they are also incredibly complex to administrate, which is why most companies have dedicated DBAs for them.
Re:Like what?
by
bucknuggets
·
· Score: 2, Insightful
> As long as you can accept the limitations of MySQL, it's perfectly usable.
Don't forget the design philosophy - in which everything inconvenient is given a default operation.
Thanks anyway - my only interest in mysql is if I need to walk someone through a windows installation of a free database. Other than that, I'd go elsewhere to avoid loosing money on data corruption.
> MySQL is faster and lighter weight than PostgreSQL in my experience.
It is lighter-weight, but in mixed-workload tests I've done (using innodb) postgresql was faster.
Postgre and Firebird(open source descendand of Interbase) seem to be mature enough. If they improve on their management tools, they might be a strong competition for small to medium database installations. For the really large ones, Microsoft has to compete against Oracle.
all this slipage is a cover for the fact that ms has been listening to it's customers ( forced by some healthy oss pressure )
1: we don't want to be forced into upgrade cycles every 12 months. enterprise systems don't work that way.
2: take the time and fix the damn bugs. we are paying for this shit lets see it work properly.
-- If you mod me down, I will become more powerful than you can imagine....
The main complaints are not this, it is that many companies paid huge amounts of money on licenses because microsoft said the give me every update license would be cheaper then purchasing the upgrades when the product was released. Now they have paid thier money and they are getting nothing.
Meanwhile some of poor DBA have to work with a product which was lacking major database capabilites when it was released, and now have to tell managers they the capabilities and money they were expecting for 2004 will be late 2005
MS slips makes more opportunities?
by
purduephotog
·
· Score: 4, Insightful
I hate to disagree with that, but we recently had a project and had the choice of which SQL to use. Customer pushed back and simply said MS.
Just because the product isn't there doesn't mean they will automatically go to another 'free' alternative- instead it means they'll simply use the older version until it wears out.
Actualy kind of sad
by
Cesaro
·
· Score: 5, Interesting
As a DBA who deals with MS SQL 2k (and 7 and 6.5) on a day to day basis (hour to hour basis?) I'm actually kind of saddened by this. I was really looking forward to playing with the TSQL/.Net paradigm shift as far as accessing data.
7.0 was a huge jump from 6.5 and 2k from 7.0 was almost as significant of a jump. I will call a spade a spade and say that the evolution of the MS SQL server has really impressed me and I was looking for good things from this next version as well. I know this is the wrong place to say such things, but I've had lots of problems with other MS problems, but this one since 7.0 has been quite good. Don't even get me started on some of their other products though.:)
I'll just go hide in my DBA hole until 2005 I guess.
Re:Actualy kind of sad
by
aclarke
·
· Score: 4, Interesting
I completely agree with you. The only thing I really HATE about SQL Server is that it only runs on Windows Operating Systems. As I "only" have about 6 years of experience managing database servers, I find Oracle very frustrating to develop for and maintain. My databases aren't THAT huge (maybe 75-80 million records) and SQL Server works great. Of course, my main client is only now switching from v.7 to 2000 so I don't think this delayed release will affect me that much. I can do all my ColdFusion and Java development and hosting in Mac/Linux so SQL Server is the only thing forcing me to keep a Windows box in my closet (which of course was locked up when I tried to use it this morning).
I do hope they can somehow do a better job with security with the next release, although that may be asking too much.:-( Last time I had to reinstall SQL Server 2000, the whole subnet was down with the SQL Slammer worm before I even had a chance to configure the server and download the patches from Microsoft. Ouch. You have to download the patches ahead of time, pull the server off the internet, install SQL Server and all the patches, change the default port (and obviously make sure your sa password is not blank, duh) and only THEN go back online. Wow.
Re:Actualy kind of sad
by
bucknuggets
·
· Score: 2, Flamebait
well, even though 2000 is a decent product - it still has quite a few obvious enhancements needed (exception handling in stored procs for example).
The direction they're headed with yukon however, is to push more.net stuff into the database. Yuk. I've always avoided their proprietary ado/vb/etc stuff in sql 2000, and.net is just more of the like.
Anyone who takes advantage of any of that stuff is stuck with sql server forever.
Re:Actualy kind of sad
by
MattRog
·
· Score: 3, Informative
You can take a look at Sybase ASE which runs on Linux, Windows, Solaris, etc.. As I'm sure you are aware Sybase wrote the original SQL Server and licensed it to Microsoft. When they split (around version 6.5 I think) Microsoft took the SQL Server name.
In any rate, Sybase ASE uses the T-SQL dialect and also has many of the same stored procedures for system administration.
--
Thanks,
--
Matt
Re:Actualy kind of sad
by
Malc
·
· Score: 2, Insightful
Either you have poor network security (i.e. your SQL Server installation was directly exposed to the internet), or poor network administration (i.e. your network was already infected by Slammer).
We had an incompetent admin and were vulnerable to Slammer for over a year on four major DB servers at our colo facility. Even though our new admin compared the firewall to sieve, it was still secure enough to protect us. I think we were vrey lucky, but I find it hard to believe that you can bring up SQL Server in a corporate environment and have it infected by Slammer before you get chance to patch it. Something's seriously wrong there.
Re:Actualy kind of sad
by
JohnFluxx
·
· Score: 2, Interesting
Hi,
Could you tell me why you would use stored procedures?
It just seems better to have another layer that handles that logic, seperate from the database. That way you can change databases easily.
Is it just because the gui tools make it easier or something?
Re:Actualy kind of sad
by
Jon+Erikson
·
· Score: 3, Informative
Because stored procedures are kept on the DB side and can be optimised and cached by the DB, and also it means that less stuff needs to be sent from DB machines to other machines - all the processing is done in the DB and just the final results sent out.
--
Jon Erikson, IT guru
Re:Actualy kind of sad
by
kpharmer
·
· Score: 3, Informative
JohnFluxx wrote: > Could you tell me why you would use stored procedures? > It just seems better to have another layer that handles that logic, seperate from the database. That way you can change databases easily.
Sure - that's a good approach - especially if you've got a product that you want to support on N databases. However, it's pretty difficult to implement a complex application with completely generic sql anyway. So, when working with complex apps - the use of simple stored procs can actually simplify porting.
But in a more typical situation -when you're developing an application for a single database, and your primary concern might be that the client may want to switch databases in the future (but it will still only run on one database product), *then* the case for stored procedures is much stronger.
Typically I'll implement stored procedures for four reasons:
#1 Parallel Development: stored procedures allow the database & application teams to develop in parallel. For example: as soon as the object model is created, the database team can approve it and commit to delivering stored procs that map to that spec. The same day the developers start writing code. While the developers are writing this code the dbas figure out the physical model and then map that to the procs. I've used this technique to often cut 3-5 weeks off project time-lines.
#2 Physical Model Adaptability: often in complex applications performance dynamics can change over time, requiring that the data model be tuned to handle new situations. With an abstraction layer of stored procedures the dbas are freed to easily make these modeling changes without significant interaction with the developers. This works better for some organizational structures, and even when the dba & programmer are on the same team, it still allows the one person with the greatest sql skills to perform the entire change - and does not require a team to perform impact analysis on both java and the database.
#3 Database Performance: again, in complex or performance-intensive applications, some queries can be extremely complex. However, the folks who are typically the best at tuning the queries are the dbas, not the developers. For example, I sometimes have to split a query into separate steps, with creation of a cartesian-product table as a first step, then joining against a few other tables as next steps, then pulling everything together in a 4-6th step. I can encapsulate that query behind the scenes and offer a relatively simple-looking table to the developers to work with. The programmer's best attempt at tuning their query took 2 minutes, and I got it down to 2 seconds - but there's no way that they can maintain the query I created. Other performance-benefits occur when the dba partitions data across a cluster, and includes logic to determine which node to run part of the query upon. This shouldn't be in the application layer - since it's very database system dependent.
#4 Miscellaneous - there are other potential benefits as well - such as keeping all the sql code where the dba can automate access plan creation, impact analysis, etc. Another misc benefit is in the creation of a security layer.
Of course, note that in none of the above scenarios am I recommending large or complex stored procedures. The kind I'm recommending are 99% sql - and easily port from one database to another.
Meanwhile, MySQL does transactions
by
ka9dgx
·
· Score: 5, Informative
Meanwhile, MySQL is now doing transactions, and VIEWs are on their way in 5.1. It's GPL, so it's free (as in speech).
--Mike--
Re:Meanwhile, MySQL does transactions
by
doofusclam
·
· Score: 3, Insightful
Transactions? Exactly how many years behind the competition is OSS on that one?
If you used real databases, in real production environments on complex data sets, you'd see that MySQL just doesn't cut it - yet. It's great for trivial 'simple but big' datasets, but for data mining and analysis it's awful.
Re:Meanwhile, MySQL does transactions
by
bwalling
·
· Score: 4, Insightful
Meanwhile, MySQL is now doing transactions, and VIEWs are on their way in 5.1. It's GPL, so it's free (as in speech).
Why not use Postgres? That way, you don't have to wait for features that all the other RDBMS products have had for years. What is it that makes MySQL so much more popular than Postgres? It sure isn't features.
Re:Meanwhile, MySQL does transactions
by
cruachan
·
· Score: 5, Insightful
Wow, views will finally be in version 5.1.
Jeez. First time I looked at MySQL a couple of years ago for a project I started putting a basic database scheme together an went to construct a view, only for my Jaw to hit the desk when I found out they were not available. Views are such a basic component of RDBMS databases that it simply hadn't occurred to me (an Oracle, DB2, SQLServer and others veteran) that software could be release that called itself a relational database that didn't have them.
Anyway, just went and used Postgres instead. It's still beyond me why people even bother giving MySQL the time of day when the incomparably superior Postgres is available under GPL.
Re:Meanwhile, MySQL does transactions
by
msgmonkey
·
· Score: 2, Insightful
I think it's the same reason that people will insist on MS, i.e. the "know" MS so assume it has best solution for the job.
The same with MySQL, at around 1999 when I first started to look at doing some (very simple) database work it was the most developed thing you could get for free. At that time, Postgres was not optimised for speed and was still regarded as research product.
Anyhow, the situation has changed somewhat but some people still think it's 1999, of course most of these people are n't RDBMS people so tend to belittle essential features, until MySQL gets them.
Re:Meanwhile, MySQL does transactions
by
Czmyt
·
· Score: 2, Informative
"PostgreSQL is released under the BSD licence" "Permission to use, copy, modify, and distribute this software and its documentation for any purpose, without fee, and without a written agreement is hereby granted, provided that the above copyright notice and this paragraph and the following two paragraphs appear in all copies."
Re:Meanwhile, MySQL does transactions
by
Dan+Ost
·
· Score: 5, Insightful
What is it that makes MySQL so much more popular than Postgres?
Lower barrier to entry.
Since the vast majority of toy applications don't need anything more than a hashed flat file (like gdbm), people find it easy to get things working with MySQL (MySQL abstracts a flat file quite easily) and suddenly think they're Database GODS. Then, when they attempt a new db project, they either force MySQL into it because it's what they know, or they look at a more powerful DB package, realize they're in over their head, and decide that the DB package is to blame for their inability to use it, thus reinforcing their idea that MySQL is a better tool.
Now I realize that there are lots of applications where MySQL is perfectly adequate, but the ease of using MySQL for toy applications has fooled lots of people who have limited db skills at best into thinking that they're experts.
--
*sigh* back to work...
Re:Meanwhile, MySQL does transactions
by
MythMoth
·
· Score: 2, Insightful
Incidentally, I'm not suggesting that Postgres is (yet) comparable to the commercial offerings. Just that of the open source solutions I've tried so far, it's the only one that's a real contender to be used in a "live" situation.
-- ---
These are not words: wierd, genious, rediculous
Re:Meanwhile, MySQL does transactions
by
mborland
·
· Score: 4, Insightful
It's still beyond me why people even bother giving MySQL the time of day when the incomparably superior Postgres is available under GPL.
I'm with you on that one. Once I installed Postgres I haven't looked back. What I admire about the Postgres team is that they focus on standards first and speed second. Smart, because eventually speed catches up (through code optimization or just over time through hardware); whereas MySQL has to add in features afterwards, and do so without slowing it down (and thus pissing off its following). Please MySQL fans, no flaming.
Postgres vs. MS SQL is sort of a different issue. MS SQL has all kinds of features Postgres doesn't have, e.g. lots of replication features (I believe, though I've never had to use them) and its optimizer seems more intelligent than Postgres'. That said, very few dataservers actually use the extended features, and my casual complaints about Postgres' optimizer are quelled by a) fixing my query b) VACUUMing the database as instructed or c) realizing that it was only a few ms slower anyway. Cons on the MS SQL Server side are that a) it ties to you one platform, b) tends to have large gaping security holes and c) tends more often to be implemented by those without a clue of DBAing or security.
Whoops, I ranted.
Re:Meanwhile, MySQL does transactions
by
Just+Some+Guy
·
· Score: 3, Insightful
What I admire about the Postgres team is that they focus on standards first and speed second. Smart, because eventually speed catches up (through code optimization or just over time through hardware)
There's nothing as gratifying when working on a project as realizing that you've built such a solid, engineered solution that you can throw out five layers of error checking that test for conditions that you can rigorously prove cannot exist. Those are the sorts of speedups that PostgreSQL has been undergoing, and even if I didn't like PostgreSQL as a product, I would certainly commend their design team for such excellent work.
-- Dewey, what part of this looks like authorities should be involved?
Re:Meanwhile, MySQL does transactions
by
poot_rootbeer
·
· Score: 4, Funny
Slashdot rule #12: comments on any story even remotely related to database systems will ultimately digress into a MySQL vs. PostgreSQL advocacy war.
MS helping OSS - Indirectly
by
UltimaGuy
·
· Score: 5, Insightful
If I had any doubts that MS is helping OSS and slowly erasing itself, it is now clearing:-)
Jokes aside, this will seriously affect businesses that have paid for their upgrade licenses, as the licenses will expire before the sql server is released. This will make decision makers view Open Source in a new light. Atleast, in Open Source you don't pay for future vaporware in the present.
-- "In questions of science the authority of a thousand is not worth the humble reasoning of a single individual."
Well, Postgres which is the one I know most about doesn't have:
Updates to Views Real Time Replication Two Phase Commit
-- ---
These are not words: wierd, genious, rediculous
except...
by
Anonymous Coward
·
· Score: 5, Interesting
Many business customers have recently been coerced into signing ongoing contracts where they receive any upgrades in a particular year in exchange for a yearly fee.
These companies are going to be extremely p155ed off when they realise that all they are going to get for their money is (maybe) XP Reloaded (think ME).
Companies cannot afford to throw money down the microsoft toilet for much longer... especially when all they get is extra bugs that they didnt need in the first place, coupled with a healthy dose of lock-in and increased support costs.
Does this sound familiar?
by
fataugie
·
· Score: 4, Funny
Microsoft (circa 2001): "With this new licensing model, you buy "software assurance" so if a new version is released in the next two years, you're entitled to a free upgrade"
Uh huh...I see that's working out nicely...
--
WTF? Over?
Re:Does this sound familiar?
by
penguinbrat
·
· Score: 2, Interesting
Did M$ Office pay off - or will it?
Re:Does this sound familiar?
by
fataugie
·
· Score: 2, Informative
Don't know, the last version I bought was Office 97. For what we use it for, there is no added value to upgrading.
By skipping Office 2000, Office XP and Office 2003, we saved mucho $$$.
--
WTF? Over?
Just More Validation for OSS Model
by
Anonymous Coward
·
· Score: 3, Insightful
Here's a company with many thousands of employees, more money than God, and a dominant position in almost every market segment they're in. And they STILL can't write secure code OR meet most of their delivery deadlines (deadlines which they set themselves, not ones that were imposed on them).
Meanwhile, the groups that produce products like MySQL and PostgreSQL have had steady releases, a wealth of needed features, and relatively few security incidents.
Unless you're already so heavily bought in to their infrastructure that any change would be prohibitively expensive, I can't see how it makes any sense to base your business on Microsoft's products. They're expensive, they're insecure, they're performance laggards, and you just can't rely on them for support.
"Early adoption of Yukon in enterprises was quite strong due to the functions and features [..]"
How can you talk about functions and features of software that has not yet been released? How can companies "early adopt" vaporware?
Yes, they can order in advance, but to me "adoption" means running something as a part of your business. Not "planning to maybe use it once you get it and if it turns out to be as good as you was promised it would be".
--
Being bitter is drinking poison and hoping someone else will die
Re:Past tense?
by
REBloomfield
·
· Score: 2, Insightful
erm, people do actually use these things before they hit production you know. We had Exchange 2003 in place months before the release. They don't just stick these products out there, they let people use4 them first and check whether things work... duh...
Re:Past tense?
by
LarsWestergren
·
· Score: 3, Insightful
They don't just stick these products out there, they let people use4 them first and check whether things work... duh...
Oh, you mean the wonderful deal where you pay for the priviledge of being a beta tester?;-)
--
Being bitter is drinking poison and hoping someone else will die
Can't screw up
by
peterdaly
·
· Score: 5, Insightful
This is one of Microsoft's most important products. Finacially, there is a huge amount of "positive perception" riding on SQL server.
Businesses may run on one of their OSes, but businesses run IN SQL Server. This product can make or (more critically) brake businesses. If rumors of major problems with SQL server screwing up business were to get out, corporate perception of them would tank.
They have no real choice with this product but to try and make sure it is ready (and take more time if needed) rather than push it to market.
It is really funny the level of fervor behind Mysql. So funny it makes you wonder if the zealots have ever used anything other to any real extent.
The company I work for software's backend can go Mysql, Postgres, Mssql, Db2, or Oracle.
For massivce connections, queries, reporting, reliability it is in this order.
1. Mssql, DB2, Oracle, all pretty much equal. 2, Postegres, tricky but holds its own. 3. Mysql, will work in the low end, forget reporting, forget huge db hits.
I like Mysql. But Mssql 7.0 hands its ass to it.
What happens is some company will be our product. Hand it over to some 25 year old self proclaimed web genius to install. Conversation is as follows.
1. "Can I have the Source?" No, it is closed, long discussion about how we suck cause our product isn't open source. 2. "Ewwww, Java, it sucks, you should rewrite in PHP" I explain it has been continually developed since 96, no way to stop the engine and write in PHP. 4."I decided to save the company some money and install Mysql" We say ok, explain issues, put them in an email and fax(CYA principle). I then advise to run Postegre, that it is more robust, and is FREE as well.
No one lists. Junior installs on Mysql, everything runs fine, site gets huge amount of traffic, database gets quirky. Management starts running huge queries on database reporting tool. Database is very slow to respond, then in a few weeks keels over.
We get called. Tech is yelling, my guys are smirking(but still polite on phone) Management, myself, and tech gets on conference. Tech starts berating me. Management starts berating me. I pull out magic email and fax with all my system recquirements, suggestions for optimal use. Hey, guess what I was write. Wait a minute, shouldn't I know best since I work for the company that writes and support the product?
Three times a week this happens with Mysql. We have 14000 customers and I swear 50 percent have some guy that thinks he knows best.... knows our product better, knows computers better...
This is a great example of where our community needs to clean up its act. And I thought I would never say that.
Mysql is good for what it is, but there are many things it is not. Learn this.
2. "Ewwww, Java, it sucks, you should rewrite in PHP" I explain it has been continually developed since 96, no way to stop the engine and write in PHP.
It looks to me that your "25 year old self proclaimed web genius" is exactly that. And doesn't know the first thing about databases, let alone operating systems, process slots, filehandles, semaphore locks, interrupts or Context switches. And is absolutely clueless about how to debug DB performance problems.
There *is* one thing that MySQL is good at and that is performance. The problem is, people often put MySQL on crappy hardware and have no clue about how the system realy works or how to tune it.
> There *is* one thing that MySQL is good at and that is performance.
Whoa. MySQL is only good at "performance" under very simplistic use cases (single table selects, low insert/update load). Which describes a web board, but not that many real world applications. I'm sure this is one of the perceptions that the guy is fighting with -- that "MySQL is teh fasterest", when in fact with their applicaiton which is obviously designed for real DB servers, it isn't.
Re:BLASPHEMY! BLASPHEMY! YOU WILL EMBRACE MYSQL!
by
Anonymous Coward
·
· Score: 2, Insightful
Of course MS SQL has transactions. Any decent database software has transactions as standard. mySQL is a toy database, just one step up from storing your data in CSV files.
Horrible Name
by
mwilliamson
·
· Score: 4, Insightful
I really do wish mickysoft would rename their flagship database something else. Are they that arrogant that they feel the need for such a generic name? That's about like naming your product "Web Server" or "Network File Server". When someone mentions SQL server, I always have them clarify whether or not they are talking in general terms for some sort of relational backend, or are they referring to microsoft's product. Sometimes they don't even know the difference, but perhaps that is microsoft's end goal.
Re:Horrible Name
by
Anonymous Coward
·
· Score: 2, Informative
Actually, if you're looking to blame someone for the name, blame Sybase.
MS SQL Server started out as a partnership between MS and Sybase to port Sybase's flagship database project (called "SQL Server") to Microsoft's OS/2 offering in 1987. This eventually turned into the first version of SQL Server for NT in 1992.
Both sides agreed to end their joint development agreement in 1994. For a time, both companies released products named SQL Server, which led to the expected confusion among PHBs.
Finally, after MS SQL Server started taking over market share, Sybase changed the name of its flagship RDBMS product to Adaptive Server Enterprise (ASE), leaving MS in sole possession of Sybase's original product name.
[Source for all this info is Inside SQL Server 2000, I believe it's based on a foreword by Jim Gray from an earlier version of this reference]
Obviously you don't know the situation
by
purduephotog
·
· Score: 3, Insightful
otherwise you'd realize you build software to specifications, one of which is "we have a site license for MS SQL Server."
That means... they tell us to build the system to operate on it, and we deliver.
Coming back to them and informing them we aren't going to listen to their needs would result in, oh, someone else having been awarded the contract.
What this article doesn't mention is that Visual Studio 2005 (formly known as Whitby) has also been delayed so that MS can release both products at the same time. (as VS.Net 2005 is supposed to be heavily integrated with the.NET features of SQL 2005)...
The thing I don't understand is why VS.NET is being delayed like this, the SQL objects should be seperate and not integrated into VS.Net anyway!
Re:BLASPHEMY! BLASPHEMY! YOU WILL EMBRACE MYSQL!
by
actiondan
·
· Score: 4, Interesting
Yep, I was shocked when I first played with MySql, having heard such good things about it, and discovered how many features it lacked that I consider essential to a serious database.
I have since got over my shock and realised that MySql is really good for what it is, but is really a different kind of beast to Oracle, MSSql etc.
Dan.
SQL Server 2005, Visual Studio 2005
by
pmsyyz
·
· Score: 4, Informative
CNET News reported five days ago on the 10th that both Yukon and Whidbey would be delayed and their final names. They need that time if they are going to clean up the shit HTML and JS outputed by VS. Not that they will, that would allow people to use Firefox.
The company said Wednesday that it has decided to push out to the first half of 2005 the delivery of the next major edition of SQL Server, code-named Yukon, and a closely related update to Visual Studio.Net, called Whidbey. Until recently, the company had said that both products would ship by the end of this year.
The final product names for Yukon and Whidbey will be SQL Server 2005 and Visual Studio 2005, said Tom Rizzo, director of product management for SQL Server.
they had to go back and make sure it had enough buffer overflow issues so they could keep the demand for MSCEs high?
Joking aside, I think these delays can be attributed to the whole "Trustworthy Computing" thing and MS discovering just how much junk code was floating around in each new version. They have deep enough pockets to ride out these kind of delays but it does open a great window of opporutnity for OS X and Linux along with a raft of other OSS solutions. A break in the constant upgrade cycle is an opening we should all be working to take advantage of, from desktop tech to database admin to kernel devs.
Slashdot - MySQL?
by
pdjohe
·
· Score: 3, Informative
Re:Slashdot - MySQL?
by
Nick+of+NSTime
·
· Score: 3, Funny
Yes. MySQL allows duplicate keys.
Re:Slashdot - MySQL?
by
bonch
·
· Score: 2, Flamebait
You think Slashdot is some sort of example of efficiency and speed?
My god, thinking about Slashcode alone makes my eyes bleed. I don't even want to think about their InnoDB setup.
I remember some guy posted about how switching to CSS would save around 20-40% or so of bandwidth. Taco's response? "Submit a patch if you want." So we're stuck with HTML 3.2 because Taco is a lazy ass who doesn't want to fix it himself.
Re:Slashdot - MySQL?
by
Chester+K
·
· Score: 4, Insightful
Isn't Slashdot run on MySQL?
And Microsoft.com runs on IIS -- but that doesn't mean that IIS is everything to everyone; nor does the fact that Slashdot runs on MySQL mean that MySQL is good for everyone.
MySQL is really good at a really limited subset of queries. If MySQL is all you know, then your ignorance is bliss in that you don't know all the other wonderful things a real RDBMS can do for you since MySQL never offered them to you.
Once you've used a real database system, you could never go back to the chains of MySQL.
--
NO CARRIER
Re:BLASPHEMY! BLASPHEMY! YOU WILL EMBRACE MYSQL!
by
Omega1045
·
· Score: 3, Informative
This is a good example of how far behind MySQL really is. I don't want to degrade the db; I have used it on several PHP/MySQL driven sites. However, Oracle, IBM, Microsoft, Sybase and others have had transactions for many years. I have only been developing professionally for about 7 years (circa 97), but I started out on SQL Server 6.5 which had full support for transactions. SQL Server 7.0 had support (via MTS) for distrubuted transactions (across multiple databases).
If MS had this back in 1997, you know Oracle had it before then.
--
Great ideas often receive violent opposition from mediocre minds. - Albert Einstein
This product lacks focus
by
fritz1968
·
· Score: 2, Informative
This product lacks focus," said Betsy Burton, analyst with the Gartner Group. "They're doing all sorts of stuff with it, first scalability was the issue, then XML support, then.Net activities, and then business intelligence and now security. The gut issue is, what is the purpose of this release? As a team trying to develop a product you have to know where you're going," she said.
This is the paragraph that explains it all. This product lacks focus. Why? Who knows? But if you cannot give your troops clear, concise goals, then everyone will go in a million different directions. And nothing will get done!
When this project first started out, it may have had the clear, concise goals. But then they started to add extra things to the project as it progressed. Sometimes adding a new feature or what-not means starting from scratch (if you wanna do it right).
If MS wants to do this right (and not delay the shipping date), then they should put a freeze on adding new features. Otherwise, it will either slip again, or a critical flaw will be found with the software.
My $0.02
-- It is not the strongest of the species that survive, nor the most intelligent, but the one most responsive to change.
But if you cannot give your troops clear, concise goals, then everyone will go in a million different directions. And nothing will get done!
True, and the 'troops' here are not only the programmers, but also the MS marketers and MS development community. XML features?.NET stuff? I am all in favor of having options, but I cannot imagine that each and every feature will be well-optimized or secure. MS SQL, which is and has been one of MS' best products, is going the way of Word by incorporating a bajillion features. All in all, this approach isn't bad (we all like features), except that this is a core element to businesses and you can't afford to put too much monkey s**t in it.
I suppose the crux is that databases like Postgres now features pretty robust, standard database functionality and so now MS thinks that they need to keep 'ahead' by putting all sorts of wonky stuff on top. I know I'm old-fashioned, but XML and.NET stuff...isn't that what middleware is for? Otherwise you're starting to embed way too much stuff too deep in your DB and not making it abstract/flexible...what DBs are supposed to be.
grow beyond ms sql 6.5
by
Anonymous Coward
·
· Score: 3, Insightful
>corperations are still using MSSQL 6.5 for critical >databases because 2000 still has some problems. >the only other database they use is Oracle, and >MSSQL is a tiny joke of a toy compared to it.
I suppose you have never run SQL 2000 on a decently powerful machine.
I also suppose you never put a load balancing application on top of a dozen or so SQL 2000 boxes.
Get over it. SQL 2000 is on par with Oracle, Sybase, DB2, etc.
marketing survey
by
martin
·
· Score: 2, Interesting
About 6 months ago I was on the phone to some marketing company who were doing a survey on Yukon and whether or not I was contemplating deploying it.
I said no because:
1) it was too tighly integrated into AD/ windows server and we didn't any of that. 2) I didn't trust it, and wouldn't till it had been in the field for at least a year.
I think they got alot of responses like 2) (going by the marketers comments) and they prob decided to wait till the new windows server is out (2006??) and deploy on the new Trusted Computing Base thing they are wittering on about.
Wow, MySQL now has an official front-end tool (instead of one of many third-party ones that it's had for ages), oohh, that'll make ALL the difference. It's got NOWHERE NEAR the feature set of MS-SQL, Oracle, PostgreSQL, or Firebird. Christ, we had to wait till version FOUR till they added native transaction support (which wasn't ever written by them), subqueries, replication, etc. and we're still not sure that it even does any of this properly now! (Each point release massively changes and/or extends features, which is stupid for a supposedly stable DB.) Sounds like a "real" DB to me that'll definitely compete with Oracle and MS-SQL, yeah right...
But because Slashdot loves MySQL this gets modded to +5 by people who don't know shit about databases, and certainly not about MS SQL Server. Great.
The only reason MySQL became popular was because it was free and ran well together with Apache on modest hardware, so ISPs could bundle it as a *simple* website backend DB. It does that pretty well (as long as you don't mind running REPAIR TABLE every now and again), but it's certainly no viable alternative to MS-SQL or Oracle. Anyone that thinks that and uses the acronym M$ in the same post really doesn't know what the fuck they're talking about.
A lot of people have ben waiting....But..
by
DelawareBoy
·
· Score: 2, Insightful
SQL Server 2000 has lots of legs to run. While there are lots of people, myself included, want to get a hold of Yukon, I don't know of many (actually, any) shops out there which are like, "We NEED Yukon to ship *Now*."
Companies have been pushing back to M$ for years to slow down their release cycle, build a more secure, more stable product. And now people are complaing that they are doing just that? They can't have it both ways. As anyone who codes can tell you, writing secure, stable software is *hard*. Releasing it on time is even harder.
If M$ can release Yukon and it is stable, secure, and fast, I'm willing to wait till 2007, even...
-Delaware Boy in 2004
Some of that Spit and Polish
by
Phrogz
·
· Score: 5, Insightful
Much as I love a good MS Bashing, I'll tell you what I find really lacking (personally) for PostgreSQL and other OSS RDBMSs - a good GUI management tool.
Something that helps you craft medium-complicated joins quickly with a few clicks and drags.
For example, see this screenshot from Visual Interdev working on MSSQL2k, creating a SQL Query for a stored proc. Sure, it's almost trivial to hand-write the SQL code. But it was even easier to just select a few tables, click on the fields I want, right-click on the joins (created automatically from the database structure) to change their type, and be done.
I use PGSQL for all my personal projects now, but I sorely miss the speed that a GUI editor like this allowed me.
The real problem
by
jeremyds
·
· Score: 5, Interesting
The real problem is not so much that the Yukon date has slipped, it's that Whidbey (The next version of Visual Studio.NET and the.NET framework) is slipping with it. For who knows what reason, Microsoft decided that these products must be released together. While Yukon promises some very nice features, most people would much rather have Whidbey released now and live with SQL 2000 for awhile longer.
To top it off, MS is not even going to be releasing any service packs for Visual Studio in the meantime. There are some rather serious issues with the current version of Visual Studio that can only be fixed by calling MS for specific hotfixes. Needless to say, much of the MS developer community is up in arms.
Re:The real problem
by
Chester+K
·
· Score: 2, Insightful
The real problem is not so much that the Yukon date has slipped, it's that Whidbey (The next version of Visual Studio.NET and the.NET framework) is slipping with it. For who knows what reason, Microsoft decided that these products must be released together.
The reason they must ship together is because SQL Server is the guinea pig for Whidbey's new hosting interfaces (running an instance of the Framework inside your own non-managed application). This is not a trivial addition to the.NET Framework.
Check out this.NET architect's blog posting going briefly into some of the details of hosting and why SQL Server is so important to Whidbey.
--
NO CARRIER
Not a great loss.. SQL2000 is a good product
by
nurb432
·
· Score: 2, Interesting
Once they got to that version of their SQL product, they got it pretty much right.
Its one of the few solid things that microsoft puts out. Previous verisons were pretty dismal.
I doubt that most pepole will ever need the 'new' features coming down the pike. They should leave it alone, instead of screwing it up or bloating it out....
-- ---- Booth was a patriot ----
'best database around for the price'?
by
kpharmer
·
· Score: 4, Interesting
Really?
Is it the best database for a linux or unix shop? Is it the best database for large reporting or search applications? Is it the best database for projects or companies with a small budget?
Ah, the answer to all of the above is 'no': - zero portability - parallelism and partitioning is primitive - licensing costs for a 4-way server can easily hit $100k, and in many configurations are more expensive than other top commercial products (db2 for example).
When it comes to prototyping, sql server is at the top of my list. However, when it comes to delivering powerful capabilities, automating operations, and scripting changes - then it's at the bottom of my list.
But I will agree with you on the.net stuff - integrating that into the database is a bad idea.
Re:'best database around for the price'?
by
bucknuggets
·
· Score: 2, Interesting
You're looking at the price/performance ranking - for oltp applications. SQL Server does have the best numbers there. However, this doesn't reflect best performance for oltp (where they hardly show up at all), and certainly not for searches/reporting (which are reflected in tpc-h).
And the only parallel features that I'm aware that they support are in using a set of distributed views to provide a single image of a set of independent servers. This is just a trivial implementation of some of the parallel features that db2 and informix use. It really isn't even in the ballpark for this kind of functionality.
slated to be released until the last quarter this year. 2005 "sounds bad", but it's only a few months.
Re:It wasn't...
by
Anonymous Coward
·
· Score: 2, Interesting
Probably not the point. Lots of people signed up to Microsoft's software subscription with the belief that updates for many packages, including SQL Server, would be released within the subscription period. Microsoft has now taken their money without providing any meaningful updates. Now their licensees will be presented with another choice: upgrade again or lose your significant investment.
sqlxml
by
Anonymous Coward
·
· Score: 2, Interesting
I'm going to guess sqlxml performance blows huge chunks. I ran several dozen benchmarks comparing oledb with sqlxml. sqlxml was at best 10x slower than oledb. With 6 concurrent clients hitting sqlserver on a nice 4CPU box, sqlxml was 100x slower. So yeah, there's going to be performance issues. It's called, dump sqlxml or sell yukon with hardware XML accelerators.
Re:BLASPHEMY! BLASPHEMY! YOU WILL EMBRACE MYSQL!
by
bstil
·
· Score: 2, Informative
Yep, I was shocked when I first played with MySql, having heard such good things about it, and discovered how many features it lacked that I consider essential to a serious database.
Have you seen versions 4.0, 4.1 or 5.0? True, 3.23 did lack many essential features.
Please called it MICROSOFT SQL server
by
hey
·
· Score: 2, Insightful
Just calling "SQL server" suggests its the only program that serves SQL.
Anyway, check out Firebird. It's way ahead of Postgres on most counts.
-Graham
Re:Try Firebird.
by
Cajal
·
· Score: 2, Informative
How do you figure that Firebird is "way ahead" of PostgreSQL? It's better than MySQL sure, and it has some abilties that PG doesn't (a Windows version and it can be embedded), but I wouldn't say that it's "way ahead."
GUI's tools for other databases
by
eberry
·
· Score: 2, Interesting
Something that helps you craft medium-complicated joins quickly with a few clicks and drags.
Don't tell me there are developers or DBA's creating stored procedures in this fashion. This is something I expect from one of my lusers using Access. The code this creates is a nightmare.
However for most other things I like the GUI too. Which is why I downloaded these GUI tools for MySQL.
-- Whoa, whoa, whoa, whoa, whoa, whoa, whoa, whoa, whoa, whoa, whoa, whoa. Lois, this isn't my Batman glass. - Peter
Re:That's okay - Holy cow 40 Million lines of code
by
Malc
·
· Score: 2, Insightful
You're comparing apples to oranges. How many lines of code are in Windows' kernel? Or alternatively, how many lines of code make up the Debian installation on my system (my desktop is KDE if that makes a difference).
Editorial license
by
Strudelkugel
·
· Score: 4, Interesting
Today I learned something about/. editorial policy. When I orginally posted the story, I thought it was interesting from the perspective of what this new disappointment might mean for Steve Ballmer as CEO. All of those comments were deleted from the post, so I guess a story isn't interesting unless it can make Microsoft look bad in some fashion.
I have a suspicion that institutional investors in Microsoft are having their patience tested with a stock price that hasn't moved, no clear vision being stated by the company (remember.Net everything?) and no official statement about how the cash hoard will be used. Unlike OSS, Microsoft has investors that can and will influence the direction of the company.
If institutions force Ballmer out, what strategy will Microsoft pursue, and what might this mean for technology? That was the question I wanted to address. Ironically, I even stated in my post that I didn't want this to become another Microsoft v. OSS story, as there are plenty of those already. The business problems of Ballmer might not seem to be a technical story, but I think they absolutely are, as whatever Microsoft does to satisfy its big investors will have great significance for the tech world.
-- Imagine how much harder physics would be if electrons had feelings! -Feynman, maybe
Re:Editorial license
by
silverbolt
·
· Score: 2, Informative
Wrong... Institutional investors have much more stock, and they can heavily influence Microsoft direction. See here
Re:postgres vs mysql
by
kpharmer
·
· Score: 2, Insightful
The business press doesn't talk much about postgresql - but companies, vendors, and skilled database developers & administrators are.
It has plenty of momentum, and is clearly ready and getting used in a wide variety of applications now.
MySQL does have an incredible amount of momentum, more than most products out there. However, it'll have to be completely rewritten from the ground up before it really becomes a threat to commercial products. That will probably take years to get right. Postgresql on the other hand is just filling in feature gaps - and has a much more evolutionary upgrade path ahead.
Re:re
by
Anonymous Coward
·
· Score: 2, Insightful
Nobody bought Sybase. Learn history. MS and Sybase bought Watcom SQL Server to joinly develop new product. After some internal fight companies split up and released thier own SQL Servers.
Anyway MS SQL Server 7.0 was a total rewrite of old Watcom code.
I know there is a huge hate of MS products on Slashdot but most of the people just don't know the SQL Server well to comment on it.
Especially amazing to see people compare MS SQL Server to MySQL. No database developer worth his salt will put any critical data into MySQL.
MySQL has it's niche but it is not in the same league as SQL Server or Oracle. Access maybe,FoxPro, BerkleyDB are competitors of MySQL.
Re:argh! can't wait
by
kpharmer
·
· Score: 2, Informative
> For those Oracle lovers in the crowd, take a look at the benchmarks - MS SQL rules the lower and middle > ground. It would rule the high end except lack of platform has held it back.
um, which benchmarks would those be? www.tpc.org doesn't have many benchmarks for desktop-sized servers (which is where sql server really does beat oracle/db2/etc). And as far as it being held back by its platform - without any of the parallel features of oracle/db2, and without any of the partitioning features - it has zero chance at the high-end.
It's basically *years* behind either of those two databases. This has nothing to do with windows, it has everything to do with lack of high-end database features in sql server. Microsoft has done a good job of improving the database client UI and adding usability features to low-end database functionality. But it hasn't added the high-end functionality, nor has it really delivered a great UI (for example: the SQL Server GUIs all sort date columns alphabetically rather than cronologically).
> Yukon is going to kill Oracle in the middle space because of development features. Got news for ya, people pick databases for reasons other than development features.
You talk about people who don't know shit about databases, but you know so much that you had to post anonymously. You clearly don't know shit about MySQL.
You're right that MySQL doesn't have all the features that Oracle and DB2 have, but those two databases don't have all the features that MySQL has. MySQL let's you tailor your databases/table types to what they are going to be used for. You can pick and even change on the fly the algorithm used for your tables. This let's you optimize tables that are read only or non-transactional for speed. Run your tables as MyISAM or HEAP if you have enough RAM, and the speed will blow away Oracle or IBM. If you need transactionality, then go with InnoDB tables.
You also show your ignorance by putting Microsoft in the same sentence as Oracle. If you were building a true enterprise system, MS would not even enter the equation. DB2 would be the only other option to consider besides Oracle. You bitch about MySQL and "Each point release massively changes features." Look at MS. Why do you think they are slipping so badly on the next release of SQL Server? Just take a look at their list of new features they are promising and then talk about "massive changes." This is also not surprising since this will be the first release where they've really added anything over what they got from Sybase.
What's so generic about it?
by
bonch
·
· Score: 2, Insightful
"Microsoft SQL Server 2000." The word Microsoft in it outta clue you in.
Oh--"mickysoft?" What is this, a high school Linux user group in 1998?
Why Analysts Suck.
by
Zebra_X
·
· Score: 2, Insightful
from the article Some think Microsoft has bitten off more than it can chew with Yukon. "This product lacks focus," said Betsy Burton, analyst with the Gartner Group. "They're doing all sorts of stuff with it, first scalability was the issue, then XML support, then.Net activities, and then business intelligence and now security. The gut issue is, what is the purpose of this release? As a team trying to develop a product you have to know where you're going," she said
Betsy clearly has no clue regarding the SQL Server product's evolution, capabilites or how these are going to change with Yukon. In fact she seems to have a very limited grasp of significance of the Yukon's release.
Unlike Oracle, SQL Server has basically hovered in the "if it ain't broke don't fix it" pattern for the last 5 years. For the most part it has delivered a decent database platform, that was for a while more cost effective than oracle. Those who have used SQL Server extensively know it's limitations. Betsy's arguments about "product lacking focus" are rediculous. That's primarily becuase Yukon seeks to rectify a large number of the problems and limitations of SQL Server 2k. It's really very difficult to provide a "focused" look at a product that is changing so significantly. In fact, her complaint is very similar to those that were uttered as Microsfot was trying to formalize the definition of.NET, which really has not clarified itself much in the last two years.
It would seem that Betsy is looking for are a few jargon sound bytes that can be displayed on a single powerpoint slide. That slide would then be shown to a bunch of people who nod their head and say, "that's a sound strategic driection". Big idea's aren't sound bytes.
Unfortunately for Microsoft, they are attempting to be ambitious with Yukon. A lot of new plumbing is going in, as well as a refinement and crystalization of the current features such as SQL -> XML queries, DTS, Replication, the integration of a first class programming language among others. These are all features that we've needed for a long time.
Yukon represents a significant change in the world of RDMS's on the Windows platform. It's sad to see that influential groups such as Gartner can't recognize or have the vision to see how much (and for the better) things are going to change for SQL Server 2K shops.
So explain to me how society mods responses like this to +5 Insightful when all the guy ? (who knows, he only posts as an AC anyway) spouts is swear words and bile.
Perhaps you ought to address the real issues one by one rather than venting your spleen. It would make a much more intersting comparison. MSSQL has advantages over MySQL... nobody will argue against that. The fact is that many people do NOT need advanced features. Its horses for courses.
MySQL has had transactions for some time, and will get triggers, views, etc. 5.0 already has stored procs, transactions, by default. Yes I know they've been around for some time in commercial offerrings, but the fact is that MySQL is OpenSource, written by volunteers. The support for MySQL is 10 times better than anything commercial I've seen, and its free.
There, I didn't use one swear word in that. Go on, try it
Re:That's okay - Holy cow 40 Million lines of code
by
PsychoSid
·
· Score: 2, Funny
Surely thats down to the absence of some sort of animated paperclip ?
Oracle and DB2
by
IO+ERROR
·
· Score: 2, Informative
Did you know: If you're a developer you can get a free development license for Oracle and/or DB2.
This is really helpful if you want to play around or learn them, but you need to have a pretty big machine to put them on. Figure on 1GB RAM, 2GB swap and at least 20GB disk, just to play around with ONE of them. Then add in the size of the data you'll be working with...
-- How am I supposed to fit a pithy, relevant quote into 120 characters?
Forgetting history ..
by
dustmite
·
· Score: 2, Insightful
Tsk, always giving MS the benefit of the doubt. Microsoft has almost ALWAYS "slipped" on major projects in the past, usually be anything up to several years. This is nothing new, and has never implied that they were about to produce a quality product in the past.
Microsoft don't "slip" on deadlines: they deliberately start out providing fake, earlier deadlines to the press. So they'll say for example "next SQL server will be out in 2004". This has two effects: (a) companies that might have been thinking about using the gap to produce a competing system consequently don't, "next great MS version will be out too soon" they say. And (b) clients using an older version that need to upgrade to something 'bigger' think "hey, next great MS version will be out soon enough, let's wait for that rather than switch to Oracle".
Then the deadline approaches and Microsoft says "whoops we're slipping". But too late for the many who've now made the decision, so they just wait out the extra time and stick with MS.
Come on, this is an OLD game from MS. Don't be so naive. Those who don't study history..
OSS databases often make good substitutes
by
jesterzog
·
· Score: 2, Insightful
I think stuff like MySql is great for small operations, but they are hardly enterprise worthy.
I agree with you to an extent, although moreso for Postgres than MySQL, the latter of which is insulting and not worthy of being labelled a real database, imho.
I also think that this is exactly why open source is such a threat to the big products like Oracle and SQL Server. The big databases certainly do have a lot of features. Certainly they're capable of much more than open source products. But if you think about it really, how many of the users actualy use all of those features?
The places where OSS products can cut into the market are with all of those customers who have a big, expensive commercial database that they really don't need. If you only use your databases for inserting, updating, selecting, stored procedures and having some integrity built in, and of course if you have an admin with some idea of what they're doing, then something like postgresql may be perfectly reasonable for your needs. It's not a top level database but for what it does, it does well and just as reliably as anything else on the market. It may not be the best choice if you have extreme load conditions or whatnot, but a lot of commercial vendor's customers don't.
This is what the commmercial vendors really have to watch out for. Although most OSS databases don't offer the breadth of features, they are starting to be viable substitutes for the majority of database tasks. It's certainly possible that the commercial vendors might suddenly find a lot of their customers disappearing from underneath them.
Because SQL Server 2000 is pretty much the best database around for the price.
.NET stuff anyway?
Who needs all that integrated
Not good for MS. A lot of people have been waiting on Yukon. Yukon is finally going to deliver online restoration, database mirroring with automatic failover, and support for mirrored backup sets.
Disappointing. SQL Server had really come a long way, too. Maybe 2005 won't be too late.
... they postponed yet another piece of software?? See me not being amazed here, I mean, it seems to be the trend at MS currently to announce new software and then postponing it due to "problems" ... I wonder why. Would it be because the want to see what OSS has to offer first so they can steal the ideas and then sell 'em off?
On the other side, if developers start saying this "slip" is becoming "a credibility issue", then maybe certain OSS apps will finally be accepted in full as being grown-up pieces of software. At best this will cause MS to loose a few points in goodwill with a large group of people that still (foolishly) place their trust in them.
Veni, Vidi, Velcro!
It's also worth the effort on Microsofts' part to get this right. After all, WinFS is going to be built on the same technology.
Vacancy for signature. Apply within.
Has any one contemplated the concept that Microsoft might actually be taking the time to make better products? I realise its taboo on slashdot to show any support to Microsoft, but the fact is that they are not stupid! Do you honestly believe they would just decide, hey, lets let linux + competitors get a foothold in our markets whilst we jack about! WRONG!
One thing anyone in the IT business should learn is to never ever under estimate microsoft.
What OSS opportunities does this create? Doesn't OSS need to close the gap with SQL 2000 before taking advantage of any slippage? How about ANSI '92 compliance for MySQL... that would be a good start!
all this slipage is a cover for the fact that ms has been listening to it's customers ( forced by some healthy oss pressure ) 1: we don't want to be forced into upgrade cycles every 12 months. enterprise systems don't work that way. 2: take the time and fix the damn bugs. we are paying for this shit lets see it work properly.
If you mod me down, I will become more powerful than you can imagine....
I hate to disagree with that, but we recently had a project and had the choice of which SQL to use. Customer pushed back and simply said MS.
Just because the product isn't there doesn't mean they will automatically go to another 'free' alternative- instead it means they'll simply use the older version until it wears out.
As a DBA who deals with MS SQL 2k (and 7 and 6.5) on a day to day basis (hour to hour basis?) I'm actually kind of saddened by this. I was really looking forward to playing with the TSQL/.Net paradigm shift as far as accessing data.
:)
7.0 was a huge jump from 6.5 and 2k from 7.0 was almost as significant of a jump. I will call a spade a spade and say that the evolution of the MS SQL server has really impressed me and I was looking for good things from this next version as well. I know this is the wrong place to say such things, but I've had lots of problems with other MS problems, but this one since 7.0 has been quite good. Don't even get me started on some of their other products though.
I'll just go hide in my DBA hole until 2005 I guess.
--Mike--
If I had any doubts that MS is helping OSS and slowly erasing itself, it is now clearing :-)
Jokes aside, this will seriously affect businesses that have paid for their upgrade licenses, as the licenses will expire before the sql server is released. This will make decision makers view Open Source in a new light. Atleast, in Open Source you don't pay for future vaporware in the present.
"In questions of science the authority of a thousand is not worth the humble reasoning of a single individual."
Many business customers have recently been coerced into signing ongoing contracts where they receive any upgrades in a particular year in exchange for a yearly fee.
These companies are going to be extremely p155ed off when they realise that all they are going to get for their money is (maybe) XP Reloaded (think ME).
Companies cannot afford to throw money down the microsoft toilet for much longer... especially when all they get is extra bugs that they didnt need in the first place, coupled with a healthy dose of lock-in and increased support costs.
Microsoft (circa 2001): "With this new licensing model, you buy "software assurance" so if a new version is released in the next two years, you're entitled to a free upgrade"
Uh huh...I see that's working out nicely...
WTF? Over?
Here's a company with many thousands of employees, more money than God, and a dominant position in almost every market segment they're in. And they STILL can't write secure code OR meet most of their delivery deadlines (deadlines which they set themselves, not ones that were imposed on them).
Meanwhile, the groups that produce products like MySQL and PostgreSQL have had steady releases, a wealth of needed features, and relatively few security incidents.
Unless you're already so heavily bought in to their infrastructure that any change would be prohibitively expensive, I can't see how it makes any sense to base your business on Microsoft's products. They're expensive, they're insecure, they're performance laggards, and you just can't rely on them for support.
Cheers,
"Early adoption of Yukon in enterprises was quite strong due to the functions and features [..]"
How can you talk about functions and features of software that has not yet been released? How can companies "early adopt" vaporware?
Yes, they can order in advance, but to me "adoption" means running something as a part of your business. Not "planning to maybe use it once you get it and if it turns out to be as good as you was promised it would be".
Being bitter is drinking poison and hoping someone else will die
This is one of Microsoft's most important products. Finacially, there is a huge amount of "positive perception" riding on SQL server.
Businesses may run on one of their OSes, but businesses run IN SQL Server. This product can make or (more critically) brake businesses. If rumors of major problems with SQL server screwing up business were to get out, corporate perception of them would tank.
They have no real choice with this product but to try and make sure it is ready (and take more time if needed) rather than push it to market.
-Pete
Soccer Goal Plans
It is really funny the level of fervor behind Mysql. So funny it makes you wonder if the zealots have ever used anything other to any real extent.
The company I work for software's backend can go Mysql, Postgres, Mssql, Db2, or Oracle.
For massivce connections, queries, reporting, reliability it is in this order.
1. Mssql, DB2, Oracle, all pretty much equal.
2, Postegres, tricky but holds its own.
3. Mysql, will work in the low end, forget reporting, forget huge db hits.
I like Mysql. But Mssql 7.0 hands its ass to it.
What happens is some company will be our product. Hand it over to some 25 year old self proclaimed web genius to install. Conversation is as follows.
1. "Can I have the Source?" No, it is closed, long discussion about how we suck cause our product isn't open source.
2. "Ewwww, Java, it sucks, you should rewrite in PHP" I explain it has been continually developed since 96, no way to stop the engine and write in PHP.
4."I decided to save the company some money and install Mysql" We say ok, explain issues, put them in an email and fax(CYA principle). I then advise to run Postegre, that it is more robust, and is FREE as well.
No one lists. Junior installs on Mysql, everything runs fine, site gets huge amount of traffic, database gets quirky. Management starts running huge queries on database reporting tool. Database is very slow to respond, then in a few weeks keels over.
We get called. Tech is yelling, my guys are smirking(but still polite on phone) Management, myself, and tech gets on conference. Tech starts berating me. Management starts berating me. I pull out magic email and fax with all my system recquirements, suggestions for optimal use. Hey, guess what I was write. Wait a minute, shouldn't I know best since I work for the company that writes and support the product?
Three times a week this happens with Mysql. We have 14000 customers and I swear 50 percent have some guy that thinks he knows best.... knows our product better, knows computers better...
This is a great example of where our community needs to clean up its act. And I thought I would never say that.
Mysql is good for what it is, but there are many things it is not. Learn this.
Puto
The Revolution Will Not Be Televised
Of course MS SQL has transactions. Any decent database software has transactions as standard. mySQL is a toy database, just one step up from storing your data in CSV files.
I really do wish mickysoft would rename their flagship database something else. Are they that arrogant that they feel the need for such a generic name? That's about like naming your product "Web Server" or "Network File Server". When someone mentions SQL server, I always have them clarify whether or not they are talking in general terms for some sort of relational backend, or are they referring to microsoft's product. Sometimes they don't even know the difference, but perhaps that is microsoft's end goal.
otherwise you'd realize you build software to specifications, one of which is "we have a site license for MS SQL Server."
That means... they tell us to build the system to operate on it, and we deliver.
Coming back to them and informing them we aren't going to listen to their needs would result in, oh, someone else having been awarded the contract.
What this article doesn't mention is that Visual Studio 2005 (formly known as Whitby) has also been delayed so that MS can release both products at the same time. (as VS.Net 2005 is supposed to be heavily integrated with the .NET features of SQL 2005)...
The thing I don't understand is why VS.NET is being delayed like this, the SQL objects should be seperate and not integrated into VS.Net anyway!
Yep, I was shocked when I first played with MySql, having heard such good things about it, and discovered how many features it lacked that I consider essential to a serious database.
I have since got over my shock and realised that MySql is really good for what it is, but is really a different kind of beast to Oracle, MSSql etc.
Dan.
CNET News reported five days ago on the 10th that both Yukon and Whidbey would be delayed and their final names. They need that time if they are going to clean up the shit HTML and JS outputed by VS. Not that they will, that would allow people to use Firefox.
Microsoft delays database, tools deliveryPhillip
Give MS a frickin' break....MS said there is going to be something like 40 *million* lines of code...
Just out of curiosity, I counted the lines of code (both c & assembler, all processors) of the 2.6.4 kernel. It is less than 5.5 million.
40 million lines of code. There's all the reason I ever need to not use it.
With 40 million lines of code, you never fix bugs, the best you can hope for is to relocate them to a really obscure place.
Suppose you were an idiot. And suppose you were a member of congress. But then I repeat myself. -- Mark Twain
Joking aside, I think these delays can be attributed to the whole "Trustworthy Computing" thing and MS discovering just how much junk code was floating around in each new version. They have deep enough pockets to ride out these kind of delays but it does open a great window of opporutnity for OS X and Linux along with a raft of other OSS solutions. A break in the constant upgrade cycle is an opening we should all be working to take advantage of, from desktop tech to database admin to kernel devs.
Isn't Slashdot run on MySQL?
This is a good example of how far behind MySQL really is. I don't want to degrade the db; I have used it on several PHP/MySQL driven sites. However, Oracle, IBM, Microsoft, Sybase and others have had transactions for many years. I have only been developing professionally for about 7 years (circa 97), but I started out on SQL Server 6.5 which had full support for transactions. SQL Server 7.0 had support (via MTS) for distrubuted transactions (across multiple databases). If MS had this back in 1997, you know Oracle had it before then.
Great ideas often receive violent opposition from mediocre minds. - Albert Einstein
This product lacks focus," said Betsy Burton, analyst with the Gartner Group. "They're doing all sorts of stuff with it, first scalability was the issue, then XML support, then .Net activities, and then business intelligence and now security. The gut issue is, what is the purpose of this release? As a team trying to develop a product you have to know where you're going," she said.
This is the paragraph that explains it all. This product lacks focus. Why? Who knows? But if you cannot give your troops clear, concise goals, then everyone will go in a million different directions. And nothing will get done!
When this project first started out, it may have had the clear, concise goals. But then they started to add extra things to the project as it progressed. Sometimes adding a new feature or what-not means starting from scratch (if you wanna do it right).
If MS wants to do this right (and not delay the shipping date), then they should put a freeze on adding new features. Otherwise, it will either slip again, or a critical flaw will be found with the software.
My $0.02
It is not the strongest of the species that survive, nor the most intelligent, but the one most responsive to change.
>corperations are still using MSSQL 6.5 for critical
>databases because 2000 still has some problems.
>the only other database they use is Oracle, and
>MSSQL is a tiny joke of a toy compared to it.
I suppose you have never run SQL 2000 on a decently powerful machine.
I also suppose you never put a load balancing application on top of a dozen or so SQL 2000 boxes.
Get over it. SQL 2000 is on par with Oracle, Sybase, DB2, etc.
About 6 months ago I was on the phone to some marketing company who were doing a survey on Yukon and whether or not I was contemplating deploying it.
I said no because:
1) it was too tighly integrated into AD/ windows server and we didn't any of that.
2) I didn't trust it, and wouldn't till it had been in the field for at least a year.
I think they got alot of responses like 2) (going by the marketers comments) and they prob decided to wait till the new windows server is out (2006??) and deploy on the new Trusted Computing Base thing they are wittering on about.
How the fuck did this get modded to +5?
Wow, MySQL now has an official front-end tool (instead of one of many third-party ones that it's had for ages), oohh, that'll make ALL the difference. It's got NOWHERE NEAR the feature set of MS-SQL, Oracle, PostgreSQL, or Firebird. Christ, we had to wait till version FOUR till they added native transaction support (which wasn't ever written by them), subqueries, replication, etc. and we're still not sure that it even does any of this properly now! (Each point release massively changes and/or extends features, which is stupid for a supposedly stable DB.) Sounds like a "real" DB to me that'll definitely compete with Oracle and MS-SQL, yeah right...
But because Slashdot loves MySQL this gets modded to +5 by people who don't know shit about databases, and certainly not about MS SQL Server. Great.
The only reason MySQL became popular was because it was free and ran well together with Apache on modest hardware, so ISPs could bundle it as a *simple* website backend DB. It does that pretty well (as long as you don't mind running REPAIR TABLE every now and again), but it's certainly no viable alternative to MS-SQL or Oracle. Anyone that thinks that and uses the acronym M$ in the same post really doesn't know what the fuck they're talking about.
SQL Server 2000 has lots of legs to run. While there are lots of people, myself included, want to get a hold of Yukon, I don't know of many (actually, any) shops out there which are like, "We NEED Yukon to ship *Now*." Companies have been pushing back to M$ for years to slow down their release cycle, build a more secure, more stable product. And now people are complaing that they are doing just that? They can't have it both ways. As anyone who codes can tell you, writing secure, stable software is *hard*. Releasing it on time is even harder. If M$ can release Yukon and it is stable, secure, and fast, I'm willing to wait till 2007, even... -Delaware Boy in 2004
Much as I love a good MS Bashing, I'll tell you what I find really lacking (personally) for PostgreSQL and other OSS RDBMSs - a good GUI management tool.
Something that helps you craft medium-complicated joins quickly with a few clicks and drags.
For example, see this screenshot from Visual Interdev working on MSSQL2k, creating a SQL Query for a stored proc. Sure, it's almost trivial to hand-write the SQL code. But it was even easier to just select a few tables, click on the fields I want, right-click on the joins (created automatically from the database structure) to change their type, and be done.
I use PGSQL for all my personal projects now, but I sorely miss the speed that a GUI editor like this allowed me.
The real problem is not so much that the Yukon date has slipped, it's that Whidbey (The next version of Visual Studio.NET and the .NET framework) is slipping with it. For who knows what reason, Microsoft decided that these products must be released together. While Yukon promises some very nice features, most people would much rather have Whidbey released now and live with SQL 2000 for awhile longer.
To top it off, MS is not even going to be releasing any service packs for Visual Studio in the meantime. There are some rather serious issues with the current version of Visual Studio that can only be fixed by calling MS for specific hotfixes. Needless to say, much of the MS developer community is up in arms.
Once they got to that version of their SQL product, they got it pretty much right.
Its one of the few solid things that microsoft puts out. Previous verisons were pretty dismal.
I doubt that most pepole will ever need the 'new' features coming down the pike. They should leave it alone, instead of screwing it up or bloating it out....
---- Booth was a patriot ----
Really?
.net stuff - integrating that into the database is a bad idea.
Is it the best database for a linux or unix shop?
Is it the best database for large reporting or search applications?
Is it the best database for projects or companies with a small budget?
Ah, the answer to all of the above is 'no':
- zero portability
- parallelism and partitioning is primitive
- licensing costs for a 4-way server can easily hit $100k, and in many configurations are more expensive than other top commercial products (db2 for example).
When it comes to prototyping, sql server is at the top of my list. However, when it comes to delivering powerful capabilities, automating operations, and scripting changes - then it's at the bottom of my list.
But I will agree with you on the
slated to be released until the last quarter this year. 2005 "sounds bad", but it's only a few months.
I'm going to guess sqlxml performance blows huge chunks. I ran several dozen benchmarks comparing oledb with sqlxml. sqlxml was at best 10x slower than oledb. With 6 concurrent clients hitting sqlserver on a nice 4CPU box, sqlxml was 100x slower. So yeah, there's going to be performance issues. It's called, dump sqlxml or sell yukon with hardware XML accelerators.
Yep, I was shocked when I first played with MySql, having heard such good things about it, and discovered how many features it lacked that I consider essential to a serious database.
Have you seen versions 4.0, 4.1 or 5.0? True, 3.23 did lack many essential features.
Just calling "SQL server" suggests its the only
program that serves SQL.
The ship date news had already been reported by Mary Jo Foley, The reporter of Microsoft news, on the 10th.
1 54 6601,00.asp
http://www.microsoft-watch.com/article2/0,1995,
Steven
What is the blind spot people have about this?
Ben is Glory! Wake up people!
Anyway, check out Firebird. It's way ahead of Postgres on most counts.
-Graham
Something that helps you craft medium-complicated joins quickly with a few clicks and drags.
Don't tell me there are developers or DBA's creating stored procedures in this fashion. This is something I expect from one of my lusers using Access. The code this creates is a nightmare.
However for most other things I like the GUI too. Which is why I downloaded these GUI tools for MySQL.
Whoa, whoa, whoa, whoa, whoa, whoa, whoa, whoa, whoa, whoa, whoa, whoa. Lois, this isn't my Batman glass. - Peter
You're comparing apples to oranges. How many lines of code are in Windows' kernel? Or alternatively, how many lines of code make up the Debian installation on my system (my desktop is KDE if that makes a difference).
Today I learned something about
I have a suspicion that institutional investors in Microsoft are having their patience tested with a stock price that hasn't moved, no clear vision being stated by the company (remember .Net everything?) and no official statement about how the cash hoard will be used. Unlike OSS, Microsoft has investors that can and will influence the direction of the company.
If institutions force Ballmer out, what strategy will Microsoft pursue, and what might this mean for technology? That was the question I wanted to address. Ironically, I even stated in my post that I didn't want this to become another Microsoft v. OSS story, as there are plenty of those already. The business problems of Ballmer might not seem to be a technical story, but I think they absolutely are, as whatever Microsoft does to satisfy its big investors will have great significance for the tech world.
Imagine how much harder physics would be if electrons had feelings! -Feynman, maybe
The business press doesn't talk much about postgresql - but companies, vendors, and skilled database developers & administrators are.
It has plenty of momentum, and is clearly ready and getting used in a wide variety of applications now.
MySQL does have an incredible amount of momentum, more than most products out there. However, it'll have to be completely rewritten from the ground up before it really becomes a threat to commercial products. That will probably take years to get right. Postgresql on the other hand is just filling in feature gaps - and has a much more evolutionary upgrade path ahead.
Nobody bought Sybase. Learn history.
MS and Sybase bought Watcom SQL Server to joinly develop new product. After some internal fight companies split up and released thier own SQL Servers.
Anyway MS SQL Server 7.0 was a total rewrite of old Watcom code.
I know there is a huge hate of MS products on Slashdot but most of the people just don't know the SQL Server well to comment on it.
Especially amazing to see people compare MS SQL Server to MySQL. No database developer worth his salt will put any critical data into MySQL.
MySQL has it's niche but it is not in the same league as SQL Server or Oracle. Access maybe,FoxPro, BerkleyDB are competitors of MySQL.
> For those Oracle lovers in the crowd, take a look at the benchmarks - MS SQL rules the lower and middle
> ground. It would rule the high end except lack of platform has held it back.
um, which benchmarks would those be? www.tpc.org doesn't have many benchmarks for desktop-sized servers (which is where sql server really does beat oracle/db2/etc). And as far as it being held back by its platform - without any of the parallel features of oracle/db2, and without any of the partitioning features - it has zero chance at the high-end.
It's basically *years* behind either of those two databases. This has nothing to do with windows, it has everything to do with lack of high-end database features in sql server. Microsoft has done a good job of improving the database client UI and adding usability features to low-end database functionality. But it hasn't added the high-end functionality, nor has it really delivered a great UI (for example: the SQL Server GUIs all sort date columns alphabetically rather than cronologically).
> Yukon is going to kill Oracle in the middle space because of development features.
Got news for ya, people pick databases for reasons other than development features.
How the fuck did this get modded to +5?
You talk about people who don't know shit about databases, but you know so much that you had to post anonymously. You clearly don't know shit about MySQL.
You're right that MySQL doesn't have all the features that Oracle and DB2 have, but those two databases don't have all the features that MySQL has. MySQL let's you tailor your databases/table types to what they are going to be used for. You can pick and even change on the fly the algorithm used for your tables. This let's you optimize tables that are read only or non-transactional for speed. Run your tables as MyISAM or HEAP if you have enough RAM, and the speed will blow away Oracle or IBM. If you need transactionality, then go with InnoDB tables.
You also show your ignorance by putting Microsoft in the same sentence as Oracle. If you were building a true enterprise system, MS would not even enter the equation. DB2 would be the only other option to consider besides Oracle. You bitch about MySQL and "Each point release massively changes features." Look at MS. Why do you think they are slipping so badly on the next release of SQL Server? Just take a look at their list of new features they are promising and then talk about "massive changes." This is also not surprising since this will be the first release where they've really added anything over what they got from Sybase.
"Microsoft SQL Server 2000." The word Microsoft in it outta clue you in.
Oh--"mickysoft?" What is this, a high school Linux user group in 1998?
from the article Some think Microsoft has bitten off more than it can chew with Yukon. "This product lacks focus," said Betsy Burton, analyst with the Gartner Group. "They're doing all sorts of stuff with it, first scalability was the issue, then XML support, then .Net activities, and then business intelligence and now security. The gut issue is, what is the purpose of this release? As a team trying to develop a product you have to know where you're going," she said
.NET, which really has not clarified itself much in the last two years.
Betsy clearly has no clue regarding the SQL Server product's evolution, capabilites or how these are going to change with Yukon. In fact she seems to have a very limited grasp of significance of the Yukon's release.
Unlike Oracle, SQL Server has basically hovered in the "if it ain't broke don't fix it" pattern for the last 5 years. For the most part it has delivered a decent database platform, that was for a while more cost effective than oracle. Those who have used SQL Server extensively know it's limitations. Betsy's arguments about "product lacking focus" are rediculous. That's primarily becuase Yukon seeks to rectify a large number of the problems and limitations of SQL Server 2k. It's really very difficult to provide a "focused" look at a product that is changing so significantly. In fact, her complaint is very similar to those that were uttered as Microsfot was trying to formalize the definition of
It would seem that Betsy is looking for are a few jargon sound bytes that can be displayed on a single powerpoint slide. That slide would then be shown to a bunch of people who nod their head and say, "that's a sound strategic driection". Big idea's aren't sound bytes.
Unfortunately for Microsoft, they are attempting to be ambitious with Yukon. A lot of new plumbing is going in, as well as a refinement and crystalization of the current features such as SQL -> XML queries, DTS, Replication, the integration of a first class programming language among others. These are all features that we've needed for a long time.
Yukon represents a significant change in the world of RDMS's on the Windows platform. It's sad to see that influential groups such as Gartner can't recognize or have the vision to see how much (and for the better) things are going to change for SQL Server 2K shops.
So explain to me how society mods responses like this to +5 Insightful when all the guy ? (who knows, he only posts as an AC anyway) spouts is swear words and bile.
... nobody will argue against that. The fact is that many people do NOT need advanced features. Its horses for courses.
Perhaps you ought to address the real issues one by one rather than venting your spleen. It would make a much more intersting comparison. MSSQL has advantages over MySQL
MySQL has had transactions for some time, and will get triggers, views, etc. 5.0 already has stored procs, transactions, by default. Yes I know they've been around for some time in commercial offerrings, but the fact is that MySQL is OpenSource, written by volunteers. The support for MySQL is 10 times better than anything commercial I've seen, and its free.
There, I didn't use one swear word in that. Go on, try it
Surely thats down to the absence of some sort of animated paperclip ?
Download Oracle or DB2 today.
This is really helpful if you want to play around or learn them, but you need to have a pretty big machine to put them on. Figure on 1GB RAM, 2GB swap and at least 20GB disk, just to play around with ONE of them. Then add in the size of the data you'll be working with...
How am I supposed to fit a pithy, relevant quote into 120 characters?
Tsk, always giving MS the benefit of the doubt. Microsoft has almost ALWAYS "slipped" on major projects in the past, usually be anything up to several years. This is nothing new, and has never implied that they were about to produce a quality product in the past.
Microsoft don't "slip" on deadlines: they deliberately start out providing fake, earlier deadlines to the press. So they'll say for example "next SQL server will be out in 2004". This has two effects: (a) companies that might have been thinking about using the gap to produce a competing system consequently don't, "next great MS version will be out too soon" they say. And (b) clients using an older version that need to upgrade to something 'bigger' think "hey, next great MS version will be out soon enough, let's wait for that rather than switch to Oracle".
Then the deadline approaches and Microsoft says "whoops we're slipping". But too late for the many who've now made the decision, so they just wait out the extra time and stick with MS.
Come on, this is an OLD game from MS. Don't be so naive. Those who don't study history ..
I agree with you to an extent, although moreso for Postgres than MySQL, the latter of which is insulting and not worthy of being labelled a real database, imho.
I also think that this is exactly why open source is such a threat to the big products like Oracle and SQL Server. The big databases certainly do have a lot of features. Certainly they're capable of much more than open source products. But if you think about it really, how many of the users actualy use all of those features?
The places where OSS products can cut into the market are with all of those customers who have a big, expensive commercial database that they really don't need. If you only use your databases for inserting, updating, selecting, stored procedures and having some integrity built in, and of course if you have an admin with some idea of what they're doing, then something like postgresql may be perfectly reasonable for your needs. It's not a top level database but for what it does, it does well and just as reliably as anything else on the market. It may not be the best choice if you have extreme load conditions or whatnot, but a lot of commercial vendor's customers don't.
This is what the commmercial vendors really have to watch out for. Although most OSS databases don't offer the breadth of features, they are starting to be viable substitutes for the majority of database tasks. It's certainly possible that the commercial vendors might suddenly find a lot of their customers disappearing from underneath them.