SQL Server Backup and Restore


Book Description

A database administrator's duties include ensuring that a database can be restored and recovered in the event of error or disaster. This book discusses how to perform backup and restore operations using SQL Server Management Studio (SSMS), basic T-SQL scripts and Red Gate's SQL Backup tool. Capturing backups using SSMS or simple scripts is fine for one-off backup operations, but any backups that form part of the recovery strategy for any given database must be automated with some built-in checks that, for example, alert the responsible database administrator immediately if a problem arises. The tool of choice in this book for backup automation is Red Gate SQL Backup. Building an automated solution will take a lot of work, but this book offers some advice on possible options, such as PowerShell scripting, T-SQL scripts and SQL Server Agent jobs. --




Instant PostgreSQL Backup and Restore How-to


Book Description

Filled with practical, step-by-step instructions and clear explanations for the most important and useful tasks. This hands-on guide provides a quick and easy way to back up and restore your database using PostgreSQL.Written for database administrators who want to create backups of their critical enterprise data and efficiently restore it using PostgreSQL.




Backup & Recovery


Book Description

Packed with practical, affordable backup and recovery solutions for UNIX, Linux, Windows, and the Mac OS X system--as well as various databases--this new guide is a complete overhaul of the author's strong-selling "UNIX Backup & Recovery," now revised and expanded with over 40 percent new material.




Unix Backup and Recovery


Book Description

Providing an overview of all facets of UNIX backup and recovery, this text offers practical solutions for environments of all sizes and budgets, explaining everything from freely-available backup systems to large-scale commercial utilities.




Teach Yourself VISUALLY LinkedIn


Book Description

A complete visual guide to the world's largest professional network Teach Yourself VISUALLY LinkedIn is your guide to becoming a part of the world's largest professional network, with over 259 million users across 200 countries and territories. Using full-color screen shots, this visually rich guide provides step-by-step instructions that show you how to get the most out of the myriad tools and features LinkedIn has to offer. The book is organized for quick, easy navigation, and written in clear, concise language that allows you to get up to speed quickly. LinkedIn has become the premier destination both for those seeking employment, and those looking to employ others. A professional take on social media, the site allows users to post resume-like profiles and network with others in their fields, connecting with past, present, and potentially future colleagues. LinkedIn is growing at a rate of two users per second, making it a major hub and networking tool for those looking to establish, maintain, or grow a professional network. This guide discusses the purpose and benefits of LinkedIn, and shows you how to set up a professional profile that will stand out from the crowd. Topics include: Setting up your account Adding endorsements and recommendations Networking with colleagues Posting status updates Showing off your strengths, talents, and accomplishments is an important part of networking, and interacting with others in your industry is an excellent way to get your name out there and make new contacts. LinkedIn facilitates both, allowing you to broaden your reach without leaving your desk. Teach Yourself VISUALLY LinkedIn helps you get on board today.




Seven NoSQL Databases in a Week


Book Description

A beginner's guide to get you up and running with Cassandra, DynamoDB, HBase, InfluxDB, MongoDB, Neo4j, and Redis Key Features Covers the basics of 7 NoSQL databases and how they are used in the enterprises Quick introduction to MongoDB, DynamoDB, Redis, Cassandra, Neo4j, InfluxDB, and HBase Includes effective techniques for database querying and management Book Description This is the golden age of open source NoSQL databases. With enterprises having to work with large amounts of unstructured data and moving away from expensive monolithic architecture, the adoption of NoSQL databases is rapidly increasing. Being familiar with the popular NoSQL databases and knowing how to use them is a must for budding DBAs and developers. This book introduces you to the different types of NoSQL databases and gets you started with seven of the most popular NoSQL databases used by enterprises today. We start off with a brief overview of what NoSQL databases are, followed by an explanation of why and when to use them. The book then covers the seven most popular databases in each of these categories: MongoDB, Amazon DynamoDB, Redis, HBase, Cassandra, InfluxDB, and Neo4j. The book doesn't go into too much detail about each database but teaches you enough to get started with them. By the end of this book, you will have a thorough understanding of the different NoSQL databases and their functionalities, empowering you to select and use the right database according to your needs. What you will learn Understand how MongoDB provides high-performance, high-availability, and automatic scaling Interact with your Neo4j instances via database queries, Python scripts, and Java application code Get familiar with common querying and programming methods to interact with Redis Study the different types of problems Cassandra can solve Work with HBase components to support common operations such as creating tables and reading/writing data Discover data models and work with CRUD operations using DynamoDB Discover what makes InfluxDB a great choice for working with time-series data Who this book is for If you are a budding DBA or a developer who wants to get started with the fundamentals of NoSQL databases, this book is for you. Relational DBAs who want to get insights into the various offerings of popular NoSQL databases will also find this book to be very useful.




Zabbix 4 Network Monitoring


Book Description

Gather detailed statistics and deploy impressive business solutions with Zabbix 4.0 Key FeaturesExperience the full impact of Zabbix 4.0, a useful and increasingly popular toolEnhance your network’s performance and manage hosts and systemsA step-by-step guide to smarter network monitoringBook Description Zabbix 4 Network Monitoring is the perfect starting point for monitoring the performance of your network devices and applications with Zabbix. Even if you’ve never used a monitoring solution before, this book will get you up and running quickly. You’ll learn to monitor more sophisticated operations with ease and soon feel in complete control of your network, ready to meet any challenges you might face. Starting with the installation, you will discover the new features in Zabbix 4.0. You will then get to grips with native Zabbix agents and Simple Network Management Protocol (SNMP) devices. You will also explore Zabbix's integrated functionality for monitoring Java application servers and VMware. This book also covers notifications, permission management, system maintenance, and troubleshooting, so you can be confident that every potential challenge and task is under your control. If you're working with larger environments, you'll also be able to find out more about distributed data collection using Zabbix proxies. Once you're confident and ready to put these concepts into practice, you will understand how to optimize and improve performance. Troubleshooting network issues is vital for anyone working with Zabbix, so the book also helps you work through any technical snags and glitches you might face. By the end of this book, you will have learned more advanced techniques to fine-tune your system and make sure it is in a healthy state. What you will learnInstall Zabbix server and an agent from sourceManage hosts, users, and permissions while acting upon monitored conditionsVisualize data with the help of ad hoc graphs, custom graphs, and mapsSimplify complex configurations and learn to automate themMonitor everything from web pages to IPMI devices and Java applications to VMware statsConfigure Zabbix to send alerts including problem severity and time periodsTroubleshoot any network issueWho this book is for If you're new to Zabbix look no further than this book. Zabbix 4 Network Monitoring is for system and network administrators who are looking to put their knowledge to work with Zabbix 4.0.




Mastering Proxmox


Book Description

Discover real world scenarios for Proxmox troubleshooting and become an expert cloud builder About This Book Formulate Proxmox-based solutions and set up virtual machines of any size while gaining expertise even on the most complex multi-cluster setups Master the skills needed to analyze, monitor, and troubleshoot real-world virtual environments This is the most up-to-date title on mastering Proxmox, with examples based on the new Linux Kernel 4.10.15 and Debian Stretch (9.x) Who This Book Is For This book is for Linux and system administrators and professionals working in IT teams who would like to design and implement an enterprise-quality virtualized environment using Proxmox. Some knowledge of networking and virtualization concepts is assumed. What You Will Learn Install basic Proxmox VE nodes and get to know the Proxmox GUI Get to know Proxmox's internal structure and mechanics Create and manage KVM or LXC-based virtual machines Understand advanced virtual networks Configure high availability Proxmox nodes Integrate Ceph big data storage with the Proxmox hypervisor Plan a large virtual environment for cloud-based services Discover real-world scenarios for Proxmox troubleshooting In Detail Proxmox is an open source server virtualization solution that has enterprise-class features for managing virtual machines, for storage, and to virtualize both Linux and Windows application workloads. You'll begin with a refresher on the advanced installation features and the Proxmox GUI to familiarize yourself with the Proxmox VE hypervisor. Then, you'll move on to explore Proxmox under the hood, focusing on storage systems, such as Ceph, used with Proxmox. Moving on, you'll learn to manage KVM virtual machines, deploy Linux containers fast, and see how networking is handled in Proxmox. You'll also learn how to protect a cluster or a VM with a firewall and explore the new high availability features introduced in Proxmox VE 5.0. Next, you'll dive deeper into the backup/restore strategy and see how to properly update and upgrade a Proxmox node. Later, you'll learn how to monitor a Proxmox cluster and all of its components using Zabbix. Finally, you'll discover how to recover Promox from disaster strikes through some real-world examples. By the end of the book, you'll be an expert at making Proxmox work in production environments with minimal downtime. Style and approach This book walks you through every aspect of virtualization using Proxmox using a practical, scenario-based approach that features best practices and all the weaponry you need to succeed when building virtual environments with Proxmox 5.0.




Scrivener For Dummies


Book Description

No matter what you want to write, Scrivener makes it easier. Whether you’re a planner, a seat-of-the-pants writer, or something in between, Scrivener provides tools for every stage of the writing process. Scrivener For Dummies walks you step-by-step through this popular writing software’s best features. This friendly For Dummies guide starts with the basics, but even experienced scriveners will benefit from the helpful tips for getting more from their favourite writing software. Walks you through customizing project templates for your project needs Offers useful advice on compiling your project for print and e-book formats Helps you set up project and document targets and minimize distractions to keep you on track and on deadline Explains how to storyboard with the corkboard, create collections, and understand their value Shows you how to use automated backups to protect your hard work along the way From idea inception to manuscript submission, Scrivener for Dummies makes it easier than ever to plan, write, organize, and revise your masterpiece in Scrivener.




SQL Server Query Performance Tuning


Book Description

Queries not running fast enough? Wondering about the in-memory database features in 2014? Tired of phone calls from frustrated users? Grant Fritchey’s book SQL Server Query Performance Tuning is the answer to your SQL Server query performance problems. The book is revised to cover the very latest in performance optimization features and techniques, especially including the newly-added, in-memory database features formerly known under the code name Project Hekaton. This book provides the tools you need to approach your queries with performance in mind. SQL Server Query Performance Tuning leads you through understanding the causes of poor performance, how to identify them, and how to fix them. You’ll learn to be proactive in establishing performance baselines using tools like Performance Monitor and Extended Events. You’ll learn to recognize bottlenecks and defuse them before the phone rings. You’ll learn some quick solutions too, but emphasis is on designing for performance and getting it right, and upon heading off trouble before it occurs. Delight your users. Silence that ringing phone. Put the principles and lessons from SQL Server Query Performance Tuning into practice today. Covers the in-memory features from Project Hekaton Helps establish performance baselines and monitor against them Guides in troubleshooting and eliminating of bottlenecks that frustrate users