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 topics such as performance tuning, backup and recovery, scaling and replication, clustering, and security. Serves as a must-have how-to guide on the new features of the 2012 release of Microsoft SQL Server Walks you through ways to manage and monitor SQL Server and automate administration Guides you through SQL Azure for cloud computing, data replication, and data warehouse performance improvements Addresses client-connectivity enhancements, new features that ensure high availability of mission-critical applications, and tighter integration with Excel and SharePoint for data analysis and reporting Highlights major changes to the suite of SQL Server BI tools, including integration, reporting, and analysis services Includes real-world case examples and best practices from Microsoft insiders If you're a database administrator eager to get started with the newest version of SQL Server, then this book is essential reading.
Real-World Skills for MCSA Certification and Beyond (Exams 70-461, 70-462, and 70-463)
Author: Tom Carpenter
Publisher: John Wiley & Sons
Implement, maintain, and repair SQL Server 2012databases As the most significant update since 2008, Microsoft SQL Server2012 boasts updates and new features that are critical tounderstand. Whether you manage and administer SQL Server 2012 orare planning to get your MCSA: SQL Server 2012 certification, thisbook is the perfect supplement to your learning and preparation.From understanding SQL Server's roles to implementing businessintelligence and reporting, this practical book explores tasks andscenarios that a working SQL Server DBA faces regularly and showsyou step by step how to handle them. Includes practice exams and coverage of exam objectives forthose seeking MSCA: SQL Server 2012 certification Explores the skills you'll need on the job as a SQL Server 2012DBA Discusses designing and implementing database solutions Walks you through administrating, maintaining, and securing SQLServer 2012 Addresses implementing high availability and datadistribution Includes bonus videos where the author walks you through someof the more difficult tasks expected of a DBA Featuring hands-on exercises and real-world scenarios, thisresource guides you through the essentials of implementing,maintaining, and repairing SQL Server 2012 databases.
If you need to deploy, manage, or secure Microsoft SQL Server 2012, this is the complete, fast-paced, task-based reference you’ve been searching for. Authored by a worldclass expert on running SQL Server in the enterprise, this book goes far beyond the basics, taking on the complex tasks that DBAs need to make the most of Microsoft’s first cloud-enabled database platform. Designed for maximum practical usability, it’s packed with expert tips and up-to-date real-world configuration guidance you simply won’t find anywhere else. As someone who helped influence the design of SQL Server 2012 and drawing on many months of beta testing, Ross Mistry provides immediately usable solutions for installation and upgrades, management and monitoring, performance and availability, security, consolidation, virtualization, troubleshooting, and more. Mistry identifies new features and corresponding best practices in every chapter, helping you take full advantage of new SQL Server innovations ranging from private cloud support to AlwaysOn Availability Groups. Understand how to: Efficiently install or upgrade the SQL Server 2012 database engine Administer and configure database engine settings, storage, I/O, and partitioning Transfer data on-premise or to the cloud Manage and optimize indexes Learn how to consolidate, virtualize and optimize SQL Server for Private Clouds Harden and audit SQL Server 2012 environments Administer security and authorization, including new Contained Databases Encrypt data and communications Design and deploy new AlwaysOn high-availability and disaster recovery features Implement maintenance best practices, including Policy-Based Management
About the Bundle Microsoft SQL Server 2012 Administration/CBT Nuggets Video Bundle represents a unique collaboration between. IT content leaders. The bundle features Sybex's Microsoft SQL Server 2012 Administration, written by Tom Carpenter, and access to over 35 hours' worth of videos from CBT Nuggets by instructor Garth Schulte. Both the book and the videos cover the key topic areas for SQL Server administrations, as well as MCSA: SQL Server 12 certification candidates need to know. Topics include designing a database design, installing and configuring SQL Server, creating databases and tables, and more. About CBT Nuggets CBT Nuggets is renowned for providing innovative training that's informative, meaningful, and engaging. They provide a variety of training, primarily in IT, project management, and office productivity topics. CBT Nuggets' comprehensive library contains thousands of training videos ranging from Cisco networking to Microsoft Word to help viewers pass certification exams, increase skills, or simply learn new things. All of the training is delivered through high-quality online streaming video. Subscribers can train 24 hours a day, seven days a week, from the convenience of a computer or mobile device. CBT Nuggets trainers are renowned for their expertise, industry-wide credibility, and engaging personalities. They enable CBT Nuggets to deliver accurate, up-to-date training, using a laid-back whiteboard presentation style. There are no scripts. CEO and founder Dan Charbonneau was a Microsoft trainer when he began recording CBT Nuggets' very first training videos back in the 1990s. Dan and his team operate CBT Nuggets from their world headquarters in Eugene, Oregon.
Pro SQL Server 2012 Administration 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. Pro SQL Server 2012 Administration 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 Ken Simmons and Sylvester Carstarphen 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. Rare 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. Helps you manage a SQL Server 2012 database at professional level Covers the gamut of database administration skills Provides guidance on performance optimization What you’ll learn Install SQL Server 2012 and create new databases Implement backup & recovery strategies to protect your database, and your job Diagnose and resolve query performance problems Apply policy-based management for consistency across all databases in an organization Turn every interaction with a client, manager or executive into a stepping-stone towards career success Who this book is for Pro SQL Server 2012 Administration 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. Table of Contents What's New? Pre-Install Considerations Choosing a High-Availability Solution Installing and Upgrading Post Installation Multi-Server Administration Security Administering Database Objects Indexing for Performance Managing Backups Restore and Recovery Strategies Automating Routine Maintenance Monitoring Your Server Auditing Extended Events Interface Managing Query Performance Secrets to Excelling as a Professional DBA What's Next?
Beginning SQL Server 2012 Administration provides the essential skills and knowledge needed to begin a successful career as an SQL Server database administrator. It’s an ideal book for those new to database administration, as well for those moving to SQL Server from other database brands such as Oracle and IBM DB2. SQL Server is more than just a database. It's situated within a larger context that includes solutions for reporting, for integrating data from other systems, for business intelligence and analysis, and more. Beginning SQL Server 2012 Administration paints the big picture to help you understand SQL Server’s place in the grand scheme. Then you’ll move into the nuts and bolts of installing the product, learning the management tools at your disposal, creating your first database, and maintaining that database in an ongoing state of readiness. Beginning SQL Server 2012 Administration goes beyond teaching just the core competencies of effective database administration. You will also learn the latest trends in SQL Server such as virtualizing and consolidating of servers, and using SQL Server in the cloud as a service. Administrators experienced on other platforms will find insight from comparisons of key features between SQL Server and other platforms. Beginning SQL Server 2012 Administration lays an excellent foundation for success as an SQL Server database administrator. Provides the essentials of successful SQL Server administration Covers the latest trends such as virtualization and cloud computing Paints the big picture of Microsoft’s data platform
MCSA GUIDE TO MICROSOFT SQL SERVER 2012 (Exam #70-462) provides a thorough introduction to essential database administration principles and practices to prepare readers for certification and career success. Ideal for formal courses, self-study, or professional reference, this detailed text employs a lab-based approach to help users develop the core knowledge and practical skills they need to master Microsoft SQL Server administration in an enterprise environment and pass Microsoft Certified Solutions Associate Exam 70-462. The text opens with information on the latest version of Microsoft SQL Server, offering step-by-step guidance on selecting an edition and completing initial installation and configuration. Several chapters then explore key topics such as database programming, security, performance tuning, backup and recovery, data integration, and system monitoring. Within each chapter, numerous resources and features reinforce teaching and learning, including learning objectives, summaries of key ideas, hands-on activities, discusssion questions, definitions of important terms, and case studies to provide real-world context. Important Notice: Media content referenced within the product description or the product text may not be available in the ebook version.
Buy the print version of¿ Microsoft SQL Server 2012 Unleashed and get the eBook version for free! eBook version includes chapters 44-60 not included in the print. See inside the book for access code and details. ¿ With up-to-the-minute content, this is the industry’s most complete, useful guide to SQL Server 2012. ¿ You’ll find start-to-finish coverage of SQL Server’s core database server and management capabilities: all the real-world information, tips, guidelines, and samples you’ll need to create and manage complex database solutions. The additional online chapters add extensive coverage of SQL Server Integration Services, Reporting Services, Analysis Services, T-SQL programming, .NET Framework integration, and much more. ¿ Authored by four expert SQL Server administrators, designers, developers, architects, and consultants, this book reflects immense experience with SQL Server in production environments. Intended for intermediate-to-advanced-level SQL Server professionals, it focuses on the product’s most complex and powerful capabilities, and its newest tools and features. Understand SQL Server 2012’s newest features, licensing changes, and capabilities of each edition Manage SQL Server 2012 more effectively with SQL Server Management Studio, the SQLCMD command-line query tool, and Powershell Use Policy-Based Management to centrally configure and operate SQL Server Utilize the new Extended Events trace capabilities within SSMS Maximize performance by optimizing design, queries, analysis, and workload management Implement new best practices for SQL Server high availability Deploy AlwaysOn Availability Groups and Failover Cluster Instances to achieve enterprise-class availability and disaster recovery Leverage new business intelligence improvements, including Master Data Services, Data Quality Services and Parallel Data Warehouse Deliver better full-text search with SQL Server 2012’s new Semantic Search Improve reporting with new SQL Server 2012 Reporting Services features Download the following from informit.com/title/9780672336928: Sample databases and code examples ¿ ¿
The start-to-finish guide to virtualizing business-critical SQL Server databases on VMware vSphere 5 By virtualizing business-critical databases, enterprises can drive far more value from existing IT infrastructure. But squeezing maximum performance out of a virtualized database instance is an art as much as a science. This indispensable start-to-finish guide brings together all the techniques, tips, and insights you need to succeed. Drawing on unsurpassed personal experience, three leading experts share complete best practices for deploying business-critical database servers in virtualized vSphere 5 environments. They cover the entire project lifecycle, bridging technical and communications gaps between SQL Server and VMware professionals that often make database virtualization more difficult than it needs to be. You’ll find specific guidance for architects and administrators responsible for systems, storage, databases, applications, or VMware virtualization. The authors also present detailed, start-to-finish coverage of performance baselining and testing: all you need to make your virtualized databases as fast as they are cost effective. Although this book focuses on SQL, the authors’ proven guidance for enhancing performance can be leveraged by any IT professional virtualizing a demanding Tier 1 application. Coverage includes • Business cases for database virtualization: consolidation, Database as a Service (DaaS), efficiency, and “SLAs on steroids” • Using the redundancy inherent in virtualization to improve availability • Constructing a careful, conservative implementation plan • Balancing disk, CPU, memory, and network for superior performance • Mastering the five key principles of database storage design • Leveraging memory: SQL MAX, page locking, NUMA, reservations, swapping, large memory pages, and more • Ensuring responsiveness by providing a fast, reliable, low-latency network • Supporting advanced AlwaysOn Failover Cluster Instances and Availability Groups • Baselining physical systems and properly determining resource requirements • Configuring performance tests from beginning to end • Migrating existing SQL Server databases onto a vSphere platform • Avoiding traps and pitfalls in virtualizing production databases • Managing and monitoring virtualized database instances and resources