Click here to close now.


Related Topics: Microsoft Cloud, Microservices Expo, Silverlight

Microsoft Cloud: Book Review

Book Review: Microsoft SQL Server 2012 Unleashed

Another Unleashed behemoth!!!

Another Unleashed behemoth!!! It is a whopping 1683 of printed pages and 2765 pages when you include the additional chapters available in the eBook you get with the printed book. If this book doesn't contain the information you need about SQL Server 2012, then you probably won't find it anywhere.

Just like I am not a server administrator, I am not a Database Administrator (DBA). I don't want to be a DBA, nothing against DBAs, but I just think it is a full time job. It is not possible for me to keep up with my .NET, iOS, Enterprise Architecture, and Software Architecture skills and also be an effective DBA.

Of course I have to be familiar enough with them to architect scalable, secure, high performing software, so I chose this book as my learning resource. It is a great resource. I have not gone too it and come away disappointed yet.

What does make this nice is there is a lot of developer content included with the book in addition to the DBA topics.

The book is broken down into 10 parts. Below is the entire Table of Contents-

Part I: Welcome to Microsoft SQL Server
Chapter 1. SQL Server 2012 Overview
Chapter 2. What’s New in SQL Server 2012
Chapter 3. Examples of SQL Server Implementations

Part II: SQL Server Tools and Utilities
Chapter 4. SQL Server Management Studio
Chapter 5. SQL Server Command-Line Utilities
Chapter 6. SQL Server Profiler

Part III: SQL Server Administration
Chapter 7. SQL Server System and Database Administration
Chapter 8. Installing SQL Server 2012
Chapter 9. Upgrading to SQL Server 2012
Chapter 10. Client Installation and Configuration
Chapter 11. Database Backup and Restore
Chapter 12. Database Mail
Chapter 13. SQL Server Agent
Chapter 14. Administering SQL Server 2012 with PowerShell
Chapter 15. SQL Server Policy-Based Management

Part IV: SQL Server Security Administration
Chapter 16. Security and Compliance
Chapter 17. Security and User Administration
Chapter 18. Data Encryption

Part V: Database Administration
Chapter 19. Creating and Managing Databases
Chapter 20. Creating and Managing Tables
Chapter 21. Creating and Managing Indexes
Chapter 22. Implementing Data Integrity
Chapter 23. Creating and Managing Views
Chapter 24. Creating and Managing Stored Procedures
Chapter 25. Creating and Managing User-Defined Functions
Chapter 26. Creating and Managing Triggers
Chapter 27. Transaction Management and the Transaction Log
Chapter 28. Database Snapshots
Chapter 29. Database Maintenance

Part VI: SQL Server Performance and Optimization
Chapter 30. Data Structures, Indexes, and Performance
Chapter 31. Understanding Query Optimization
Chapter 32. Query Analysis
Chapter 33. Locking and Performance
Chapter 34. Database Design and Performance
Chapter 35. Monitoring SQL Server Performance
Chapter 36. SQL Server Database Engine Tuning Advisor
Chapter 37. Managing Workloads with the Resource Governor
Chapter 38. A Performance and Tuning Methodology

Part VII: SQL Server High Availability
Chapter 39. SQL Server High Availability Fundamentals
Chapter 40. Data Replication
Chapter 41. Database Mirroring
Chapter 42. SQL Server Failover Clustering
Chapter 43. SQL Server AlwaysOn and Availability Groups

Part VIII: SQL Server Application Development
Chapter 44. What’s New for Transact-SQL in SQL Server 2012
Chapter 45. Transact-SQL Programming Guidelines, Tips, and Tricks
Chapter 46. Advanced Stored Procedure Programming and Optimization
Chapter 47. SQL Server and the .NET Framework
Chapter 48. SQLCLR: Developing SQL Server Objects in .NET
Chapter 49. Using XML in SQL Server 2012
Chapter 50. SQL Server Service Broker
Chapter 51. SQL Server Full-Text Search
Chapter 52. Working with SQL Azure

Part IX: SQL Server Business Intelligence Features
Chapter 53. SQL Server 2012 Analysis Services
Chapter 54. SQL Server Integration Services
Chapter 55. SQL Server 2012 Reporting Services
Chapter 56. Master Data Services and Data Quality Services
Chapter 57. Parallel Data Warehouse

Part X: Bonus Chapters
Chapter 58. Managing Linked Servers
Chapter 59. SQL Server Disaster Recovery Planning
Chapter 60. SQL Server Configuration Options

Almost every chapter begins with a section that covers what is new in SQL Server 2012. There are a ton of diagrams that are really helpful with learning the topics, and a ton of great tables that help to summarize topics.

The thing I like most about this book is the quantity of information about profiling, tracing, monitoring, and performance. There is a whole chapter on locking!!! The authors writing style makes it an easy to read book, or at least as easy as server reading can get.

My only gripe about the book is that over 1000 of the pages are only available in eBook format. It is time to break this book down into 2, or maybe 3 printed volumes. I use eBooks for searching for topics, but do not read them. After 8 - 10 hours a day staring at a computer I don't want to read a book on one. This will be my last edition of this awesome book if I can't get it all in print when the next edition is released.

The code downloads are organized by chapter and usable are very usable. Each chapter has a folder.

If you are in anyway involved with SQL Server 2012, you owe it to yourself to get this book. It will not leave my side!!!!

I highly recommend this book for DBA's, developers, and architects.

Microsoft SQL Server 2012 Unleashed

Microsoft SQL Server 2012 Unleashed

More Stories By Tad Anderson

Tad Anderson has been doing Software Architecture for 18 years and Enterprise Architecture for the past few.

Latest Stories
In his session at @ThingsExpo, Tony Shan, Chief Architect at CTS, will explore the synergy of Big Data and IoT. First he will take a closer look at the Internet of Things and Big Data individually, in terms of what, which, why, where, when, who, how and how much. Then he will explore the relationship between IoT and Big Data. Specifically, he will drill down to how the 4Vs aspects intersect with IoT: Volume, Variety, Velocity and Value. In turn, Tony will analyze how the key components of IoT ...
When it comes to IoT in the enterprise, namely the commercial building and hospitality markets, a benefit not getting the attention it deserves is energy efficiency, and IoT’s direct impact on a cleaner, greener environment when installed in smart buildings. Until now clean technology was offered piecemeal and led with point solutions that require significant systems integration to orchestrate and deploy. There didn't exist a 'top down' approach that can manage and monitor the way a Smart Buildi...
SYS-CON Events announced today that has been named a "Bronze Sponsor" of SYS-CON's @DevOpsSummit Silicon Valley, which will take place November 3-5, 2015, at the Santa Clara Convention Center in Santa Clara, CA. provides open-source software ELK turned into a log analytics platform that is simple, infinitely- scalable, highly available, and secure.
DevOps has often been described in terms of CAMS: Culture, Automation, Measuring, Sharing. While we’ve seen a lot of focus on the “A” and even on the “M”, there are very few examples of why the “C" is equally important in the DevOps equation. In her session at @DevOps Summit, Lori MacVittie, of F5 Networks, will explore HTTP/1 and HTTP/2 along with Microservices to illustrate why a collaborative culture between Dev, Ops, and the Network is critical to ensuring success.
Today, we are in the middle of a paradigm shift as we move from managing applications on VMs and containers to embracing everything that the cloud and XaaS (Everything as a Service) has to offer. In his session at 17th Cloud Expo, Kevin Hoffman, Advisory Solutions Architect at Pivotal Cloud Foundry, will provide an overview of 12-factor apps and migrating enterprise apps to the cloud. Kevin Hoffman is an Advisory Solutions Architect for Pivotal Cloud Foundry, and has spent the past 20 years b...
DevOps delivers remarkable results. But does it help all of IT? Can traditional ‘mode 1’ IT benefit as much as innovative ‘mode 2’? How about the rest of your business? Or have you just shifted your bottleneck? And if so, what can you do about it? Improving dev and ops is necessary, but not sufficient. It often just shifts the burden sideways (e.g., to PMs, SQA, InfoSec, DBAs, NOC, etc.), upstream (to the PMO, Controller, Business Liaison, etc.), or downstream (to TechPubs, Service Desk, Traini...
SYS-CON Events announced today that Secure Infrastructure & Services will exhibit at SYS-CON's 17th International Cloud Expo®, which will take place on November 3–5, 2015, at the Santa Clara Convention Center in Santa Clara, CA. Secure Infrastructure & Services (SIAS) is a managed services provider of cloud computing solutions for the IBM Power Systems market. The company helps mid-market firms built on IBM hardware platforms to deploy new levels of reliable and cost-effective computing and hig...
The enterprise is being consumerized, and the consumer is being enterprised. Moore's Law does not matter anymore, the future belongs to business virtualization powered by invisible service architecture, powered by hyperscale and hyperconvergence, and facilitated by vertical streaming and horizontal scaling and consolidation. Both buyers and sellers want instant results, and from paperwork to paperless to mindless is the ultimate goal for any seamless transaction. The sweetest sweet spot in innov...
Mobile messaging has been a popular communication channel for more than 20 years. Finnish engineer Matti Makkonen invented the idea for SMS (Short Message Service) in 1984, making his vision a reality on December 3, 1992 by sending the first message ("Happy Christmas") from a PC to a cell phone. Since then, the technology has evolved immensely, from both a technology standpoint, and in our everyday uses for it. Originally used for person-to-person (P2P) communication, i.e., Sally sends a text...
SYS-CON Events announced today that ProfitBricks, the provider of painless cloud infrastructure, will exhibit at SYS-CON's 17th International Cloud Expo®, which will take place on November 3–5, 2015, at the Santa Clara Convention Center in Santa Clara, CA. ProfitBricks is the IaaS provider that offers a painless cloud experience for all IT users, with no learning curve. ProfitBricks boasts flexible cloud servers and networking, an integrated Data Center Designer tool for visual control over the...
“The Internet of Things transforms the way organizations leverage machine data and gain insights from it,” noted Splunk’s CTO Snehal Antani, as Splunk announced accelerated momentum in Industrial Data and the IoT. The trend is driven by Splunk’s continued investment in its products and partner ecosystem as well as the creativity of customers and the flexibility to deploy Splunk IoT solutions as software, cloud services or in a hybrid environment. Customers are using Splunk® solutions to collect ...
SYS-CON Events announced today that Alert Logic, the leading provider of Security-as-a-Service solutions for the cloud, has been named “Bronze Sponsor” of SYS-CON's 17th International Cloud Expo® and DevOps Summit 2015 Silicon Valley, which will take place November 3–5, 2015, at the Santa Clara Convention Center in Santa Clara, CA. Alert Logic provides Security-as-a-Service for on-premises, cloud, and hybrid IT infrastructures, delivering deep security insight and continuous protection for cust...
Organizations already struggle with the simple collection of data resulting from the proliferation of IoT, lacking the right infrastructure to manage it. They can't only rely on the cloud to collect and utilize this data because many applications still require dedicated infrastructure for security, redundancy, performance, etc. In his session at 17th Cloud Expo, Emil Sayegh, CEO of Codero Hosting, will discuss how in order to resolve the inherent issues, companies need to combine dedicated a...
You have your devices and your data, but what about the rest of your Internet of Things story? Two popular classes of technologies that nicely handle the Big Data analytics for Internet of Things are Apache Hadoop and NoSQL. Hadoop is designed for parallelizing analytical work across many servers and is ideal for the massive data volumes you create with IoT devices. NoSQL databases such as Apache HBase are ideal for storing and retrieving IoT data as “time series data.”
Clearly the way forward is to move to cloud be it bare metal, VMs or containers. One aspect of the current public clouds that is slowing this cloud migration is cloud lock-in. Every cloud vendor is trying to make it very difficult to move out once a customer has chosen their cloud. In his session at 17th Cloud Expo, Naveen Nimmu, CEO of Clouber, Inc., will advocate that making the inter-cloud migration as simple as changing airlines would help the entire industry to quickly adopt the cloud wit...