Microsoft launched on Sunday its corporate database aimed at taking market share from Oracle. Microsoft’s SQL Server 2005, delayed several times as engineers sought to make the software more reliable and secure, is a corporate database program designed to store and retrieve business data. Along with SQL Server, Microsoft also launched Visual Studio 2005, a software tools program used to create applications.
Thay still dont have any support for spatial objects? Even MySQL already have it! For many people like me this is still no-database.
You realize that GIS vendors support SQL Server for spatial data? FEMA and USDA use SQL Server for spatial data? Oracle Spatial is available as an option, not built in? What does that tell you?
Not sure if this is what you need (and I may talk out of my ass now), but recently there was a thread about new GIST functionality built in the upcoming release of Postgres thanks to 3rd party financing. Look in the release notes.
Nevermind, wrong topic 🙂
(MySql == database)
&&
(MsSql != database)
LOL
I’m so happy that Microsoft finally released Visual Studio 2005 last week. It’s their best development suite since Visual Studio 6 that was so good for its time.
Visual Studio 2005 and .NET 2.0 really made my day, week, year… I spent the whole weekend testing the final release and I was so surprised that nothing wrong happened. It’s great from the beginning to the end and I can’t wait to attend the launch conference.
…and I was so surprised that nothing wrong happened.
I suppose you expected something to go wrong…that’s just sad.
What? VisualStudio 2005 is the worst, most bloated piece of frozen-syrup slow crap that has ever graced my computer. I fart in its general direction!
If you are looking for a great development environment, you should check out KDevelopment running in Gnome on Gentoo running on a Mac tied into a PostgreSQL database. Mwha! Now THAT’S programing!
Actually, I’m just kidding. I hadn’t seen any Linux troll’s yet and I was kinda missing them.
I think my next database will be DB4O.
http://www.db4o.com/
Actually, Microsoft released both SQL Server 2005 and Visual Studio 2005 on 10/27/2005 … Check it out by reading the microsoft.com website … It must be a slow news day on OSNews
Actually, Microsoft released both SQL Server 2005 and Visual Studio 2005 on 10/27/2005 … Check it out by reading the microsoft.com website … It must be a slow news day on OSNews
If you are an ISV or MS Partner, you would have known -as written in several MS publications- that the official Release Date for both products was November, 7th 2005.
Therefore, what you’ve seen released on the website was the .NET 2.0 Compact Framework (which has been released a few days earlier).
I repeat, just in case, the Official Date is/was November, 7th 2005. That is, today.
Official as in boxed sets, yes. If you are a MSDN Subscriber, it was available to download 12 days ago (ahead of schedule). Either way, this is a cause for celebration!
Actually, last week only the professional versions have been available for download, as well as the 2.0 framework itself. As of today, everything’s officially available from retails and the express editions are up for the first time. What’s really surprising to me is that the express development tools are all available for free for everyone that gets them before 6 Nov 2006. Woohoo for introductory pricing! 🙂
I hope the new version of SQL server is a bit easier to deal with in a virtual hosting environment, at least in terms of moving databases from one server to another. I’m not a DB expert, but the only “proper” way I’ve found to move a MS SQL DB from one host to another involves creating an empty DB on the destination host, detaching the DB from the empty .MDF file, and attaching it to the .MDF from the old host. However, in most virtual hosting environments I’ve used, you don’t get sufficient access to the SQL daemon to detach/attach (or import a .BAK file, if you have one of those) – and often, the host charges a rather hefty per-incident fee to do it for you.
In the same vein, it would be nice if they would it possible to get information out of an MDF file without having to run SQL server. A few months ago, I had MDF/LDF files from an old version of SQL server, that the current version refused to read. I finally got it imported to the new host by assembling a spare box from parts, putting a copy of Win2k server and Sql2k on it (Since SQL 2k Ent. won’t run on XP – precious), attaching the database on the spare machine, then connecting to it from my main machine with a program called “SQL To Access,” exporting the contents to a MDB, opening that up in Access, and using the SQL upsize wizard to push the contents to the empty SQL DB on the new host. I’m pretty sure that I sacrificed a goat at some point as well.
Even if all the hassle is due to my ignorance and there is a much easier way, it sure as hell isn’t easy to find. In contrast, it took me about an hour to figure out how to export the contents of one MySQL db to another – and it was possible to do it entirely through PHPMyAdmin, without any intervention from the hosting company.
I haven’t actually used a database in a website, I’ve only dealt with them from the support side. But if I ever were, my experience so far would incline me heavily towards MySQL even if the site were running on a Windows host.
I’ve used SQL Server 2000 on serval projects and i’ve looking forward to 2005. I had an oppurtunity to experiment with it and so far i really like what i see.
If you carefully look at the features, you will realize that MS is not only going after DB2 and Oracle but its taking on Informatica and IBM Websphere DataStage in the ETL market as well as Cognos and Business Objects in Business Intelligence and Reporting market. Dollar for dollar you will not be able to find a product which can match the features of SQL Server 2005. When you start adding the prices of DB2 and Oracle add-ons to match MS SQL Server 2005 capabilities, you will realize the ludicrous amount of money you will have for DB2 and Oracle compared to MS SQL Server 2005.
Kudos to Microsoft for a job well done.
PS: I’ve used all the products mentioned above expect for Congos and Business objects products and I don’t work for MS.
I am using the Beta version of C# express and it is working good for my personal use.
A full VS2005 would be great
I am using the Beta version of C# express and it is working good for my personal use.
A full VS2005 would be great
You can uninstall your beta of Express and install the final.
http://msdn.microsoft.com/vstudio/express
see here…
http://www.mysql.com/
More proprietary lock-in from Redmond.
Yawn.
JT