Overview

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
Microsoft SQL Server 2012 Bible

Available on NOOK devices and apps  
  • NOOK Devices
  • Samsung Galaxy Tab 4 NOOK
  • NOOK HD/HD+ Tablet
  • NOOK
  • 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
BN.com price
(Save 42%)$59.99 List Price
Note: This NOOK Book can be purchased in bulk. Please email us for more information.

Overview

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: 9781118282175
  • Publisher: Wiley
  • Publication date: 8/6/2012
  • Series: Bible , #773
  • Sold by: Barnes & Noble
  • Format: eBook
  • Edition number: 1
  • Pages: 1416
  • Sales rank: 523,336
  • File size: 53 MB
  • Note: This product may take a few minutes to download.

Meet 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.

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: Client Connectivity 71

Chapter 5: SQL Server Management and Development Tools 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 Physical Database Schema 143

Chapter 8: Data Types, Expressions, and Scalar Functions 173

Chapter 9: Merging Data with Joins, Subqueries, and CTEs 213

Chapter 10: Aggregating, Windowing, and Ranking Data 249

Chapter 11: Projecting Data Through Views 271

Chapter 12: Modifying Data In SQL Server 291

Part III: Advanced T-SQL Data Types and Querying Techniques 323

Chapter 13: Working with Hierarchies 325

Chapter 14: Using XML Data 339

Chapter 15: Executing Distributed Queries 367

Part IV: Programming with T-SQL 387

Chapter 16: Programming with T-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 Service Broker 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 with PowerShell 769

Chapter 31: Managing Data in Windows Azure SQL Database 801

Part VI: Securing Your SQL Server 831

Chapter 32: Authentication Types in SQL Server 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 and Capture 945

Chapter 42: SQL Audit 967

Chapter 43: Management Data Warehouse 977

Part VIII: Performance Tuning and Optimization 993

Chapter 44: Interpreting Query Execution Plans 995

Chapter 45: Indexing Strategies 1005

Chapter 46: Maximizing Query Plan Reuse 1041

Chapter 47: Managing Transactions, Locking, and Blocking 1047

Chapter 48: Data Compression 1097

Chapter 49: Partitioning 1109

Chapter 50: Resource Governor 1131

Part IX: Business Intelligence 1141

Chapter 51: Business Intelligence Database Design 1143

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

Chapter 53: Building Multidimensional Cubes in Analysis Services with MDX 1195

Chapter 54: Confi guring and Administering Analysis Services 1223

Chapter 55: Authoring Reports in Reporting Services 1233

Chapter 56: Configuring and Administering Reporting Services 1261

Chapter 57: Data Mining with Analysis Services 1281

Chapter 58: Creating and Deploying BI Semantic Models 1299

Chapter 59: Creating and Deploying Power View Reports 1327

Index 1347

Read More Show Less

Customer Reviews

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

5 Star

(0)

4 Star

(0)

3 Star

(0)

2 Star

(0)

1 Star

(0)

Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com 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 & Noble.com 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 & Noble.com 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 BN.com 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

Reminder:

  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com 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 BN.com. 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)