Book Image

What's New in SQL Server 2012

Book Image

What's New in SQL Server 2012

Overview of this book

Microsoft SQL Server has been part of the enterprise database landscape since SQL Server 7 arrived in 1998 and has evolved into the relational and BI platform of choice by businesses around the globe. The performance and full feature set of SQL Server has been widely recognized by the business community and it is viewed as a powerful weapon in their database and business intelligence arsenal. SQL Server brings numerous benefits to all businesses, central to which is a thorough understanding of the technology, both current and new.This is the book both DBAs and developers always wanted to buy but could never find in the bookstore. This is a SQL Server book that contains only the new features introduced in SQL Server 2012.This book will give you a competitive advantage by helping you to quickly learn and understand the new features of SQL Server 2012. Most readers will already have an established knowledge of SQL Server and will want to update their 2008/2008R2 knowledge swiftly with least pain.This book takes you through all of the new features of SQL Server 2012, from installing core database services and features, to the new administration and updated Transact-SQL functions. You will discover the new Analysis Services features, introduce data alerts and reporting features and explore the new enhancements to Integration Services. In addition you will learn how to automate, cleanse and transform critical business data with DQS and world-class enterprise level availability features.Finally, you will venture into simulating real-world database loads using Distributed Replay and complete your journey with a look at the new SQL Server cloud services and the new Hadoop big data platform.
Table of Contents (19 chapters)
What's New in SQL Server 2012
Credits
About the Authors
Acknowledgment
Acknowledgment
About the Reviewers
www.PacktPub.com
Preface
Free Chapter
1
Installing SQL Server 2012
Index

Acknowledgment

This, my first book, is dedicated to Steve Potts, an extraordinary teacher. He willingly gave up his lunchtimes and endless extra hours teaching an intense, hyperactive, and very inquisitive eleven-year old how to solder together computers and write 6502 assembly language. Amazingly, I can still do both! If you are reading this Steve, a huge "thank you"—it was time well invested. You kindled an interest for life that turned into a career that has taken me to some fascinating places no one could have imagined back then.

In chronological order, I would like to thank Dilip Ventakesh at Packt Publishing, who first approached me with the idea for this book back in 2011. Likewise to Professor Mark Whitehorn, Chair of Analytics at the University of Dundee in Scotland, who not only encouraged me in this endeavor, but spent his valuable time taking me through an impromptu telephone crash course on authoring.

Equal thanks go to our patient reviewers at Packt Publishing, especially Sonali Tharwani, who together with our external reviewers, Phil Brammer (@PhilBrammer) and Raunak Jhawar, reviewed every chapter of this book. I would also like to thank Allan Mitchell, who gave us very useful and detailed feedback on the BI stack chapters.

An extra special thanks must be extended to Simon Robinson, a good friend and colleague, and Senior Software Engineer at Nokia. I had the pleasure of working closely with Simon for three years, and know him as a highly competent database developer and DBA. He not only reviewed the Hadoop chapter for us, but also added valuable extra content born out of his greater experience with Hadoop in a production environment. Thanks Simon!

My final reviewer thanks also go to two fellow database professionals, who are also good friends, for their dedication to this title. Alison Coughtrie, Data Warehouse Architect at the University of Dundee in Scotland, and Lynlee Moon (Li Li), EMEA DBA Manager at NewEdge in London, who have both done great jobs at very short notice turning around their reviews. A personal "thank you" from me to both of you.

Of course my final thanks must go to my co-author and SQL Server BI Developer, Rachel. Over ten months, we have spent every weekend and countless evenings researching, writing, and rewriting this book as the shifting sands of a brand new and very large SQL Server release have moved beneath our feet. Your journalistic training, writing discipline, attention to detail, and enthusiasm have all made this a better book than I could have written by myself, and it has been good fun and a pleasure writing it with you. Somehow, and thankfully, your good sense of humor has remained intact! A big thank you for being a great co-author who has truly shared an immense effort.

When do you want to start writing the next one?