Friday, October 23, 2009

SQL Server 2008 and Visual Studio 2008



Chapter 2 -
New Development Tools
Microsoft Visual Studio 2008 Programming
by Jamie Plenderleith and Steve Bunn 
McGraw-Hill/Osborne © 2009























SQL Server 2008 and Visual Studio 2008


Microsoft SQL Server 2008 provides some new, powerful, and very helpful features that help developers deliver high-end database systems. Some of these features include the following:





  • Transparent data encryption   SQL Server 2008 enables encryption of entire databases, data files, and log files, without the need for application changes. Some of the benefits of transparent data encryption include searching encrypted data using either range or fuzzy searches, secure data from unauthorized users, and data encryption.





  • Enhanced auditing   SQL Server 2008 improves compliance and security by allowing you to audit activity on your data. Auditing includes information about when data has been read and any data modifications. This means you don’t need to write and maintain database logging code manually. How many times have you added DateCreated, DateUpdated, CreatedBy, and UpdatedBy columns to tables? SQL Server 2008 can define audit specifications in each database, so audit configuration can be ported with databases.





  • Resource Governor   SQL Server 2008 enables organizations to provide a consistent and predictable response to end users with the introduction of Resource Governor. Resource Governor enables database administrators to define resource limits and priorities for different workloads, which enables concurrent workloads to provide consistent performance to end users.





  • Plan freezing   SQL Server 2008 enables greater query performance stability and predictability by providing new functionality to lock down query plans, enabling organizations to promote stable query plans across hardware server replacements, server upgrades, and production deployments.





  • Hot-add CPU   Additional CPUs can be added to SQL Server 2008 while the database is in use, without requiring any hardware maintenance downtime. This obviously requires enterprise-level hardware that supports hot-add of CPUs and memory.





  • Enhanced database mirroring   When SQL Server encounters a page error while mirroring, it can automatically repair the paging error by requesting a fresh copy of the corrupted page from its mirror partner.





  • Backup compression   Administrators short on storage need not necessarily resort to NTFS compression. With SQL Server 2008 backup compression, less disk I/O is required, less storage is required to keep backups online, and backups run faster.





  • Data compression   Improved data compression enables data to be stored more effectively and reduces the storage requirements for your data.




























TeamUnknown Release
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)