000 | 04227nam a2200325 a 4500 | ||
---|---|---|---|
001 | 36843 | ||
005 | 20240430145228.0 | ||
008 | 120917s2012 inua 001 0 eng d | ||
020 |
_a9781118106877 (pbk.) : _c59.99 |
||
020 |
_a1118106873 (pbk.) : _c59.99 |
||
040 |
_aNjBwBT _cNjBwBT |
||
050 | 1 | 4 |
_aQA76.9.C55 _bM5328 2012 |
069 | _a09305507 | ||
090 | _aQA 76.9 .C55 M5328 2012 | ||
245 | 0 | 0 |
_aMicrosoft SQL server 2012 bible / _cAdam Jorgensen ... [et al.]. |
260 |
_aIndianapolis, IN : _bWiley Pub., _cc2012. |
||
300 |
_axxxii, 1384 p. : _bill. ; _c23 cm. |
||
505 | 0 | _a 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 | |
500 | _aIncludes index. | ||
630 | 0 | 0 |
_aSQL server. _9134039 |
650 | 0 |
_aClient/server computing. _953793 |
|
650 | 0 |
_aDatabase management. _9134041 |
|
700 | 1 |
_aJorgensen, Adam. _9134043 |
|
852 | 1 | _9P59.99usd | |
907 |
_a36843 _b10-01-12 _c09-30-12 |
||
942 |
_cBOOK _00 |
||
998 |
_aaudmc _b09-30-12 _cm _da _e- _feng _ginu _h0 |
||
945 |
_g0 _i5074901 _j0 _laudmc _o- _p220.16 _q- _r- _s- _t1 _u0 _v0 _w0 _x0 _yi14046763 _z09-30-12 |
||
999 |
_c36843 _d36843 |