Microsoft SQL Server Resources
About SQL Server 2005
SQL Server 2005 is the 3rd generation in the Microsoft SQL Server family. Available for both 32 and 64-bit architecture, SQL Server 2005 is the next generation data management and analysis software that delivers increased scalability, availability, and security to enterprise data and analytical applications.
Tightly integrated with Visual Studio 2005 and BizTalk Server 2006, SQL Server 2005 makes it easier than ever to create, deploy and manage your world-class databases. Four versions of SQL Sever 2005 are released: Express (free), Workgroup, Standard and Enterprise editions. Base on the unique needs of your business, we can recommend the right version of SQL Server for you.
| Visual Studio .NET Integration |
Service Broker |
.NET Framwork Hosting |
| Native HTTP Support |
Native Web Service Support |
XML Technologies |
| Transact-SQL Enhancements |
Reporting Services |
Analysis Services |
| SQL Server Integration Services (formerly DTS) |
Notification Services |
|
| Schema-based Security |
Data encryption with key management |
Enhancement to SQL Server logins |
| EXECUTE AS impersonation |
DDL Triggers |
xp-cmdshell disabled by default |
| Additional security for .NET code |
|
|
| SQL Server Management Studio |
Database Mirroring |
Data Partitioning |
| Online Recovery |
Database Snapshots |
Online Indexing |
| Data encryption |
|
|
SQL Server 2005 & 2000 Service Packs and Patches
Other Resources
