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