Microsoft SQL Server 2012 Administration. Real-World Skills for MCSA Certification and Beyond (Exams 70-461, 70-462, and 70-463)

The ideal on-the-job reference guide for SQL Server 2008 database administrators If you manage and administer SQL Server 2008 in the real world, you need this detailed guide at your desk. From planning to disaster recovery, this practical book explores tasks and scenarios that a working SQL Server DBA faces regularly and shows you step by step how to handle them. Topics include installation and configuration, creating databases and tables, optimizing the database server, planning for high availability, and more. And, if you're preparing for MCTS or MCITP certification in SQL Server 2008 administration, this book is the perfect supplement to your preparation, featuring a CD with practice exams, flashcards, and video walkthroughs of the more difficult administrative tasks Delves into Microsoft's SQL Server 2008, a rich set of enterprise-level database services for business-critical applications Explores the skills you'll need on the job as a SQL Server 2008 administrator Shows you how to implement, maintain, and repair the SQL Server database, including bonus videos on the CD where the authors walks you through the more difficult tasks Covers database design, installation and configuration, creating databases and tables, security, backup and high availability, and more Supplements your preparation for MCTS and MCITP SQL Server 2008 certification with in-depth coverage of the skill sets required for certification, as defined by Microsoft Uses hands-on exercises and real-world scenarios to keep what you're learning grounded in the reality of the workplace Make sure you're not only prepared for certification, but also for your job as a SQL Server 2008 administrator, with this practical reference! Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.

A soup-to-nuts guide for messaging administrators Exchange Server is the world’s leading e-mail server software. Windows 7 and Server 2008 R2 have made changes that messaging administrators need to know and understand in their daily work with Exchange Server. This Sybex guide focuses on the skills, concepts, technologies, and potential pitfalls that admins in the trenches need to understand. It also provides the information they need to earn MCITP certification. Updates in Exchange Server, the world’s leading e-mail server software, require messaging administrators to update their knowledge in order to provide the best possible e-mail solutions Highly focused and comprehensive, this guide teaches you to design a highly available e-mail messaging server, install and configure Exchange Server 2010, work with recipients, groups and mailboxes, configure public folders, secure Exchange, and more CD includesvideo walkthroughs of more difficult tasks, practice exams, and electronic flashcards. Exchange Server 2010 Administration offers real-world knowledge that messaging admins need every day and helps prepare candidates for the MCITP certification exam. CD-ROM/DVD and other supplementary materials are not included as part of the e-book file, but are available for download after purchase.

A manual for Windows 7 desktop technicians and administrators It is estimated that 90 percent of the world’s computers run Windows. Desktop technicians and administrators need this comprehensive manual to guide them through their daily work with Windows 7. While this Sybex guide is packed with information you’ll need to know for the MCITP certification exam, it is equally valuable in real-world situations you will encounter on the job. Covers troubleshooting, hardware and software applications, large-scale desktop environment management, and planning and configuring the desktop infrastructure using Windows 7 Provides plenty of relevant information for those seeking MCITP certification, including full coverage of the exam objectives for both Desktop Support Technician and Desktop Administrator exams Includes a CD with valuable study tools for the MCITP exams including video walkthroughs, flashcards, and two practice exams. Windows 7 Desktop Support and Administration provides knowledge that will be needed on certification exams and remains a valuable reference for support and administrative personnel on the job. Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.

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.

The ideal on-the-job reference guide for project managers who use Microsoft Project 2010 This must-have guide to using Microsoft Project 2010 is written from a real project manager's perspective and is packed with information you can use on the job. The book explores using Project 2010 during phases of project management, reveals best practices, and walks you through project flow from planning through tracking to closure. This valuable book follows the processes defined in the PMBOK® Guide, Fourth Edition, and also provides exam prep for Microsoft's MCTS: Project 2010 certification. Explains Microsoft Project 2010, the leading software tool for project managers Shows working project managers practical ways to use Project 2010 on the job Delves into project planning, tracking, reporting, and project closure, and explores best practices for all phases of planning Reveals new software features, including tools that show what factors are affecting the schedule, a «what-if» scenario builder, and how slippages affect other aspects of the project Follows processes and procedures from The Guide to Project Management Body of Knowledge (PMBOK®), Fourth Edition Covers the skill set required for the MCTS: Microsoft Project 2010, Managing Projects certification, so you can use this book for exam prep This valuable book follows the processes defined in the PMBOK Guide, Fourth Edition, and also provides exam prep for Microsoft's MCTS: Project 2010, Managing Projects certification. Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file. (PMBOK is a registered mark of the Project Management Institute, Inc.)

Mobile computing skills are becoming standard in the IT industry Mobile Computing Deployment and Management: Real World Skills for CompTIA Mobility+ Certification and Beyond is the ultimate reference for mobile computing. Certified Wireless Network Expert Robert J. Bartz guides IT and networking professionals through the fundamental and advanced concepts of mobile computing, providing the information and instruction necessary to get up to speed on current technology and best practices. The book maps to the CompTIA Mobility+ (MB0-001) exam, making it an ideal resource for those seeking this rewarding certification. The mobile device has already overshadowed the PC as a primary means for Internet access for a large portion of the world's population, and by 2020, there will be an estimated 10 billion mobile devices worldwide. Mobile connectivity has become the new standard for business professionals, and when combined with cloud computing, it creates a world where instant access is the norm. To remain relevant, IT professionals must hone their mobile skills. The ability to manage, develop, and secure a mobile infrastructure is quickly becoming a key component to entering the IT industry, and professionals lacking those skills will be left behind. This book covers all aspects of mobile computing, including: Radio frequency, antenna, and cellular technology Physical and logical infrastructure technologies Common mobile device policies and application management Standards and certifications, and more Each chapter includes hands-on exercises, real-world examples, and in-depth guidance from the perspective of a mobile computing expert. IT professionals looking to expand their capabilities need look no further than Mobile Computing Deployment and Management: Real World Skills for CompTIA Mobility+ Certification and Beyond for the most comprehensive approach to mobile computing on the market today.

SQL Server 2008 is how-to guide for experienced DBAs. Tutorial-based, this book will get you over the learning curve of how to configure and administer SQL Server 2008. Whether you're an administrator or developer using SQL Server, you can't avoid wearing a DBA hat at some point. The book is loaded with unique tips and workarounds for the most difficult SQL Server admin issues, including managing and monitoring SQL Server, automating administration, security, performance tuning, scaling and replications, clustering, and backup and recovery. A companion website is also available.

Learn to take advantage of the opportunities offered by SQL Server 2014 Microsoft's SQL Server 2014 update means big changes for database administrators, and you need to get up to speed quickly because your methods, workflow, and favorite techniques will be different from here on out. The update's enhanced support of large-scale enterprise databases and significant price advantage mean that SQL Server 2014 will become even more widely adopted across the industry. The update includes new backup and recovery tools, new AlwaysOn features, and enhanced cloud capabilities. In-memory OLTP, Buffer Pool Extensions for SSDs, and a new Cardinality Estimator can improve functionality and smooth out the workflow, but only if you understand their full capabilities. Professional Microsoft SQL Server 2014 is your comprehensive guide to working with the new environment. Authors Adam Jorgensen, Bradley Ball, Ross LoForte, Steven Wort, and Brian Knight are the dream team of the SQL Server community, and they put their expertise to work guiding you through the changes. Improve oversight with better management and monitoring Protect your work with enhanced security features Upgrade performance tuning, scaling, replication, and clustering Learn new options for backup and recovery Professional Microsoft SQL Server 2014 includes a companion website with sample code and efficient automation utilities, plus a host of tips, tricks, and workarounds that will make your job as a DBA or database architect much easier. Stop getting frustrated with administrative issues and start taking control. Professional Microsoft SQL Server 2014 is your roadmap to mastering the update and creating solutions that work.

Prepare for the MCSA Windows Server 2012 exams with this Sybex study guide Microsoft's new version of the MCSA certification for Windows Server 2012 requires passing three exams. This value-priced study guide includes more than 1,000 pages of quality exam-prep content, covering 100 percent of the objective domains of all three exams (as well as the Upgrade exam, 70-417). Also includes more than 500 practice questions. You also have access to three bonus exams, electronic flashcards, and videos showing how to perform the more difficult tasks. Both first-time MCSA candidates and those wishing to upgrade from Server 2008 certification will benefit from this complete test-prep guide. Provides a comprehensive study guide for all three MCSA Windows Server 2012 exams: 70-410, 70-411, and 70-412, as well as the Upgrade exam: 70-417 Covers installing and configuring Windows Server 2012; deploying and configuring DNS service; administering Active Directory; creating and managing Group Policy Objects; and configuring server roles and features, Hyper-V, and core networking services Explains basic networking concepts, DHCP, deploying and maintaining servers, configuring a network policy server infrastructure and high availability in Windows Server 2012, and much more Features real-world scenarios, hands-on exercises, practice exams, electronic flashcards, and over an hour of video demonstrations Covers all exam objectives MCSA Windows Server 2012 Complete Study Guide arms you with all the information you must master to achieve MCSA certification on Windows Server 2012.

Prepare for the MCSA Windows Server 2012 R2 Exams Microsoft's new version of the MCSA certification for Windows Server 2012 R2 requires passing three exams (or one Upgrade exam if you have your MCSA or MCITP in Windows Server 2008). This value-priced study guide includes more than 1,000 pages of quality exam-prep content, covering 100% of the objective domains of all three exams (as well as the Upgrade exam, 70-417). In addition, you get access to an interactive practice test environment with more than 500 questions, electronic flashcards, and videos showing how to perform the more difficult tasks. Both first-time MCSA candidates and those wishing to upgrade from Server 2008 certification will benefit from this complete test-prep guide. Completely updated to cover the Windows Server 2012 R2 Exams Provides a comprehensive study guide for all three MCSA Windows Server 2012 R2 exams: 70-410, 70-411, and 70-412, as well as the Upgrade exam: 70-417 Covers installing and configuring Windows Server 2012; deploying and configuring DNS service; administering Active Directory; creating and managing Group Policy Objects; and configuring server roles and features, Hyper-V, and core networking services Explains basic networking concepts, DHCP, deploying and maintaining servers, configuring a network policy server infrastructure and high availability in Windows Server 2012, and much more Features real-world scenarios, hands-on exercises, practice exam questions, electronic flashcards, and over an hour of video demonstrations Covers all exam objectives MCSA Windows Server 2012 R2 Complete Study Guide arms you with all the information you must master to achieve MCSA certification on Windows Server 2012 R2.