{"product_id":"9781430239161","title":"Pro SQL Server 2012 Administration","description":"\u003cp\u003e\u003cem\u003ePro SQL Server 2012 Administration\u003c\/em\u003e is a one-stop source for all the knowledge you'll need to professionally manage a database under Microsoft SQL Server 2012. SQL Server administration is a complex field requiring an unusually broad and well-rounded skill set. A good database administrator must be part system administrator, part database design expert, and part SQL tuning optimization guru. Above all, he or she must be capable of restoring a damaged database at any time. Database administration requires excellent people skills for dealing with management and clients, and solid technical skills for dealing with the hardware and the software.\u003c\/p\u003e\u003cp\u003e\u003cem\u003ePro SQL Server 2012 Administration\u003c\/em\u003e addresses all aspects of database administration, regardless of the size of the implementation. Install SQL Server 2012 and create new database environments. Develop a sound backup strategy for your database. Perform recovery as needed, which many consider to be job #1. Authors \u003cstrong\u003eKen Simmons\u003c\/strong\u003e and \u003cstrong\u003eSylvester Carstarphen\u003c\/strong\u003e also help you automate your work through the use of policy-based management. Performance optimization gets good coverage, so that you can render assistance when developers need help with problem queries. \u003c\/p\u003e\u003cp\u003eRare among database and other technical books is solid guidance on the people side of the equation. Success as a database administrator comes from working well with others, becoming involved in the community, and building the right combination of technical knowledge and people skills to solve problems and get things done professionally and amicably. Simmons and Carstarphen pay special attention to these aspects of the job in this new edition of their comprehensive book on SQL Server administration.\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eHelps you manage a SQL Server 2012 database at professional level \u003c\/li\u003e\n\u003cli\u003eCovers the gamut of database administration skills \u003c\/li\u003e\n\u003cli\u003eProvides guidance on performance optimization \u003c\/li\u003e\n\u003c\/ul\u003eWhat you’ll learn\u003cul\u003e   \u003cli\u003eInstall SQL Server 2012 and create new databases \u003c\/li\u003e   \u003cli\u003eImplement backup \u0026amp; recovery strategies to protect your database, and your job \u003c\/li\u003e   \u003cli\u003eDiagnose and resolve query performance problems \u003c\/li\u003e   \u003cli\u003eApply policy-based management for consistency across all databases in an organization \u003c\/li\u003e   \u003cli\u003eTurn every interaction with a client, manager or executive into a stepping-stone towards career success \u003c\/li\u003e  \u003c\/ul\u003e  Who this book is for      \u003cp\u003e     \u003cem\u003ePro SQL Server 2012 Administration\u003c\/em\u003e is aimed at junior and seasoned database administrators who are looking to develop their knowledge and skill set in Microsoft SQL Server 2012. Readers should already have some exposure to databases in general, or to SQL Server in specific.         \u003c\/p\u003e     Table of Contents\u003col\u003e   \u003cli\u003eWhat's New? \u003c\/li\u003e   \u003cli\u003ePre-Install Considerations \u003c\/li\u003e   \u003cli\u003eChoosing a High-Availability Solution \u003c\/li\u003e   \u003cli\u003eInstalling and Upgrading \u003c\/li\u003e   \u003cli\u003ePost Installation \u003c\/li\u003e   \u003cli\u003eMulti-Server Administration \u003c\/li\u003e   \u003cli\u003eSecurity \u003c\/li\u003e   \u003cli\u003eAdministering Database Objects \u003c\/li\u003e   \u003cli\u003eIndexing for Performance \u003c\/li\u003e   \u003cli\u003eManaging Backups \u003c\/li\u003e   \u003cli\u003eRestore and Recovery Strategies \u003c\/li\u003e   \u003cli\u003eAutomating Routine Maintenance \u003c\/li\u003e   \u003cli\u003eMonitoring Your Server \u003c\/li\u003e   \u003cli\u003eAuditing \u003c\/li\u003e   \u003cli\u003eExtended Events Interface \u003c\/li\u003e   \u003cli\u003eManaging Query Performance \u003c\/li\u003e   \u003cli\u003eSecrets to Excelling as a Professional DBA \u003c\/li\u003e   \u003cli\u003eWhat's Next? \u003c\/li\u003e  \u003c\/ol\u003e","brand":"Apress","offers":[{"title":"Default Title","offer_id":47124701774064,"sku":"9781430239161","price":47.99,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0737\/7593\/9824\/files\/9781430239161_p0.jpg?v=1763750335","url":"https:\/\/shop-qa.barnesandnoble.com\/products\/9781430239161","provider":"Barnes \u0026 Noble (DEV)","version":"1.0","type":"link"}