| Author: Babu Akkandi 10 Jan 2009 | Member Level: Diamond | Rating:  Points: 6 |
Hi,
SQL Server 2005 has come up with new BI reporting tools, which is also called as 'Yukon'. This was the only significant reason to bring in the new version of SQL Server 2005 apart from the basic elements of SQL Server 2000.
A quick summary of the differences:
Feature:
SQL Server 2000:
Security:Owner = Schema, hard to remove old users at times
Encryption:No options built in, expensive third party options with proprietary skills required to implement properly.
High Availability: Clustering or Log Shipping require Enterprise Edition. Expensive hardware.
Scalability:Limited to 2GB, 4CPUs in Standard Edition. Limited 64-bit support.
SQL Server 2005:
Security: Schema is separate. Better granularity in easily controlling security. Logins can be authenticated by certificates.
Encryption: Encryption and key management build in.
High Availability: Clustering, Database Mirroring or Log Shipping available in Standard Edition. Database Mirroring can use cheap hardware.
Scalability: 4 CPU, no RAM limit in Standard Edition. More 64-bit options offer chances for consolidation.
http://www.microsoft.com/sql/prodinfo/overview/whats-new-in-sqlserver2005.mspx
Hope It Helps!
Thanks and Regards,
Babu Akkandi
Microsoft Technology
|
| Author: Tejinder Singh Barnala 12 Jan 2009 | Member Level: Gold | Rating: Points: 3 |
new feture in sql server 2005
snapshot isolation level
snapshot replication
dedicated admin connection(DAC)
new version of DTS(only for data transformation) , known as SSIS (for extraction, transformation and load)
Report builder in ssrs 2005
ranking functions
pivot and unpivot
by default all security related feature disable, you have to enable them for use
hope it will help you
Many Thanks
Tejinder Singh Barnala
/*I have the simplest tastes. I am always satisfied with the best*/
|
| Author: ani 12 Jan 2009 | Member Level: Gold | Rating: Points: 4 |
hi
SQL Server 2005 implemented the concept of a database object schema. A schema is a distinct namespace to facilitate the separation, management, and ownership of database objects. It removed the tight coupling of database objects and owners to improve the security administration of database objects. Database object schemas offer functionality to control and help secure application objects within a database environment not available in previous versions of SQL Server.
for refer this link also
http://www.microsoft.com/sqlserver/2005/en/us/express-starter-schemas.aspx#4
regards
ani
|