PowerShell for SQL Server Essentials

Author: Donabel Santos

Publisher: Packt Publishing Ltd

ISBN: 1784397105

Category: Computers

Page: 186

View: 8947

DOWNLOAD NOW »

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.
Release

SQL Server 2014 with PowerShell v5 Cookbook

Author: Donabel Santos

Publisher: Packt Publishing Ltd

ISBN: 1785283618

Category: Computers

Page: 760

View: 6629

DOWNLOAD NOW »

Over 150 real-world recipes to simplify database management, automate repetitive tasks, and enhance your productivity About This Book This book helps you build a strong foundation to get you comfortable using PowerShell with SQL Server, empowering you to create more complex scripts for your day-to-day job The book provides numerous guidelines, tips, and explanations on how and when to use PowerShell cmdlets, WMI, SMO, .NET classes, or other components It offers easy-to-follow, practical recipes to help you get the most out of SQL Server and PowerShell Who This Book Is For If you are a SQL Server database professional (DBA, developer, or BI developer) who wants to use PowerShell to automate, integrate, and simplify database tasks, this books is for you. Prior knowledge of scripting would be helpful, but it is not necessary. What You Will Learn Explore database objects and execute queries on multiple servers Manage and monitor the running of SQL Server services and accounts Back up and restore databases Create an inventory of database properties and server configuration settings Maintain permissions and security for users Work with CLR assemblies, XML, and BLOB objects in SQL Manage and deploy SSIS packages and SSRS reports In Detail PowerShell can be leveraged when automating and streamlining SQL Server tasks. PowerShell comes with a rich set of cmdlets, and integrates tightly with the .NET framework. Its scripting capabilities are robust and flexible, allowing you to simplify automation and integration across different Microsoft applications and components. The book starts with an introduction to the new features in SQL Server 2014 and PowerShell v5 and the installation of SQL Server. You will learn about basic SQL Server administration tasks and then get to know about some security-related topics such as the authentication mode and assigning permissions. Moving on, you will explore different methods to back up and restore your databases and perform advanced administration tasks such as working with Policies, Filetables, and SQL audits. The next part of the book covers more advanced HADR tasks such as log shipping and data mirroring, and then shows you how to develop your server to work with BLOB, XML, and JSON. Following on from that, you will learn about SQL Server's BI stack, which includes SSRS reports, the SSIS package, and the SSAS cmdlet and database. Snippets not specific to SQL Server will help you perform tasks quickly on SQL servers. Towards the end of the book, you will find some useful information, which includes a PowerShell tutorial for novice users, some commonly-used PowerShell and SQL Server syntax, and a few online resources. Finally, you will create your own SQL Server Sandbox VMs. All these concepts will help you to efficiently manage your administration tasks. Style and approach SQL Server 2014 with PowerShell v5 Cookbook is an example-focused book that provides step-by-step instructions on how to accomplish specific SQL Server tasks using PowerShell. Each recipe is followed by an analysis of the steps or design decisions taken and additional information about the task at hand. Working scripts are provided for all examples so that you can dive in right away. You can read this book sequentially by chapter or you can pick and choose which topics you need right away.
Release

Tableau 10 Business Intelligence Cookbook

Author: Donabel Santos

Publisher: Packt Publishing Ltd

ISBN: 1786469731

Category: Computers

Page: 476

View: 415

DOWNLOAD NOW »

Create powerful, effective visualizations to help analyze your data with Tableau 10 by your side About This Book Cook your favorite Tableau 10 business intelligence recipe with the help of this easy-to-follow book Build beautiful, interactive dashboards and visualizations in Tableau 10 that help you make informed decisions This rich collection of independent recipes cover everything needed to become an advanced Tableau user and get an edge over other Tableau users Who This Book Is For This book is targeted to business, data, and analytics professionals who want to build rich interactive visualizations using Tableau. Familiarity with previous versions of Tableau would be helpful, but is not necessary. What You Will Learn Become familiar with the Tableau interface Build basic to more advanced charts with step-by-step recipes Use filters, calculated fields, parameters, and actions to add interactivity to charts and dashboards Prepare and transform data for analysis using Tableau's built-in tools and functions Create effective and compelling dashboards and story points Leverage Tableau's mapping capabilities to visualize location and shape data Integrate analytics and forecasting to enhance data analysis Get to know tips and tricks to work more quickly and effectively in Tableau Increase your confidence and competence in creating rich, interactive visualizations in Tableau In Detail Tableau is a software tool that can speed up data analysis through its rich visualization capabilities, and help uncover insights for better and smarter decision making. This book is for the business, technology, data and analytics professionals who use and analyze data and data-driven approaches to support business operations and strategic initiatives in their organizations. This book provides easy-to-follow recipes to get the reader up and running with Tableau 10, and covers basic to advanced use cases and scenarios. The book starts with building basic charts in Tableau and moves on to building more complex charts by incorporating different Tableau features and interactivity components. There is an entire chapter dedicated to dashboard techniques and best practices. A number of recipes specifically for geospatial visualization, analytics, and data preparation are also covered. By the end of this book, you'll have gained confidence and competence to analyze and communicate data and insights more efficiently and effectively by creating compelling interactive charts, dashboards, and stories in Tableau. Style and approach This book is a collection of independent recipes that cover a wide range of options for data visualization on offer with Tableau. With the help of the recipes in this book, you can explore Tableau and pick the business intelligence solution that's best suited for your needs.
Release

Learning PowerShell DSC

Author: James Pogran

Publisher: Packt Publishing Ltd

ISBN: 1787281515

Category: Computers

Page: 272

View: 4652

DOWNLOAD NOW »

A learning guide to get you started with PowerShell DSC. About This Book Create flexible and maintainable deployments using DSC configuration scripts that stand the test of time. Explore the core architecture, concepts, and practices in depth. Learning PowerShell DSC is a step-by-step guide that shows you how to start using and taking advantage of PowerShell DSC along with configuring and deploying applications. Who This Book Is For If you are a system administrator, developer, or engineer and are responsible for configuration management and automation, then this book is for you. IT professionals who wish to learn PowerShell Desired State Configuration for the efficient management, configuration, and deployment of systems will also find this book useful. What You Will Learn Explore PowerShell Desired State Configuration and activities around it, including the need for configuration management and abstraction. Create reusable DSC configurations and debug/ troubleshoot configuration files. Learn about the PowerShell DSC architecture with the help of push-and-pull management and workflows. Define DSC configuration scripts and data files and push DSC configuration files remotely and locally. Validate DSC Pull Server install and register target nodes with a DSC Pull Server. Learn about DSC Cross Platform and install PowerShell on Linux and macOS along with real-life DSC uses and different types of deployment. In Detail The main goal of this book is to teach you to configure, deploy, and manage your system using the new features of PowerShell v5/v6 DSC. This book begins with the basics of PowerShell Desired State Configuration, covering its architecture and components. It familiarizes you with the set of Windows PowerShell language extensions and new Windows PowerShell commands that make up DSC. Then it helps you create DSC custom resources and work with DSC configurations with the help of practical examples. Finally, it describes how to deploy configuration data using PowerShell DSC. Throughout this book, we will be focusing on concepts such as building configurations with parameters, the local configuration manager, and testing and restoring configurations using PowerShell DSC. By the end of the book, you will be able to deploy a real-world application end-to-end and will be familiar enough with the powerful Desired State Configuration platform to achieve continuous delivery and efficiently and easily manage and deploy data for systems. Style and approach The purpose of this book is to introduce readers to the powerful PowerShell Desired State Configuration platform to achieve continuous delivery, efficient management, and the easy deployment of data for systems.
Release

Tableau 10 Bootcamp

Intensive training for data visualization and dashboarding

Author: Joshua N. Milligan,Donabel Santos

Publisher: Packt Publishing Ltd

ISBN: 1787282929

Category: Computers

Page: 384

View: 1775

DOWNLOAD NOW »

Sharpen your data visualization skills with Tableau 10 Bootcamp. About This Book Make informed decisions using powerful visualizations in Tableau Learn effective data storytelling to transform how your business uses ideas Use this extensive bootcamp that makes you an efficient Tableau user in a short span of time Who This Book Is For This book caters to business, data, and analytics professionals who want to build rich interactive visualizations using Tableau Desktop. Familiarity with previous versions of Tableau will be helpful, but not necessary. What You Will Learn Complete practical Tableau tasks with each chapter Build different types of charts in Tableau with ease Extend data using calculated fields and parameters Prepare and refine data for analysis Create engaging and interactive dashboards Present data effectively using story points In Detail Tableau is a leading visual analytics software that can uncover insights for better and smarter decision-making. Tableau has an uncanny ability to beautify your data, compared to other BI tools, which makes it an ideal choice for performing fast and easy visual analysis. A military camp style fast-paced learning book that builds your understanding of Tableau 10 in no time. This day based learning guide contains the best elements from two of our published books, Learning Tableau 10 - Second Edition and Tableau 10 Business Intelligence Cookbook, and delivers practical, learning modules in manageable chunks. Each chunk is delivered in a "day", and each "day" is a productive day. Each day builds your competency in Tableau. You will increase your competence in integrating analytics and forecasting to enhance data analysis during the course of this Bootcamp. Each chapter presents core concepts and key takeaways about a topic in Tableau and provides a series of hands-on exercises. In addition to these exercises, at the end of the chapter, you will find self-check quizzes and extra drills to challenge you, to take what you learned to the next level. To summarize, this book will equip you with step-by-step instructions through rigorous tasks, practical callouts, and various real-world examples and assignments to reinforce your understanding of Tableau 10. Style and approach A fast paced book filled with highly-effective real-world examples to help you build new things and help you in solving problems in newer and unseen ways.
Release

AWS Tools for PowerShell 6

Author: Ramesh Waghmare

Publisher: Packt Publishing Ltd

ISBN: 1785880438

Category: Computers

Page: 372

View: 795

DOWNLOAD NOW »

Leverage the power of PowerShell to bring the best out of your AWS infrastructure About This Book A collection of real-world-tested Powershell scripts that can be used to manage your Windows server efficiently Follow step-by-step processes to solve your problems with Windows servers using AWS tools Design examples that work in the Amazon free usage tier, which lets you run the Windows platform on cloud Who This Book Is For This book will be useful for (but not limited to) Windows System administrators, cloud engineers, architects, DevOps engineers, and all those who want to accomplish tasks on the AWS Public Cloud using PowerShell. What You Will Learn Install the AWS Tools for PowerShell 6 Understand key services provided by Amazon Web services (AWS) Understand the Virtual Private Cloud Use PowerShell 6 for AWS Identity and Access Management (IAM) Use PowerShell 6 for AWS Elastic Compute Cloud (EC2) Use PowerShell 6 for AWS Simple Storage Service (S3) Use PowerShell 6 for AWS Relational Database Service (RDS) Build fault-tolerant and highly-available applications using PowerShell 6 In Detail AWS Tools for PowerShell 6 shows you exactly how to automate all the aspects of AWS. You can take advantage of the amazing power of the cloud, yet add powerful scripts and mechanisms to perform common tasks faster than ever before. This book expands on the Amazon documentation with real-world, useful examples and production-ready scripts to automate all the aspects of your new cloud platform. It will cover topics such as managing Windows with PowerShell, setting up security services, administering database services, and deploying and managing networking. You will also explore advanced topics such as PowerShell authoring techniques, and configuring and managing storage and content delivery. By the end of this book, you will be able to use Amazon Web Services to automate and manage Windows servers. You will also have gained a good understanding of automating the AWS infrastructure using simple coding. Style and approach This step-by-step guide starts with simple examples then expands to full-blown administrative tasks leading to the efficient management of Windows servers. Each topic covers a section related to Amazon Web Services products, and the examples are built on one another to deliver a comprehensive library of scripts for administrators.
Release

Microsoft SQL Server 2012 Administration

Real-World Skills for MCSA Certification and Beyond (Exams 70-461, 70-462, and 70-463)

Author: Tom Carpenter

Publisher: John Wiley & Sons

ISBN: 1118654900

Category: Computers

Page: 936

View: 4829

DOWNLOAD NOW »

Implement, maintain, and repair SQL Server 2012databases As the most significant update since 2008, Microsoft SQL Server2012 boasts updates and new features that are critical tounderstand. Whether you manage and administer SQL Server 2012 orare planning to get your MCSA: SQL Server 2012 certification, thisbook is the perfect supplement to your learning and preparation.From understanding SQL Server's roles to implementing businessintelligence and reporting, this practical book explores tasks andscenarios that a working SQL Server DBA faces regularly and showsyou step by step how to handle them. Includes practice exams and coverage of exam objectives forthose seeking MSCA: SQL Server 2012 certification Explores the skills you'll need on the job as a SQL Server 2012DBA Discusses designing and implementing database solutions Walks you through administrating, maintaining, and securing SQLServer 2012 Addresses implementing high availability and datadistribution Includes bonus videos where the author walks you through someof the more difficult tasks expected of a DBA Featuring hands-on exercises and real-world scenarios, thisresource guides you through the essentials of implementing,maintaining, and repairing SQL Server 2012 databases.
Release

Microsoft Windows Server Administration Essentials

Author: Tom Carpenter

Publisher: John Wiley & Sons

ISBN: 111814869X

Category: Computers

Page: 400

View: 3587

DOWNLOAD NOW »

The core concepts and technologies you need to administer aWindows Server OS Administering a Windows operating system (OS) can be a difficulttopic to grasp, particularly if you are new to the field of IT.This full-color resource serves as an approachable introduction tounderstanding how to install a server, the various roles of aserver, and how server performance and maintenance impacts anetwork. With a special focus placed on the new Microsoft TechnologyAssociate (MTA) certificate, the straightforward,easy-to-understand tone is ideal for anyone new to computeradministration looking to enter the IT field. Each chapter offers aclear and concise look at the core Windows administration conceptsyou need to know to gain an understanding of these difficulttopics. Offers a clear, no-nonsense approach to administering a Windowsoperating system and presents it in such a way that IT beginnerswill confidently comprehend the subject matter Targets the MTA 98-365 exam by covering Windows Serverinstallation, server roles, storage, and active directoryinfrastructure Provides you with a solid foundation of various networkingtopics so that you can gain a strong understanding of WindowsServer administration concepts Includes review questions and suggested labs to further enhanceyour learning process With this book by your side, you will be armed with the coreconcepts and technologies needed to administer a Windows Serveroperating system.
Release

HDInsight Essentials - Second Edition

Author: Rajesh Nadipalli

Publisher: Packt Publishing Ltd

ISBN: 1784396664

Category: Computers

Page: 178

View: 2757

DOWNLOAD NOW »

If you want to discover one of the latest tools designed to produce stunning Big Data insights, this book features everything you need to get to grips with your data. Whether you are a data architect, developer, or a business strategist, HDInsight adds value in everything from development, administration, and reporting.
Release

Microsoft Azure Essentials - Fundamentals of Azure

Author: Michael Collier,Robin Shahan

Publisher: Microsoft Press

ISBN: 0735697302

Category: Computers

Page: 246

View: 9559

DOWNLOAD NOW »

Microsoft Azure Essentials from Microsoft Press is a series of free ebooks designed to help you advance your technical skills with Microsoft Azure. The first ebook in the series, Microsoft Azure Essentials: Fundamentals of Azure, introduces developers and IT professionals to the wide range of capabilities in Azure. The authors - both Microsoft MVPs in Azure - present both conceptual and how-to content for key areas, including: Azure Websites and Azure Cloud Services Azure Virtual Machines Azure Storage Azure Virtual Networks Databases Azure Active Directory Management tools Business scenarios Watch Microsoft Press’s blog and Twitter (@MicrosoftPress) to learn about other free ebooks in the “Microsoft Azure Essentials” series.
Release