Microsoft SQL Server 2012 Bible and over one million other books are available for Amazon Kindle. Learn more
CDN$ 45.13
  • List Price: CDN$ 71.99
  • You Save: CDN$ 26.86 (37%)
Only 7 left in stock (more on the way).
Ships from and sold by Amazon.ca.
Gift-wrap available.
Quantity:1
Have one to sell?
Flip to back Flip to front
Listen Playing... Paused   You're listening to a sample of the Audible audio edition.
Learn more
See all 2 images

Microsoft SQL Server 2012 Bible Paperback – Aug 28 2012


See all 3 formats and editions Hide other formats and editions
Amazon Price New from Used from
Kindle Edition
"Please retry"
Paperback
"Please retry"
CDN$ 45.13
CDN$ 45.13 CDN$ 68.93

2014 Books Gift Guide
Thug Kitchen, adapted from the wildly popular web site beloved by Gwyneth Paltrow ("This might be my favorite thing ever"), is featured in our 2014 Books Gift Guide. More gift ideas

Frequently Bought Together

Microsoft SQL Server 2012 Bible + Professional Microsoft SQL Server 2012 Administration
Price For Both: CDN$ 82.74


Customers Who Bought This Item Also Bought



Product Details


Product Description

From the Back Cover

Something for you on every page

If you're a database administrator or developer, this book is your complete, one-stop resource for SQL Server 2012. The authors provide in-depth coverage of core techniques, best practices, and smart workarounds, as well as plenty of examples and sample code. They also fully cover such new features as AlwwaysOn connectivity, new indexes, Power View, Master Data Services, Data Quality Services, PowerPivot for SQL Server 2012, and more.

  • Thoroughly explore all new features in SQL Server 2012
  • Understand advanced T-SQL data types and querying techniques
  • Ensure high availability for mission-critical applications
  • Start using SQL Azure for cloud computing
  • Master new security and compliance settings
  • Leverage your data with tools for BI, data warehousing, and Enterprise Information Management solutions
  • Get up to speed on the latest enhancements to the BI toolset

About the Author

Adam Jorgensen is the President of Pragmatic Works Consulting, a Director for the Professional Association of SQL Server (PASS), a SQL Server MVP, and a well-known speaker, author, and executive mentor. His focus is on helping companies realize their full potential using their data in ways they have not previously imagined. Adam is very involved in the community, delivering more than 75 community sessions per year. Based in Jacksonville, FL, Adam has written and contributed to five previous books on SQL Server, analytics, and SharePoint. Coauthors Jorge Segarra, Patrick LeBlanc, Jose Chinchilla, and Aaron Nelson are well-known experts on SQL Server and Business Intelligence.


Inside This Book (Learn More)
Browse Sample Pages
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
Search inside this book:

What Other Items Do Customers Buy After Viewing This Item?

Customer Reviews

There are no customer reviews yet on Amazon.ca
5 star
4 star
3 star
2 star
1 star

Most Helpful Customer Reviews on Amazon.com (beta)

Amazon.com: 10 reviews
13 of 13 people found the following review helpful
Targeted towards beginner to mid-level DBA and developers Dec 31 2012
By Jaewoo Kim - Published on Amazon.com
Format: Paperback Verified Purchase
This is a good book if you are new to MS SQL. There is much to learn here.

If you are already intimately familiar with previous versions of MS SQL (2005-2008), then the value of this book will be limited.

There simply isn't enough advanced information. But there is plenty of beginner to intermediate knowledge that would be very helpful, which I think is the target audience of this book.

Pros:
1)Comprehensive coverage of all aspects of MS SQL 2012 (much of the knowledge is also applicable to SQL 2005 and 2008).
2)Well written and good explanations. I particularly like the sample code in the text.

Cons:
1)There is a lot of breadth but not a ton of depth. Many topics are covered only superficially.
2)Not enough information on how MS SQL 2012 is different from MS SQL 2008.
3 of 3 people found the following review helpful
Very thorough, but with some errors Feb. 16 2014
By Jeremiah - Published on Amazon.com
Format: Paperback Verified Purchase
I found this book to be very thorough with all of it's examples and explanations. I did not however, like the fact that there were some proofing mistakes, e.g. misspelled words or even wrong diagrams (even though the provided diagram showed the same thing, but was not related to the exact example provided in the text). The proofing errors bothered me quite a bit since have a degree in English.

If you can get past a few errors, this book will be highly valuable for you if you are looking at a job that relies heavily on SQL (query performance tuning, custom reporting, T-SQL, etc).
2 of 2 people found the following review helpful
Very good reference, but lacks depth Jan. 5 2014
By D. Johnson - Published on Amazon.com
Format: Paperback Verified Purchase
The SQL Server 2012 Bible is a very good book, and it goes far beyond any documentation or examples that Microsoft provides for its own product. The book covers nearly every topic at some level, but that is sort of my one complaint with the book -- it never goes very deep with any topics. You'll find one or two examples for each of the concepts it covers, but that is about it -- it doesn't discuss, for example, the meaning of every parameter of a built-in stored procedure call. Or the possible meaning of every option of every T-SQL command. For that we're still stuck to searching online and crossing our fingers that we'll find something.

I know that is partly the nature of the book, because it does try to cover everything, but if someone is looking for in-depth examples on specific topics, perhaps a more specialized book is a better choice.

But for anyone looking for a general purpose reference for SQL Server, this is excellent, and should be the first SQL Server book you purchase.
The best book on SQL Server 2012 Nov. 8 2014
By Mario De Ghetto - Published on Amazon.com
Format: Paperback
I have written many reviews on the books of the series "Bible" and once again I must to emphasize the high quality of these books, in "physical" terms (quality of paper and binding, layout, font and images usage etc.) and from the point of view of content.
In this case, the book focuses on Microsoft SQL Server 2012, a professional-level and distributed DBMS with various types of licenses. The SQL Server 2012 Express edition is even distributed free of charge, with the only limit of 10 GB per database, to allow its use for limited applications (study, personal productivity, small business realities, and so on).
The book is structured very well: start with the basics, then move on to programming with T-SQL and stored procedures, then it provides the necessary informations for its use in a company, including its Business Intelligence Platform.
In the part relating to the design of the database, there is an explanation of 'theory of databases' (keys, relationships, normal forms), absolutely essential for anyone who has not practice with databases, but also for those who need only a simple memory "refreshing".
Finally, if you go on the website (http://eu.wiley.com/WileyCDA/WileyTitle/productCd-1118106873.html ), you can find all the examples and code fragments TSQL.
In conclusion, a remarkable book and essential for anyone who wants to experiment with SQL Server 2012.

Here is the list of the 59 chapters of the book:

Part I: Laying the Foundations 1

Chapter 1: The World of SQL Server
Chapter 2: Data Architecture
Chapter 3: Installing SQL Server
Chapter 4: Client Connectivity
Chapter 5: SQL Server Management and Development Tools

Part II: Building Databases and Working with Data
Chapter 6: Introducing Basic Query Flow
Chapter 7: Relational Database Design and Creating the Physical Database Schema
Chapter 8: Data Types, Expressions, and Scalar Functions
Chapter 9: Merging Data with Joins, Subqueries, and CTEs
Chapter 10: Aggregating, Windowing, and Ranking Data
Chapter 11: Projecting Data Through Views
Chapter 12: Modifying Data In SQL Server

Part III: Advanced T-SQL Data Types and Querying Techniques
Chapter 13: Working with Hierarchies
Chapter 14: Using XML Data
Chapter 15: Executing Distributed Queries

Part IV: Programming with T-SQL
Chapter 16: Programming with T-SQL
Chapter 17: Developing Stored Procedures
Chapter 18: Building User-Defi ned Functions

Part V: Enterprise Data Management
Chapter 19: Confi guring SQL Server
Chapter 20: Policy Based Management
Chapter 21: Backup and Recovery Planning
Chapter 22: Maintaining the Database
Chapter 23: Transferring Databases
Chapter 24: Database Snapshots
Chapter 25: Asynchronous Messaging with Service Broker
Chapter 26: Log Shipping
Chapter 27: Database Mirroring
Chapter 28: Replicating Data
Chapter 29: Clustering
Chapter 30: Confi guring and Managing SQL Server with PowerShell
Chapter 31: Managing Data in Windows Azure SQL Database

Part VI: Securing Your SQL Server
Chapter 32: Authentication Types in SQL Server
Chapter 33: Authorizing Securables
Chapter 34: Data Encryption
Chapter 35: Row-Level Security

Part VII: Monitoring and Auditing
Chapter 36: Creating Triggers
Chapter 37: Performance Monitor and PAL
Chapter 38: Using Profi ler and SQL Trace
Chapter 39: Wait States
Chapter 40: Extended Events
Chapter 41: Data Change Tracking and Capture
Chapter 42: SQL Audit
Chapter 43: Management Data Warehouse

Part VIII: Performance Tuning and Optimization
Chapter 44: Interpreting Query Execution Plans
Chapter 45: Indexing Strategies
Chapter 46: Maximizing Query Plan Reuse
Chapter 47: Managing Transactions, Locking, and Blocking
Chapter 48: Data Compression
Chapter 49: Partitioning
Chapter 50: Resource Governor

Part IX: Business Intelligence
Chapter 51: Business Intelligence Database Design
Chapter 52: Building, Deploying, and Managing ETL Workflows in Integration Services
Chapter 53: Building Multidimensional Cubes in Analysis Services with MDX
Chapter 54: Confi guring and Administering Analysis Services
Chapter 55: Authoring Reports in Reporting Services
Chapter 56: Configuring and Administering Reporting Services
Chapter 57: Data Mining with Analysis Services
Chapter 58: Creating and Deploying BI Semantic Models
Chapter 59: Creating and Deploying Power View Reports

Italian version of this book review: http://fsharpdazero.wordpress.com/2014/11/09/recensione-del-libro-sql-server-2012-bible-2/
A great deal of information Sept. 13 2013
By L. Smith - Published on Amazon.com
Format: Kindle Edition Verified Purchase
contains a lot of very useful information. It has come up short in some areas (encryption) with supplying complete information and examples. Overall, it's ok/useful.


Feedback