Microsoft SQL Server 2012 Bible
by Jorgensen, Adam; Segarra, Jorge; LeBlanc, Patrick; Chinchilla, Jose; Nelson, AaronEdition: 1st
Format: Paperback
Pub. Date: 2012-08-28
Publisher(s): Wiley
Other versions by this Author
List Price: $59.99
Buy New
Usually Ships in 8 - 10 Business Days.
$59.93
Rent Book
Select for Price
Rent Digital
$43.20*
Used Book
We're Sorry
Sold Out
How Marketplace Works:
- This item is offered by an independent seller and not shipped from our warehouse
- Item details like edition and cover design may differ from our description; see seller's comments before ordering.
- Sellers much confirm and ship within two business days; otherwise, the order will be cancelled and refunded.
- Marketplace purchases cannot be returned to eCampus.com. Contact the seller directly for inquiries; if no response within two days, contact customer service.
- Additional shipping costs apply to Marketplace purchases. Review shipping costs at checkout.
Summary
Harness the powerful new SQL Server 2011 Microsoft SQL Server 2011 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 youre a database administrator or developer, Microsoft SQL Server 2011 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 2011, 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 books companion web site, which you can use to jumpstart your own projects. Serves as an authoritative guide to Microsofts SQL Server 2011 for database administrators and developers Covers all the softwares 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 2011 with Microsoft SQL Server 2011 Bible.
Author Biography
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.
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
An electronic version of this book is available through VitalSource.
This book is viewable on PC, Mac, iPhone, iPad, iPod Touch, and most smartphones.
By purchasing, you will be able to view this book online, as well as download it, for the chosen number of days.
Digital License
You are licensing a digital product for a set duration. Durations are set forth in the product description, with "Lifetime" typically meaning five (5) years of online access and permanent download to a supported device. All licenses are non-transferable.
More details can be found here.
A downloadable version of this book is available through the eCampus Reader or compatible Adobe readers.
Applications are available on iOS, Android, PC, Mac, and Windows Mobile platforms.
Please view the compatibility matrix prior to purchase.