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

Format:

Book

Contributor:

Jorgensen, Adam.

Series:

Programmer to programmer.

Wrox programmer to programmer

Language:

English

Subjects (All):

Database management.

SQL server.

Physical Description:

1 online resource (962 p.)

Edition:

1st edition

Other Title:

Microsoft SQL server 2012 administration

Professional SQL server 2012 administration

SQL server 2012 administration

Place of Publication:

Indianapolis, Ind. : J. Wiley & Sons, Inc., 2012.

Language Note:

English

System Details:

text file

Summary:

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

Contents:

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

Notes:

Includes index.

ISBN:

9781118286845

1118286847

OCLC:

784883675