|
|
FEATURES & BENEFITS AT A GLANCE
|
Out-of-Box Performance
|
|
|
Pain-Free Administration
|
- Automatically defragment and grow database and log files
- Automatically back up databases and recover from system failures
- Pre-configure maintenance tasks based on time schedule or database states
- Monitor and optimize performance with graphical tools like Index Consultant and Application Profiling Wizard
- Deploy scale-out database servers in minutes, not days
|
|
Feature-Rich Development
|
- SQL compliant with ANSI 92 + extensions, T-SQL, SQLX, triggers and stored procedures written in SQL, Java, .NET, Perl and PHP
- Advanced features like OLAP, materialized views, snapshot isolation, full-text search, regular expressions
- Built-in support for 2D and 3D spatial data, including spatial data types and geographic computations
- Native data access through ADO.NET, OLE DB, ODBC 3.5/level 2, JDBC 3.0 and Open Client
- Support for C#, VB.NET, C/C++, ASP, ASP.NET, JSP, Java, PHP and Perl DBD
|
 
|
|