Format:
1 online resource (939 pages)
Edition:
1st ed.
ISBN:
9781118859261
Content:
Learn to take advantage of the opportunities offered by SQL Server 2014 Microsoft's SQL Server 2014 update means big changes for database administrators, and you need to get up to speed quickly because your methods, workflow, and favorite techniques will be different from here on out. The update's enhanced support of large-scale enterprise databases and significant price advantage mean that SQL Server 2014 will become even more widely adopted across the industry. The update includes new backup and recovery tools, new AlwaysOn features, and enhanced cloud capabilities. In-memory OLTP, Buffer Pool Extensions for SSDs, and a new Cardinality Estimator can improve functionality and smooth out the workflow, but only if you understand their full capabilities. Professional Microsoft SQL Server 2014 is your comprehensive guide to working with the new environment. Authors Adam Jorgensen, Bradley Ball, Ross LoForte, Steven Wort, and Brian Knight are the dream team of the SQL Server community, and they put their expertise to work guiding you through the changes. Improve oversight with better management and monitoring Protect your work with enhanced security features Upgrade performance tuning, scaling, replication, and clustering Learn new options for backup and recovery Professional Microsoft SQL Server 2014 includes a companion website with sample code and efficient automation utilities, plus a host of tips, tricks, and workarounds that will make your job as a DBA or database architect much easier. Stop getting frustrated with administrative issues and start taking control. Professional Microsoft SQL Server 2014 is your roadmap to mastering the update and creating solutions that work.
Content:
Cover -- TitlePage -- Copyright -- Contents -- Chapter 1 SQL Server 2014 Architecture -- SQL Server 2014 Ecosystem -- New Important Features in 2014 -- Production DBA -- Development DBA -- Business Intelligence DBA and Developer -- SQL Server Architecture -- Database Files and Transaction Log -- SQL Server Native Client -- Standard System Databases -- Schemas -- Synonyms -- Dynamic Management Objects -- SQL Server 2014 Data Types -- Editions of SQL Server -- Edition Overview -- Licensing -- Summary -- Chapter 2 Installing SQL Server 2014 Best Practices -- Planning the System -- Hardware Options -- Software and Install Options -- Installing SQL Server -- New Installs -- Side-by-Side Installs -- Upgrades -- Attended Installations -- Unattended Installs -- Installing Analysis Services -- Multidimensional and Data Mining Mode (UDM Mode) -- Tabular Mode -- Installing PowerPivot for SharePoint -- Burning in the System -- Post-Install Configuration -- Configuring SQL Server Settings for Performance -- tempdb -- Configuring SQL Server Settings for Security -- SQL Server Configuration Manager -- Back It Up -- Uninstalling SQL Server -- Uninstalling Reporting Services -- Uninstalling Analysis Services -- Uninstalling the SQL Server Database Engine -- Troubleshooting a Failed Install -- Summary -- Chapter 3 Upgrading SQL Server 2014 Best Practices -- Why Upgrade to SQL Server 2014? -- Risk Mitigation-the Microsoft Contribution -- Independent Software Vendors and SQL Community Contributions -- Upgrading to SQL Server 2014 -- In-Place Upgrading -- Side-by-Side Upgrade -- In-Place Upgrade versus Side-by-Side Upgrade Considerations -- Pre-Upgrade Steps and Tools -- Pre-Upgrade Steps -- Pre-Upgrade Tools -- Backward Compatibility -- Unsupported and Discontinued Features in SQL Server 2014 -- SQL Server 2014 Deprecated Database Features.
Note:
Description based on publisher supplied metadata and other sources
Additional Edition:
9781118859131
Additional Edition:
Erscheint auch als Druck-Ausgabe 9781118859131
Language:
English
