作者:Michael Lee, Gentry Bieker
出版日期:January 20, 2009
出版社:Sybex
页数:792
ISBN:ISBN-10: 047028904X ISBN-13: 978-0470289044
文件格式:PDF
Product Description
As Microsoft’s bestselling database manager, SQL Server is highlyflexible and customizable, and has excellent support—the 2008 versionoffers several significant new capabilities. This book offers accurateand expert coverage on the updates to SQL Server 2008 such as itsenhanced security; the ability to encrypt an entire database, datafiles, and log files without the need for application changes; ascalable infrastructure that can manage reports and analysis of anysize and complexity; and its extensive performance data collection.
From the Back Cover
Harness the Powerful New Features of SQL Server 2008
Whether you’re a database administrator or application developer,this in-depth guide is your key to delivering improved data collection,storage, reporting, and security with SQL Server 2008. Mastering SQLServer 2008 brings you up to speed on architecture, installation, andconfiguration essentials, before moving to the step-by-step instructionyou need for more advanced topics such as procedural programming, queryoptimization, how to use spatial data, SQL Server in the .NET world,and more.
You’ll master the extensive toolset, explore useful third-partytools, and most importantly, find out how to choose and use the rightSQL Server features for the specific tasks you have.
Coverage includes:
Installing and configuring SQL Server 2008Understanding SQL Server’s place within the Microsoft architectureMaking data reliably and efficiently available to your consumersSecuring your data with SQL Server 2008’s new Transparent Data Encryption featureIntegrating XML technology into SQL ServerCreating index architectures for maximum benefit and minimum costExploring new geometry and geography data types for today’s businessesMaximizing data warehousing and business intelligence tools