||XML and JSON Recipes for SQL Server|
Quickly find solutions to dozens of common problems encountered while using XML and JSON features that are built into SQL Server. Content is presented in the popular problem-solution format. Look up the problem that you want to solve. Read the solution. Apply the solution directly in your own code. Problem solved!
This book shows how to take advantage of XML and JSON to share data and automate tasks. JSON is commonly used to move data back and forth between the database and front-end applications, often running in a browser. This book shows all you need to know about transforming query results into JSON format, and back again. Also covered are the processes and techniques for moving data into and out of XML format for business intelligence and other purposes, such as when transferring data from a reporting system into a data warehouse, or between different database brands such as between SQL Server and Oracle.
Microsoft intensively implements XML in SQL Server and i ...
||Node.js 8 the Right Way|
||Learning Node, 2nd Edition|
||Pro SQL Server Internals, 2nd Edition|
Improve your ability to develop, manage, and troubleshoot SQL Server solutions by learning how different components work "under the hood", and how they communicate with each other. The detailed knowledge helps in implementing and maintaining high-throughput databases critical to your business and its customers. You'll learn how to identify the root cause of each problem and understand how different design and implementation decisions affect performance of your systems.
New in this second edition is coverage of SQL Server 2016 Internals, including In-Memory OLTP, columnstore enhancements, Operational Analytics support, Query Store, JSON, temporal tables, stretch databases, security features, and other improvements in the new SQL Server version. The knowledge also can be applied to Microsoft Azure SQL Databases that share the same code with SQL Server 2016.
Pro SQL Server Internals is a book for developers and database administrators, an ...
||Mastering Ubuntu Server|
Ubuntu is a Debian-based Linux operating system, and has various versions targeted at servers, desktops, phones, tablets and televisions. The Ubuntu Server Edition, also called Ubuntu Server offers support for several common configurations, and also simplifies common Linux server deployment processes.
With this book as their guide, readers will be able to configure and deploy Ubuntu Servers using Ubuntu Server 16.04, with all the skills necessary to manage real servers. The book begins with the concept of user management, group management, as well as file-system permissions. To manage your storage on Ubuntu Server systems, you will learn how to add and format storage and view disk usage. Later, you will also learn how to configure network interfaces, manage IP addresses, deploy Network Manager in order to connect to networks, and manage network interfaces. Furthermore, you will understand how to start and stop services so that you can manage runnin ...
||Ubuntu Server Cookbook|
Ubuntu is one of the most secure operating systems and defines the highest level of security as compared other operating system. Ubuntu server is a popular Linux distribution and the first choice when deploying a Linux server. It can be used with a $35 Raspberry Pi to top-notch, thousand-dollar-per-month cloud hardware. Built with lists that there are 4 million + websites built using Ubuntu. With its easy-to-use package management tools and availability of well-known packages, we can quickly set up our own services such as web servers and database servers using Ubuntu.
This book will help you develop the skills required to set up high performance and secure services with open source tools. Starting from user management and an in-depth look at networking, we then move on to cover the installation and management of web servers and database servers, as well as load balancing various services. You will quickly learn to set up your own cloud and minimize costs and efforts with app ...
||Agile Project Management Using Team Foundation Server 2015|
This book will help you get started with agile project management using Microsoft's latest releases of its market-leading Team Foundation Server (TFS) 2015, and Visual Studio Team Services (VSTS). The book demonstrates agile concepts and how to implement them using TFS/VSTS.
Many organizations are using agile practices today. Agility has become a key enabler for running better projects with more successful end results and high quality output. At the same time, adoption of TFS/VSTS has increased dramatically, from being just a new version control system in the very beginning to becoming the fully-featured market leader it is today.
In order to benefit the most from agile practices you need an Application Lifecycle Management (ALM) toolset that supports your way of working. With TFS/VSTS, Microsoft has provided a powerful tool that is very customizable. This book shows you how you can use TFS/VSTS to implement many agile practices and how they fit into a well-thought-out ALM ...
||Troubleshooting Windows Server with PowerShell|
This book shows you how to use PowerShell to quickly pinpoint, diagnose, and solve problems with your Windows Server environment, reducing the need for external tools, and ensuring you stay up-to-date with PowerShell as it quickly becomes one of the most useful tools in an administrator's toolkit.
Authors Derek Schauland and Donald Jacobs take you through a range of examples, showing you how to gather information from different computer sources. Whether you are logged into the server locally or just wanting to check the status of a server from your local computer, the right PowerShell cmdlets can give you a lot of information quickly, and allow you to troubleshoot your servers from the command line with little interaction with the server's desktop. ...
||XenServer Administration Handbook|
Packed with practical advice, this hands-on guide provides valuable information you need to most effectively optimize and manage the XenServer open source virtualization platform. Whether you run a modest installation of a few blades or multiple global enterprise datacenters, this book focuses on the most critical issues you're likely to encounter when designing a XenServer deployment and helps you handle day-to-day management tasks.
Tim Mackey and J.K. Benedict from Citrix Systems, the company that manages XenServer show you how to design a deployment through best practices, deployment blueprints, and installation guidelines. The book's second part features concise, easy-to-implement recipes for day-to-day management, such as user rights, backup strategies, and hardware maintenance. ...
||Learning Node, 2nd Edition|
||Practical Maintenance Plans in SQL Server|
This book is a complete guide to setting up and maintaining maintenance plans for SQL Server Database Administrators. Maintenance plans too often consist of a backup task and that's it, but there is so much more that can and must be done to ensure the integrity of your most important company resource – the data you are tasked to manage and safeguard. This book walks even the newest of users through creating a powerful, automated maintenance plan.
Automate your job using SQL Server Agent to leverage the power of Maintenance Plans to deliver real, proactive solutions to common issues. Schedule common tasks such as backups and index rebuilds to run automatically, and get early-warning notifications of impending problems relating to resource usage and query performance. By the time your boss knows to call you about a problem, you'll have already called him to describe your solution. ...