Click here to close now.


Microsoft Cloud Authors: Jayaram Krishnaswamy, Elizabeth White, Andreas Grabner, Jim Kaskade, Pat Romanski

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
"Matrix is an ambitious open standard and implementation that's set up to break down the fragmentation problems that exist in IP messaging and VoIP communication," explained John Woolf, Technical Evangelist at Matrix, in this interview at @ThingsExpo, held Nov 4–6, 2014, at the Santa Clara Convention Center in Santa Clara, CA.
As more intelligent IoT applications shift into gear, they’re merging into the ever-increasing traffic flow of the Internet. It won’t be long before we experience bottlenecks, as IoT traffic peaks during rush hours. Organizations that are unprepared will find themselves by the side of the road unable to cross back into the fast lane. As billions of new devices begin to communicate and exchange data – will your infrastructure be scalable enough to handle this new interconnected world?
SYS-CON Events announced today that Super Micro Computer, Inc., a global leader in high-performance, high-efficiency server, storage technology and green computing, will exhibit at the 17th International Cloud Expo®, which will take place on November 3–5, 2015, at the Santa Clara Convention Center in Santa Clara, CA. Supermicro (NASDAQ: SMCI), the leading innovator in high-performance, high-efficiency server technology is a premier provider of advanced server Building Block Solutions® for Data Center, Cloud Computing, Enterprise IT, Hadoop/Big Data, HPC and Embedded Systems worldwide. Supermi...
Nowadays, a large number of sensors and devices are connected to the network. Leading-edge IoT technologies integrate various types of sensor data to create a new value for several business decision scenarios. The transparent cloud is a model of a new IoT emergence service platform. Many service providers store and access various types of sensor data in order to create and find out new business values by integrating such data.
Too often with compelling new technologies market participants become overly enamored with that attractiveness of the technology and neglect underlying business drivers. This tendency, what some call the “newest shiny object syndrome,” is understandable given that virtually all of us are heavily engaged in technology. But it is also mistaken. Without concrete business cases driving its deployment, IoT, like many other technologies before it, will fade into obscurity.
There are so many tools and techniques for data analytics that even for a data scientist the choices, possible systems, and even the types of data can be daunting. In his session at @ThingsExpo, Chris Harrold, Global CTO for Big Data Solutions for EMC Corporation, will show how to perform a simple, but meaningful analysis of social sentiment data using freely available tools that take only minutes to download and install. Participants will get the download information, scripts, and complete end-to-end walkthrough of the analysis from start to finish. Participants will also be given the pract...
WebRTC services have already permeated corporate communications in the form of videoconferencing solutions. However, WebRTC has the potential of going beyond and catalyzing a new class of services providing more than calls with capabilities such as mass-scale real-time media broadcasting, enriched and augmented video, person-to-machine and machine-to-machine communications. In his session at @ThingsExpo, Luis Lopez, CEO of Kurento, will introduce the technologies required for implementing these ideas and some early experiments performed in the Kurento open source software community in areas ...
Electric power utilities face relentless pressure on their financial performance, and reducing distribution grid losses is one of the last untapped opportunities to meet their business goals. Combining IoT-enabled sensors and cloud-based data analytics, utilities now are able to find, quantify and reduce losses faster – and with a smaller IT footprint. Solutions exist using Internet-enabled sensors deployed temporarily at strategic locations within the distribution grid to measure actual line loads.
“In the past year we've seen a lot of stabilization of WebRTC. You can now use it in production with a far greater degree of certainty. A lot of the real developments in the past year have been in things like the data channel, which will enable a whole new type of application," explained Peter Dunkley, Technical Director at Acision, in this interview at @ThingsExpo, held Nov 4–6, 2014, at the Santa Clara Convention Center in Santa Clara, CA.
The Internet of Everything is re-shaping technology trends–moving away from “request/response” architecture to an “always-on” Streaming Web where data is in constant motion and secure, reliable communication is an absolute necessity. As more and more THINGS go online, the challenges that developers will need to address will only increase exponentially. In his session at @ThingsExpo, Todd Greene, Founder & CEO of PubNub, will explore the current state of IoT connectivity and review key trends and technology requirements that will drive the Internet of Things from hype to reality.
There will be 20 billion IoT devices connected to the Internet soon. What if we could control these devices with our voice, mind, or gestures? What if we could teach these devices how to talk to each other? What if these devices could learn how to interact with us (and each other) to make our lives better? What if Jarvis was real? How can I gain these super powers? In his session at 17th Cloud Expo, Chris Matthieu, co-founder and CTO of Octoblu, will show you!
Today’s connected world is moving from devices towards things, what this means is that by using increasingly low cost sensors embedded in devices we can create many new use cases. These span across use cases in cities, vehicles, home, offices, factories, retail environments, worksites, health, logistics, and health. These use cases rely on ubiquitous connectivity and generate massive amounts of data at scale. These technologies enable new business opportunities, ways to optimize and automate, along with new ways to engage with users.
Through WebRTC, audio and video communications are being embedded more easily than ever into applications, helping carriers, enterprises and independent software vendors deliver greater functionality to their end users. With today’s business world increasingly focused on outcomes, users’ growing calls for ease of use, and businesses craving smarter, tighter integration, what’s the next step in delivering a richer, more immersive experience? That richer, more fully integrated experience comes about through a Communications Platform as a Service which allows for messaging, screen sharing, video...
With major technology companies and startups seriously embracing IoT strategies, now is the perfect time to attend @ThingsExpo in Silicon Valley. Learn what is going on, contribute to the discussions, and ensure that your enterprise is as "IoT-Ready" as it can be! Internet of @ThingsExpo, taking place Nov 3-5, 2015, at the Santa Clara Convention Center in Santa Clara, CA, is co-located with 17th Cloud Expo and will feature technical sessions from a rock star conference faculty and the leading industry players in the world. The Internet of Things (IoT) is the most profound change in personal an...
WebRTC converts the entire network into a ubiquitous communications cloud thereby connecting anytime, anywhere through any point. In his session at WebRTC Summit,, Mark Castleman, EIR at Bell Labs and Head of Future X Labs, will discuss how the transformational nature of communications is achieved through the democratizing force of WebRTC. WebRTC is doing for voice what HTML did for web content.
SYS-CON Events announced today that Sandy Carter, IBM General Manager Cloud Ecosystem and Developers, and a Social Business Evangelist, will keynote at the 17th International Cloud Expo®, which will take place on November 3–5, 2015, at the Santa Clara Convention Center in Santa Clara, CA.
The Internet of Things (IoT) is growing rapidly by extending current technologies, products and networks. By 2020, Cisco estimates there will be 50 billion connected devices. Gartner has forecast revenues of over $300 billion, just to IoT suppliers. Now is the time to figure out how you’ll make money – not just create innovative products. With hundreds of new products and companies jumping into the IoT fray every month, there’s no shortage of innovation. Despite this, McKinsey/VisionMobile data shows "less than 10 percent of IoT developers are making enough to support a reasonably sized team....
As a company adopts a DevOps approach to software development, what are key things that both the Dev and Ops side of the business must keep in mind to ensure effective continuous delivery? In his session at DevOps Summit, Mark Hydar, Head of DevOps, Ericsson TV Platforms, will share best practices and provide helpful tips for Ops teams to adopt an open line of communication with the development side of the house to ensure success between the two sides.
The IoT market is on track to hit $7.1 trillion in 2020. The reality is that only a handful of companies are ready for this massive demand. There are a lot of barriers, paint points, traps, and hidden roadblocks. How can we deal with these issues and challenges? The paradigm has changed. Old-style ad-hoc trial-and-error ways will certainly lead you to the dead end. What is mandatory is an overarching and adaptive approach to effectively handle the rapid changes and exponential growth.
Today air travel is a minefield of delays, hassles and customer disappointment. Airlines struggle to revitalize the experience. GE and M2Mi will demonstrate practical examples of how IoT solutions are helping airlines bring back personalization, reduce trip time and improve reliability. In their session at @ThingsExpo, Shyam Varan Nath, Principal Architect with GE, and Dr. Sarah Cooper, M2Mi's VP Business Development and Engineering, will explore the IoT cloud-based platform technologies driving this change including privacy controls, data transparency and integration of real time context w...