Book excerpt: Appending worksheets from a workbook

One of the most common scenarios of working with Excel files is the existence of workbooks that have multiple worksheets of the same format. But, can all worksheets from a workbook be appended into a single table? Can new worksheets automatically be appended in the next refresh? For answers, read this excerpt from Gil Raviv’s…


Managing SQL Server high availability and disaster recovery

In this sample chapter from Exam Ref 70-764 Administering a SQL Database Infrastructure, learn how to design appropriate high availability and disaster recovery solutions in SQL Server with special attention to installation, configuration, and administration processes.


Preparing on-premises Active Directory for Azure AD Connect

Azure Active Directory Connect is Microsoft’s replacement for DirSync and Azure Active Directory Sync tools. In Skill 4.1 from Exam Ref 70-346 Managing Office 365 Identities and Requirements, 2nd Edition, explore how to prepare your on-premises Active Directory environment for synchronization of user accounts, group accounts, and more.


Managing database concurrency in SQL Server

In this sample chapter from Exam Ref 70-762 Developing SQL Databases, explore skills related to the goal of managing database concurrency, including how to implement transactions, manage isolation levels, and more.


Configuring service authentication & account policies in Windows Server 2016

Many apps and services that you install on Windows Server run in the security context of a user account, known as a service account. In Skill 2.1 from Exam Ref 70-742 Identity with Windows Server 2016, learn how account policies enable you to control fundamental security features and how these features help secure your network—and…


Installing, upgrading, and migrating servers and workloads

In Skill 1.1 from Exam Ref 70-743 Upgrading Your Skills to MCSA: Windows Server 2016, review installation requirements for the base installation of Windows Server and learn how Windows Server 2016 differs from previous versions.


Productivity solutions in Microsoft SharePoint Server 2016

In this sample chapter from Exam Ref 70-339 Managing Microsoft SharePoint Server 2016, explore upgrade methods, customizations, and functionality provided within the SharePoint farm itself to improve productivity and business processes.


Implementing Windows containers

The containers feature virtualizes operating systems in Windows Server 2016. In this chapter from Exam Ref 70-740 Installation, Storage and Compute with Windows Server 2016, learn how to deploy and manage Windows containers in cooperation with Docker.


Designing a multidimensional BI semantic model

In this chapter from Exam Ref 70-768 Developing SQL Data Models, learn how to create a multidimensional database by using Microsoft SQL Server Analysis Services (SSAS), design and implement dimensions in a cube, and implement measures and measure groups in a cube.