INTRODUCING MICROSOFT SQL SERVER 2012
CONTENTS PART 1 DATABASE ADMINISTRATION CHAPTER 1 SQL SERVER 2012 EDITIONS AND ENGINE ENHANCEMENTS SQL SERVER 2012 ENHANCEMENTS FOR DATABASE ADMINISTRATORS AVAILABILITY ENHANCEMENTS SCALABILITY AND PERFORMANCE ENHANCEMENTS MANAGEABILITY ENHANCEMENTS SECURITY ENHANCEMENTS PROGRAMMABILITY ENHANCEMENTS SQL SERVER 2012 EDITIONS ENTERPRISE EDITION STANDARD EDITION BUSINESS INTELLIGENCE EDITION SPECIALIZED EDITIONS SQL SERVER 2012 LICENSING OVERVIEW HARDWARE AND SOFTWARE REQUIREMENTS INSTALLATION, UPGRADE, AND MIGRATION STRATEGIES THE IN-PLACE UPGRADE SIDE-BY-SIDE MIGRATION CHAPTER 2 HIGH-AVAILABILITY AND DISASTER-RECOVERY ENHANCEMENTS SQL SERVER ALWAYSON: A FLEXIBLE AND INTEGRATED SOLUTION ALWAYSON AVAILABILITY GROUPS UNDERSTANDING CONCEPTS AND TERMINOLOGY CONFIGURING AVAILABILITY GROUPS MONITORING AVAILABILITY GROUPS WITH THE DASHBOARD ACTIVE SECONDARIES READ-ONLY ACCESS TO SECONDARY REPLICAS BACKUPS ON SECONDARY ALWAYSON FAILOVER CLUSTER INSTANCES SUPPORT FOR DEPLOYING SQL SERVER 2012 ON WINDOWS SERVER CORE SQL SERVER 2012 PREREQUISITES FOR SERVER CORE SQL SERVER FEATURES SUPPORTED ON SERVER CORE SQL SERVER ON SERVER CORE INSTALLATION ALTERNATIVES ADDITIONAL HIGH-AVAILABILITY AND DISASTER-RECOVERY ENHANCEMENTS SUPPORT FOR SERVER MESSAGE BLOCK DATABASE RECOVERY ADVISOR ONLINE OPERATIONS ROLLING UPGRADE AND PATCH MANAGEMENT CHAPTER 3 PERFORMANCE AND SCALABILITY COLUMNSTORE INDEX OVERVIEW COLUMNSTORE INDEX FUNDAMENTALS AND ARCHITECTURE HOW IS DATA STORED WHEN USING A COLUMNSTORE INDEX? HOW DO COLUMNSTORE INDEXES SIGNIFICANTLY IMPROVE THE SPEED OF QUERIES? COLUMNSTORE INDEX STORAGE ORGANIZATION COLUMNSTORE INDEX SUPPORT AND SQL SERVER 2012 COLUMNSTORE INDEX RESTRICTIONS COLUMNSTORE INDEX DESIGN CONSIDERATIONS AND LOADING DATA WHEN TO BUILD A COLUMNSTORE INDEX WHEN NOT TO BUILD A COLUMNSTORE INDEX LOADING NEW DATA CREATING A COLUMNSTORE INDEX CREATING A COLUMNSTORE INDEX BY USING SQL SERVER MANAGEMENT STUDIO CREATING A COLUMNSTORE INDEX USING TRANSACT-SQL USING COLUMNSTORE INDEXES USING HINTS WITH A COLUMNSTORE INDEX COLUMNSTORE INDEX OBSERVATIONS AND BEST PRACTICES CHAPTER 4 SECURITY ENHANCEMENTS SECURITY ENHANCEMENTS IN SQL SERVER 2012 SECURITY MANAGEABILITY IMPROVEMENTS DEFAULT SCHEMA FOR GROUPS USER-DEFINED SERVER ROLES AUDIT ENHANCEMENTS AUDIT SUPPORTED ON ALL SKUS IMPROVED RESILIENCE USER-DEFINED AUDIT EVENT RECORD FILTERING DATABASE AUTHENTICATION ENHANCEMENTS ENABLING CONTAINED DATABASES CREATING USERS CONTAINED DATABASE AUTHENTICATION SECURITY CONCERNS ADDITIONAL SECURITY ENHANCEMENTS CRYPTOGRAPHY CHANGES TIGHT INTEGRATION WITH SHAREPOINT AND ACTIVE DIRECTORY PROVISIONING ENHANCEMENTS NEW PERMISSIONS CHAPTER 5 PROGRAMMABILITY AND BEYOND-RELATIONAL ENHANCEMENTS PAIN POINTS OF USING THE BEYOND RELATIONAL PARADIGM SQL SERVER 2012 BEYOND-RELATIONAL GOALS RICH UNSTRUCTURED DATA AND SERVICES ECOSYSTEM BEYOND-RELATIONAL EXAMPLE FILESTREAM ENHANCEMENTS FILETABLE FILETABLE PREREQUISITES CREATING A FILETABLE MANAGING FILETABLE FULL-TEXT SEARCH STATISTICAL SEMANTIC SEARCH CONFIGURING SEMANTIC SEARCH SEMANTIC SEARCH EXAMPLES SPATIAL ENHANCEMENTS SPATIAL DATA SCENARIOS SPATIAL DATA FEATURES SUPPORTED IN SQL SERVER SPATIAL TYPE IMPROVEMENTS ADDITIONAL SPATIAL IMPROVEMENTS EXTENDED EVENTS PART 2 BUSINESS INTELLIGENCE DEVELOPMENT CHAPTER 6 INTEGRATION SERVICES DEVELOPER EXPERIENCE ADD NEW PROJECT DIALOG BOX GENERAL INTERFACE CHANGES GETTING STARTED WINDOW SSIS TOOLBOX SHARED CONNECTION MANAGERS SCRIPTING ENGINE EXPRESSION INDICATORS UNDO AND REDO PACKAGE SORT BY NAME STATUS INDICATORS CONTROL FLOW EXPRESSION TASK EXECUTE PACKAGE TASK DATA FLOW SOURCES AND DESTINATIONS TRANSFORMATIONS COLUMN REFERENCES COLLAPSIBLE GROUPING DATA VIEWER CHANGE DATA CAPTURE SUPPORT CDC CONTROL FLOW CDC DATA FLOW FLEXIBLE PACKAGE DESIGN VARIABLES EXPRESSIONS DEPLOYMENT MODELS SUPPORTED DEPLOYMENT MODELS PROJECT DEPLOYMENT MODEL FEATURES PROJECT DEPLOYMENT WORKFLOW PARAMETERS PROJECT PARAMETERS PACKAGE PARAMETERS PARAMETER USAGE POST-DEPLOYMENT PARAMETER VALUES INTEGRATION SERVICES CATALOG CATALOG CREATION CATALOG PROPERTIES ENVIRONMENT OBJECTS ADMINISTRATION VALIDATION PACKAGE EXECUTION LOGGING AND TROUBLESHOOTING TOOLS SECURITY PACKAGE FILE FORMAT CHAPTER 7 DATA QUALITY SERVICES DATA QUALITY SERVICES ARCHITECTURE DATA QUALITY SERVER DATA QUALITY CLIENT KNOWLEDGE BASE MANAGEMENT DOMAIN MANAGEMENT KNOWLEDGE DISCOVERY MATCHING POLICY DATA QUALITY PROJECTS CLEANSING PROJECTS MATCHING PROJECTS ACTIVITY MONITORING CONFIGURATION INTEGRATION INTEGRATION SERVICES MASTER DATA SERVICES CHAPTER 8 MASTER DATA SERVICES GETTING STARTED UPGRADE CONSIDERATIONS MASTER DATA MANAGER EXPLORER INTEGRATION MANAGEMENT USER AND GROUP PERMISSIONS MODEL DEPLOYMENT MDS ADD-IN FOR EXCEL INSTALLATION OF THE MDS ADD-IN MASTER DATA MANAGEMENT MODEL-BUILDING TASKS SHORTCUT QUERY FILES DATA QUALITY MATCHING MISCELLANEOUS CHANGES SHAREPOINT INTEGRATION METADATA BULK UPDATES AND EXPORT TRANSACTIONS WINDOWS POWERSHELL CHAPTER 9 ANALYSIS SERVICES AND POWERPIVOT ANALYSIS SERVICES SERVER MODES ANALYSIS SERVICES PROJECTS TABULAR MODELING MULTIDIMENSIONAL MODEL STORAGE SERVER MANAGEMENT PROGRAMMABILITY POWERPIVOT FOR EXCEL INSTALLATION AND UPGRADE USABILITY MODEL ENHANCEMENTS DAX POWERPIVOT FOR SHAREPOINT INSTALLATION AND CONFIGURATION MANAGEMENT CHAPTER 10 REPORTING SERVICES NEW RENDERERS EXCEL 2010 RENDERER WORD 2010 RENDERER SHAREPOINT SHARED SERVICE ARCHITECTURE FEATURE SUPPORT BY SHAREPOINT EDITION SHARED SERVICE ARCHITECTURE BENEFITS SERVICE APPLICATION CONFIGURATION POWER VIEW DATA SOURCES POWER VIEW DESIGN ENVIRONMENT DATA VISUALIZATION SORT ORDER MULTIPLE VIEWS HIGHLIGHTED VALUES FILTERS DISPLAY MODES POWERPOINT EXPORT DATA ALERTS DATA ALERT DESIGNER ALERTING SERVICE DATA ALERT MANAGER ALERTING CONFIGURATION PART DATABASE ADMINISTRATION CHAPTER SQL SERVER 2012 EDITIONS AND ENGINE ENHANCEMENTS CHAPTER HIGH-AVAILABILITY AND DISASTER-RECOVERY ENHANCEMENTS PERFORMANCE AND SCALABILITY PROGRAMMABILITY AND BEYOND-RELATIONAL ENHANCEMENTS