| 000 -LEADER | |
|---|---|
| fixed length control field | 04227nam a2200325 a 4500 |
| 001 - CONTROL NUMBER | |
| control field | 36843 |
| 005 - DATE AND TIME OF LATEST TRANSACTION | |
| control field | 20240430145228.0 |
| 008 - FIXED-LENGTH DATA ELEMENTS--GENERAL INFORMATION | |
| fixed length control field | 120917s2012 inua 001 0 eng d |
| 020 ## - INTERNATIONAL STANDARD BOOK NUMBER | |
| International Standard Book Number | 9781118106877 (pbk.) : |
| Terms of availability | 59.99 |
| 020 ## - INTERNATIONAL STANDARD BOOK NUMBER | |
| International Standard Book Number | 1118106873 (pbk.) : |
| Terms of availability | 59.99 |
| 040 ## - CATALOGING SOURCE | |
| Original cataloging agency | NjBwBT |
| Transcribing agency | NjBwBT |
| 050 14 - LIBRARY OF CONGRESS CALL NUMBER | |
| Classification number | QA76.9.C55 |
| Item number | M5328 2012 |
| 069 ## - | |
| -- | 09305507 |
| 090 ## - LOCALLY ASSIGNED LC-TYPE CALL NUMBER (OCLC); LOCAL CALL NUMBER (OCLC) | |
| Classification number (OCLC) (R) ; Classification number, CALL (RLIN) (NR) | QA 76.9 .C55 M5328 2012 |
| 245 00 - TITLE STATEMENT | |
| Title | Microsoft SQL server 2012 bible / |
| Statement of responsibility, etc | Adam Jorgensen ... [et al.]. |
| 260 ## - PUBLICATION, DISTRIBUTION, ETC. (IMPRINT) | |
| Place of publication, distribution, etc | Indianapolis, IN : |
| Name of publisher, distributor, etc | Wiley Pub., |
| Date of publication, distribution, etc | c2012. |
| 300 ## - PHYSICAL DESCRIPTION | |
| Extent | xxxii, 1384 p. : |
| Other physical details | ill. ; |
| Dimensions | 23 cm. |
| 505 0# - FORMATTED CONTENTS NOTE | |
| Formatted contents note | 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 ## - GENERAL NOTE | |
| General note | Includes index. |
| 630 00 - SUBJECT ADDED ENTRY--UNIFORM TITLE | |
| Uniform title | SQL server. |
| 9 (RLIN) | 134039 |
| 650 #0 - SUBJECT ADDED ENTRY--TOPICAL TERM | |
| Topical term or geographic name as entry element | Client/server computing. |
| 9 (RLIN) | 53793 |
| 650 #0 - SUBJECT ADDED ENTRY--TOPICAL TERM | |
| Topical term or geographic name as entry element | Database management. |
| 9 (RLIN) | 134041 |
| 700 1# - ADDED ENTRY--PERSONAL NAME | |
| Personal name | Jorgensen, Adam. |
| 9 (RLIN) | 134043 |
| 852 1# - LOCATION/CALL NUMBER | |
| -- | P59.99usd |
| 907 ## - LOCAL DATA ELEMENT G, LDG (RLIN) | |
| a | |
| b | 10-01-12 |
| c | 09-30-12 |
| 942 ## - ADDED ENTRY ELEMENTS (KOHA) | |
| Koha item type | Books |
| 998 ## - LOCAL CONTROL INFORMATION (RLIN) | |
| -- | audmc |
| Operator's initials, OID (RLIN) | 09-30-12 |
| Cataloger's initials, CIN (RLIN) | m |
| First Date, FD (RLIN) | a |
| -- | - |
| -- | eng |
| -- | inu |
| -- | 0 |
| 945 ## - LOCAL PROCESSING INFORMATION (OCLC) | |
| g | 0 |
| i | 5074901 |
| j | 0 |
| l | audmc |
| o | - |
| p | 220.16 |
| q | - |
| r | - |
| s | - |
| t | 1 |
| u | 0 |
| v | 0 |
| w | 0 |
| x | 0 |
| y | i14046763 |
| z | 09-30-12 |
| Lost status | Source of classification or shelving scheme | Damaged status | Not for loan | Home library | Current library | Shelving location | Date acquired | Cost, normal purchase price | Total Checkouts | Full call number | Barcode | Date last seen | Cost, replacement price | Price effective from | Koha item type |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Library of Congress Classification | American University in Dubai | American University in Dubai | Main Collection | 2012-09-30 | 220.16 | QA 76.9 .C55 M5328 2012 | 5074901 | 2023-12-01 | 220.16 | 2015-07-25 | Books |