| Description |
1 online resource (1684 pages) |
| Contents |
Cover; Contents; Chapter 1: SQL Server 2012 Architecture; SQL Server 2012 Ecosystem; New Important Features in 2012; SQL Server Architecture; Editions of SQL Server; Summary; Chapter 2: Installing SQL Server 2012 Best Practices; Planning the System; Installing SQL Server; Installing Analysis Services; Installing PowerPivot for SharePoint; Burning in the System; Post-Install Configuration; Uninstalling SQL Server; Troubleshooting a Failed Install; Summary; Chapter 3: Upgrading SQL Server 2012 Best Practices; Why Upgrade to SQL Server 2012?; Upgrading to SQL Server 2012 |
|
Pre-Upgrade Steps and ToolsBackward Compatibility; SQL Server Component Considerations; Post-Upgrade Checks; Summary; Chapter 4: Managing and Troubleshooting the Database Engine; Configuration and Administration Tools; Troubleshooting Tools; Management Studio; Monitoring Processes in T-SQL; Multiserver Management; Trace Flags; Getting Help from Support; Summary; Chapter 5: Automating SQL Server; Maintenance Plans; Automating SQL Server with SQL Server Agent; SQL Server Agent Security; Configuring SQL Server Agent; Database Mail; Multiserver Administration; Summary |
|
Chapter 6: Service Broker in SQL Server 2012Asynchronous Messaging; Configuring SQL Server Service Broker; Using SQL Server Service Broker; Summary; Chapter 7: SQL Server CLR Integration; Introduction to the CLR; Creating CLR Assemblies; Securing CLR; Performance Monitoring; Summary; Chapter 8: Securing the Database Instance; Authentication Types; Authorizing Securables; Row Level Security; Summary; Chapter 9: Change Management; Creating Solutions and Projects; Policy-Based Management; DDL Trigger Syntax; Trigger Views; Scripting Overview; Creating Change Scripts; Data-Tier Applications |
|
Performance MonitorMonitoring Events; Monitoring with Dynamic Management Views and Functions; Monitoring Logs; Management Data Warehouse; SQL Server Standard Reports; System Center Management Pack; SQL Server Best Practice Analyzer; System Center Advisor; Summary; Chapter 13: Performance Tuning T-SQL; Physical Query Processing Part One: Compilation and Recompilation; Physical Query Processing Part Two: Execution; Summary; Chapter 14: Indexing Your Database; Noteworthy Index-Related Features in SQL Server; Partitioned Tables and Indexes; Index Maintenance |
| Summary |
Chapter 10: Configuring the Server for Optimal Performance; What Every DBA Needs to Know About Performance; What the Developer DBA Needs to Know About Performance; What the Production DBA Needs to Know About Performance; CPU; Memory; I/O; Summary; Chapter 11: Optimizing SQL Server 2012; Application Optimization; The Silent Killer: I/O Problems; Table and Index Partitioning; Data Compression; CPU Considerations; Memory Considerations and Enhancements; Resource Governor; Summary; Chapter 12: Monitoring Your SQL Server; The Goal of Monitoring; Choosing the Appropriate Monitoring Tools |
|
An essential how-to guide for experienced DBAs on the most significant product release since 2005!Microsoft SQL Server 2012 will have major changes throughout the SQL Server and will impact how DBAs administer the database. With this book, a team of well-known SQL Server experts introduces the many new features of the most recent version of SQL Server and deciphers how these changes will affect the methods that administrators have been using for years. Loaded with unique tips, tricks, and workarounds for handling the most difficult SQL Server admin issues, this how-to guide deciphers topics su |
| Notes |
Improving Query Performance with Indexes |
|
Print version record |
| SUBJECT |
SQL server. http://id.loc.gov/authorities/names/n90684343
|
|
SQL server fast |
| Subject |
Database management.
|
|
Database management
|
| Form |
Electronic book
|
| Author |
Wort, Steven
|
|
LoForte, Ross
|
|
Knight, Brian
|
| ISBN |
9781118286845 |
|
1118286847 |
|
