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: Chrissy LeMaire
Publisher: Simon and Schuster
ISBN: 1617296708
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! 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.

Author: Travis Plunk
Publisher: Simon and Schuster
ISBN: 1638350612
Category : Computers
Languages : en
Pages : 358

View

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

Author: Kristen Pol
Publisher: Packt Publishing Ltd
ISBN: 184951819X
Category : Computers
Languages : en
Pages : 185

View

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

Author: James Petty
Publisher: Simon and Schuster
ISBN: 1638354820
Category : Computers
Languages : en
Pages : 334

View

Book Description
Automate complex tasks and processes with PowerShell scripts. This amazing book teaches you how to write, test, and organize high-quality, reusable scripts for Windows, Linux, and cloud-based systems. Learn PowerShell Scripting in a Month of Lunches, Second Edition takes you beyond command-line PowerShell and opens up the amazing world of scripting and automation. In just 27 bite-sized lessons, you’ll learn to write scripts that can eliminate repetitive manual tasks, create custom reusable tools, and build effective pipelines and workflows. In Learn PowerShell Scripting in a Month of Lunches, Second Edition you’ll learn: Setting up a reliable scripting environment Designing functions and scripts Effective pipeline usage Scripting and security Dealing with errors and bugs Source control with git Sharing and publishing scripts Professional-grade scripting practices The PowerShell language lets you write scripts to control nearly every aspect of Windows. Just master a few straightforward scripting skills, and you'll save yourself from hours of tedious tasks. This revised second edition is fully updated to PowerShell’s latest version, including hands-on examples that perfectly demonstrate modern PowerShell’s cross-platform applications. About the technology You can write PowerShell scripts to automate nearly any admin task on Windows, Linux, and macOS. This book shows you how! In just 27 short lessons you can complete on your lunch break, you’ll learn to create, organize, test, and share scripts and tools that will save you hours of time in your daily work. About the book Learn PowerShell Scripting in a Month of Lunches, Second Edition is a hands-on introduction to PowerShell automation and toolbuilding. Updated for the latest version of PowerShell, this thoroughly revised bestseller teaches you how to write efficient scripts, find and squash bugs, and organize your tools into libraries. Along the way, you’ll even pick up tips for securing and managing Linux and macOS systems. What's inside Setting up a reliable scripting environment Designing functions and scripts Effective pipeline usage Sharing and publishing scripts About the reader Beginning to intermediate knowledge of PowerShell required. About the author James Petty is CEO of PowerShell.org and The DevOps Collective and a Microsoft MVP. Don Jones and Jeffery Hicks are the authors of the first edition of Learn PowerShell Scripting in a Month of Lunches. Table of Contents PART 1 1 Before you begin 2 Setting up your scripting environment 3 WWPD: What would PowerShell do? 4 Review: Parameter binding and the PowerShell pipeline 5 Scripting language: A crash course 6 The many forms of scripting (and which to choose) 7 Scripts and security PART 2 8 Always design first 9 Avoiding bugs: Start with a command 10 Building a basic function and script module 11 Getting started with advanced functions 12 Objects: The best kind of output 13 Using all the streams 14 Simple help: Making a comment 15 Errors and how to deal with them 16 Filling out a manifest PART 3 17 Changing your brain when it comes to scripting 18 Professional-grade scripting 19 An introduction to source control with Git 20 Pestering your script 21 Signing your script 22 Publishing your script PART 4 23 Squashing bugs 24 Enhancing script output presentation 25 Wrapping up the .NET Framework 26 Storing data—not in Excel! 27 Never the end

Author: Chris Binnie
Publisher: John Wiley & Sons
ISBN: 1119277655
Category : Computers
Languages : en
Pages : 144

View

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

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: Bastian Gruber
Publisher: Simon and Schuster
ISBN: 1638351821
Category : Computers
Languages : en
Pages : 398

View

Book Description
Create bulletproof, high-performance web apps and servers with Rust. In Rust Web Development you will learn: Handling the borrow checker in an asynchronous environment Learning the ingredients of an asynchronous Rust stack Creating web APIs and using JSON in Rust Graceful error handling Testing, tracing, logging, and debugging Deploying Rust applications Efficient database access Rust Web Development is a pragmatic, hands-on guide to creating server-based web applications with Rust. If you’ve designed web servers using Java, NodeJS, or PHP, you’ll instantly fall in love with the performance and development experience Rust delivers. Hit the ground running! Author Bastian Gruber’s sage advice makes it easy to start tackling complex problems with Rust. You’ll learn how to work efficiently using pure Rust, along with important Rust libraries such as tokio for async runtimes, warp for web servers and APIs, and reqwest to run external HTTP requests. About the technology If you’re sick of cookie-cutter web development tools that are slow, resource hungry, and unstable, Rust is the solution. Rust services deliver rock-solid safety guarantees, an amazing developer experience, and even a compiler that automatically prevents common mistakes! About the book Rust Web Development, teaches you to build server-side web apps using Rust, along with important Rust libraries like tokio for async runtimes, warp for web servers and APIs, and reqwest to run external HTTP requests. The book is packed full of examples, code samples, and pro tips for setting up your projects and organizing your code. As you go, you’ll build a complete Q&A web service and iterate on your code chapter-by-chapter, just like a real development project. What's inside Handle the borrow checker in an asynchronous environment Build web APIs and handle JSON Compose a tech stack for asynchronous Rust development Handle errors gracefully Test, trace, log, and debug Deploy Rust applications to multiple environments About the reader This book is for web developers familiar with Java, Node, or Go, and the absolute basics of Rust. About the author Bastian Gruber was part of the official Rust Async Working Group, and founded the Rust and Tell Berlin MeetUp group. Table of Contents PART 1 INTRODUCTION TO RUST 1 Why Rust? 2 Laying the foundation PART 2 GETTING STARTED 3 Create your first route handler 4 Implement a RESTful API 5 Clean up your codebase 6 Logging, tracing, and debugging 7 Add a database to your application 8 Integrate third-party APIs PART 3 BRING IT INTO PRODUCTION 9 Add authentication and authorization 10 Deploy your application 11 Testing your Rust application

Author: Felienne Hermans
Publisher: Simon and Schuster
ISBN: 163835605X
Category : Computers
Languages : en
Pages : 254

View

Book Description
"A great book with deep insights into the bridge between programming and the human mind." - Mike Taylor, CGI Your brain responds in a predictable way when it encounters new or difficult tasks. This unique book teaches you concrete techniques rooted in cognitive science that will improve the way you learn and think about code. In The Programmer’s Brain: What every programmer needs to know about cognition you will learn: Fast and effective ways to master new programming languages Speed reading skills to quickly comprehend new code Techniques to unravel the meaning of complex code Ways to learn new syntax and keep it memorized Writing code that is easy for others to read Picking the right names for your variables Making your codebase more understandable to newcomers Onboarding new developers to your team Learn how to optimize your brain’s natural cognitive processes to read code more easily, write code faster, and pick up new languages in much less time. This book will help you through the confusion you feel when faced with strange and complex code, and explain a codebase in ways that can make a new team member productive in days! Foreword by Jon Skeet. About the technology Take advantage of your brain’s natural processes to be a better programmer. Techniques based in cognitive science make it possible to learn new languages faster, improve productivity, reduce the need for code rewrites, and more. This unique book will help you achieve these gains. About the book The Programmer’s Brain unlocks the way we think about code. It offers scientifically sound techniques that can radically improve the way you master new technology, comprehend code, and memorize syntax. You’ll learn how to benefit from productive struggle and turn confusion into a learning tool. Along the way, you’ll discover how to create study resources as you become an expert at teaching yourself and bringing new colleagues up to speed. What's inside Understand how your brain sees code Speed reading skills to learn code quickly Techniques to unravel complex code Tips for making codebases understandable About the reader For programmers who have experience working in more than one language. About the author Dr. Felienne Hermans is an associate professor at Leiden University in the Netherlands. She has spent the last decade researching programming, how to learn and how to teach it. Table of Contents PART 1 ON READING CODE BETTER 1 Decoding your confusion while coding 2 Speed reading for code 3 How to learn programming syntax quickly 4 How to read complex code PART 2 ON THINKING ABOUT CODE 5 Reaching a deeper understanding of code 6 Getting better at solving programming problems 7 Misconceptions: Bugs in thinking PART 3 ON WRITING BETTER CODE 8 How to get better at naming things 9 Avoiding bad code and cognitive load: Two frameworks 10 Getting better at solving complex problems PART 4 ON COLLABORATING ON CODE 11 The act of writing code 12 Designing and improving larger systems 13 How to onboard new developers

Author: Carl S. Gold
Publisher: Manning
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