New Books for Windows Phone 7 & 7.5 and Microsoft SQL Server 2012 T-SQL – #bookreview

Microsoft Press recently has released two new books, one for developers who work with Windows Phone 7 & 7.5 and the other for newcomers to Microsoft SQL Server 2012 T-SQL. 

Windows Phone 7 Development Internals
Andrew Whitechapel
(Microsoft Press, paperback, Kindle)

Andrew Whitechapel’s hefty new 809-page development internals guidebook focuses on Windows Phone 7 design and architecture and helps you learn best practices for building Windows Phone 7 applications. It is illustrated with numerous screenshots, code examples, and other illustrations.

The book “covers the breadth of application development for the Windows Phone platform, both the major 7 and 7.1/7.5 versions and the minor 7.1.1 version,” Whitechapel writes.

Windows Phone 7 Development Internals is aimed at experienced .NET developers who are familiar with Microsoft Silverlight and want to dig into Windows Phone’s platform design and API surface.

“The Windows Phone 7 release only supports C#,” Whitechapel notes, “and although support for Visual Basic was introduced with the 7.1 SDK, this book focuses purely on C# and XAML.”

In each of the 20 chapters, several features are introduced, and Whitechapel provides “one or more sample [Silverlight] applications and walks you through the significant code (C# and XAML).”

The book’s author is a senior program manager for the Windows Phone Application Platform.

#

Microsoft SQL Server 2012 T-SQL Fundamentals
Itzik Ben-Gan
(Microsoft Press, paperback, Kindle)

Transact-SQL, more commonly known as T-SQL, is the Microsoft SQL Server dialect of the ISO and ANSI standards for SQL. T-SQL code is used to query and modify data in SQL Server 2012.

Itzik Ben-Gan, one of the leading experts on T-SQL, emphasizes that his new book “covers fundamentals [and] is mainly aimed at T-SQL practitioners with little or no experience.” But others who have some T-SQL experience also can find it helpful for filling in gaps in knowledge. The book also is recommended for database administrators, business intelligence (BI) practitioners, report writer, analysts, architects, and SQL Server power users who have “just started working with SQL Server and need to write queries and develop code using Transact-SQL.”

Microsoft SQL Server 2012 T-SQL Fundamentals is structured into 10 chapters. The first chapter provides “Background to T-SQL Querying and Programming. Chapters 2 through 8 examine “various aspects of querying and modifying data.” Chapter 9 looks at concurrency and transactions, and Chapter 10 provides an overview of programmable objects.

The book’s one appendix shows you how to “get started and set up your environment so that you have everything you need to get the most out of this book.” The major discussions include: “Getting Started with SQL Database”; “Installing an On-Premises Implementation of SQL Server”; “Downloading Source Code and Installing the Sample Database”; “Working with SQL Server Management Studio”; and “Working with SQL Server Books Online.”

#

Si Dunn

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.