SQL Server 2014 with PowerShell v5 Cookbook
SQL Server 2014 with PowerShell v5 Cookbook

Author: Donabel Santos

Publisher: Packt Publishing Ltd

Published: 2015-12-04

Total Pages: 760

ISBN-13: 1785283618

DOWNLOAD EBOOK

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.

Tableau 10 Business Intelligence Cookbook
Tableau 10 Business Intelligence Cookbook

Author: Donabel Santos

Publisher: Packt Publishing Ltd

Published: 2016-11-30

Total Pages: 476

ISBN-13: 1786469731

DOWNLOAD EBOOK

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.

Lync Server Cookbook
Lync Server Cookbook

Author: Fabrizio Volpe

Publisher: Packt Publishing Ltd

Published: 2015-01-27

Total Pages: 392

ISBN-13: 178217348X

DOWNLOAD EBOOK

If you work with Lync on a daily basis or if you have to use a specific feature of Lync for a project, this is the book for you. For solutions architects, technical consultants, and administrators, if you have a Lync deployment and you want to upgrade, integrate, secure, or extend it to the cloud, you can get valuable information from the recipes in this book.

Microsoft Application Virtualization Cookbook
Microsoft Application Virtualization Cookbook

Author: James Preston

Publisher: Packt Publishing Ltd

Published: 2015-08-17

Total Pages: 218

ISBN-13: 1785283502

DOWNLOAD EBOOK

Over 55 hands-on recipes covering the key aspects of a successful App-V deployment About This Book Deploy a resilient App-V infrastructure Combine App-V with Remote Desktop Services, Citrix XenDesktop, and System Center Configuration Manager Discover Shared Content Store Mode, Scripting, and Connection Groups to extend your deployment Who This Book Is For If you have some experience with App-V but are overwhelmed by the range of features on offer, then this book is for you. A basic understanding of App-V and common Windows Server technologies (Active Directory/Group Policy/PowerShell) is necessary. What You Will Learn Deploy a full App-V infrastructure Deploy App-V clients and prerequisites Leverage connection groups to combine App-V packages Reduce hardware requirements for your Remote Desktop Session Hosts Extend the use of your investments in Microsoft System Center Configuration Manager Discover which applications your users are running Resolve issues with your deployment quickly Customize App-V packages to your needs Scale out your App-V infrastructure to accommodate increasing requirements In Detail With an ever-increasing number of applications being deployed in the workplace, Microsoft App-V 5 enables administrators to abstract these applications from clients, in turn reducing the time taken to complete the software deployment lifecycle. Part of the Microsoft Desktop Optimization Pack, App-V 5 centralizes the management of applications with a variety of deployment methods to suit each environment. With this hands-on Cookbook, you will learn how best to utilize features of App-V that you may already be familiar with, as well as gain insights into features only recently introduced such as the enhanced Connection Groups and Shared Content Store Mode. The book starts with the deployment of a scalable App-V infrastructure and progresses to cover the sequencing of common applications, as well as how you can take advantage of the new Office 2013 and Office 365 deployment methods. In later chapters, you will discover integrations with Microsoft Remote Desktop Services, Citrix XenDesktop, and Microsoft System Centre Configuration Manager. Finally, you will learn to leverage the App-V reporting server, Microsoft Excel, and pivot tables to gain insights into which applications are being used, along with how to troubleshoot issues with your deployment. Style and approach A practical Cookbook full of task-based recipes, complete with screenshots and explanations to supplement.

VMware vSphere 5.x Datacenter Design Cookbook
VMware vSphere 5.x Datacenter Design Cookbook

Author: Hersey Cartwright

Publisher: Packt Publishing Ltd

Published: 2014-01-24

Total Pages: 401

ISBN-13: 1782177019

DOWNLOAD EBOOK

A practical guide packed with step-by-step recipes to design a virtual datacenter using VMware 5.x. This book is a guide for anyone interested in designing virtualized datacenters using VMware vSphere 5.x and the supporting components. Current administrators of VMware vSphere environments will find this book useful when interested in becoming a vSphere Architect or are interested in learning more about the virtual datacenter design process. Knowledge of vSphere installation, configuration, and administration is a prerequisite.

SQL Server 2012 with PowerShell V3 Cookbook
SQL Server 2012 with PowerShell V3 Cookbook

Author: Donabel Santos

Publisher: Packt Pub Limited

Published: 2012

Total Pages: 634

ISBN-13: 9781849686464

DOWNLOAD EBOOK

SQL Server 2012 with PowerShell V3 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,This book is written for the SQL Server database professional (DBA, developer, BI developer) who wants to use PowerShell to automate, integrate, and simplify database tasks. A little bit of scripting background is helpful, but not necessary.

Microsoft Team Foundation Server 2015 Cookbook
Microsoft Team Foundation Server 2015 Cookbook

Author: Tarun Arora

Publisher: Packt Publishing Ltd

Published: 2016-01-30

Total Pages: 340

ISBN-13: 1784396966

DOWNLOAD EBOOK

Over 80 hands-on DevOps and ALM-focused recipes for Scrum Teams to enable the Continuous Delivery of high-quality Software... Faster! About This Book Release high quality, reliable software quickly through building, testing, and deployment automation Improve the predictability, reliability, and availability of TFS in your organization by scheduling administration and maintenance activities Extend, customize, and integrate tools with TFS, enabling your teams to manage their application lifecycles effectively Who This Book Is For This book is aimed at software professionals including Developers, Testers, Architects, Configuration Analysts, and Release Managers who want to understand the capabilities of TFS to deliver better quality software faster. A working setup of TFS 2015 and some familiarity with the concepts of software life cycle management is assumed. What You Will Learn Creating a Team Project with Dashboards, Assigning License, Adding users, and Auditing Access Setting up a Git repository in an existing TFVC-based Team Project Setting up branch policies and conducting Pull requests with code reviews Mapping, assigning and tracking work items shared by multiple teams Setting up and customizing Backlogs, Kanban board, Sprint Taskboard, and dashboards Creating a Continuous Integration, Continuous Build, and Release Pipeline Integrating SonarQube with TFBuild to manage Technical Debt Triggering Selenium Web Tests on a Selenium Test Grid using TFBuild Using Visual Studio Team Services Cloud load testing capability with new Build framework Extending and customizing the capabilities of Team Foundation Server using API and Process Editor In Detail Team Foundation Server (TFS) allows you to manage code repositories, build processes, test infrastructure, and deploy labs. TFS supports your team, enabling you to connect, collaborate, and deliver on time. Microsoft's approach to Application Lifecycle Management (ALM) provides a flexible and agile environment that adapts to the needs of your team, removes barriers between roles, and streamlines processes. The book introduces you to creating and setting up team projects for scrum teams. You'll explore various source control repositories, branching, and merging activities, along with a demonstration of how to embed quality into every code check-in. Then, you'll discover agile project planning and management tools. Later, emphasis is given to the testing and release management features of TFS which facilitate the automation of the release pipeline in order to create potentially shippable increments. By the end of the book, you'll have learned to extend and customize TFS plugins to incorporate them into other platforms and enable teams to manage the software lifecycle effectively. Style and approach This book is a recipe-based guide that uses a problem-solution format to call out inefficiencies in the software development lifecycle and then guides you, step-by-step, on how you can use Team Foundation Server to your advantage in those areas.

System Center 2012 R2 Virtual Machine Manager Cookbook
System Center 2012 R2 Virtual Machine Manager Cookbook

Author: Edvaldo Alessandro Cardoso

Publisher: Packt Publishing Ltd

Published: 2014-06-25

Total Pages: 640

ISBN-13: 1782176853

DOWNLOAD EBOOK

This book is a step-by-step guide packed with recipes that cover architecture design and planning. The book is also full of deployment tips, techniques, and solutions. If you are a solutions architect, technical consultant, administrator, or any other virtualization enthusiast who needs to use Microsoft System Center Virtual Machine Manager in a real-world environment, then this is the book for you. We assume that you have previous experience with Windows 2012 R2 and Hyper-V.

Hyper-V Network Virtualization Cookbook
Hyper-V Network Virtualization Cookbook

Author: Ryan Boud

Publisher: Packt Publishing Ltd

Published: 2014-11-28

Total Pages: 308

ISBN-13: 1782177817

DOWNLOAD EBOOK

If you are a virtualization architect, engineer, or administrator who wants to leverage Hyper-V to create virtual networks (virtual data centers), this is the book for you. Prior knowledge of Hyper-V or a similar solution and a good understanding of the end goals of creating a virtual network is required.

Microsoft Windows Server AppFabric Cookbook
Microsoft Windows Server AppFabric Cookbook

Author: Hammad Rajjoub

Publisher: Packt Publishing Ltd

Published: 2012-07-26

Total Pages: 587

ISBN-13: 1849684197

DOWNLOAD EBOOK

Over 60 recipes for getting the most out of WCF/WF services on the Microsoft Windows Platform using Windows Server AppFabric with this book and ebook.