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.
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.
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.
All your Windows Server 2008 R2 questions answered—on the spot! Get up to speed on the new features of Windows Server 2008 R2 with this indispensableguide. Designed for busy IT professionals, it's the perfect go-to resource for quick answers and real-world solutions as you administer the new server OS. You'll find easy-to-read lists, quick-reference tables, helpful thumb tabs, and much more in a handy, compact format that puts the information you need at your fingertips. Topics include: Getting started and adding roles and functionality Automating tasks Managing users, groups, directories, and the centralized desktop Handling folder security, disk management, storage, backup, and recovery Monitoring and maintaining web servers Troubleshooting IP and managing remote access Doing performance tuning and maintaining virtual servers
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.
Данная книга - краткий исчерпывающий справочник по администрированию нового варианта установки серверной операционной системы Windows Server 2008 - Windows Server 2008 Server Core. Особенность Server Core состоит в том, что администрирование осуществляется либо из командной строки, либо удаленно. В книге дается детальное описание обоих способов администрирования. Подробно описываются возможности и особенности Server Core, отличия от полной версии Windows Server 2008. Рассказывается о развертывании Server Core в интерактивном и автоматическом режимах (с использованием файла ответов). Особое внимание уделено установке ролей и компонентов, а также администрированию служб, процессов, драйверов и устройств из командной строки. Кроме того, отдельно рассматривается использование компьютера с Server Core в качестве контроллера домена, DHCP- и DNS-сервера, сервера печати, файлового сервера, веб-сервера, сервера Hyper-V и сервера потокового мультимедиа. Книга состоит из 13 глав, хорошо иллюстрирована и предназначена для администраторов и ИТ-специалистов.