MICROSOFT SQL SERVER 2005
ABOUT THIS BOOK FOOLISH ASSUMPTIONS CONVENTIONS USED IN THIS BOOK HOW THIS BOOK IS ORGANIZED PART I: SQL SERVER 2005: AN OVERVIEW PART II: BASIC OPERATIONS PART III: WORKING WITH SQL SERVER PART IV: PROTECTING YOUR DATA PART V: ADMINISTERING A SQL SERVER SYSTEM PART VI: USING SQL SERVER BUSINESS INTELLIGENCE (BI) SERVICES PART VII: THE PART OF TENS ABOUT THE WEB SITE ICONS USED IN THIS BOOK WHERE TO GO FROM HERE GETTING TO KNOW SQL SERVER 2005 A CLIENT-SERVER DATABASE OLTP OLAP A SECURE DATABASE A PROGRAMMABLE DATABASE TRANSACT-SQL SQL SERVER MANAGEMENT STUDIO BUSINESS INTELLIGENCE DEVELOPMENT STUDIO A SCALABLE DATABASE AN AVAILABLE DATABASE MISCELLANEOUS CHANGES ONLINE INDEXING ONLINE PAGE AND FILE RESTORE A RELIABLE DATABASE BACKING UP DATA REPLICATION A MANAGEABLE DATABASE COMMAND-LINE TOOLS GRAPHICAL TOOLS SQL SERVER AGENT PERFORMANCE TOOLS A DATABASE THAT SUPPORTS BUSINESS INTELLIGENCE SECURITY ENHANCEMENTS SYSTEM CATALOG SECURITY PASSWORD POLICY ENFORCEMENT SCHEMA AND USER SEPARATION AUTOMATED CERTIFICATE CREATION FOR SSL TRANSACT-SQL ENHANCEMENTS IMPROVED XML SUPPORT ERROR HANDLING TRANSACT-SQL TEMPLATES OTHER DEVELOPER-ORIENTATED ENHANCEMENTS SUPPORT FOR THE COMMON LANGUAGE RUNTIME NEW DATATYPES SQL MANAGEMENT OBJECTS (SMO) SCRIPTING ACTIONS HTTP ENDPOINTS MANAGEABILITY ENHANCEMENTS NEW MANAGEMENT TOOLS PROFILER DYNAMIC CONFIGURATION FULL-TEXT SEARCH SQL SERVER SERVICE BROKER DEDICATED ADMINISTRATOR CONNECTION SQLCMD EASIER UPDATES WMI CONFIGURATION DATABASE MAIL AVAILABILITY ENHANCEMENTS CONCURRENT DATA ACCESS AVAILABILITY AFTER SERVER FAILURE AVAILABILITY DURING DATABASE MAINTENANCE SCALABILITY ENHANCEMENTS INSTALLING IN A CLUSTER PARTITIONING DATA DATABASE ENGINE TUNING ADVISOR HOT-ADD MEMORY SUPPORT BUSINESS INTELLIGENCE ENHANCEMENTS INTEGRATION SERVICES ANALYSIS SERVICES REPORTING SERVICES STARTING MANAGEMENT STUDIO AND CONNECTING TO SQL SERVER USING REGISTERED SERVERS EXPLORING DATABASE OBJECTS USING THE OBJECT EXPLORER VIEW AND MODIFY DATABASE PROPERTIES SECURITY GETTING AN OVERVIEW ON THE SUMMARY TAB ASKING QUESTIONS IN THE QUERY PANE CUSTOMIZING THE ENVIRONMENT SETTING STARTUP OPTIONS DISPLAYING RESULTS KEYBOARD SHORTCUTS RESTORING THE DEFAULT CONFIGURATION USING TEMPLATES IN MANAGEMENT STUDIO FIRING UP SQL SERVER 2005 EXPLORING THE OBJECT EXPLORER CREATING DATABASES CREATING TABLES DEFINING RELATIONSHIPS ADDING CONSTRAINTS ADDING DATA TO THE DATABASE USING THE QUERY EDITOR USING THE SELECT STATEMENT FILTERING WITH THE WHERE CLAUSE SORTING WITH ORDER BY RETRIEVING DATA FROM MULTIPLE TABLES JOINS MODIFYING A TEMPLATE DESIGNING THE APPLICATION CREATING A NEW PROJECT BUILDING THE CONNECTION TO THE DATA BUILDING THE USER INTERFACE DEBUGGING THE APPLICATION INTRODUCING XML XML AND SQL SERVER 2000 XML AND SQL SERVER 2005 THE XML DATATYPE CREATING XML DOCUMENTS AND FRAGMENTS USING UNTYPED AND TYPED XML USING UNTYPED XML UNDERSTANDING THE XML SCHEMA DEFINITION LANGUAGE USING TYPED XML QUERYING XML UNDERSTANDING XQUERY CREATING INDEXES FOR THE XML DATATYPE USING THE XML DATA MODIFICATION LANGUAGE CONVERTING DATA TO AND FROM XML USING THE FOR XML STATEMENT USING THE OPENXML KEYWORD INTRODUCING CLR INTEGRATION DEVELOPMENT MANUAL CODING AND DEPLOYMENT COMPARISON WITH TRADITIONAL APPROACHES POTENTIAL BENEFITS OF CLR INTEGRATION CLR AND T-SQL COMPARISON CLR AND EXTENDED STORED PROCEDURE COMPARISON CLR AND MIDDLE TIER COMPARISON CLR CODE ACCESS SECURITY WHAT A STORED PROCEDURE IS TYPES OF STORED PROCEDURE WHAT A STORED PROCEDURE DOES REASONS TO USE A STORED PROCEDURE SYSTEM STORED PROCEDURES CREATING A STORED PROCEDURE CREATING A PROCEDURE WITHOUT PARAMETERS CREATING A STORED PROCEDURE WITH A PARAMETER NAMING STORED PROCEDURES CALLING A STORED PROCEDURE CLR STORED PROCEDURES HANDLING ERRORS WITH T-SQL THE TRYCATCH CONSTRUCT RULES FOR THE TRYCATCH CONSTRUCT ERROR MESSAGE SEVERITY LEVELS USING ERROR FUNCTIONS USING ERROR CODES RAISERROR USING NESTED TRYCATCH CONSTRUCTS @@ERROR INTRODUCING THE NEW SECURITY MODEL SECURITY TERMINOLOGY PRINCIPALS HIERARCHY SECURABLES HIERARCHY NEW SECURITY FEATURES GRANULAR PERMISSIONS CONTROL PERMISSIONS BASICS PERMISSION LEVELS HOW PERMISSIONS APPLY TO SPECIFIC SECURABLES WORKING WITH THE NEW SECURITY MODEL LOGINS AND USERS SEPARATION OF USERS AND SCHEMAS THE DEFAULT SCHEMA GRANTING PERMISSIONS TO A USER MODULE EXECUTION CONTEXT CATALOG SECURITY USING COMMON LANGUAGE RUNTIME SECURITY AVAILABILITY OVERVIEW REDUCING DOWNTIME WITH DATABASE MIRRORING DATABASE MIRRORING OVERVIEW TRANSPARENT CLIENT REDIRECT DATABASE VIEWS DIFFERENCES FROM FAILOVER CLUSTERING SIMILARITIES TO FAILOVER CLUSTERING RECOVERY MODELS SPEEDING RECOVERY WITH CHECKPOINTING AUTOMATIC CHECKPOINTS SETTING THE RECOVERY INTERVAL USING FAILOVER CLUSTERING DATABASE SNAPSHOTS NAMING DATABASE SNAPSHOTS CREATING A DATABASE SNAPSHOT DELETING UNWANTED DATABASE SNAPSHOTS REVERTING TO A DATABASE SNAPSHOT BACKING UP AND RESTORING DATA ASSESSING THE RISKS TO PROTECT AGAINST CHECKING BACKUPS RESTORING DATA UNDERSTANDING TRANSACTIONS ACID THE TRANSACTION LOG CODING TRANSACTIONS A SIMPLE UPDATE A SIMPLE TRANSACTION IMPLICIT TRANSACTIONS UNDERSTANDING CONSTRAINTS, DEFAULTS, RULES, AND TRIGGERS CONSTRAINTS DEFAULTS RULES TRIGGERS USING CHECK CONSTRAINTS CREATING A CHECK CONSTRAINT VISUALLY DROPPING A CHECK CONSTRAINT VISUALLY CREATING A CHECK CONSTRAINT WITH T-SQL DDL TRIGGERS PREVENTING UNDESIRED CHANGES AUDITING CHANGES DML TRIGGERS THE INSERTED AND DELETED TABLES TRIGGERS FOR AUDITING DML USING SQL SERVER CONFIGURATION MANAGER ADDING SQL SERVER CONFIGURATION MANAGER TO AN MMC CONSOLE MANAGING SQL SERVER SERVICES CONNECTING TO A REMOTE COMPUTER CONFIGURING NETWORK PROTOCOLS CONFIGURING CLIENT COMPUTERS CONFIGURING USING SQLCMD GETTING STARTED WITH SQLCMD EXECUTING A T-SQL SCRIPT WITH SQLCMD LOGGING IN AS A SPECIFIED USER CONNECTING TO A REMOTE SQL SERVER INSTANCE CONFIGURING USING SQL SERVER MANAGEMENT STUDIO SQL SERVER INSTANCE LEVEL CONFIGURATION CONFIGURING AT THE DATABASE LEVEL INTRODUCING SQL SERVER AGENT MANAGING AGENT FROM SQL SERVER MANAGEMENT STUDIO STARTING AND STOPPING SQL SERVER AGENT SETTING SQL AGENT TO START AUTOMATICALLY USING AGENT IN BUSINESS INTELLIGENCE PERMISSIONS FOR SQL AGENT PERMISSIONS FOR USERS CONFIGURING SQL SERVER AGENT WINDOWS PERMISSIONS ENABLING SQL AGENT EXTENDED STORED PROCEDURES CREATING JOBS AND ALERTS CREATING A SQL AGENT JOB CREATING A SQL AGENT ALERT USING T-SQL WITH SQL SERVER AGENT USING THE MAINTENANCE PLAN WIZARD THE NOTIFICATION SERVICES APPROACH THE BASIC STEPS NEW NOTIFICATION FEATURES IN SQL SERVER 2005 HOW NOTIFICATION SERVICES WORKS WORKING WITH EVENTS APPLICATION DEFINITION AND INSTANCE CONFIGURATION FILES THE APPLICATION DEFINITION FILE THE INSTANCE CONFIGURATION FILE USING MAINTENANCE PLANS BACKING UP DIFFERENT TYPES OF BACKUP RESTORING FROM BACKUPS CHECKING ERROR LOGS WORKING WITH INDEXES HALTING RUNAWAY QUERIES WITH THE DEDICATED ADMINISTRATOR CONNECTION LOOKING UNDER THE COVERS WITH PROFILER USING THE DATABASE ENGINE TUNING ADVISOR REPLICATION OVERVIEW REPLICATION JARGON REPLICATION ENHANCEMENTS IN SQL SERVER 2005 SECURITY FOR REPLICATION REPLICATING YOUR DATA SETTING UP A PUBLISHER AND DISTRIBUTOR CREATING A NEW PUBLICATION CREATING A SUBSCRIPTION INTRODUCING SERVICE BROKER QUEUES MESSAGES BEHIND THE SCENES OVERVIEW OF BUSINESS INTELLIGENCE BUSINESS INTELLIGENCE TOOLS DATA WAREHOUSES INTEGRATION SERVICES OVERVIEW CREATING AN INTEGRATION SERVICES PACKAGE SOURCES TRANSFORMATIONS DESTINATIONS TASK FLOWS ERROR FLOWS EVENT HANDLING LOGGING OPTIONS PACKAGE RESTART DIGITAL SIGNING THE CONTROL FLOW TAB THE DATA FLOW TAB THE EVENT HANDLERS TAB THE PACKAGE EXPLORER TAB THE TOOLBOX THE SOLUTION EXPLORER IMPORT/EXPORT WIZARD CREATING AN INTEGRATION SERVICES PROJECT DEPLOYING AN INTEGRATION SERVICES PROJECT INTRODUCING ANALYSIS SERVICES NEW FEATURES IN ANALYSIS SERVICES 2005 KEY PERFORMANCE INDICATORS MANAGING ANALYSIS SERVICES BUSINESS INTELLIGENCE DEVELOPMENT STUDIO AND ANALYSIS SERVICES CREATING AN ANALYSIS SERVICES PROJECT DATA MINING OVERVIEW OF REPORTING SERVICES REPLICATING TO A REPORT SERVER DATABASE MIRRORING AND DATABASE VIEWS CREATING REPORTS VIEWING REPORTS MANAGING REPORTS MANAGING IN REPORT MANAGER MANAGING IN SQL SERVER MANAGEMENT STUDIO DISTRIBUTING REPORTS TO THOSE WHO NEED THEM REPORT DEFINITION LANGUAGE REPORT BUILDER REPORT VIEWER CONTROLS BOOKS ONLINE THE PUBLIC NEWSGROUPS MICROSOFT FORUMS THE SQL SERVER 2005 WEB SITE THE SQL SERVER DEVELOPER CENTER THE BUSINESS INTELLIGENCE SITE THE INTEGRATION SERVICES DEVELOPER CENTER THE REPORTING SERVICES WEB SITE CHANNEL 9 OTHER WEB SITES VISUAL STUDIO 2005 MICROSOFT OFFICE INFOPATH 2003 RED-GATE TOOLS QUEST SOFTWARE PROMPTSQL