Welcome!

Blog Feed Post

Microsoft SQL Server 2012 A Beginners Guide Book Review

This book is a really great beginners guide for core SQL Server 2012, and it also does a great job of introducing new features introduced in SQL Server 2012. What I mean by core is that topics like Master Data Services and Data Quality Services are not introduced. That is not a bad thing. By limiting the scope of the book, the author was able to better the topics that are included.

I wanted this book because I like having a book about the basics close by. I am not in SQL Server everyday and when I find myself needing to go back to it, I not only want books on the advanced features nearby, I want the basics also.

The book covers all the basics you need to know to get up and running quickly. After a really nice introduction where the author covers the new 2012 features and where they are covered in the book, they have a nice overview of relational databases and detailed coverage of the installation process.

The book is broken into five parts. I have listed the parts and the chapters in each below. The titles of the chapters show the topics covered.

Part I: Basic Concepts and Installation
Chapter 1. Relational Database Systems: An Introduction
Chapter 2. Planning the Installation and Installing SQL Server
Chapter 3. SQL Server Management Studio

Part II: Transact-SQL Language
Chapter 4. SQL Components
Chapter 5. Data Definition Language
Chapter 6. Queries
Chapter 7. Modification of a Table's Contents
Chapter 8. Stored Procedures and User-Defined Functions
Chapter 9. System Catalog
Chapter 10. Indices
Chapter 11. Views
Chapter 12. Security System of the Database Engine
Chapter 13. Concurrency Control
Chapter 14. Triggers

Part III: SQL Server: System Administration
Chapter 15. System Environment of the Database Engine
Chapter 16. Backup, Recovery, and System Availability
Chapter 17. Automating System Administration Tasks
Chapter 18. Data Replication
Chapter 19. Query Optimizer
Chapter 20. Performance Tuning

Part IV: SQL Server and Business Intelligence
Chapter 21. Business Intelligence: An Introduction
Chapter 22. SQL Server Analysis Services
Chapter 23. Business Intelligence and Transact-SQL
Chapter 24. SQL Server Reporting Services
Chapter 25. Optimizing Techniques for Relational Online Analytical Processing

Part V: Beyond Relational Data
Chapter 26. SQL Server and XML
Chapter 27. Spatial Data
Chapter 28. SQL Server Full-Text Search

The author has a great writing style and really explains things clearly making good use of diagrams, code samples, and tables. I mention that because I have seen books that don't.

The author has made all the scripts, sample database, and exercise solutions available. The author also makes use of the AdventureWorks and AdventureWorksDW database. I thought is was strange they didn't use the AdventureWorks2012 and the AdventureWorksDW2012 version available on CodePlex, but that was probably because they weren't available at the time the book was written.

Like I said at the beginning if the review, this is a beginners book, just like the title states. You won't find coverage of topics like cursors, buy you will find all the basics are covered.

All in all I highly recommend this book as the starting point for anyone looking to learn SQL Server 2012

Microsoft SQL Server 2012 A Beginners Guide 5/E (Beginner's Guides)

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.

Latest Stories
Dynatrace is an application performance management software company with products for the information technology departments and digital business owners of medium and large businesses. Building the Future of Monitoring with Artificial Intelligence Today we can collect lots and lots of performance data. We build beautiful dashboards and even have fancy query languages to access and transform the data. Still performance data is a secret language only a couple of people understand. The more busi...
DXWordEXPO New York 2018, colocated with CloudEXPO New York 2018 will be held November 11-13, 2018, in New York City and will bring together Cloud Computing, FinTech and Blockchain, Digital Transformation, Big Data, Internet of Things, DevOps, AI, Machine Learning and WebRTC to one location.
Today, we have more data to manage than ever. We also have better algorithms that help us access our data faster. Cloud is the driving force behind many of the data warehouse advancements we have enjoyed in recent years. But what are the best practices for storing data in the cloud for machine learning and data science applications?
@DevOpsSummit at Cloud Expo, taking place November 12-13 in New York City, NY, is co-located with 22nd international CloudEXPO | first international DXWorldEXPO and will feature technical sessions from a rock star conference faculty and the leading industry players in the world. The widespread success of cloud computing is driving the DevOps revolution in enterprise IT. Now as never before, development teams must communicate and collaborate in a dynamic, 24/7/365 environment. There is no time t...
Bill Schmarzo, author of "Big Data: Understanding How Data Powers Big Business" and "Big Data MBA: Driving Business Strategies with Data Science" is responsible for guiding the technology strategy within Hitachi Vantara for IoT and Analytics. Bill brings a balanced business-technology approach that focuses on business outcomes to drive data, analytics and technology decisions that underpin an organization's digital transformation strategy.
DevOpsSummit New York 2018, colocated with CloudEXPO | DXWorldEXPO New York 2018 will be held November 11-13, 2018, in New York City. Digital Transformation (DX) is a major focus with the introduction of DXWorldEXPO within the program. Successful transformation requires a laser focus on being data-driven and on using all the tools available that enable transformation if they plan to survive over the long term.
Charles Araujo is an industry analyst, internationally recognized authority on the Digital Enterprise and author of The Quantum Age of IT: Why Everything You Know About IT is About to Change. As Principal Analyst with Intellyx, he writes, speaks and advises organizations on how to navigate through this time of disruption. He is also the founder of The Institute for Digital Transformation and a sought after keynote speaker. He has been a regular contributor to both InformationWeek and CIO Insight...
When talking IoT we often focus on the devices, the sensors, the hardware itself. The new smart appliances, the new smart or self-driving cars (which are amalgamations of many ‘things'). When we are looking at the world of IoT, we should take a step back, look at the big picture. What value are these devices providing. IoT is not about the devices, its about the data consumed and generated. The devices are tools, mechanisms, conduits. This paper discusses the considerations when dealing with the...
CI/CD is conceptually straightforward, yet often technically intricate to implement since it requires time and opportunities to develop intimate understanding on not only DevOps processes and operations, but likely product integrations with multiple platforms. This session intends to bridge the gap by offering an intense learning experience while witnessing the processes and operations to build from zero to a simple, yet functional CI/CD pipeline integrated with Jenkins, Github, Docker and Azure...
The now mainstream platform changes stemming from the first Internet boom brought many changes but didn’t really change the basic relationship between servers and the applications running on them. In fact, that was sort of the point. In his session at 18th Cloud Expo, Gordon Haff, senior cloud strategy marketing and evangelism manager at Red Hat, will discuss how today’s workloads require a new model and a new platform for development and execution. The platform must handle a wide range of rec...
CloudEXPO New York 2018, colocated with DXWorldEXPO New York 2018 will be held November 11-13, 2018, in New York City and will bring together Cloud Computing, FinTech and Blockchain, Digital Transformation, Big Data, Internet of Things, DevOps, AI, Machine Learning and WebRTC to one location.
Bill Schmarzo, Tech Chair of "Big Data | Analytics" of upcoming CloudEXPO | DXWorldEXPO New York (November 12-13, 2018, New York City) today announced the outline and schedule of the track. "The track has been designed in experience/degree order," said Schmarzo. "So, that folks who attend the entire track can leave the conference with some of the skills necessary to get their work done when they get back to their offices. It actually ties back to some work that I'm doing at the University of San...
For years the world's most security-focused and distributed organizations - banks, military/defense agencies, global enterprises - have sought to adopt cloud technologies that can reduce costs, future-proof against data growth, and improve user productivity. The challenges of cloud transformation for these kinds of secure organizations have centered around data security, migration from legacy systems, and performance. In our presentation, we will discuss the notion that cloud computing, properl...
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 settlement products to hedge funds and investment banks. After, he co-founded a revenue cycle management company where he learned about Bitcoin and eventually Ethereal. Andrew's role at ConsenSys Enterprise is a mul...
IoT is rapidly becoming mainstream as more and more investments are made into the platforms and technology. As this movement continues to expand and gain momentum it creates a massive wall of noise that can be difficult to sift through. Unfortunately, this inevitably makes IoT less approachable for people to get started with and can hamper efforts to integrate this key technology into your own portfolio. There are so many connected products already in place today with many hundreds more on the h...