Mastering Sql Server 2008

Mastering SQL Server 2008

As Microsoft’s bestselling database manager, SQL Server is highly flexible and customizable, and has excellent support—the 2008 version offers several significant new capabilities. This book offers accurate and expert coverage on the updates to SQL Server 2008 such as its enhanced security; the ability to encrypt an entire database, data files, and log files without the need for application changes; a scalable infrastructure that can manage reports and analysis of any size and complexity; and its extensive performance data collection.

Mastering Sql Server 2008

As Microsoft s bestselling database manager, SQL Server is highly flexible and customizable, and has excellent support-the 2008 version offers several significant new capabilities. This book offers accurate and expert coverage on the updates to SQL Server 2008 such as its enhanced security; the ability to encrypt an entire database, data files, and log files without the need for application changes; a scalable infrastructure that can manage reports and analysis of any size and complexity; and its extensive performance data collection. 1. Overview of Microsoft SQL Server 20082. Understanding SQL Server Architecture3. Databases, Files, and Resource Management4. Tables and CRUD Operations5. Procedural programming6. Managing Data Integrity7. SQL Server and XML8. Managing User Security9. Data Recovery10. Monitoring SQL Server Activity11. Using the SQL Server Agent Service12. Data Availability and Distribution13. SQL Server Data Security14. Indexing Strategies for Query Optimization15. Transactions and Locking Strategies16. Using Resource Governor and Policy-Based Management17. SQL Server and the .NET Client18. Leveraging the SQL Server .NET CLR19. Using Spatial Data20. Service Oriented Architecture and the Service Broker21. Full Text Search Services

Mastering SQL Server Profiler