Microsoft SQL Server Resources
About SQL Server 2008 R2
SQL Server 2008 R2 is the most current version of the Microsoft SQL Server family. Available for both 32 and 64-bit architecture, SQL Server 2008 R2 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 2008, SQL Server 2008 R2 makes it easier than ever to create, deploy and manage your world-class databases. Four versions of SQL Sever 2008 R2 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
