Wiley (8-2009) | PDF | 1680 pages | 0470257040 | 32.70Mb

Microsoft SQL Server 2008 Bible /by Paul Nielsen (Author), Uttam Parui (Author), Mike White (Contributor) .Harness the power of SQL Server, Microsoft’s high-performance database and data analysis software package, by accesing everything you need to know in Microsoft SQL Server 2008 Bible.

Learn the best practices, tips, and tricks from this comprehensive tutorial and reference, which includes specific examples and sample code, with nearly every task demonstrated in both a graphical and SQL code method. Understand how to develop SQL Server databases and data connections, how to administer the SQL Server and keep databases performing optimally, and how to navigate all the new features of the 2008 release.
*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