Author: Don Jones
Publisher: Manning Publications
Release Date: 2014-05-08
Summary Learn SQL Server Administration in a Month of Lunches is the perfect way to get started with SQL Server operations, including maintenance, backup and recovery, high availability, and performance monitoring. In about an hour a day over a month, you'll learn exactly what you can do, and what you shouldn't touch. Most importantly, you'll learn the day-to-day tasks and techniques you need to keep SQL Server humming along smoothly. Purchase of the print book includes a free eBook in PDF, Kindle, and ePub formats from Manning Publications. About the Book Microsoft SQL Server is used by millions of businesses, ranging in size from Fortune 500s to small shops worldwide. Whether you're just getting started as a DBA, supporting a SQL Server-driven application, or you've been drafted by your office as the SQL Server admin, you do not need a thousand-page book to get up and running. Learn SQL Server Administration in a Month of Lunches is the perfect way to get started with SQL Server. This concise, easy-to-read book skips academic introductions and teaches you day-to-day techniques for maintenance, backup and recovery, performance monitoring, and more. Each of the 21 short lessons gives you practical takeaways you'll use over and over. What's Inside Master the basics—indexes, logins, backup, recovery ... and more Learn what you can and cannot do when supporting a third-party application Monitor and improve performance Written by expert trainer and bestselling author Don Jones Accessible to readers of any level of experience, the book covers techniques for all versions of SQLServer 2005-2014. About the Author Don Jones is a Microsoft MVP, speaker, and trainer. He is the creator of the Month of Lunches series and author of over 50 books on PowerShell, IIS, Active Directory, SCCM, SQL Server, and more. Table of Contents Before you begin Server assessment and configuration T-SQL crash course Managing databases Backup and recovery Authentication: who are you? Authorization: what are you allowed to do? Accounting: what did you do? Analyzing indexes Maintaining indexes Tuning index designs Reading query execution plans Block and deadlock analysis Automating management with SQL Server Agent Multiserver management Windows PowerShell and SQL Server Using Extended Events Monitoring and analyzing performance Options for high availability Virtualizing SQL Server Moving, migrating, and upgrading databases SQL Server performance checklist Never the end
Author: Tom Carpenter
Publisher: John Wiley & Sons
Release Date: 2013-06-03
Implement, maintain, and repair SQL Server 2012 databases As the most significant update since 2008, Microsoft SQL Server 2012 boasts updates and new features that are critical to understand. Whether you manage and administer SQL Server 2012 or are planning to get your MCSA: SQL Server 2012 certification, this book is the perfect supplement to your learning and preparation. From understanding SQL Server's roles to implementing business intelligence and reporting, 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. Includes practice exams and coverage of exam objectives for those seeking MSCA: SQL Server 2012 certification Explores the skills you'll need on the job as a SQL Server 2012 DBA Discusses designing and implementing database solutions Walks you through administrating, maintaining, and securing SQL Server 2012 Addresses implementing high availability and data distribution Includes bonus videos where the author walks you through some of the more difficult tasks expected of a DBA Featuring hands-on exercises and real-world scenarios, this resource guides you through the essentials of implementing, maintaining, and repairing SQL Server 2012 databases.
DBA Survivor is a book to help new database administrators understand more about the world of database administration. More and more people are moving into the DBA profession, and many are looking for a getting-started guide. Blogs are written about how to be an exceptional DBA and what to do in your first 100 days. This book takes a different approach, injecting some humor into helping you understand how to hit the ground running, and most importantly how to survive as a DBA. And it’s not just survival that matters. Author Thomas LaRock wants much more for you than mere survival. He wants you to have excellence, competence, visibility, confidence, and service. These are the traits and characteristics of DBAs who truly succeed and become respected in their profession. Don’t settle for just muddling through your job each day. Strive to excel. Aim to make a difference, for your clients, and for your colleagues. Focuses on the soft skills that distinguish truly exceptional DBAs Takes a humorous approach to keep readers engaged Written by a SQL Server "Most Valuable Professional" and board member of PASS
This book describes, diagnoses, and solves the most common problems with SQL Server 2005, 2008, and 2008 R2. The authors explain a basic approach to troubleshooting and the essential tools. They explore areas in which problems arise with regularity: high disk I/O (RAID misconfiguration, inadequate I/O throughput, poor workload distribution, SAN issues, disk partition misalignment); high CPU usage (insufficient memory, poorly written queries, inadequate indexing, inappropriate configuration option settings); memory mismanagement; missing indexes; blocking (caused mainly by poorly designed databases that lack proper keys and indexing, and applications that apply needlessly restrictive transaction isolation levels); deadlocking (Bookmark Lookup, Serializable Range Scan, Cascading Constraint); full transaction logs (lack of log backups, hefty index maintenance operations, long running transaction, problems with replication and mirroring environments); and accidentally-lost data. Finally, the authors discuss diagnosing tools such as the Performance Monitor, Dynamic Management Views, and server-side tracing. --
Author: Peter Carter
Release Date: 2015-11-16
Pro SQL Server Administration brings SQL Server administration into the modern era with strong coverage of hybrid cloud environments, In-Memory OLTP, and installation on Server Core. This comprehensive guide to SQL Server Administration for today’s DBA helps you to administer the new and key areas of SQL Server, including Columnstore indexes and the In-Memory OLTP feature set introduced in 2014. You will also be guided through the administration of traditional areas of SQL Server, including how to secure your instance, monitor and maintain your instance, and to use features such as AlwaysOn to make your instance highly available. Also covered is the use of SQL Server features to scale out read-only workloads. Pro SQL Server Administration is an all-new book taking up-to-date and modern approach that you'll want and need to further your career as a SQL Server database administrator. Extensive coverage of hybrid cloud environments involving Azure SQL Database Detailed discussions on all new, key features, including AlwaysOn and in-memory support Comprehensive coverage of key skills, such as monitoring, maintenance and indexing
"Congratulations! You are going to WIN your next SQL Server interview. “SQL The One” book can guide you to achieve the success in your next interview. This book covers Microsoft SQL Server interview experiences, questions and answers for a range of SQL DBA’s and SQL Server Professionals. All of these questions have been collected from the people who attended interviews at various multinational companies across the world. It also covers “How to prepare for a SQL DBA interview?” and “How to become an expert in your career?” Salient Features of Book All interview questions are asked in various MNC Covers 1090 real time questions and answers 254 questions on SQL Server Performance Tuning Covers all SQL Server HA & DR features 316 questions on SQL Server HA & DR features Lots of scenario based questions Covers SQL Server 2005, 2008, 2008 R2, 2012, 2014 and 2016 Questions are categorized In-depth explanations An Interview Experience with Microsoft Useful as a reference guide for SQL DBA Interview preparation
Author: Craig S. Mullins
Release Date: 2012-10-11
Genre: Business & Economics
Database Administration, Second Edition , is the definitive, technology-independent guide to the modern discipline of database administration. Packed with best practices and proven solutions for any database platform or environment, this text fully reflects the field’s latest realities and challenges. Drawing on more than thirty years of database experience, Mullins focuses on problems that today’s DBAs actually face, and skills and knowledge they simply must have. Mullins presents realistic, thorough, and up-to-date coverage of every DBA task, including creating database environments, data modeling, normalization, design, performance, data integrity, compliance, governance, security, backup/recovery, disaster planning, data and storage management, data movement/distribution, data warehousing, connectivity, metadata, tools, and more. This edition adds new coverage of “Big Data,” database appliances, cloud computing, and NoSQL. Mullins includes an entirely new chapter on the DBA’s role in regulatory compliance, with substantial new material on data breaches, auditing, encryption, retention, and metadata management. You’ll also find an all-new glossary, plus up-to-the-minute DBA rules of thumb.
Author: Donald W. Jones
Publisher: Manning Publications
Release Date: 2016-10-01
PowerShell provides a single, unified administrative command line from which to control and automate virtually every aspect of a Windows system. It accepts and executes commands immediately, and scripts can be written to manage most Windows servers like Exchange, IIS, and SharePoint. This updated book covers PowerShell features that run on Windows 7, Windows Server 2008 R2, and later. This edition is appropriate for PowerShell version 3 and later. There is coverage for new PowerShell version 5 features like PowerShellGet, however PowerShell fundamentals are unchanged. Learn Windows PowerShell in a Month of Lunches, Third Edition is an innovative tutorial designed for busy IT professionals. With just one hour a day for a month, readers will be automating Windows tasks faster than they ever thought possible. They start with the basics (What is PowerShell and what can be done with it). Then, it moves systematically through the techniques and features that facilitate efficient and effective results. Purchase of the print book includes a free eBook in PDF, Kindle, and ePub formats from Manning Publications.
Delve inside the core SQL Server engine—and put that knowledge to work—with guidance from a team of well-known internals experts. Whether database developer, architect, or administrator, you’ll gain the deep knowledge you need to exploit key architectural changes—and capture the product’s full potential. Discover how SQL Server works behind the scenes, including: What happens internally when SQL Server builds, expands, shrinks, and moves databases How to use event tracking—from triggers to the Extended Events Engine Why the right indexes can drastically reduce your query execution time How to transcend normal row-size limits with new storage capabilities How the Query Optimizer operates Multiple techniques for troubleshooting problematic query plans When to force SQL Server to reuse a cached query plan—or create a new one What SQL Server checks internally when running DBCC How to choose among five isolation levels and two concurrency models when working with multiple concurrent users
When New York–based graphic designers and long-time friends Timothy Goodman and Jessica Walsh found themselves single at the same time, they decided to try an experiment. The old adage says that it takes 40 days to change a habit—could the same be said for love? So they agreed to date each other for 40 days, record their experiences in questionnaires, photographs, videos, texts, and artworks, and post the material on a website they would create for this purpose. What began as a small experiment between two friends became an Internet sensation, drawing 5 million unique (and obsessed) visitors from around the globe to their site and their story since it was launched in July 2013. 40 Days of Dating: An Experiment is a beautifully designed, expanded look at the experiment and the results, including a great deal of material that never made it onto the site, such as who they were as friends and individuals before the 40 days and who they have become since. Note: 40 Days of Dating has a special binding that allows it to open very flat by attaching the endpapers to the inside covers.
Summary Learn Active Directory Management in a Month of Lunches is a practical, hands-on tutorial designed for IT pros new to Active Directory. It skips the theory and concentrates on the day-to-day administration tasks you need to know to keep your network running smoothly. Just set aside an hour a day for a month—lunchtime would be perfect—and you'll be comfortable and productive with Active Directory before you know it. About the Book At the heart of your Windows network is Active Directory, the control center for administration, security, and other core management functions. If you're new to Active Directory administration—or if you find yourself unexpectedly thrust into that role—you'll need to get up to speed fast. Learn Active Directory Management in a Month of Lunches is a hands-on tutorial designed for IT pros new to Active Directory. Without assuming previous administration experience, the book starts by walking you through the most important day-to-day system management tasks. You'll learn how to administer AD both from the GUI tools built into Windows and by using PowerShell at the command line. Along the way, you'll touch on best practices for managing user access, setting group policies, automating backups, and more. This book assumes no prior experience with Active Directory or Windows administration. Examples are based in Windows Server 2012 Purchase of the print book includes a free eBook in PDF, Kindle, and ePub formats from Manning Publications. What's Inside ADM tasks you'll need every day GUI and command line techniques Content tested by new administrators Well-illustrated, clearly explained examples About the Author Richard Siddaway is an experienced all-around Windows administrator with two decades of experience. He's the author of PowerShell in Practice andPowerShell and WMI, and coauthor of PowerShell in Depth. Table of Contents PART 1 MANAGING ACTIVE DIRECTORY DATA Before you begin Creating user accounts Managing user accounts Managing groups Troubleshooting users and groups Managing computer accounts Managing organizational units PART 2 MANAGING GROUP POLICY Creating Group Policies Managing Group Policies Fine-grained password policies PART 3 MANAGING THE ACTIVE DIRECTORY SERVICE Creating domain controllers Managing domain controllers Protecting AD data Security: Default groups and delegation Managing DNS Managing sites and subnets AD replication Managing AD trusts PART 4 MAINTENANCE AND TROUBLESHOOTING Troubleshooting your AD Maintaining and monitoring Active Directory Future work and final exam Into the cloud
Author: Peter A. Carter
Release Date: 2016-07-27
Automate your workload and manage more databases and instances with greater ease and efficiency by combining metadata-driven automation with powerful tools like PowerShell and SQL Server Agent. Automate your new instance-builds and use monitoring to drive ongoing automation, with the help of an inventory database and a management data warehouse. The market has seen a trend towards there being a much smaller ratio of DBAs to SQL Server instances. Automation is the key to responding to this challenge and continuing to run a reliable database platform service. Expert Scripting and Automation for SQL Server DBAs guides you through the process of automating the maintenance of your SQL Server enterprise. Expert Scripting and Automation for SQL Server DBAs shows how to automate the SQL Server build processes, monitor multiple instances from a single location, and automate routine maintenance tasks throughout your environment. You will also learn how to create automated responses to common or time consuming break/fix scenarios. The book helps you become faster and better at what you do for a living, and thus more valuable in the job market. Extensive coverage of automation using PowerShell and T-SQL Detailed discussion and examples on metadata-driven automation Comprehensive coverage of automated responses to break/fix scenarios What You Will Learn Automate the SQL Server build process Create intelligent, metadata-drive routines Automate common maintenance tasks Create automated responses to common break/fix scenarios Monitor multiple instance from a central location Utilize T-SQL and PowerShell for administrative purposes Who This Book Is For Expert Scripting and Automation for SQL Server DBAs is a book for SQL Server database administrators responsible for managing increasingly large numbers of databases across their business enterprise. The book is also useful for any database administrator looking to ease their workload through automation. The book addresses the needs of these audiences by showing how to get more done through less effort by implementing an intelligent, automated-processes service model using tools such as T-SQL, PowerShell, Server Agent, and the Management Data Warehouse.
Written in an easy-to-follow, example-driven format, there are plenty of stepbystep instructions to help get you started! The book has a friendly approach, with the opportunity to learn by experimenting. If you are a BI and Data Warehouse developer new to Microsoft Business Intelligence, and looking to get a good understanding of the different components of Microsoft SQL Server for Business Intelligence, this book is for you. It’s assumed that you will have some experience in databases systems and T-SQL. This book is will give you a good upshot view of each component and scenarios featuring the use of that component in Data Warehousing and Business Intelligence systems.
Summary Learn Linux in a Month of Lunches shows you how to install and use Linux for all the things you do with your OS, like connecting to a network, installing software, and securing your system. Whether you're just curious about Linux or have to get up and running for your job, you'll appreciate how this book concentrates on the tasks you need to know how to do in 23 easy lessons. About the Technology If you've only used Windows or Mac OS X, you may be daunted by the Linux operating system. And yet learning Linux doesn't have to be hard, and the payoff is great. Linux is secure, flexible, and free. It's less susceptible to malicious attacks, and when it is attacked, patches are available quickly. If you don't like the way it looks or behaves, you can change it. And best of all, Linux allows users access to different desktop interfaces and loads of software, almost all of it completely free. About the Book Learn Linux in a Month of Lunches shows you how to install and use Linux for all the things you do with your OS, like connecting to a network, installing software, and securing your system. Whether you're just curious about Linux or need it for your job, you'll appreciate how this book focuses on just the tasks you need to learn. In easy-to-follow lessons designed to take an hour or less, you'll learn how to use the command line, along with practical topics like installing software, customizing your desktop, printing, and even basic networking. You'll find a road map to the commands and processes you need to be instantly productive. What's Inside Master the command line Learn about file systems Understand desktop environments Go from Linux novice to expert in just one month About the Reader This book is for anyone looking to learn how to use Linux. No previous Linux experience required. About the Author Steven Ovadia is a professor and librarian at LaGuardia Community College, CUNY. He curates The Linux Setup, a large collection of interviews with desktop Linux users, and writes for assorted library science journals. Table of Contents PART 1 - GETTING LINUX UP AND RUNNING Before you begin Getting to know Linux Installing Linux Getting to know your system Desktop environments Navigating your desktop PART 2 - A HOME OFFICE IN LINUX Installing software An introduction to Linux home/office software Text files and editors Working with files and folders on the command line Working with common command-line applications, part 1 Working with common command-line applications, part 2 Using the command line productively Explaining the Linux filesystem hierarchy Windows programs in Linux Establishing a workflow PART 3 - HOME SYSTEM ADMIN ON LINUX An in-depth look at package management and maintenance Updating the operating system Linux security Connecting to other computers Printing Version control for non-programmers Never the end