The new test release, Community Technology Preview (or CTP) 5, is a significant milestone in that it will come with a Go Live license for the product. That indicates the latest SQL release is nearly finished and ready for Microsoft support.
Though it was once pegged as a technology that could only handle smaller databases, SQL Server is now running data warehouses larger than 20 Tbytes in size, according to Microsoft, and is now a leader in Gartner's magic quadrant for data warehousing. SQL Server 2008 will add even better compression technology, which Peter Hammond, president of Microsoft partner and business intelligence vendor CyberSavvy, in an interview, called "huge." Hammond said SQL Server 2008's back-up compression ratios are between 60% and 80%.
SQL Server 2008 will focus on a few areas of improvement beyond what's in the popular SQL Server 2005, including even better scalability, improved business intelligence features and creating an easier way to develop against SQL Server via technologies like LINQ, a new database querying syntax. There will be new support for spatial -- think geo-location -- data, better date and time support, and support for unstructured data that will percolate attributes of documents and files into the data.
Encryption is another big improvement. Transparent encryption means the application that coordinates data in the database won't require that the user specifically request to decrypt information. With transparent encryption, the database does all the translation without user input.
"With 2008, we're making 2005 better," Microsoft director of product management Francois Ajenstat said in an interview. "We're really targeting that high-end scenario. With 2008, we are at par with Oracle and IBM." Bold claims, but SQL seems to be on a roll.
Stay connected and informed by visiting the CA Solutions Center Community!

Become a member today for instant access to free InformationWeek research, expert advice, peer perspectives, and more on the following topics:
- Application Performance Management (APM)
- Security Management
- Mainframe 2.0
- IT Automation
- Service Assurance
Also, visit our Government and Financial Services groups to see how these technologies apply specifically to those industries.
NOTE: Offer valid for U.S., U.S. possessions, & Canada only.