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…
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.
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.
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.
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…
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.
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.
In Skill 1.1 from Exam Ref 70-744 Securing Windows Server 2016, learn about whole-disk and file encryption in Windows Server 2016.
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.
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.