Learn dbatools in a Month of Lunches

Learn dbatools in a Month of Lunches
Author: Chrissy LeMaire
Publisher: Simon and Schuster
Total Pages: 398
Release: 2022-08-16
Genre: Computers
ISBN: 1638351260
GET BOOK

Download Learn dbatools in a Month of Lunches Book in PDF, Epub and Kindle

If you work with SQL Server, dbatools is a lifesaver. This book will show you how to use this free and open source PowerShell module to automate just about every SQL server task you can imagine—all in just one month! In Learn dbatools in a Month of Lunches you will learn how to: Perform instance-to-instance and customized migrations Automate security audits, tempdb configuration, alerting, and reporting Schedule and monitor PowerShell tasks in SQL Server Agent Bulk-import any type of data into SQL Server Install dbatools in secure environments Written by a group of expert authors including dbatools creator Chrissy LeMaire, Learn dbatools in a Month of Lunches teaches you techniques that will make you more effective—and efficient—than you ever thought possible. In twenty-eight lunchbreak lessons, you’ll learn the most important use cases of dbatools and the favorite functions of its core developers. Stabilize and standardize your SQL server environment, and simplify your tasks by building automation, alerting, and reporting with this powerful tool. About the technology For SQL Server DBAs, automation is the key to efficiency. Using the open-source dbatools PowerShell module, you can easily execute tasks on thousands of database servers at once—all from the command line. dbatools gives you over 500 pre-built commands, with countless new options for managing SQL Server at scale. There’s nothing else like it. About the book Learn dbatools in a Month of Lunches teaches you how to automate SQL Server using the dbatools PowerShell module. Each 30-minute lesson introduces a new automation that will make your daily duties easier. Following the expert advice of dbatools creator Chrissy LeMaire and other top community contributors, you’ll learn to script everything from backups to disaster recovery. What's inside Performing instance-to-instance and customized migrations Automating security audits, best practices, and standardized configurations Administering SQL Server Agent including running PowerShell scripts effectively Bulk-importing many types of data into SQL Server Executing advanced tasks and increasing efficiency for everyday administration About the reader For DBAs, accidental DBAs, and systems engineers who manage SQL Server. About the author Chrissy LeMaire is a GitHub Star and the creator of dbatools. Rob Sewell is a data engineer and a passionate automator. Jess Pomfret and Cláudio Silva are data platform architects. All are Microsoft MVPs. Table of Contents 1 Before you begin 2 Installing dbatools 3 The dbatools lab 4 A gentle introduction to dbatools commands 5 Writing to SQL Server 6 Finding SQL Server instances on your network 7 Inventorying your SQL estate 8 Registered Servers 9 Logins and users 10 Backups 11 Restore 12 Snapshots 13 Install and update SQL Server 14 Preparing for disaster 15 Performing your first advanced SQL Server instance migration, part 1 16 Performing your first advanced SQL Server instance migration, part 2 17 High availability and disaster recovery 18 PowerShell and SQL Server Agent 19 SQL Server Agent administration 20 Creating and working with SQL Server Agent objects 21 Data masking 22 DevOps automation 23 Tracing SQL Server activity 24 Security and encryption 25 Data compression 26 Validating your estate with dbachecks 27 Working in the cloud 28 dbatools configurations and logging 29 Never the end

Learn SQL Server Administration in a Month of Lunches

Learn SQL Server Administration in a Month of Lunches
Author: Don Jones
Publisher: Simon and Schuster
Total Pages: 390
Release: 2014-04-30
Genre: Computers
ISBN: 1638353166
GET BOOK

Download Learn SQL Server Administration in a Month of Lunches Book in PDF, Epub and Kindle

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

Learn Git in a Month of Lunches

Learn Git in a Month of Lunches
Author: Rick Umali
Publisher: Simon and Schuster
Total Pages: 596
Release: 2015-09-01
Genre: Computers
ISBN: 1638353492
GET BOOK

Download Learn Git in a Month of Lunches Book in PDF, Epub and Kindle

Summary Learn Git in a Month of Lunches introduces the discipline of source code control using Git. Whether you're a newbie or a busy pro moving your source control to Git, you'll appreciate how this book concentrates on the components of Git you'll use every day. In easy-to-follow lessons designed to take an hour or less, you'll dig into Git's distributed collaboration model, along with core concepts like committing, branching, and merging. Purchase of the print book includes a free eBook in PDF, Kindle, and ePub formats from Manning Publications. About the Book Git is the source code control system preferred by modern development teams. Its decentralized architecture and lightning-fast branching let you concentrate on your code instead of tedious version control tasks. At first, Git may seem like a sprawling beast. Fortunately, to get started you just need to master a few essential techniques. Read on! Learn Git in a Month of Lunches introduces the discipline of source code control using Git. Helpful for both newbies who have never used source control and busy pros, this book concentrates on the components of Git you'll use every day. In easy-to-follow lessons that take an hour or less, you'll dig into Git's distributed collaboration model, along with core concepts like committing, branching, and merging. This book is a road map to the commands and processes you need to be instantly productive. What's Inside Start from square one—no experience required The most frequently used Git commands Mental models that show how Git works Learn when and how to branch code About the Reader No previous experience with Git or other source control systems is required. About the Author Rick Umali uses Git daily as a developer and is a skilled consultant, trainer, and speaker. Table of Contents Before you begin An overview of Git and version control Getting oriented with Git Making and using a Git repository Using Git with a GUI Tracking and updating files in Git Committing parts of changes The time machine that is Git Taking a fork in the road Merging branches Cloning Collaborating with remotes Pushing your changes Keeping in sync Software archaeology Understanding git rebase Workflows and branching conventions Working with GitHub Third-party tools and Git Sharpening your Git

Beginning Android Tablet Games Programming

Beginning Android Tablet Games Programming
Author: Jeremy Kerfs
Publisher: Apress
Total Pages: 197
Release: 2012-01-13
Genre: Computers
ISBN: 1430238534
GET BOOK

Download Beginning Android Tablet Games Programming Book in PDF, Epub and Kindle

Android games programmers now have the power to write games for Android tablets. Beginning Android Tablet Games Programming explains how to enhance your Android games using the new tablet interface and the additional screen estate. You'll learn how to bring your programming skills up to date and into a world where touch screens, games physics, and artificial intelligence come together in new and surprising ways. Beginning Android Tablet Games Programming shows how to quickly and easily set up an Android development environment—in no time at all, you'll be programming away. You'll begin with some simple games using sprites and choreographed movement. Next, you'll learn how to handle user input in the modern age of touch screens and motion. Along the way, you'll discover how to use that extra screen space on a tablet to provide more relaxed and more interesting user interactions in your games. You'll learn how to use sound and music, for instance, to make your application menus more user-friendly. The Android operating system has recently acquired multicore functionality to meet the demands of multicore devices now entering the tablet market. With Beginning Android Tablet Games Programming, you'll discover how to harness that new power with your games programming through more process-demanding and fun techniques, including physics modeling, rich game world representation, artificial intelligence, and multiplayer interactions. Throughout each chapter of Beginning Android Tablet Games Programming, you'll find code that you can add or adapt to your own games to create the components you want. You can also work up to wrapping everything together into a complete Mario-type example game. Finally, when you have your first games ready, learn how developers have released their games and made a profit. You'll find tips on how to present your games in the Android and other application markets, and a solid approach to games marketing and monetization.

Expert Oracle SQL

Expert Oracle SQL
Author: Tony Hasler
Publisher: Apress
Total Pages: 599
Release: 2014-07-05
Genre: Computers
ISBN: 1430259787
GET BOOK

Download Expert Oracle SQL Book in PDF, Epub and Kindle

Expert Oracle SQL: Optimization, Deployment, and Statistics is about optimizing individual SQL statements, especially on production database systems. This Oracle-specific book begins by assuming you have already identified a particular SQL statement and are considering taking steps to improve its performance. The book describes a systematic process by which to diagnose a problem statement, identify a fix, and to implement that fix safely in a production system. You'll learn not only to improve performance when it is too slow, but also to stabilize performance when it is too variable. You'll learn about system statistics and how the Cost-Based Optimizer uses them to determine a suitable execution plan for a given statement. That knowledge provides the foundation from which to identify the root cause, and to stabilize and improve performance. Next after identifying a problem and the underlying root cause is to put in place a solution. Expert Oracle SQL: Optimization, Deployment, and Statistics explains how to apply various remedies such as changing the SQL statement, adding hints, changing the physical design, and more, and how they can be brought to bear on fixing a problem once and for all. Rolling a change out smoothly is an important topic when dealing with tuning and optimization. Expert Oracle SQL: Optimization, Deployment, and Statistics does not let you down in this critical area. The book contains two chapters of good information from an experienced professional on how to safely deploy changes into production so that your systems remaining running and available throughout the deployment process. Describes a systematic approach to tuning Oracle SQL Explains how things are supposed to work, what can go wrong, and how to fix it Takes you through the steps needed to stabilize performance in your production systems

Drupal 7 Multilingual Sites

Drupal 7 Multilingual Sites
Author: Kristen Pol
Publisher: Packt Publishing Ltd
Total Pages: 185
Release: 2012-01-01
Genre: Computers
ISBN: 184951819X
GET BOOK

Download Drupal 7 Multilingual Sites Book in PDF, Epub and Kindle

A practical book with plenty of screenshots to guide you through the many features of multilingual Drupal. A demo ecommerce site is provided if you want to practice on a sample site, although you can apply the techniques learnt in the book directly to your site too. Any Drupal users who know the basics of building a Drupal site and are familiar with the Drupal UI, will benefit from this book. No previous knowledge of localization or internationalization is required.

Learning PostgreSQL

Learning PostgreSQL
Author: Salahaldin Juba
Publisher: Packt Publishing Ltd
Total Pages: 464
Release: 2015-11-30
Genre: Computers
ISBN: 178398919X
GET BOOK

Download Learning PostgreSQL Book in PDF, Epub and Kindle

Create, develop and manage relational databases in real world applications using PostgreSQL About This Book Learn about the PostgreSQL development life cycle including its testing and refactoring Build productive database solutions and use them in Java applications A comprehensive guide to learn about SQL, PostgreSQL procedural language and PL/pgSQL Who This Book Is For If you are a student, database developer or an administrator, interested in developing and maintaining a PostgreSQL database, then this book is for you. No knowledge of database programming or administration is necessary. What You Will Learn Learn concepts of data modelling and relation algebra Install and set up PostgreSQL database server and client software Implement data structures in PostgreSQL Manipulate data in the database using SQL Implement data processing logic in the database with stored functions, triggers and views Test database solutions and assess the performance Integrate database with Java applications Detailed knowledge of the main PostgreSQL building objects, most used extensions Practice database development life cycle including analysis, modelling, (documentation), testing, bug fixes and refactoring In Detail PostgreSQL is one of the most powerful and easy to use database management systems. It has strong support from the community and is being actively developed with a new release every year. PostgreSQL supports the most advanced features included in SQL standards. Also it provides NoSQL capabilities, and very rich data types and extensions. All that makes PostgreSQL a very attractive solution in various kinds of software systems. The book starts with the introduction of relational databases with PostegreSQL. It then moves on to covering data definition language (DDL) with emphasis on PostgreSQL and common DDL commands supported by ANSI SQL. You will then learn the data manipulation language (DML), and advanced topics like locking and multi version concurrency control (MVCC). This will give you a very robust background to tune and troubleshoot your application. The book then covers the implementation of data models in the database such as creating tables, setting up integrity constraints, building indexes, defining views and other schema objects. Next, it will give you an overview about the NoSQL capabilities of PostgreSQL along with Hstore, XML, Json and arrays. Finally by the end of the book, you'll learn to use the JDBC driver and manipulate data objects in the Hibernate framework. Style and approach An easy-to-follow guide to learn programming build applications with PostgreSQL, and manage a PostgreSQL database instance.

Learn PowerShell in a Month of Lunches, Fourth Edition

Learn PowerShell in a Month of Lunches, Fourth Edition
Author: Travis Plunk
Publisher: Simon and Schuster
Total Pages: 358
Release: 2022-05-31
Genre: Computers
ISBN: 1638350612
GET BOOK

Download Learn PowerShell in a Month of Lunches, Fourth Edition Book in PDF, Epub and Kindle

Designed for busy IT professionals, this innovative guide will take you from the basics to PowerShell proficiency through 25 tutorials you can do in your lunch break. In Learn PowerShell in a Month of Lunches, Fourth Edition you will learn: Discoverability with the Help system Background jobs and automation techniques Simple scripting to automate repetitive tasks Managing cloud services from major cloud providers Extending PowerShell with commands Common syntax and commands cheat sheet Learn PowerShell in a Month of Lunches, Fourth Edition is a task-focused guide for administering your systems using PowerShell. It covers core language features and admin tasks, with each chapter a mini-tutorial you can easily complete in under an hour. Discover how PowerShell works on different operating systems, and start automating tasks so they take just a few seconds to complete. No previous scripting experience required. The book is based on the bestselling Learn Windows PowerShell in a Month of Lunches by community legends Don Jones and Jeffery Hicks. PowerShell team members Travis Plunk and Tyler Leonhardt and Microsoft MVP James Petty have updated this edition to the latest version of PowerShell, including its multi-platform expansion into Linux and macOS. About the technology PowerShell gives you complete command line control over admin tasks like adding users, exporting data, and file management. Whether you’re writing one-liners or building complex scripts to manage cloud resources and CI/CD pipelines, PowerShell can handle the task. And now that PowerShell is truly cross-platform, you don’t have to switch scripting languages when you move between Windows, Linux, and macOS. About the book Learn PowerShell in a Month of Lunches, Fourth Edition is a new edition of the bestseller that introduced PowerShell to over 100,000 readers. With bite-sized lessons and hands-on exercises, this amazing book guides you from your first command to writing and debugging reusable scripts for Windows, Linux, and macOS. Set aside just an hour a day and you’ll soon be tackling increasingly complex automation tasks with PowerShell. What's inside Discoverability with the Help system PowerShell on macOS and Linux Background jobs and automation techniques Managing cloud services from major cloud providers Common syntax and commands cheat sheet About the reader No previous experience with PowerShell or Bash required. About the author James Petty is CEO of PowerShell.org and The DevOps Collective, and a Microsoft MVP. Travis Plunk is an engineer on the PowerShell team. Tyler Leonhardt is an engineer on Visual Studio Code. Don Jones and Jeffery Hicks are the original authors of Learn Windows PowerShell in a Month of Lunches.

PowerShell: Automating Administrative Tasks

PowerShell: Automating Administrative Tasks
Author: Michael Shepard
Publisher: Packt Publishing Ltd
Total Pages: 737
Release: 2017-02-24
Genre: Computers
ISBN: 1787128059
GET BOOK

Download PowerShell: Automating Administrative Tasks Book in PDF, Epub and Kindle

Learn PowerShell from the inside out, right from basic scripting all the way to becoming a master at automating, managing, and maintaining your Windows environment About This Book Use proven best practices to optimize code and automate redundant tasks Get to grips with PowerShell's advanced functions and effectively administer your system Create a variety of PowerShell scripts to automate your environment Who This Book Is For If you are a system administrator who wants to become an expert in automating and managing your Windows environment, then this course is for you. Some basic understanding of PowerShell would be helpful. What You Will Learn Discover PowerShell commands and cmdlets and understand PowerShell formatting Solve common problems using basic file input/output functions Use .NET classes in Windows PowerShell and C# and manage Exchange Online Use PowerShell in C# to manage Exchange Online and work with .NET classes in PowerShell Automate LYNC clients, consuming client-side object models to administrate SharePoint Online Optimize code through the use of functions, switches, and looping structures Manage files, folders, and registries through the use of PowerShell Discover best practices to manage Microsoft systems In Detail Are you tired of managing Windows administrative tasks manually and are looking to automate the entire process? If yes, then this is the right course for you. This learning path starts your PowerShell journey and will help you automate the administration of the Windows operating system and applications that run on Windows. It will get you up and running with PowerShell, taking you from the basics of installation to writing scripts and performing web server automation. You will explore the PowerShell environment and discover how to use cmdlets, functions, and scripts to automate Windows systems. The next installment of the course focuses on gaining concrete knowledge of Windows PowerShell scripting to perform professional-level scripting. The techniques here are packed with PowerShell scripts and sample C# code to automate tasks. You will use .NET classes in PowerShell and C# to manage Exchange Online. In the final section, you will delve into real-world examples to learn how to simplify the management of your Windows environment. You will get to grips with PowerShell's advanced functions and how to most effectively administer your system. This Learning Path combines some of the best that Packt has to offer in one complete, curated package. It includes content from the following Packt products: Getting Started with PowerShell by Michael Shepard Windows PowerShell for .Net Developers Second Edition by Chendrayan Venkatesan and Sherif Talaat Mastering Windows PowerShell Scripting by Brenton J.W. Blawat Style and approach This is a step-by-step course to help you effectively administer and maintain your development environment with PowerShell.

Linux Server Security

Linux Server Security
Author: Chris Binnie
Publisher: John Wiley & Sons
Total Pages: 144
Release: 2016-05-16
Genre: Computers
ISBN: 1119277655
GET BOOK

Download Linux Server Security Book in PDF, Epub and Kindle

Learn how to attack and defend the world’s most popular web server platform Linux Server Security: Hack and Defend presents a detailed guide for experienced admins, aspiring hackers and other IT professionals seeking a more advanced understanding of Linux security. Written by a 20-year veteran of Linux server deployment this book provides the insight of experience along with highly practical instruction. The topics range from the theory of past, current, and future attacks, to the mitigation of a variety of online attacks, all the way to empowering you to perform numerous malicious attacks yourself (in the hope that you will learn how to defend against them). By increasing your understanding of a hacker’s tools and mindset you're less likely to be confronted by the all-too-common reality faced by many admins these days: someone else has control of your systems. Master hacking tools and launch sophisticated attacks: perform SQL injections, deploy multiple server exploits and crack complex passwords. Defend systems and networks: make your servers invisible, be confident of your security with penetration testing and repel unwelcome attackers. Increase your background knowledge of attacks on systems and networks and improve all-important practical skills required to secure any Linux server. The techniques presented apply to almost all Linux distributions including the many Debian and Red Hat derivatives and some other Unix-type systems. Further your career with this intriguing, deeply insightful, must-have technical book. Diverse, broadly-applicable and hands-on practical, Linux Server Security: Hack and Defend is an essential resource which will sit proudly on any techie's bookshelf.