SQL Server 2008 was released on August 6, 2008, announced to the SQL Server Special Interest Group at the ESRI 2008 User's Conference on August 6, 2008 by Ed Katibah (Spatial Program Manager at Microsoft), and aims to make data management self-tuning, self organizing, and self maintaining with the development of SQL Server Always On technologies, to provide near-zero downtime. SQL Server 2008 also includes support for structured and semi-structured data, including digital media formats for pictures, audio, video and other multimedia data. In current versions, such multimedia data can be stored as BLOBs (binary large objects), but they are generic bitstreams. Intrinsic awareness of multimedia data will allow specialized functions to be performed on them. According to Paul Flessner, senior Vice President of Server Applications at Microsoft, SQL Server 2008 can be a data storage backend for different varieties of data: XML, email, time/calendar, file, document, spatial, etc. as well as perform search, query, analysis, sharing, and synchronization across all data types.
Other new data types include specialized date and time types and a Spatial data type for location-dependent data. Better support for unstructured and semi-structured data is provided using the new FILESTREAM data type, which can be used to reference any file stored on the file system.Structured data and metadata about the file is stored in SQL Server database, whereas the unstructured component is stored in the file system. Such files can be accessed both via Win32 file handling APIs as well as via SQL Server using T-SQL; doing the latter accesses the file data as a BLOB. Backing up and restoring the database backs up or restores the referenced files as well.SQL Server 2008 also natively supports hierarchical data, and includes T-SQL constructs to directly deal with them, without using recursive queries.
The full-text search functionality has been integrated with the database engine. According to a Microsoft technical article, this simplifies management and improves performance.
SQL Server Pro is a trade digital publication and website owned by Penton serving the information needs of IT Professionals in various fields including data processing, database administration, database development, computer-related consulting, and many other areas.
The Editorial Director is Marcia Parker, and the company has editorial offices in the San Francisco Bay Area and Fort Collins, Colorado, USA.
Established in 1999, SQL Server Pro is a website for Microsoft SQL Server professionals. Common topics of the website and digital publication include:
- Backup and Recovery
- High Availability
- Performance Tuning
SQL Server 2008 Pro MSDN
- Brand: Server
- Product Code: Pro
- Availability: In Stock
- Ex Tax: $680.00