SYS-CON MEDIA Authors: Stackify Blog, Zakia Bouachraoui, Elizabeth White, Pat Romanski, Liz McMillan

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
Serverless applications increase developer productivity and time to market, by freeing engineers from spending time on infrastructure provisioning, configuration and management. Serverless also simplifies Operations and reduces cost - as the Kubernetes container infrastructure required to run these applications is automatically spun up and scaled precisely with the workload, to optimally handle all runtime requests. Recent advances in open source technology now allow organizations to run Serv...
In a recent survey, Sumo Logic surveyed 1,500 customers who employ cloud services such as Amazon Web Services (AWS), Microsoft Azure, and Google Cloud Platform (GCP). According to the survey, a quarter of the respondents have already deployed Docker containers and nearly as many (23 percent) are employing the AWS Lambda serverless computing framework. It's clear: serverless is here to stay. The adoption does come with some needed changes, within both application development and operations. Th...
The benefits of automated cloud deployments for speed, reliability and security are undeniable. The cornerstone of this approach, immutable deployment, promotes the idea of continuously rolling safe, stable images instead of trying to keep up with managing a fixed pool of virtual or physical machines. In this talk, we'll explore the immutable infrastructure pattern and how to use continuous deployment and continuous integration (CI/CD) process to build and manage server images for any platform....
AI and machine learning disruption for Enterprises started happening in the areas such as IT operations management (ITOPs) and Cloud management and SaaS apps. In 2019 CIOs will see disruptive solutions for Cloud & Devops, AI/ML driven IT Ops and Cloud Ops. Customers want AI-driven multi-cloud operations for monitoring, detection, prevention of disruptions. Disruptions cause revenue loss, unhappy users, impacts brand reputation etc.
Atmosera delivers modern cloud services that maximize the advantages of cloud-based infrastructures. Offering private, hybrid, and public cloud solutions, Atmosera works closely with customers to engineer, deploy, and operate cloud architectures with advanced services that deliver strategic business outcomes. Atmosera's expertise simplifies the process of cloud transformation and our 20+ years of experience managing complex IT environments provides our customers with the confidence and trust tha...
Containers and Kubernetes allow for code portability across on-premise VMs, bare metal, or multiple cloud provider environments. Yet, despite this portability promise, developers may include configuration and application definitions that constrain or even eliminate application portability. In this session we'll describe best practices for "configuration as code" in a Kubernetes environment. We will demonstrate how a properly constructed containerized app can be deployed to both Amazon and Azure ...
Enterprises are adopting Kubernetes to accelerate the development and the delivery of cloud-native applications. However, sharing a Kubernetes cluster between members of the same team can be challenging. And, sharing clusters across multiple teams is even harder. Kubernetes offers several constructs to help implement segmentation and isolation. However, these primitives can be complex to understand and apply. As a result, it’s becoming common for enterprises to end up with several clusters. This...
Is advanced scheduling in Kubernetes achievable?Yes, however, how do you properly accommodate every real-life scenario that a Kubernetes user might encounter? How do you leverage advanced scheduling techniques to shape and describe each scenario in easy-to-use rules and configurations? In his session at @DevOpsSummit at 21st Cloud Expo, Oleg Chunikhin, CTO at Kublr, answered these questions and demonstrated techniques for implementing advanced scheduling. For example, using spot instances and co...
At CloudEXPO Silicon Valley, June 24-26, 2019, Digital Transformation (DX) is a major focus with expanded DevOpsSUMMIT and FinTechEXPO programs within the DXWorldEXPO agenda. 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. A total of 88% of Fortune 500 companies from a generation ago are now out of business. Only 12% still survive. Similar percentages are found throug...
Public clouds dominate IT conversations but the next phase of cloud evolutions are "multi" hybrid cloud environments. The winners in the cloud services industry will be those organizations that understand how to leverage these technologies as complete service solutions for specific customer verticals. In turn, both business and IT actors throughout the enterprise will need to increase their engagement with multi-cloud deployments today while planning a technology strategy that will constitute a ...
GCP Marketplace is based on a multi-cloud and hybrid-first philosophy, focused on giving Google Cloud partners and enterprise customers flexibility without lock-in. It also helps customers innovate by easily adopting new technologies from ISV partners, such as commercial Kubernetes applications, and allows companies to oversee the full lifecycle of a solution, from discovery through management.
Using serverless computing has a number of obvious benefits over traditional application infrastructure - you pay only for what you use, scale up or down immediately to match supply with demand, and avoid operating any server infrastructure at all. However, implementing maintainable and scalable applications using serverless computing services like AWS Lambda poses a number of challenges. The absence of long-lived, user-managed servers means that states cannot be maintained by the service. Lo...
Today most companies are adopting or evaluating container technology - Docker in particular - to speed up application deployment, drive down cost, ease management and make application delivery more flexible overall. As with most new architectures, this dream takes significant work to become a reality. Even when you do get your application componentized enough and packaged properly, there are still challenges for DevOps teams to making the shift to continuous delivery and achieving that reducti...
Using serverless computing has a number of obvious benefits over traditional application infrastructure - you pay only for what you use, scale up or down immediately to match supply with demand, and avoid operating any server infrastructure at all. However, implementing maintainable and scalable applications using serverless computing services like AWS Lambda poses a number of challenges. The absence of long-lived, user-managed servers means that states cannot be maintained by the service. Lo...
At CloudEXPO Silicon Valley, June 24-26, 2019, Digital Transformation (DX) is a major focus with expanded DevOpsSUMMIT and FinTechEXPO programs within the DXWorldEXPO agenda. 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. A total of 88% of Fortune 500 companies from a generation ago are now out of business. Only 12% still survive. Similar percentages are found throug...