Learn SQL Server Administration in a Month of Lunches PDF Download

Author: Don Jones
Publisher: Simon and Schuster
ISBN: 1638353166
Category : Computers
Languages : en
Pages : 390

View

Book Description
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: Don Jones
Publisher: Manning
ISBN: 9781617295096
Category : Computers
Languages : en
Pages : 0

View

Book Description
Summary Discover how scripting is different from command-line PowerShell, as you explore concrete hands-on examples in this handy guide. The book includes and expands on many of the techniques presented in Learn PowerShell Toolmaking in a Month of Lunches. Purchase of the print book includes a free eBook in PDF, Kindle, and ePub formats from Manning Publications. About the Technology Automate it! With Microsoft's PowerShell language, you can write scripts to control nearly every aspect of Windows. Just master a few straightforward scripting skills, and you'll be able to eliminate repetitive manual tasks, create custom reusable tools, and build effective pipelines and workflows. Once you start scripting in PowerShell, you'll be amazed at how many opportunities you'll find to save time and effort. About the Book Learn PowerShell Scripting in a Month of Lunches teaches you how to expand your command-line PowerShell skills into effective scripts and tools. In 27 bite-size lessons, you'll discover instantly useful techniques for writing efficient code, finding and squashing bugs, organizing your scripts into libraries, and much more. Advanced scripters will even learn to access the .NET Framework, store data long term, and create nice user interfaces. What's Inside Designing functions and scripts Effective pipeline usage Dealing with errors and bugs Professional-grade scripting practices About the Reader Written for devs and IT pros comfortable with PowerShell and Windows. About the Authors Don Jones is a PowerShell MVP, speaker, and trainer who has written dozens of books on information technology topics. Jeffery Hicks is a PowerShell MVP and an independent consultant, trainer, and author. Don and Jeff coauthored Manning's Learn Windows PowerShell in a Month of Lunches, Learn PowerShell Toolmaking in a Month of Lunches, and PowerShell in Depth. Table of Contents PART 1 - INTRODUCTION TO SCRIPTING Before you begin Setting up your scripting environment WWPD: what would PowerShell do? Review: parameter binding and the PowerShell pipeline Scripting language crash course The many forms of scripting (and which to use) Scripts and security PART 2 - BUILDING A POWERSHELL SCRIPT Always design first Avoiding bugs: start with a command Building a basic function and script module Going advanced with your function Objects: the best kind of output Using all the pipelines Simple help: making a comment Dealing with errors Filling out a manifest PART 3 - GROWN-UP SCRIPTING Changing your brain when it comes to scripting Professional-grade scripting An introduction to source control with git Pestering your script Signing your script Publishing your script PART 4 - ADVANCED TECHNIQUES Squashing bugs Making script output prettier Wrapping up the .NET Framework Storing data-not in Excel! Never the end

Author: Chrissy LeMaire
Publisher: Simon and Schuster
ISBN: 1638351260
Category : Computers
Languages : en
Pages : 398

View

Book Description
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

Author: Rick Umali
Publisher: Simon and Schuster
ISBN: 1638353492
Category : Computers
Languages : en
Pages : 596

View

Book Description
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

Author: Bruce Payette
Publisher: Manning Publications
ISBN: 9781935182139
Category : Microsoft Windows (Computer file)
Languages : en
Pages : 0

View

Book Description
A guide to using Windows PowerShell to script Windows administrative tasks and control Windows from the command line.

Author: Donabel Santos
Publisher: Packt Publishing Ltd
ISBN: 1784397105
Category : Computers
Languages : en
Pages : 186

View

Book Description
This book is written for SQL Server administrators and developers who want to leverage PowerShell to work with SQL Server. Some background with scripting will be helpful but not necessary.

Author: Jacques Chester
Publisher: Simon and Schuster
ISBN: 1617296643
Category : Computers
Languages : en
Pages : 270

View

Book Description
Take the pain out of managing serverless applications. Knative, a collection of Kubernetes extensions curated by Google, simplifies building and running serverless systems. Knative in Action guides you through the Knative toolkit, showing you how to launch, modify, and monitor event-based apps built using cloud-hosted functions like AWS Lambda. You''ll learn how to use Knative Serving to develop software that is easily deployed and autoscaled, how to use Knative Eventing to wire together disparate systems into a consistent whole, and how to integrate Knative into your shipping pipeline. about the technology With Knative, managing a serverless application''s full lifecycle is a snap. Knative builds on Kubernetes orchestration features, making it easy to deploy and run serverless apps. It handles low-level chores--such as starting and stopping instances--so you can concentrate on features and behavior. about the book Knative in Action teaches you to build complex and efficient serverless applications. You''ll dive into Knative''s unique design principles and grasp cloud native concepts like handling latency-sensitive workloads. You''ll deliver updates with Knative Serving and interlink apps, services, and systems with Knative Eventing. To keep you moving forward, every example includes deployment advice and tips for debugging. what''s inside Deploy a service with Knative Serving Connect systems with Knative Eventing Autoscale responses for different traffic surges Develop, ship, and operate software about the reader For software developers comfortable with CLI tools and an OO language like Java or Go. about the author Jacques Chester has worked in Pivotal and VMWare R&D since 2014, contributing to Knative and other projects.

Author: Elton Stoneman
Publisher: Manning Publications
ISBN: 1617297054
Category : Computers
Languages : en
Pages : 462

View

Book Description
Summary Go from zero to production readiness with Docker in 22 bite-sized lessons! Learn Docker in a Month of Lunches is an accessible task-focused guide to Docker on Linux, Windows, or Mac systems. In it, you’ll learn practical Docker skills to help you tackle the challenges of modern IT, from cloud migration and microservices to handling legacy systems. There’s no excessive theory or niche-use cases—just a quick-and-easy guide to the essentials of Docker you’ll use every day. Purchase of the print book includes a free eBook in PDF, Kindle, and ePub formats from Manning Publications. About the technology The idea behind Docker is simple: package applica­tions in lightweight virtual containers that can be easily installed. The results of this simple idea are huge! Docker makes it possible to manage applications without creating custom infrastructures. Free, open source, and battle-tested, Docker has quickly become must-know technology for developers and administrators. About the book Learn Docker in a Month of Lunches introduces Docker concepts through a series of brief hands-on lessons. Follow­ing a learning path perfected by author Elton Stoneman, you’ll run containers by chapter 2 and package applications by chapter 3. Each lesson teaches a practical skill you can practice on Windows, macOS, and Linux systems. By the end of the month you’ll know how to containerize and run any kind of application with Docker. What's inside Package applications to run in containers Put containers into production Build optimized Docker images Run containerized apps at scale About the reader For IT professionals. No previous Docker experience required. About the author Elton Stoneman is a consultant, a former architect at Docker, a Microsoft MVP, and a Pluralsight author. Table of Contents PART 1 - UNDERSTANDING DOCKER CONTAINERS AND IMAGES 1. Before you begin 2. Understanding Docker and running Hello World 3. Building your own Docker images 4. Packaging applications from source code into Docker Images 5. Sharing images with Docker Hub and other registries 6. Using Docker volumes for persistent storage PART 2 - RUNNING DISTRIBUTED APPLICATIONS IN CONTAINERS 7. Running multi-container apps with Docker Compose 8. Supporting reliability with health checks and dependency checks 9. Adding observability with containerized monitoring 10. Running multiple environments with Docker Compose 11. Building and testing applications with Docker and Docker Compose PART 3 - RUNNING AT SCALE WITH A CONTAINER ORCHESTRATOR 12. Understanding orchestration: Docker Swarm and Kubernetes 13. Deploying distributed applications as stacks in Docker Swarm 14. Automating releases with upgrades and rollbacks 15. Configuring Docker for secure remote access and CI/CD 16. Building Docker images that run anywhere: Linux, Windows, Intel, and Arm PART 4 - GETTING YOUR CONTAINERS READY FOR PRODUCTION 17. Optimizing your Docker images for size, speed, and security 18. Application configuration management in containers 19. Writing and managing application logs with Docker 20. Controlling HTTP traffic to containers with a reverse proxy 21. Asynchronous communication with a message queue 22. Never the end

Author: Carl S. Gold
Publisher: Manning Publications
ISBN: 161729652X
Category : Computers
Languages : en
Pages : 502

View

Book Description
The beating heart of any product or service business is returning clients. Don't let your hard-won customers vanish, taking their money with them. In Fighting Churn with Data you'll learn powerful data-driven techniques to maximize customer retention and minimize actions that cause them to stop engaging or unsubscribe altogether. Summary The beating heart of any product or service business is returning clients. Don't let your hard-won customers vanish, taking their money with them. In Fighting Churn with Data you'll learn powerful data-driven techniques to maximize customer retention and minimize actions that cause them to stop engaging or unsubscribe altogether. This hands-on guide is packed with techniques for converting raw data into measurable metrics, testing hypotheses, and presenting findings that are easily understandable to non-technical decision makers. Purchase of the print book includes a free eBook in PDF, Kindle, and ePub formats from Manning Publications. About the technology Keeping customers active and engaged is essential for any business that relies on recurring revenue and repeat sales. Customer turnover—or “churn”—is costly, frustrating, and preventable. By applying the techniques in this book, you can identify the warning signs of churn and learn to catch customers before they leave. About the book Fighting Churn with Data teaches developers and data scientists proven techniques for stopping churn before it happens. Packed with real-world use cases and examples, this book teaches you to convert raw data into measurable behavior metrics, calculate customer lifetime value, and improve churn forecasting with demographic data. By following Zuora Chief Data Scientist Carl Gold’s methods, you’ll reap the benefits of high customer retention. What's inside Calculating churn metrics Identifying user behavior that predicts churn Using churn reduction tactics with customer segmentation Applying churn analysis techniques to other business areas Using AI for accurate churn forecasting About the reader For readers with basic data analysis skills, including Python and SQL. About the author Carl Gold (PhD) is the Chief Data Scientist at Zuora, Inc., the industry-leading subscription management platform. Table of Contents: PART 1 - BUILDING YOUR ARSENAL 1 The world of churn 2 Measuring churn 3 Measuring customers 4 Observing renewal and churn PART 2 - WAGING THE WAR 5 Understanding churn and behavior with metrics 6 Relationships between customer behaviors 7 Segmenting customers with advanced metrics PART 3 - SPECIAL WEAPONS AND TACTICS 8 Forecasting churn 9 Forecast accuracy and machine learning 10 Churn demographics and firmographics 11 Leading the fight against churn

Author: Matthew Dowst
Publisher: Simon and Schuster
ISBN: 1638351899
Category : Computers
Languages : en
Pages : 414

View

Book Description
Take PowerShell beyond simple scripts and build time-saving automations for your team, your users, and the world. In Practical Automation with PowerShell you will learn how to: Build PowerShell functions to automate common and complex tasks Create smart automations that are adaptable to new challenges Structure your code for sharing and reusability Store and secure your automations Execute automations with Azure Automation, Jenkins, Task Scheduler, and Cron Share your automations with your team and non-technical colleagues Store and retrieve data, credentials, and variables Use source control solutions to maintain and test code changes Provide front-end UI solutions for PowerShell automations Practical Automation in PowerShell reveals how you can use PowerShell to build automation solutions for a huge number of common admin and DevOps tasks. Author Matthew Dowst uses his decades of experience to lay out a real blueprint for setting up an enterprise scripting environment with PowerShell. The book goes beyond the basics to show you how to handle the unforeseen complexities that can keep automations from becoming reusable and resilient. From the console to the cloud, you'll learn how to manage your code, avoid common pitfalls, and create sharable automations that are adaptable to different use cases. About the Technology The PowerShell scripting language is a force multiplier, giving you programmatic control over your whole data center. With this powerful tool, you can create reusable automations that radically improve consistency and productivity on your Ops team. This book shows you how to design, write, organize, and deploy scripts to automate operations on systems of all sizes, from local servers to enterprise clusters in the cloud. About the Book Practical Automation with PowerShell: Effective scripting from the console to the cloud shows you how to build PowerShell automations for local and cloud systems. In it, you’ll find tips for identifying automatable tasks, techniques for structuring and managing scripts, and lots of well-explained example code. You’ll even learn how to adapt existing scripts to new use cases and empower non-technical users through easy-to-understand SharePoint frontends. What’s Inside Structure PowerShell code for sharing and reusability Store and secure your automations Execute automation with Azure Automation, Jenkins, Task Scheduler, and Cron Store and retrieve data, credentials, and variables Use source control solutions to maintain and test code changes About the Reader For sysadmin and IT professionals who manage backend systems. About the Author Matthew Dowst has over 15 years of experience in IT management and consulting. Table of contents PART 1 1 PowerShell automation 2 Get started automating PART 2 3 Scheduling automation scripts 4 Handling sensitive data 5 PowerShell remote execution 6 Making adaptable automations 7 Working with SQL 8 Cloud-based automation 9 Working outside of PowerShell 10 Automation coding best practices PART 3 11 End-user scripts and forms 12 Sharing scripts among a team 13 Testing your scripts 14 Maintaining your code