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."
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.
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.
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.
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....
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.
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
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
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
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
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."
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).
There, I said it. 2007.
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"
"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
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.
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.
> 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: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?
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.
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.
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.
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: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.
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?
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.
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.
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.
'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: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
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".
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: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.
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.
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.
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."
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:
.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.
.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).
Yukon will allow structs as column types, and will do mapping between
Longhorn replaces Win32 with
There, I said it. 2007.
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?
i think you'll find PostgreSQL is also pretty good value for money!
"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
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.
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
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?
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.
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
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.
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.
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.
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?
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.
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.
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.
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
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).
Hey freaks: now you're ju
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".
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
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