Professional Microsoft SQL server 2012 administration / / Adam Jorgensen ... [et al.]

• Record Nr.: UNINA9910816563103321
• Pubbl/distr/stampa: Indianapolis, Ind., : J. Wiley & Sons, Inc., 2012
• ISBN: 1-118-28684-7
• Edizione: [1st edition]
• Descrizione fisica: 1 online resource (962 p.)
• Collana: Wrox programmer to programmer
• Altri autori (Persone): JorgensenAdam
• Disciplina: 005.75/85; 005.7585
• Soggetti: Database management
• Lingua di pubblicazione: Inglese
• Formato: Materiale a stampa
• Livello bibliografico: Monografia
• Note generali: Includes index.
• Nota di contenuto: Professional: Microsoft® SQL Server® 2012 Administration; About The Authors; About The Technical Editors; Credits; Acknowledgments; Contents; Introduction; Who This Book Is For; How This Book Is Structured; What You Need To Use This Book; Conventions; Source Code; Errata; P2P.wrox.com; Chapter 1: SQL Server 2012 Architecture; SQL Server 2012 Ecosystem; New Important Features in 2012; Production DBA; Development DBA; Business Intelligence DBA and Developer; SQL Server Architecture; Database Files and Transaction Log; SQL Native Client; Standard System Databases; Schemas; Synonyms; Dynamic Management ObjectsSQL Server 2012 Data Types; Editions of SQL Server; Edition Overview; Licensing; Summary; Chapter 2: Installing SQL Server 2012 Best Practices; Planning the System; Hardware Options; Software and Install Options; Installing SQL Server; New Installs; Side-by-Side Installs; Upgrades; Unattended Installs; Attended Installations; 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 Setting for SecurityBest Practices Analyzer (BPA); 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 2012 Best Practices; Why Upgrade to SQL Server 2012?; Risk Mitigation - the Microsoft Contribution; Independent Software Vendors and SQL Community Contributions; Upgrading to SQL Server 2012; In-Place Upgrading; Side-by-Side Upgrade; In-Place Upgrade versus Side-By-Side Upgrade ConsiderationsPre-Upgrade Steps and Tools; Pre-Upgrade Steps; Pre-Upgrade Tools; Backward Compatibility; Unsupported and Discontinued Features in SQL Server 2012; SQL Server 2012 Deprecated Database Features; Other SQL Server 2012 Changes Affecting Behavior; SQL Server Component Considerations; Upgrading Full-Text Catalog; Upgrading Reporting Services; Upgrading to 64-Bit; Post-Upgrade Checks; Poor Query Performance After Upgrade; Summary; Chapter 4: Managing And Troubleshooting The Database Engine; Configuration and Administration Tools; SQL Server Configuration ManagerStartup Parameters; Startup Stored Procedures; Partially Contained Databases; Troubleshooting Tools; Dedicated Administrator Connection; Rebuilding the System Databases; Management Studio; Reports; Configuring SQL Server in Management Studio; Filtering Objects; Error Logs; Activity Monitor; Monitoring Processes in T-SQL; sp_who and sp_who2; sys.dm_exec_connections; sys.dm_exec_sql_text; Multiserver Management; Central Management Servers and Server Groups; SQL Server Utility; Trace Flags; Getting Help from Support; SQLDumper.exe; SQLDiag.exe; Summary; Chapter 5: Automating SQL Server
• Sommario/riassunto: 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