05247nam 2200625 a 450 991079015900332120200520144314.01-118-28684-7(CKB)2670000000167008(EBL)821996(OCoLC)784883675(SSID)ssj0000664106(PQKBManifestationID)12239027(PQKBTitleCode)TC0000664106(PQKBWorkID)10613867(PQKB)10141113(Au-PeEL)EBL821996(CaPaEBR)ebr10630608(CaONFJC)MIL573926(CaSebORM)9781118106884(MiAaPQ)EBC821996(EXLCZ)99267000000016700820120217d2012 uy 0engur|n|---|||||txtccrProfessional Microsoft SQL server 2012 administration[electronic resource] /Adam Jorgensen ... [et al.]1st editionIndianapolis, Ind. J. Wiley & Sons, Inc.20121 online resource (962 p.)Wrox programmer to programmerIncludes index.1-118-10688-1 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; SynonymsDynamic 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; tempdbConfiguring 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 UpgradeIn-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 ToolsSQL 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; SummaryChapter 5: Automating SQL ServerAn 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 deciphersProgrammer to programmer.Database managementDatabase management.005.75/85005.7585Jorgensen Adam865174MiAaPQMiAaPQMiAaPQBOOK9910790159003321Professional Microsoft SQL server 2012 administration3740376UNINA