New forms of data are invading organisations. Enabled by new types of information, such as digitisation of images and video, and sensor information from RFID tags, the amount of digital information within an organisation is growing at an astonishing rate. All of this new data is quickly becoming a key component of many critical business activities. SQL Server 2008 helps you capitalise on this data explosion by offering new capabilities to efficiently store, query and manage any data, so you can turn all that data into a new form of energy for your company.
Support for new data types
SQL Server enables applications to store unstructured data such as documents and images directly in the file system, yet retrieve them with the same query access as relational data, so that you can now manage multiple data types from within the database, including these newly supported formats:
- - Date/Time
- - Spatial Indexes
Data integration features
- - SQL Server Integration Services improves the extraction, transformation and loading of data.
- - Change Data Capture (CDC) is a generic component that will track database changes asynchronously and expose the changes through a simple relational interface.
- - MERGE SQL Statements enables developers to provide multiple updates with a single statement.
