Book Details...

Microsoft SQL Server 2008 Bible

Microsoft SQL Server 2008 Bible : Whether you're a database developer, DBA, or BI Developer, SQL Server 2008 promises to change the way you deliver enterprise data solutions. Open this detailed, experience-based guide for clear explanations of the concepts balanced with real-world examples and best practices gleaned from years of field and consulting experience. SQL Server is an immense product - this book is your guide to the strategies and details that matter most. Master the data architecture concepts that drive database technologies. Write elegant set-based queries that respond well to a comprehensive indexing strategy. Code an efficient and robust data abstraction layer with stored procedures. Learn the best way to connect to SQL Server with ADO or Microsoft Access. Use PowerShell and Policy-based Management to better administer your servers. Use Analysis Services, MDX, and Excel to analyze data trends. Optimize performance with data compression, resource governor, and partitioning.