Microsoft SQL Server 2012 Pocket Consultant – Just add LARGE pocket – #bookreview #sxswi #in

Microsoft© SQL Server© 2012 Pocket Consultant
By William P. Stanek
(Microsoft Press,
paperback, list price $39.99; Kindle edition, list price $31.99)

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.


  • Si Dunn is a novelist, screenwriter, photojournalist, and book reviewer. His published books include: DARK SIGNALS, a Vietnam War memoir; ERWIN'S LAW, a private-detective novel; and JUMP, a novella about a combat veteran suffering from PTSD and alienation while trying to work for newspapers as a journalist. Several of his feature screenplays recently were under option to movie producers. He spent nearly 15 years working as a technical writer and software tester in the telecommunications industry. His current programming interests include Go, JavaScript, Python, R, Angular, and other languages and frameworks. He is a U.S. Navy veteran and a graduate of the University of North Texas.

Leave a Reply

%d bloggers like this: