Adam Jorgensen, Jorge Segarra, Patrick Leblanc, Jose Chinchilla, Aaron Nelson

Microsoft SQL Server 2012 Bible (eBook, PDF)

• Format: PDF

Produktbeschreibung

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.

---

Dieser Download kann aus rechtlichen Gründen nur mit Rechnungsadresse in D ausgeliefert werden.

Produktdetails

• Verlag: John Wiley & Sons
• Erscheinungstermin: 9. August 2012
• Englisch
• ISBN-13: 9781118286821
• Artikelnr.: 37348995

Autorenporträt

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.

Inhaltsangabe

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