Welcome!

Microsoft Cloud Authors: Elizabeth White, Liz McMillan, Mihai Corbuleac, Pat Romanski, David Bermingham

Blog Feed Post

Microsoft SQL Server 2012 Unleashed Book Review

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

Read the original blog entry...

More Stories By Tad Anderson

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

@ThingsExpo Stories
SYS-CON Events announced today that ContentMX, the marketing technology and services company with a singular mission to increase engagement and drive more conversations for enterprise, channel and SMB technology marketers, has been named “Sponsor & Exhibitor Lounge Sponsor” of SYS-CON's 18th Cloud Expo, which will take place on June 7-9, 2016, at the Javits Center in New York City, New York. “CloudExpo is a great opportunity to start a conversation with new prospects, but what happens after the...
What a difference a year makes. Organizations aren’t just talking about IoT possibilities, it is now baked into their core business strategy. With IoT, billions of devices generating data from different companies on different networks around the globe need to interact. From efficiency to better customer insights to completely new business models, IoT will turn traditional business models upside down. In the new customer-centric age, the key to success is delivering critical services and apps wit...
Join us at Cloud Expo | @ThingsExpo 2016 – June 7-9 at the Javits Center in New York City and November 1-3 at the Santa Clara Convention Center in Santa Clara, CA – and deliver your unique message in a way that is striking and unforgettable by taking advantage of SYS-CON's unmatched high-impact, result-driven event / media packages.
In his keynote at 18th Cloud Expo, Andrew Keys, Co-Founder of ConsenSys Enterprise, will provide an overview of the evolution of the Internet and the Database and the future of their combination – the Blockchain. Andrew Keys is Co-Founder of ConsenSys Enterprise. He comes to ConsenSys Enterprise with capital markets, technology and entrepreneurial experience. Previously, he worked for UBS investment bank in equities analysis. Later, he was responsible for the creation and distribution of life ...
SYS-CON Events announced today that BMC Software has been named "Siver Sponsor" of SYS-CON's 18th Cloud Expo, which will take place on June 7-9, 2015 at the Javits Center in New York, New York. BMC is a global leader in innovative software solutions that help businesses transform into digital enterprises for the ultimate competitive advantage. BMC Digital Enterprise Management is a set of innovative IT solutions designed to make digital business fast, seamless, and optimized from mainframe to mo...
SYS-CON Events announced today that MobiDev will exhibit at SYS-CON's 18th International Cloud Expo®, which will take place on June 7-9, 2016, at the Javits Center in New York City, NY. MobiDev is a software company that develops and delivers turn-key mobile apps, websites, web services, and complex software systems for startups and enterprises. Since 2009 it has grown from a small group of passionate engineers and business managers to a full-scale mobile software company with over 200 develope...
SoftLayer operates a global cloud infrastructure platform built for Internet scale. With a global footprint of data centers and network points of presence, SoftLayer provides infrastructure as a service to leading-edge customers ranging from Web startups to global enterprises. SoftLayer's modular architecture, full-featured API, and sophisticated automation provide unparalleled performance and control. Its flexible unified platform seamlessly spans physical and virtual devices linked via a world...
SYS-CON Events announced today that Alert Logic, Inc., the leading provider of Security-as-a-Service solutions for the cloud, will exhibit at SYS-CON's 18th International Cloud Expo®, which will take place on June 7-9, 2016, at the Javits Center in New York City, NY. Alert Logic, Inc., provides Security-as-a-Service for on-premises, cloud, and hybrid infrastructures, delivering deep security insight and continuous protection for customers at a lower cost than traditional security solutions. Ful...
Companies can harness IoT and predictive analytics to sustain business continuity; predict and manage site performance during emergencies; minimize expensive reactive maintenance; and forecast equipment and maintenance budgets and expenditures. Providing cost-effective, uninterrupted service is challenging, particularly for organizations with geographically dispersed operations.
As cloud and storage projections continue to rise, the number of organizations moving to the cloud is escalating and it is clear cloud storage is here to stay. However, is it secure? Data is the lifeblood for government entities, countries, cloud service providers and enterprises alike and losing or exposing that data can have disastrous results. There are new concepts for data storage on the horizon that will deliver secure solutions for storing and moving sensitive data around the world. ...
SYS-CON Events announced today TechTarget has been named “Media Sponsor” of SYS-CON's 18th International Cloud Expo, which will take place on June 7–9, 2016, at the Javits Center in New York City, NY, and the 19th International Cloud Expo, which will take place on November 1–3, 2016, at the Santa Clara Convention Center in Santa Clara, CA. TechTarget is the Web’s leading destination for serious technology buyers researching and making enterprise technology decisions. Its extensive global networ...
The IoTs will challenge the status quo of how IT and development organizations operate. Or will it? Certainly the fog layer of IoT requires special insights about data ontology, security and transactional integrity. But the developmental challenges are the same: People, Process and Platform. In his session at @ThingsExpo, Craig Sproule, CEO of Metavine, will demonstrate how to move beyond today's coding paradigm and share the must-have mindsets for removing complexity from the development proc...
SYS-CON Events announced today that Commvault, a global leader in enterprise data protection and information management, has been named “Bronze Sponsor” of SYS-CON's 18th International Cloud Expo, which will take place on June 7–9, 2016, at the Javits Center in New York City, NY, and the 19th International Cloud Expo, which will take place on November 1–3, 2016, at the Santa Clara Convention Center in Santa Clara, CA. Commvault is a leading provider of data protection and information management...
SYS-CON Events announced today that MangoApps will exhibit at SYS-CON's 18th International Cloud Expo®, which will take place on June 7-9, 2016, at the Javits Center in New York City, NY. MangoApps provides modern company intranets and team collaboration software, allowing workers to stay connected and productive from anywhere in the world and from any device. For more information, please visit https://www.mangoapps.com/.
The essence of data analysis involves setting up data pipelines that consist of several operations that are chained together – starting from data collection, data quality checks, data integration, data analysis and data visualization (including the setting up of interaction paths in that visualization). In our opinion, the challenges stem from the technology diversity at each stage of the data pipeline as well as the lack of process around the analysis.
Designing IoT applications is complex, but deploying them in a scalable fashion is even more complex. A scalable, API first IaaS cloud is a good start, but in order to understand the various components specific to deploying IoT applications, one needs to understand the architecture of these applications and figure out how to scale these components independently. In his session at @ThingsExpo, Nara Rajagopalan is CEO of Accelerite, will discuss the fundamental architecture of IoT applications, ...
SYS-CON Events announced today that Tintri Inc., a leading producer of VM-aware storage (VAS) for virtualization and cloud environments, will exhibit at the 18th International CloudExpo®, which will take place on June 7-9, 2016, at the Javits Center in New York City, New York, and the 19th International Cloud Expo, which will take place on November 1–3, 2016, at the Santa Clara Convention Center in Santa Clara, CA.
In his session at 18th Cloud Expo, Bruce Swann, Senior Product Marketing Manager at Adobe, will discuss how the Adobe Marketing Cloud can help marketers embrace opportunities for personalized, relevant and real-time customer engagement across offline (direct mail, point of sale, call center) and digital (email, website, SMS, mobile apps, social networks, connected objects). Bruce Swann has more than 15 years of experience working with digital marketing disciplines like web analytics, social med...
A strange thing is happening along the way to the Internet of Things, namely far too many devices to work with and manage. It has become clear that we'll need much higher efficiency user experiences that can allow us to more easily and scalably work with the thousands of devices that will soon be in each of our lives. Enter the conversational interface revolution, combining bots we can literally talk with, gesture to, and even direct with our thoughts, with embedded artificial intelligence, wh...
SYS-CON Events announced today that EastBanc Technologies will exhibit at SYS-CON's 18th International Cloud Expo®, which will take place on June 7-9, 2016, at the Javits Center in New York City, NY. EastBanc Technologies has been working at the frontier of technology since 1999. Today, the firm provides full-lifecycle software development delivering flexible technology solutions that seamlessly integrate with existing systems – whether on premise or cloud. EastBanc Technologies partners with p...