- What’s New in Security and User Administration . - An Overview of SQL Server Security . - SQL Server Security: Users ...298. - Managing SQL Server Logins ...313. - Using T-SQL to Manage Logins . - Managing SQL Server Users . - Using SSMS to Manage Users ...318. - Using T-SQL to Manage Users . - Using SSMS to Manage Database Roles...321. - Using T-SQL to Manage Database Roles. - Managing SQL Server Permissions . - Using SSMS to Manage Permissions...323. - Using T-SQL to Manage Permissions. - Summary ...334. - 12 Data Encryption 335 What’s New in Data Encryption...336. - SQL Server Key Management...339. - Compliance and SQL Server ...366. - SQL Server Auditing...368. - 14 Database Backup and Restore 377 What’s New in Database Backup and Restore ...377. - Full Database Backups ...380. - Differential Database Backups ...380. - Differential Partial Backups ...381. - File and Filegroup Backups...381. - Copy-Only Backups ...382. - Transaction Log Backups ...382. - Full Database Backups with Transaction Log Backups ...396. - System Database Backups ...403. - Restoring the System Databases ...421. - Frequency of Backups ...423. - Snapshot Backups ...425. - Considerations for Very Large Databases...425. - Summary ...426. - 15 Database Mail 427 What’s New in Database Mail...427. - Using T-SQL to Update and Delete Mail Objects...432. - Using SQL Server Agent Mail. - Summary ...448. - 16 SQL Server Scheduling and Notification 449 What’s New in Scheduling and Notification ...450. - Configuring the SQL Server Agent . - Configuring SQL Server Agent Properties ...450. - Configuring the SQL Server Agent Startup Account ...452. - SQL Server Agent Proxy Account . - Viewing the SQL Server Agent Error Log ...456. - SQL Server Agent Security . - ptg 17 Administering SQL Server 2008 with PowerShell 481. - What’s New with PowerShell...481. - SQL Server Management Objects ...484. - PowerShell in SQL Server 2008. - SQL Server PowerShell . - SQL Server Agent Support ...509. - SQL Server–Specific Tasks ...514. - Summary ...522. - 18 SQL Server High Availability 523 What’s New in High Availability ...524. - Database Mirroring . - Summary ...542. - What’s New in Data Replication ...546. - Planning for SQL Server Data Replication . - SQL Server Replication Types . - Snapshot Replication ...574. - Transactional Replication ...574. - Scripting Replication...600. - Monitoring Replication ...603. - Monitoring Replication within SQL Server Management Studio...606. - New and Improved Peer-to-Peer Replication ...609. - Data Replication and Database Mirroring for Fault Tolerance and High Availability . - 20 Database Mirroring 617 What’s New in Database Mirroring . - What Is Database Mirroring?. - When to Use Database Mirroring ...621. - Roles of the Database Mirroring Configuration. - Database Mirroring Operating Modes. - Setting Up and Configuring Database Mirroring. - Identifying the Other Endpoints for Database Mirroring ...632. - Configuring Database Mirroring by Using the Wizard ...633. - Client Setup and Configuration for Database Mirroring ...647. - Migrate to Database Mirroring 2008 as Fast as You Can ...649. - Using Replication and Database Mirroring Together...651. - 21 SQL Server Clustering 655 What’s New in SQL Server Clustering . - How Microsoft SQL Server Clustering Works...656. - How MSCS Sets the Stage for SQL Server Clustering...663. - Installing SQL Server Clustering. - Configuring SQL Server Database Disks...666. - Installing SQL Server . - The Connection Test Program for a SQL Server Cluster...681. - Potential Problems to Watch Out for with SQL Server Clustering ...684. - Summary ...685. - SQL Server Health Checks ...705. - Part IV Database Administration 23 Creating and Managing Databases 709 What’s New in Creating and Managing Databases...710. - Data Storage in SQL Server . - Using T-SQL to Create Databases . - Using T-SQL to Set Database Options ...725. - Expanding Databases...730. - Shrinking Databases ...731. - Detaching and Attaching Databases ...737. - Summary ...740. - 24 Creating and Managing Tables 741 What’s New in SQL Server . - Using Object Explorer to Create Tables ...742. - Using T-SQL to Create Tables . - Using T-SQL to Modify Tables ...766. - Using Database Diagrams to Modify Tables...772. - Dropping Tables ...773. - Using Partitioned Tables ...774
Xem thử không khả dụng, vui lòng xem tại trang nguồn hoặc xem
Tóm tắt