Sie sind bereits eingeloggt. Klicken Sie auf 2. tolino select Abo, um fortzufahren.
Bitte loggen Sie sich zunächst in Ihr Kundenkonto ein oder registrieren Sie sich bei bücher.de, um das eBook-Abo tolino select nutzen zu können.
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…mehr
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.
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 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
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
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
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
Es gelten unsere Allgemeinen Geschäftsbedingungen: www.buecher.de/agb
Impressum
www.buecher.de ist ein Internetauftritt der buecher.de internetstores GmbH
Geschäftsführung: Monica Sawhney | Roland Kölbl | Günter Hilger
Sitz der Gesellschaft: Batheyer Straße 115 - 117, 58099 Hagen
Postanschrift: Bürgermeister-Wegele-Str. 12, 86167 Augsburg
Amtsgericht Hagen HRB 13257
Steuernummer: 321/neu
