Microsoft SQL Server 2012 Pocket Consultant

William R. Stanek

Published by

Microsoft Press

ISBN

9780735663763

RRP

£30.99

Reviewed by

Uma Devi Kanagaratnam MBCS

Score

9 out of 10

SQL Server 2012 is the latest edition to the Microsoft family, which is being promoted as the cloud-ready information platform.

The three main editions are Enterprise, Business Intelligence and Standard. SQL Server 2012 will continue to be available in Developer, Express and Compact editions, however the Workgroup, Small Business and Datacenter editions are being retired; all functionality of the Datacentre edition with be incorporated within the Enterprise edition.

The author has presented the topics in a step-by-step approach that is easy to read and understand. The book is targeted towards an audience with some experience of SQL Server. It’s a good guide, but by no means an exhaustive resource for SQL server 2012.

Part 1 focuses on managing SQL server, the associated services and clients. Part 2 dives into implementation and configuration of the SQL environment, including security. Part 3 involves schemas, tables, views, indexes and partitions. Here readers are presented with best practices pertaining to data management. Many database tasks can be automated, thus allowing high availability and increasing productivity.

Back-up, log shipping and replication are some of the topics focused in the final part of optimisation, maintenance and recovery.

The book structure of combining samples, note, best practices, caution, real world and tip is beneficial to the readers. The author has offered enough information in this book to enable the reader to perform the necessary core administrative task for SQL server.

The book scores 9 / 10 in terms of content and value for money.

Further information: Microsoft Press

June 2012