Microsoft SQL Server 2008 R2 Unleashed

 Microsoft SQL Server 2008 Unleashed R2 Ebook
\r Description \rMicrosoft SQL Server 2008 Unleashed R2 ebook

Microsoft ® SQL Server 2008 Unleashed R2

Ray Rankin

Paul Bertucci

Chris Gallelli

Alex T. Silverstein

Includes full coverage of SQL Server 2008 in addition to the R2 cover

This is the most comprehensive and useful of SQL Server 2008 and 2008 R2. It presents start-to-end coverage of SQL Server’s core database server and management capabilities, plus complete listings of integration, reporting and Analysis Services, Application Development and much more

Four Expert SQL Server administrators, developers and consultants have packed this book with real information, tips, guidelines and samples taken from his own experience in creating and managing complex database solutions. Writing for intermediate and advanced level SQL Server professionals, they focus on the most complex, powerful, and its newest tools and features. For example, you will find invaluable information about administering SQL Server more effectively, analyze and optimize queries, implementing data warehouse, ensuring high availability, and performance tuning.

The accompanying CD-ROM contains an extraordinary library of helpful tools and information, including sample databases and all code samples . Whether you are responsible for SQL Server 2008 analysis, design, implementation, support, management and troubleshooting, offers no other book which you so highly value.

  • Understanding Microsoft SQL Server 2008 environment, R2 newest features, and each edition character
  • Manage SQL Server 2008 more efficiently with SQL Server Management Studio, SQLCMD command-line query tool, and PowerShell
  • effectively manage security, users, backup / restore, replication, Database Mail, and database objects, from tables and indexes to stored procedures and triggers
  • high availability with clustering, database mirroring, and other features
  • Use the new policy-based management to centrally configure and use SQL Server across the organization
  • Use SQL Server Profiler to capture the issues and identify bottlenecks
  • improve performance, optimize, design efficient databases and manage the workload with the new Resource Governor
  • developing applications with SQL Server 2008 improvements in T-SQL and SQLCLR. NET integration, LINQ to SQL, XML, and XQuery
  • Make the most of Analysis Services, Integration Services and Reporting Services specifically Microsoft’s new R2 reporting improvements
  • improve data security with column- level and Transparent Data Encryption

Ray Rankin, president of Gotham Consulting Services, has worked with Sybase and Microsoft SQL Server for more than 23 years and is co-author of Sybase SQL Server Unleashed, Microsoft SQL Server 2000 Unleashed and Microsoft SQL Server 2005 Unleashed . Paul Bertucci, founder of Database Archi Tech, has more than 30 years of experience in database design, architecture, replication, tuning, integration and high availability. Chris Gallelli, president of cgal Consulting Services, specializing in database administration, tuning, and programming. Alex T. Silverstein is managing principal and chief architect of the Unified Digital Group, LLC, a developer of custom SQL Server and Microsoft. NET solutions.

CD-ROM includes:

  • additional 15 chapters
  • Code samples, scripts and databases used in the book
  • free version of SQL Shot (Performance & Tuning software)

Category: Databases / Microsoft SQL Server

Covers: Microsoft ® SQL Server 2008 R2

User Level: Intermediate-Advanced

\r Microsoft SQL Server 2008 Unleashed R2 Ebook

Leave a comment