Yes, you will need a big pocket to carry around this 558-page “practical, portable guide.”
It’s intended for: (1) SQL Server administrators; (2) those making the transition to administrator status; and (3) anyone with SQL Server responsibility in a company that is upgrading from older versions to the newest, Microsoft SQL Server 2012.
If your pockets aren’t big enough to do the job, put it in a bag, stick it on a shelf near your workstation, or store it in digital format so you can read it on your mobile device. In other words, get it – whether you are experienced with SQL Server 2012 or still in the process of learning it.
The book is well-written and well-structured. And it is reasonably well-illustrated with screenshots, code samples, tables, notes, tips, lists and step-by-step instructions. It also has been given some good editing: At the time of this review, the book’s errata page showed no confirmed issues.
The author, William R. Stanek, is the series editor for Microsoft’s “Pocket Consultant” books. He has written more than 100 books, and he has more than 20 years’ experience in advanced programming and systems management.
His latest “Pocket Consultant” work is structured into four parts with a total of 12 chapters and a nicely detailed, 23-page index.
Part 1 is titled “Microsoft SQL Server 2012 Essentials.” The chapters are:
- Chapter 1, Managing Your SQL Servers
- Chapter 2, Managing SQL Server Services and Clients
Part 2 is “Microsoft SQL Server 2012 Management and Security.” Its chapters are:
- Chapter 3, Implementing Policy-Based Management
- Chapter 4, Configuring and Tuning Your SQL Servers
- Chapter 5, Tuning and Linking Your SQL Servers
- Chapter 6, Database Administration Essentials
- Chapter 7, Implementing SQL Server 2012 Security
Part 3 is titled “Microsoft SQL Server 2012 Data Management.” The chapters are:
- Chapter 8, Manipulating Schemas, Tables, and Views
- Chapter 9, Using Indexes, Constraints, and Partitions
Part 4 is “Microsoft SQL Server 2012 Optimization, Maintenance, and Recovery.” The chapters are:
- Chapter 10, Automating and Maintaining SQL Server 2012
- Chapter 11, SQL Server 2012 Backup and Recovery
- Chapter 12, SQ: Server 2012 Profiling and Monitoring
The author assumes that you are “fairly familiar with SQL commands and stored procedures as well as the Windows user interface.” He urges that if you are new to SQL and Microsoft SQL Server 2012, pick up a few other books, too. There is, he notes, “simply no way that one book can do it all.”
– Si Dunn is a novelist, screenwriter, freelance book reviewer, and former software technical writer and software/hardware QA test specialist. His latest book is Dark Signals, a Vietnam War memoir available soon in paperback. He also is the author of a detective novel, Erwin’s Law, a novella, Jump, and several other books and short stories.