Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.


Maximize the New Capabilities of Microsoft SQL Server 2008

Take immediate advantage of all the innovative features and benefits available in SQL Server 2008 with help from this expert guide. Written by the technical director for SQL Server Magazine, this book offers a concise yet in-depth look at the new and improved enterprise data management capabilities, developer functions, Business Intelligence tools, and security enhancements of SQL Server 2008. This is the perfect resource for decision-makers, developers, and DBAs preparing for upgrades or migration. Get details on:

  • The new Transparent Data Encryption, Extended Events, filtered indexes, and auditing features
  • The new Resource Governor, policy-based management framework, T-SQL IntelliSense and debugging, and PowerShell integration
  • Availability enhancements-Failover Clustering, Database Mirroring, peer-to-peer replication, backup compression, and the new table lock escalation
  • The new ADO.NET Entity Framework
  • LINQ (Language Integrated Query)
  • The new native DATE, TIME, FILESTREAM, and Geospatial data types
  • T-SQL enhancements, such as the new DECLARE, MERGE, and GROUPING SETS statements
  • The more powerful BI toolset, including Integration Services Data Profiling, Analysis Services new Cube Designer, and Reporting Services new tablix controls
  • Improved Microsoft Office integration capabilities
Les mer
Offers details on the innovative features and benefits available in SQL Server 2008. This guide provides an overview of the enterprise data management capabilities, developer functions, Business Intelligence tools, and security enhancements. It is suitable for decision-makers, developers, and DBAs preparing for upgrades or migration.
Les mer
Part I: Database Administration Features
Chapter 1. Architecture
Chapter 2. Administration
Chapter 3. Availability
Part II: Database Development Features
Chapter 4. AD0.NET Entity Framework
Chapter 5. Language Integrated Query (LINQ)
Chapter 6. New Data Types
Chapter 7. New T-SQL Features
Part III: Business Intelligence Features
Chapter 8. Business Intelligence
Chapter 9. Office Integration
Part IV: Appendixes
Appendix A. Installation and Upgrade
Appendix B. Quick Facts
Index
Les mer

Produktdetaljer

ISBN
9780071546409
Publisert
2009-02-16
Utgave
2. utgave
Utgiver
McGraw-Hill Education - Europe
Vekt
444 gr
Høyde
226 mm
Bredde
180 mm
Dybde
16 mm
Aldersnivå
P, 06
Språk
Product language
Engelsk
Format
Product format
Heftet
Antall sider
272

Forfatter

Biografisk notat

Mike Otey is the senior technical editor for SQL Server Magazine and Windows 2000 Magazine. He is also president of TECA, Inc., a software development and consulting firm. Mike is also the author of Osborne's best-selling SQL Server 2000 Developer's Guide.