|
|
|
|
| LEADER |
11561nmm a2200505 u 4500 |
| 001 |
EB001935055 |
| 003 |
EBX01000000000000001097957 |
| 005 |
00000000000000.0 |
| 007 |
cr||||||||||||||||||||| |
| 008 |
210123 ||| eng |
| 020 |
|
|
|a 9781118654736
|
| 020 |
|
|
|a 1118654730
|
| 020 |
|
|
|a 9781118654903
|
| 050 |
|
4 |
|a QA76.9.D3
|
| 100 |
1 |
|
|a Carpenter, Tom
|
| 245 |
0 |
0 |
|a Microsoft SQL Server 2012 administration
|b real-world skills for MCSA certification and beyond : exams 70-461, 70-462, and 70-463
|c Tom Carpenter
|
| 260 |
|
|
|a Hoboken, N.J.
|b John Wiley & Sons
|c 2013
|
| 300 |
|
|
|a 1 online resource
|
| 505 |
0 |
|
|a File System Management -- Network Configuration Administration -- Summary -- Chapter Essentials -- Chapter 4: SQL Server Command-Line Administration -- Introducing the Command Prompt -- General Command-Prompt Options -- Font Settings -- Screen Layout -- Color Choices -- General Commands -- Directory and Folder Navigation -- Directory and Folder Listing -- Screen Management -- Displaying Information -- Redirecting Output -- Administrative Commands -- Batch Files -- Using Logic (IF and GOTO) -- Passing Data -- Including Comments -- Mastering SQLCMD -- Introducing Windows PowerShell -- Using SQL Server PowerShell Extensions -- Summary -- Chapter Essentials -- Chapter 5: Querying SQL Server -- Understanding the SQL Language -- Queries -- Short Learning Curve -- Varied Query Modes -- Standardization -- Added Logical Capabilities of T-SQL -- SQL Statement Types -- Data Manipulation Language -- Data Definition Language -- Data Control Language -- SQL Syntactical Elements -- Keywords -- Comments -- Batch Directives -- SQL Statements -- Clauses -- Identifiers -- Variables -- Data Types -- System Functions -- Operators and Expressions -- Statement Terminator -- Coding Recommendations -- Capitalize Keywords -- Use Standard SQL -- Do Not Use Keywords as Identifiers -- Using SELECT Statements -- Basic SELECT Statements -- Filtered SELECT Statements -- Sorted SELECT Statements -- Handling NULL Data -- Converting Data in Result Sets -- Identifying Collation Details -- Using Data from Multiple Tables -- Advanced Query Techniques -- Subqueries -- Aggregate Queries -- Using DDL Statements -- Creating Objects -- Altering Objects -- Deleting Objects -- Using DCL Statements -- Granting Access -- Denying Access -- Revoking Permissions -- Modifying Data -- The INSERT Statement -- The UPDATE Statement -- The DELETE Statement -- Tuning and Optimizing Queries
|
| 505 |
0 |
|
|a Cover -- Copyright -- Acknowledgments -- About the Author -- Contents at a Glance -- Contents -- Table of Exercises -- Introduction -- Who Should Read This Book -- What You Will Learn -- What You Need -- Suggested Home Lab Setup -- What Is Covered in This Book -- Additional Study Tools -- How to Contact the Author -- Part I: Introducing SQL Server 2012 -- Chapter 1: Understanding SQL Server's Role -- What Is Information Technology? -- The Importance of IT -- The Components of IT -- Introduction to Databases -- Types of Databases -- Weighing the Benefits of Using a Local or Server-Based Database -- Important Database Terms -- Database Servers and Applications -- Database Application Types -- SQL Server's Role -- New Features Introduced in SQL Server 2012 -- Features Introduced in SQL Server 2008 -- Features Introduced in SQL Server 2005 -- Core Features of SQL Server -- SQL Server Roles -- Summary -- Chapter Essentials -- Chapter 2: Installing SQL Server 2012 -- Installation Planning -- SQL Server 2012 Architecture -- Installation Planning Process -- Managing Permissions -- Installing a Default Instance -- SQL Server Installation Center Tasks -- Installation -- Installing Named Instances -- Installing to a Cluster -- Installing Extra Features -- Upgrading from Previous Versions -- Handling Upgrades -- Understanding Migrations -- Validating an Installation -- Removing an Installation -- Summary -- Chapter Essentials -- Chapter 3: Working with the Administration Tools -- SQL Server Configuration Manager -- Overview of the SSCM -- Performing Common SSCM Tasks -- SQL Server Management Studio -- Overview of the SSMS -- Performing Common SSMS Tasks -- SQL Server Data Tools -- Overview of SSDT -- Performing Common SSDT Tasks -- SQL Server Profiler -- Books Online -- Windows Server Administration for the DBA -- User Account Management
|
| 505 |
0 |
|
|a Chapter 14: Creating Jobs, Operators, and Alerts -- Standardize, Automate, and Update -- Understanding SQL Server Jobs -- Job Steps -- Job Configuration Properties -- Typical Jobs -- Creating T-SQL Jobs -- Creating SSIS Jobs -- Creating Windows Command Jobs -- Creating and Using Operators -- Creating and Using Alerts -- Using WSUS for SQL Server 2012 -- Summary -- Chapter Essentials -- Chapter 15: Performance Monitoring and Tuning -- Performance Tuning Principles -- Why Performance Tuning Matters -- Common Performance Tuning Myths -- Performance and Troubleshooting Tools -- Blocks, Locks, and Deadlocks -- Understanding Locks -- Lock Types -- Granularity of Locks -- Lock Isolation Levels -- Blocks and Deadlocks -- SQL Server Profiler -- Database Engine Tuning Advisor -- Creating a DTA Workload File -- Analyzing Your Workload File -- Applying DTA Recommendations -- Performance Monitoring with System Monitor -- Installing the System Monitor -- Viewing Live Performance Data -- Logging Counters in Windows Server 2003 -- Data Collection in Windows Server 2008 -- Using the Resource Governor -- Performance Studio -- Advanced Monitoring Tools -- Dynamic Management Views -- DBCC -- Resource Monitor -- Summary -- Chapter Essentials -- Chapter 16: Policy-Based Management -- Policy-Based Management -- PBM Components -- Creating Conditions -- Creating Policies -- Evaluating Policies -- Centralized Server Management -- Major Benefits and Requirements -- Creating a Central Management Server -- Registering Subscriber Servers -- Standardizing with PBM and CMS -- Standardizing -- Automating -- Updating -- Summary -- Chapter Essentials -- Chapter 17: Backup and Restoration -- Backing Up a Database -- Creating a Backup Plan -- Choosing a Recovery Model -- Using the Different Backup Types -- Working with Backup Devices and Files -- Compressing Backups
|
| 505 |
0 |
|
|a Transaction Processing -- Error Handling -- Summary -- Chapter Essentials -- Part II: Designing Database Solutions -- Chapter 6: Database Concepts and Terminology -- Relational Database Theory -- Data -- Information -- Tables -- Table Components -- Relationship Types -- Database Design Processes -- Systems Development Life Cycle -- Database Life Cycle -- Business, Users, Model -- Project Management for the DBA -- The Define Phase -- The Design Phase -- The Deliver Phase -- The Determine Phase -- Summary -- Chapter Essentials -- Chapter 7: ERD and Capacity Planning -- Planning a Database -- User Surveys -- Evaluating Business Processes -- Developing Use Cases -- Understanding Entity Relationship Diagramming -- Building an ERD -- Creating an ERD in Visio -- Creating an ERD in OSA -- Capacity Planning -- Summary -- Chapter Essentials -- Chapter 8: Normalization and Other Design Issues -- Designing for Normalization -- Normal Forms -- Normalizing a Database -- Denormalizing a Database -- Designing for Performance -- Designing for Availability -- Designing for Security -- Summary -- Chapter Essentials -- Part III: Implementing Database Solutions -- Chapter 9: Creating SQL Server Databases -- SQL Server Databases -- System Databases -- User Databases -- Database Storage -- Database Data Files -- Database Filegroups -- Transaction Logs -- Database Options and Properties -- Autogrowth -- Recovery Model -- Compatibility Level -- Auto Shrink -- Restrict Access -- More Database Properties -- Creating Databases in the GUI -- Creating Databases with T-SQL -- Creating Databases with PowerShell -- Attaching and Detaching Databases -- Database Snapshots -- Creating Snapshots -- Reverting to Snapshots -- Summary -- Chapter Essentials -- Chapter 10: Creating Tables -- Data Types -- Data Type Categories -- Collations -- Configuring Server Instance Collations
|
| 505 |
0 |
|
|a Configuring Database Collations -- Configuring Column Collations -- Table Creation Process -- Creating Tables with the Table Designer -- Creating Tables with T-SQL -- Data Partitioning -- Vertical and Horizontal Partitioning -- Data Partitioning with Functions and Schemes -- Summary -- Chapter Essentials -- Chapter 11: Indexes and Views -- Understanding Indexes -- Indexes Defined -- Index Types -- Creating Basic Indexes -- Creating a Clustered Index -- Creating a Nonclustered Index -- Creating Advanced Indexes -- Creating a Covering Index -- Creating a Filtered Index -- Managing Indexes -- Dropping an Index -- Disabling and Enabling Indexes -- Understanding Index Fragmentation -- Understanding Views -- Creating Views -- Summary -- Chapter Essentials -- Chapter 12: Triggers and Stored Procedures -- Triggers Defined -- Types of Triggers -- Recursive and Nested Triggers -- Using Triggers -- Creating Triggers -- Understanding Stored Procedures -- Creating Stored Procedures -- How Triggers Differ from Stored Procedures -- Summary -- Chapter Essentials -- Chapter 13: Implementing Advanced Features -- Understanding and Installing Analysis Services -- Analysis Services Tools -- Analysis Services Optional Components -- Installing and Configuring Analysis Services -- Understanding Integration Services -- Installing and Configuring Integration Services -- Creating a Basic Integration Services Package -- Troubleshooting and Debugging an SSIS Package -- Scheduling Your Package to Run Automatically -- Security Protection Levels -- Understanding and Installing Reporting Services -- Implementing Database Mail -- Configuring Full-Text Indexing -- Implementing Transparent Data Encryption -- TDE Architecture -- TDE Implementation Process -- Data Compression -- Summary -- Chapter Essentials -- Part IV: Administering and Maintaining SQL Server 2012
|
| 653 |
|
|
|a Database management / Examinations / fast
|
| 653 |
|
|
|a SQL server / fast
|
| 653 |
|
|
|a COMPUTERS / Data Processing / bisacsh
|
| 653 |
|
|
|a Electronic data processing personnel / Certification / fast
|
| 653 |
|
|
|a Bases de données / Gestion / Examens / Guides de l'étudiant
|
| 653 |
|
|
|a SQL server / http://id.loc.gov/authorities/names/n90684343
|
| 653 |
|
|
|a Database management / Examinations / Study guides
|
| 653 |
|
|
|a Electronic data processing personnel / Certification / Study guides
|
| 653 |
|
|
|a SQL server / blmlsh
|
| 041 |
0 |
7 |
|a eng
|2 ISO 639-2
|
| 989 |
|
|
|b OREILLY
|a O'Reilly
|
| 776 |
|
|
|z 1118654730
|
| 776 |
|
|
|z 1118487168
|
| 776 |
|
|
|z 9781118654903
|
| 776 |
|
|
|z 1118654900
|
| 776 |
|
|
|z 9781118654736
|
| 776 |
|
|
|z 9781118487167
|
| 856 |
4 |
0 |
|u https://learning.oreilly.com/library/view/~/9781118654903/?ar
|x Verlag
|3 Volltext
|
| 082 |
0 |
|
|a 374
|
| 082 |
0 |
|
|a 658
|
| 082 |
0 |
|
|a 005.7585
|
| 520 |
|
|
|a Implement, maintain, and repair SQL Server 2012 databases As the most significant update since 2008, Microsoft SQL Server 2012 boasts updates and new features that are critical to understand. Whether you manage and administer SQL Server 2012 or are planning to get your MCSA: SQL Server 2012 certification, this book is the perfect supplement to your learning and preparation. From understanding SQL Server's roles to implementing business intelligence and reporting, this practical book explores tasks and scenarios that a working SQL Server DBA faces regularly and shows you step by ste
|