LEADER 05247nam 2200625 a 450 001 9910790159003321 005 20200520144314.0 010 $a1-118-28684-7 035 $a(CKB)2670000000167008 035 $a(EBL)821996 035 $a(OCoLC)784883675 035 $a(SSID)ssj0000664106 035 $a(PQKBManifestationID)12239027 035 $a(PQKBTitleCode)TC0000664106 035 $a(PQKBWorkID)10613867 035 $a(PQKB)10141113 035 $a(Au-PeEL)EBL821996 035 $a(CaPaEBR)ebr10630608 035 $a(CaONFJC)MIL573926 035 $a(CaSebORM)9781118106884 035 $a(MiAaPQ)EBC821996 035 $a(EXLCZ)992670000000167008 100 $a20120217d2012 uy 0 101 0 $aeng 135 $aur|n|---||||| 181 $ctxt 182 $cc 183 $acr 200 00$aProfessional Microsoft SQL server 2012 administration$b[electronic resource] /$fAdam Jorgensen ... [et al.] 205 $a1st edition 210 $aIndianapolis, Ind. $cJ. Wiley & Sons, Inc.$d2012 215 $a1 online resource (962 p.) 225 1 $aWrox programmer to programmer 300 $aIncludes index. 311 $a1-118-10688-1 327 $aProfessional: 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 327 $aDynamic 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 327 $aConfiguring 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 327 $aIn-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 327 $aSQL 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 327 $aChapter 5: Automating SQL Server 330 $aAn 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 410 0$aProgrammer to programmer. 606 $aDatabase management 615 0$aDatabase management. 676 $a005.75/85 676 $a005.7585 701 $aJorgensen$b Adam$0865174 801 0$bMiAaPQ 801 1$bMiAaPQ 801 2$bMiAaPQ 906 $aBOOK 912 $a9910790159003321 996 $aProfessional Microsoft SQL server 2012 administration$93740376 997 $aUNINA