Microsoft SQL Server 2012 Bible


Harness the powerful new SQL Server 2012

Microsoft SQL Server 2012 is the most significant update to this product since 2005, and it may change how database administrators and developers perform many aspects of their jobs. If you're a database administrator or developer, Microsoft SQL Server 2012 Bible teaches you everything you need to take full advantage of this major release. This detailed guide not only covers all the new features of SQL Server 2012, it also shows you step ...

See more details below
$41.07 price
(Save 31%)$59.99 List Price

Pick Up In Store

Reserve and pick up in 60 minutes at your local store

Other sellers (Paperback)
  • All (16) from $30.24   
  • New (12) from $32.90   
  • Used (4) from $30.24   
Microsoft SQL Server 2012 Bible

Available on NOOK devices and apps  
  • NOOK Devices
  • Samsung Galaxy Tab 4 NOOK 7.0
  • Samsung Galaxy Tab 4 NOOK 10.1
  • NOOK HD Tablet
  • NOOK HD+ Tablet
  • NOOK eReaders
  • NOOK Color
  • NOOK Tablet
  • Tablet/Phone
  • NOOK for Windows 8 Tablet
  • NOOK for iOS
  • NOOK for Android
  • NOOK Kids for iPad
  • PC/Mac
  • NOOK for Windows 8
  • NOOK for PC
  • NOOK for Mac
  • NOOK for Web

Want a NOOK? Explore Now

NOOK Book (eBook)
$34.49 price
(Save 42%)$59.99 List Price


Harness the powerful new SQL Server 2012

Microsoft SQL Server 2012 is the most significant update to this product since 2005, and it may change how database administrators and developers perform many aspects of their jobs. If you're a database administrator or developer, Microsoft SQL Server 2012 Bible teaches you everything you need to take full advantage of this major release. This detailed guide not only covers all the new features of SQL Server 2012, it also shows you step by step how to develop top-notch SQL Server databases and new data connections and keep your databases performing at peak.

The book is crammed with specific examples, sample code, and a host of tips, workarounds, and best practices. In addition, downloadable code is available from the book's companion web site, which you can use to jumpstart your own projects.

  • Serves as an authoritative guide to Microsoft's SQL Server 2012 for database administrators and developers
  • Covers all the software's new features and capabilities, including SQL Azure for cloud computing, enhancements to client connectivity, and new functionality that ensures high-availability of mission-critical applications
  • Explains major new changes to the SQL Server Business Intelligence tools, such as Integration, Reporting, and Analysis Services
  • Demonstrates tasks both graphically and in SQL code to enhance your learning
  • Provides source code from the companion web site, which you can use as a basis for your own projects
  • Explores tips, smart workarounds, and best practices to help you on the job

Get thoroughly up to speed on SQL Server 2012 with Microsoft SQL Server 2012 Bible.

Read More Show Less

Product Details

  • ISBN-13: 9781118106877
  • Publisher: Wiley
  • Publication date: 8/28/2012
  • Series: Bible Series, #773
  • Edition number: 1
  • Pages: 1416
  • Sales rank: 675,421
  • Product dimensions: 7.30 (w) x 9.20 (h) x 2.10 (d)

Meet the Author

Adam Jorgensen is the President of Pragmatic WorksConsulting, a Director for the Professional Association of SQLServer (PASS), a SQL Server MVP, and a well-known speaker, author,and executive mentor. His focus is on helping companies realizetheir full potential using their data in ways they have notpreviously imagined. Adam is very involved in the community,delivering more than 75 community sessions per year. Based inJacksonville, FL, Adam has written and contributed to five previousbooks on SQL Server, analytics, and SharePoint. Coauthors JorgeSegarra, Patrick LeBlanc, Jose Chinchilla, and Aaron Nelson arewell-known experts on SQL Server and Business Intelligence.

Read More Show Less

Table of Contents

Introduction    xxix

Part I: Laying the Foundations 1

Chapter 1: The World of SQL Server    3

Chapter 2: Data Architecture     15

Chapter 3: Installing SQL Server     31

Chapter 4: ClientConnectivity       71

Chapter 5: SQL Server Management and DevelopmentTools     81

Part II: Building Databases and Working with Data 109

Chapter 6: Introducing Basic Query Flow   111

Chapter 7: Relational Database Design and Creating the PhysicalDatabase Schema      143

Chapter 8: Data Types, Expressions, and ScalarFunctions      173

Chapter 9: Merging Data with Joins, Subqueries, andCTEs     213

Chapter 10: Aggregating, Windowing, and RankingData    249

Chapter 11: Projecting Data ThroughViews     271

Chapter 12: Modifying Data In SQLServer      291

Part III: Advanced T-SQL Data Types and Querying Techniques323

Chapter 13: Working withHierarchies      325

Chapter 14: Using XML Data      339

Chapter 15: Executing DistributedQueries      367

Part IV: Programming with T-SQL 387

Chapter 16: Programming withT-SQL       389

Chapter 17: Developing Stored Procedures    431

Chapter 18: Building User-Defi ned Functions   453

Part V: Enterprise Data Management 467

Chapter 19: Confi guring SQL Server    469

Chapter 20: Policy Based Management    531

Chapter 21: Backup and Recovery Planning    547

Chapter 22: Maintaining the Database    585

Chapter 23: Transferring Databases    615

Chapter 24: Database Snapshots     635

Chapter 25: Asynchronous Messaging with ServiceBroker      647

Chapter 26: Log Shipping      661

Chapter 27: Database Mirroring     685

Chapter 28: Replicating Data      727

Chapter 29: Clustering      745

Chapter 30: Confi guring and Managing SQL Server withPowerShell  769

Chapter 31: Managing Data in Windows Azure SQLDatabase   801

Part VI: Securing Your SQL Server 831

Chapter 32: Authentication Types in SQLServer     833

Chapter 33: Authorizing Securables    841

Chapter 34: Data Encryption      853

Chapter 35: Row-Level Security     861

Part VII: Monitoring and Auditing 877

Chapter 36: Creating Triggers     879

Chapter 37: Performance Monitor and PAL    909

Chapter 38: Using Profi ler and SQL Trace   919

Chapter 39: Wait States    931

Chapter 40: Extended Events      937

Chapter 41: Data Change Tracking andCapture     945

Chapter 42: SQL Audit      967

Chapter 43: Management Data Warehouse    977

Part VIII: Performance Tuning and Optimization 993

Chapter 44: Interpreting Query ExecutionPlans     995

Chapter 45: Indexing Strategies   1005

Chapter 46: Maximizing Query Plan Reuse    1041

Chapter 47: Managing Transactions, Locking, andBlocking    1047

Chapter 48: Data Compression    1097

Chapter 49: Partitioning      1109

Chapter 50: Resource Governor    1131

Part IX: Business Intelligence 1141

Chapter 51: Business Intelligence DatabaseDesign    1143

Chapter 52: Building, Deploying, and Managing ETL Workfl ows inIntegration Services      1155

Chapter 53: Building Multidimensional Cubes in Analysis Serviceswith MDX   1195

Chapter 54: Confi guring and Administering AnalysisServices     1223

Chapter 55: Authoring Reports in Reporting Services  1233

Chapter 56: Configuring and Administering ReportingServices    1261

Chapter 57: Data Mining with Analysis Services   1281

Chapter 58: Creating and Deploying BI SemanticModels      1299

Chapter 59: Creating and Deploying Power ViewReports      1327

Index      1347

Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star


4 Star


3 Star


2 Star


1 Star


Your Rating:

Your Name: Create a Pen Name or

Barnes & Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation


  • - By submitting a review, you grant to Barnes & and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Terms of Use.
  • - Barnes & reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously

    If you find inappropriate content, please report it to Barnes & Noble
    Why is this product inappropriate?
    Comments (optional)