Slashdot Mirror
MSSQL 2005 Finally Released
mnovotny writes "Computerworld reports that Microsoft is finally set to release their belated SQL Server 2005. From the article: 'Despite a two-year delay, several users who have tested the software cited the improved performance and new functionality it brings as positive developments that likely will convince them to upgrade soon.' The free version can be downloaded directly from Microsoft."
Before the Anti-Microsoft redirect gets out. Please take into accounts. Most People who choose MS SQL Server already have a windows network, Oracle is to expensive for their needs, MySQL 5 just was released with most of the functionality that was in MS SQL 2000, Not many good tools for PostGreSQL, Easier to integrate with .NET, and gives PHB the warm and fuzzies. I have been working with MS SQL 2000 and I must say I was surprising pleased with it, other then the POS that is called DTS, I never had any problems with SQL server, with it crashing or problems handling a lot of data, or configuring security. My only Fear with MS SQL 2005 is that it will break so much compatibility that we well need to redo a lot of stored procedures and all our working around for DTS.
MS SQL Server Yes it is closed sources, I don't know what type of security holes they will find in it, It is defiantly bloated because it will not fit 5 1/2 single density floppy disk with enough rooms for a 2000 record table. If you already have MS SQL 2000 and in a year or so you need to upgrade it will probably be easer to go to 2005 them migrating to the others.
If something is so important that you feel the need to post it on the internet... It probably isn't that important.
You can download 'web installers' I believe, but ISO images are here
The limited stored proc language that SQL server had before was actually a good thing; you could do some limited stuff in the DB. Thus, you weren't often able to give in to the tendency to stick application logic in the database tier.
And this quote pretty much says it all: Raichura said the support for Microsoft's Common Language Runtime technology via Visual Studio will let him avoid having to go to multiple developers with different specialties. "I can natively write stored procedures straight into software," he said. "This increases my resource pool because it reduces the distinction between software developers and architects."
Read: Now, I can pay people less to create a complete fucking pigsty that will perform well enough that the app will appear largely stable.
I installed SQL Server 2005 Enterprise downloaded from the MSDN last week.
The Management Studio Interface is pretty good, although not as responsive as I would like on a 2.8 GHz P4. Thankfully stored procedures can be edited in a non-modal window (in tabs).
SQL server also comes with MSXML 6 and SQLXML4. The upgrade analysis tool is very neat.
Microsoft Visual Studio 2005 Professional is much more CPU intensive than the Management Studio. They do look rather similar.
Microsoft Visual SourceSafe 2005 has an updated inteface, however many screens still look the same.
Clearly, this (as well as news of Oracle's "free/lite" version of 10g), are good news... that Open Source projects like MySQL, PHP, PostgreSQL, etc are forcing the "cathedral" software shops to re-examine their ways, since they (Microsoft & others) can't rely on piracy anymore (due to impacted profits) to keep the "pipeline full" and "mindshare". It's good for the closed source developers, and ultimately it will be good for OSS developers, as OSS entries in these fields mature. Competition is good, and the developers benefit.
Make sure everyone's vote counts: Verified Voting
And paint them even further into a corner such that migration to another DB is next to impossible.
One of the most exciting features in SQL Server 2005 for me is the new Report Builder. SQL Server 2005 includes a new ClickOnce WinForms app called Report Builder that allows end-users to design their own reports from a business-user friendly data model. It is very similar to Business Object's WebIntelligence for those of you familiar with that product, but with an apparently more affordable licensing arrangement.
Essentially, the data architect takes the OLTP or data warehouse and abstracts it via metadata into Business entities with which end users are familiar. In Business Objects, this semantic layer is called a Business Universe and in SQLServer Reporting Services it's called the Data Model. Because this semantic layer understands how the data should be put together, it writes the underlying SQL necessary to give the user the answer they want. In principle and demos, it is very slick. We'll soon see how the two stack up in reality at my place of business, as we're setting up both this week to play with.
http://developers.slashdot.org/comments.pl?sid=166 851&cid=13914395
Clearly, this (as well as news of Oracle's "free/lite" version of 10g), are good news... that Open Source projects like MySQL, PHP....
MS HAS ALWAYS OFFERED A FREE DATABASE ENGINE, its no secret. SQl Server 2005 Express is just the new version of this product which has been available for years. Because of its easy transition to Sql Server its used a lot as a started Database for companies trying to sell in the SBM market. A lot of software application make use of MSDE (which is what the engine was called before Express edition)
For more information here http://www.microsoft.com/sql/msde/default.mspx
Now as for the Express editions being free... They are not (someone let me know if I am wrong here). They cost like 40 bucks or so, I had the beta installed on my system, once beta was over it prompted me to register/pay for it within 30 days..etc the usual MS registration.
Keeping the business logic out of the database may be good for you if the only thing your database ever talks to is a web app, but lots of us have databases that talk to a LOT of different applications. Rather than reinvent the wheel implementing the buisness logic in a million apps, we keep it in the database, where it keeps everthing consistant, no matter what app is talking to the database, and where it can run fast.
It appears that MS has done some interesting feature shuffling in their various free editions.
m pare-features.mspx
http://www.microsoft.com/sql/prodinfo/features/co
Has anyone out their tested out what is available in SQL express as far as job scheduling , DTS (now ETL) and replication?
Does anyone want to flame me for unashamedly using MS SQL?
As best as I can tell from their spec sheet, the following features of MSDE 2000 are not available in SQL Express:
* No job scheduler in SQL express. SQLAgent worked fine in MSDE 2000.
* Replication: MSDE for SQL could public and subscribe (as far as I understand), while SQL Express 2005 can only subscribe.
* They've changed the name of DTS to "Enterprise ETL Platform" or SSIS or something. While I haven't tested it out yet, it appears that DTS functionality is limited to basic import and export. For the really useful stuff (DTS to web services, for example) you need the pro edition.
Added:
* A user interface. MSDE 2000 basically had none. If you didn't have visual studio, or a developer's license to MSSQL, or some 3rd party administration and query tool, you basically had to use osql (command line).
* You get 4GB instead of 2GB.
Now, I have access to a few large corporate MS SQL servers, so this shouldn't really be a problem. However, large corporate servers have complex change-control processes.
Consequently, I rely on the desktop editions for all my ad-hoc stuff, development, and stuff that hasn't quite made it to production. I also run a database for a non-profit on MSDE, and was hoping to keep the replication features while moving up to SQL Express.
My motto: "A cat is no trade for integrity."
This must be in satire, or ignorance.
a ger
a ger
/ powerdesigner
Q L%20GUI%20Tools/document_view
Postgresql has a great variety of tools, both OSS and commercial that work great. I've been working on an updated list of all the tools. Here are a few of the most popular admin tools:
PGadminIII
http://www.sqlmanager.net/products/postgresql/man
DBvisualizer
http://www.minq.se/products/dbvis/
EMS Postgresql Manager
http://www.sqlmanager.net/products/postgresql/man
PHPpgadmin
http://sourceforge.net/projects/phppgadmin
Sybase Power Designer
http://www.sybase.com/products/enterprisemodeling
ERWIN data modeller
http://www3.ca.com/Solutions/Product.asp?ID=260
CASE Studio 2
http://www.casestudio.com/enu/default.aspx
Postgresql has a vibrant tool community. If you want more info on Postgresql tools see
http://techdocs.postgresql.org/v2/Guides/PostgreS
1) 1GB of RAM usage maximum.
2) 1 Processor usabe maximum (unlimited cores though).
3) 4GB total DB size maximum.
There are other limits too, like it can't do some enterprise things like a DB cluster, but the major ones are the size and processing limitation. So it would probably work as a web backend, but wouldn't scale without buying a bigger version.
A database release especially a MS database is about as interesting as somebody releasing a new ftp client.
Got Code?
You must not be into Object Oriented programming where you separate out the logic into tiers: Persistence Layer, Biz Logic Layer and Presentation Layer. Also, you must have been a DB admin before you were an app developer. Or maybe you've never been an app developer.
The MiniMSFT blog you link to has a tendancy to report the negatives only. For instance, the blog post links to Wesner Moise's post regarding some VS 2005 bugs he'd found. What is not as well publicized is Wesner's next post, in which he says,
"Despite the few hiccups, I am enjoying VS 2005 and have been able to work with it productively. VS 2005 is stable and performant, and it's better to have it arrive now rather than later. The runtime is solid, and various products across Microsoft and outside also depend on it being delivered on a timely basis."
Yes, I've found a few minor hiccups in VS2005 as well. But honestly, it's nothing like MiniMSFT would have it seem. I can't speak for everyone, but VS2005 has been solid for us since RTM (we were a MS beta tester from Beta 1 through RTM), and we're very happy with its current form.
Tech, life, family, faith: Give me a visit
It is pretty easy to scale most things in a big n-tier system. Just buy more servers. The database however is really hard to scale. You quickly get to a point where twice the money will buy you only very little extra performance.
Therefore I treat the database as the "sacred resource". This almost always means that business logic is kept outside the database.
Your approach was right in the 80's when client/server was the norm. Today you should have an n-tier system and have the business logic in an application server.
You can still have lots of different applications while using centralized code. Only, now you call the application server instead of the database.
The Internet is full. Go Away!!!
Here's hoping it went through more testing than VS2005 did...
Did you actually use VC2005, or did you just read a crappy blog entry and assume it fact >.<
Here's the scoop: I've used the VC2005 betas for about two months now. They work fine. No, seriously. Never once did I have a crash. Never once did it corrupt my hard drive. And never once did it kill a penguin. Guys, seerisnah.
Granted, it takes a teensy bit longer to boot than EMACS, but it has a lot of nice features. Like the oft-maligned "intellisense" - it's nice having the function/method/class prototypes at your fingertips as you fill in a function. Or the new, secure versions of strcpy(), memcpy(), and others. It can compile code for a wide variety of applications, such as:
It also supports a wide variety of CPUs:
Fairly impressive, all considering. Although I don't write multi-threaded apps, it does have some nice debugging tools for creating them, a nice GUI for those too lazy to write their own resource scripts, and a nifty-as-all-hell IDE. Contrary to popular opinion, it's stable as all hell, has more features than a nerd's Swiss Army Knife and creates fast code. Quite frankly, for those who actually program, it's a dream - and Microsoft released a beta that any of you could have download from http://msdn.microsoft.com/ (The free and fully-functional Beta is closed now. What, you don't regularly check Microsoft Developer's Network here? :-D)
So... All the VC2005 bashing seems to come from a blind hatred of Microsoft (remember, Bill Gates created his empire coding from his garage, like any proper geek would) and a blind belief in anything that will bash Microsoft. If you actually use VC2005, it's wonderful.
But wait, you can! You can download the "Express Edition" free (as in beer) from here. I don't know how much the "Express Edition" differs from the full product, but if you guys are going to whine about something, at least use it first
DATABASE WOW WOW