Microsoft SQL Server 2008

Bol Partner

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. 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

Bol

Learn to use all of the powerful features available in SQL Server 2008 quickly and easily 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. Get Started on Microsoft SQL Server 2008 in No Time Learn to use all of the powerful features available in SQL Server 2008 quickly and easily. Microsoft SQL Server 2008: A Beginner's Guide explains the fundamentals of each topic alongside examples and tutorials that walk you through real-world database tasks. Install SQL Server 2008, construct high-performance databases, use powerful Transact-SQL statements, create stored procedures and triggers, and execute simple and complex database queries. Performance tuning, Database Engine security, Business Intelligence, and XML are also covered. Set up, configure, and maintain SQL Server 2008 Build and manage database objects using Transact-SQL statements Create stored procedures and user-defined functions Optimize database performance, availability, and reliability Implement solid security using authentication, encryption, and authorization Automate tasks using SQL Server Agent Create reliable data backups and perform flawless system restores Use all-new SQL Server 2008 Business Intelligence, development, and administration tools Learn in detail the SQL Server XML technology (SQLXML)