| Performance |
|
| Security |
- Operating system authentication (aka Single Sign-On) via Kerberos
- SSL data encryption
- Optimal use of .NET Framework security controls
|
| Enterprise Application Functionality |
- Connection failover and load balancing
- Bulk load operations via ADO.NET Bulk APIs
- Side-by-side installation
- Load balancing
- ClickOnce deployment
- SQL up-leveling
- Interoperability between databases and different versions of each database
|
| Provider Functionality |
- Support for LINQ, Entity SQL, and Microsoft Enterprise Libraries
- Seamless integration with Visual Studio 2005, 2008, and 2010
- One provider supports all versions of SQL Server
- Statistical counters integrated with Windows perfmon
- Full Unicode and ANSI character set support
- Built-in runtime troubleshooting and tracing capabilities
- Advanced data type support
- Distributed transaction support
|
| SQL Server Features |
- Managed code assemblies – Call procedures that are defined as .NET Managed Code Assemblies in the same fashion that stored procedures are invoked. This allows you to leverage the advantages of the 100% managed run-time.
- Triggers on DDL Events – Associate a trigger with Data Definition Language (DDL) statements such as CREATE TABLE.
- Support for Snapshot transaction isolation level – Support for new transaction isolation levels introduced in the SQL Server 2005 release: Read Committed with Snapshots and Snapshot Isolation Level. These new transaction isolation levels provide optimistic locking capabilities, allowing greater application transaction control.
|
| .NET Framework |
- Support for .NET Framework 2.0, 3.0, 3.5, and 4.0
- Support for .NET Framework 1.x
- ADO.NET 2.0 conformance
- Support for version 5.0 of the Enterprise Library including the Data Access Application Block (DAAB) and the Logging Application Block (LAB)
|
