Conquer Windows Server 2019—from the inside out! Dive into Windows Server 2019—and really put your Windows Serverexpertise to work. Focusing on Windows Server 2019’s most powerful and innovative features, this supremely organized reference packs hundreds of timesaving solutions, tips, and workarounds—all you need to plan, implement, or manage Windows Server in enterprise, data center, cloud, and hybrid environments. Fully reflecting new innovations for security, hybrid cloud environments, and Hyper-Converged Infrastructure (HCI), it covers everything from cluster sets to Windows Subsystem for Linux. You’ll discover how experts tackle today’s essential tasks—and challenge yourself to new levels of mastery. • Optimize the full Windows Server 2019 lifecycle, from planning and configuration through rollout and administration • Leverage new configuration options including App Compatibility Features on Demand (FOD) or Desktop Experience • Ensure fast, reliable upgrades and migrations • Manage Windows servers, clients, and services through Windows Admin Center • Seamlessly deliver and administer core DNS, DHCP, fi le, print, storage, and Internet services • Use the Storage Migration Service to simplify storage moves and configuration at the destination • Seamlessly integrate Azure IaaS and hybrid services with Windows Server 2019 • Improve agility with advanced container technologies, including container networking and integration into Kubernetes orchestration clusters • Deliver Active Directory identity, certifi cate, federation, and rights management services • Protect servers, clients, VMs, assets, and users with advanced Windows Server 2019 security features, from Just Enough Administration to shielded VMs and guarded virtualization fabrics • Monitor performance, manage event logs, confi gure advanced auditing, and perform backup/recovery Windows Server 2019 For Experienced Windows Server Users and IT Professionals • Your role: Experienced intermediate to-advanced level Windows Server user or IT professional • Prerequisites: Basic understanding of Windows Server procedures, techniques, and navigation

Conquer SQL Server 2019 administration–from the inside out Dive into SQL Server 2019 administration–and really put your SQL Server DBA expertise to work. This supremely organized reference packs hundreds of timesaving solutions, tips, and workarounds–all you need to plan, implement, manage, and secure SQL Server 2019 in any production environment: on-premises, cloud, or hybrid. Six experts thoroughly tour DBA capabilities available in SQL Server 2019 Database Engine, SQL Server Data Tools, SQL Server Management Studio, PowerShell, and Azure Portal. You’ll find extensive new coverage of Azure SQL, big data clusters, PolyBase, data protection, automation, and more. Discover how experts tackle today’s essential tasks–and challenge yourself to new levels of mastery. Explore SQL Server 2019’s toolset, including the improved SQL Server Management Studio, Azure Data Studio, and Configuration Manager Design, implement, manage, and govern on-premises, hybrid, or Azure database infrastructures Install and configure SQL Server on Windows and Linux Master modern maintenance and monitoring with extended events, Resource Governor, and the SQL Assessment API Automate tasks with maintenance plans, PowerShell, Policy-Based Management, and more Plan and manage data recovery, including hybrid backup/restore, Azure SQL Database recovery, and geo-replication Use availability groups for high availability and disaster recovery Protect data with Transparent Data Encryption, Always Encrypted, new Certificate Management capabilities, and other advances Optimize databases with SQL Server 2019’s advanced performance and indexing features Provision and operate Azure SQL Database and its managed instances Move SQL Server workloads to Azure: planning, testing, migration, and post-migration

Conquer Windows Server 2016—from the inside out! Dive into Windows Server 2016—and really put your Windows Server expertise to work. Focusing on Windows Server 2016’s most powerful and innovative features, this supremely organized reference packs hundreds of timesaving solutions, tips, and workarounds—all you need to plan, implement, or manage Windows Server in enterprise, data center, cloud, and hybrid environments. Fully reflecting Windows Server new capabilities for the cloud-first era, Orin covers everything from Nano Server to Windows Server and Hyper-V Containers. You’ll discover how experts tackle today’s essential tasks—and challenge yourself to new levels of mastery. • Optimize the full Windows Server 2016 lifecycle, from planning and configuration through rollout and administration • Ensure fast, reliable upgrades and migrations • Seamlessly deliver core DNS, DHCP, file, print, storage, and Internet services • Use IPAM to centrally manage all enterprise DNS and DHCP infrastructure • Gain dramatic storage utilization improvements with built-in deduplication and storage replica • Build flexible cloud and hybrid environments with Windows Containers and Shielded VMs • Seamlessly integrate Azure IaaS services with Windows Server 2016 • Slash resource usage and improve availability with tiny Nano Server installations • Improve configuration management with Desired State Configuration and Chef • Deliver Active Directory identity, certificate, federation, and rights management services • Protect servers, clients, assets, and users with advanced Windows Server 2016 security features including Just Enough Administration For Experienced Windows Server Users and IT Professionals • Your role: Experienced intermediate-to-advanced level Windows Server user or IT professional • Prerequisites: Basic understanding of Windows Server procedures, techniques, and navigation

New edition of the bestselling guide to Mastering Windows Server, updated to Windows Server 2022 with improved security, better platform flexibility, new windows admin center, upgraded Hyper-V manager and hybrid cloud support Key Features Develop necessary skills to design and implement Microsoft Server 2019 in enterprise environment Provide support to your medium to large enterprise and leverage your experience in administering Microsoft Server 2019 Effectively administering Windows server 2019 with the help of practical examples Book DescriptionMastering Windows Server 2019 – Second Edition covers all of the essential information needed to implement and utilize this latest-and-greatest platform as the core of your data center computing needs. You will begin by installing and managing Windows Server 2019, and by clearing up common points of confusion surrounding the versions and licensing of this new product. Centralized management, monitoring, and configuration of servers is key to an efficient IT department, and you will discover multiple methods for quickly managing all of your servers from a single pane of glass. To this end, you will spend time inside Server Manager, PowerShell, and even the new Windows Admin Center, formerly known as Project Honolulu. Even though this book is focused on Windows Server 2019 LTSC, we will still discuss containers and Nano Server, which are more commonly related to the SAC channel of the server platform, for a well-rounded exposition of all aspects of using Windows Server in your environment. We also discuss the various remote access technologies available in this operating system, as well as guidelines for virtualizing your data center with Hyper-V. By the end of this book, you will have all the ammunition required to start planning for, implementing, and managing Windows.What you will learn Work with the updated Windows Server 2019 interface, including Server Core and Windows Admin Center Secure your network and data with new technologies in Windows Server 2019 Learn about containers and understand the appropriate situations to use Nano Server Discover new ways to integrate your data center with Microsoft Azure Harden your Windows Servers to help keep the bad guys out Virtualize your data center with Hyper-V Who this book is for If you are a System Administrator or an IT professional interested in designing and deploying Windows Server 2019 then this book is for you. Previous experience of Windows Server operating systems and familiarity with networking concepts is required.

This is the eBook of the printed book and may not include any media, website access codes, or print supplements that may come packaged with the bound book. Conquer today’s Windows 10—from the inside out! Dive into Windows 10—and really put your Windows expertise to work. Focusing on the most powerful and innovative features of Windows 10, this supremely organized reference packs hundreds of timesaving solutions, tips, and workarounds—all fully reflecting the major Windows 10 Anniversary Update. From new Cortana and Microsoft Edge enhancements to the latest security and virtualization features, you’ll discover how experts tackle today’s essential tasks—and challenge yourself to new levels of mastery. Install, configure, and personalize the newest versions of Windows 10 Understand Microsoft’s revamped activation and upgrade processes Discover major Microsoft Edge enhancements, including new support for extensions Use today’s improved Cortana services to perform tasks, set reminders, and retrieve information Make the most of the improved ink, voice, touch, and gesture support in Windows 10 Help secure Windows 10 in business with Windows Hello and Azure AD Deploy, use, and manage new Universal Windows Platform (UWP) apps Take advantage of new entertainment options, including Groove Music Pass subscriptions and connections to your Xbox One console Manage files in the cloud with Microsoft OneDrive and OneDrive for Business Use the improved Windows 10 Mail and Calendar apps and the new Skype app Fine-tune performance and troubleshoot crashes Master high-efficiency tools for managing Windows 10 in the enterprise Leverage advanced Hyper-V features, including Secure Boot, TPMs, nested virtualization, and containers In addition, this book is part of the Current Book Service from Microsoft Press. Books in this program will receive periodic updates to address significant software changes for 12 to 18 months following the original publication date via a free Web Edition. Learn more at https://www.microsoftpressstore.com/cbs.

Conquer Microsoft Office 2019–from the inside out! Dive into Microsoft Office 2019–and really put its productivity toolsand services to work! This supremely organized reference packs hundreds of timesaving solutions, tips, and workarounds–all you need to make the most of Office’s most powerful tools for productivity and decision-making. Renowned Office expert Joe Habraken offers a complete tour of Office 2019 and Office 365, with cutting-edge techniques and shortcuts for Word, Excel, PowerPoint, Outlook, Publisher, online Office apps, and more. Discover how experts tackle today’s key tasks–and challenge yourself to new levels of mastery. Create amazing content faster with Office’s new features, tools, and shortcuts Share, collaborate with, and secure Office files in the cloud Organize, edit, and format complex documents with Microsoft Word Build tables of contents, captions, indexes, and footnotes that automatically update Efficiently enter and manage data in Excel workbooks, and format it for easy understanding Build flexible, reliable Excel workbooks with formulas and functions Integrate data from external sources, including web tables, text files, and more Transform data into insight with Excel charts, Sparklines, and PivotTables Quickly create presentations with PowerPoint themes, Reuse Slides, and Libraries Build more impactful slides with advanced formatting, SmartArt, animation, transitions, and multimedia Use PowerPoint 2019 tools to present more effectively, both in person and online Systematically improve email productivity and security with Outlook 2019 Manage appointments and tasks, and quickly plan meetings

Your one-stop reference for Windows Server 2019 and PowerShell know-how Windows Server 2019 & PowerShell All-in-One For Dummies offers a single reference to help you build and expand your knowledge of all things Windows Server, including the all-important PowerShell framework. Written by an information security pro and professor who trains aspiring system administrators, this book covers the broad range of topics a system administrator needs to know to run Windows Server 2019, including how to install, configure, and secure a system. This book includes coverage of: Installing & Setting Up Windows Server Configuring Windows Server 2019 Administering Windows Server 2019 Configuring Networking Managing Security Working with Windows PowerShell Installing and Administering Hyper-V Installing, Configuring, and Using Containers If you’re a budding or experienced system administrator looking to build or expand your knowledge of Windows Server, this book has you covered.

Conquer SQL Server 2017 administration—from the inside out Dive into SQL Server 2017 administration—and really put your SQL Server DBA expertise to work. This supremely organized reference packs hundreds of timesaving solutions, tips, and workarounds—all you need to plan, implement, manage, and secure SQL Server 2017 in any production environment: on-premises, cloud, or hybrid. Four SQL Server experts offer a complete tour of DBA capabilities available in SQL Server 2017 Database Engine, SQL Server Data Tools, SQL Server Management Studio, and via PowerShell. Discover how experts tackle today’s essential tasks—and challenge yourself to new levels of mastery. • Install, customize, and use SQL Server 2017’s key administration and development tools • Manage memory, storage, clustering, virtualization, and other components • Architect and implement database infrastructure, including IaaS, Azure SQL, and hybrid cloud configurations • Provision SQL Server and Azure SQL databases • Secure SQL Server via encryption, row-level security, and data masking • Safeguard Azure SQL databases using platform threat protection, firewalling, and auditing • Establish SQL Server IaaS network security groups and user-defined routes • Administer SQL Server user security and permissions • Efficiently design tables using keys, data types, columns, partitioning, and views • Utilize BLOBs and external, temporal, and memory-optimized tables • Master powerful optimization techniques involving concurrency, indexing, parallelism, and execution plans • Plan, deploy, and perform disaster recovery in traditional, cloud, and hybrid environments For Experienced SQL Server Administrators and Other Database Professionals • Your role: Intermediate-to-advanced level SQL Server database administrator, architect, developer, or performance tuning expert • Prerequisites: Basic understanding of database administration procedures

Efficiently manage and administer enterprise environments using Microsoft Windows Server 2019 Key FeaturesLeverage Windows Server 2019 to improve enterprise workflow efficiency and increase productivityDeliver enterprise-grade cloud services that can be applied in your infrastructureGet up and running with PowerShell and the all-new Hyper-V improvementsBook Description Do you want to get up and running with essential administrative tasks in Windows Server 2019? This second edition of the Windows Server 2019 Cookbook is packed with practical recipes that will help you do just that. The book starts by taking you through the basics that you need to know to get a Windows Server operating system working, before teaching you how to navigate through daily tasks using the upgraded graphical user interface (GUI). You'll then learn how to compose an optimal Group Policy and perform task automation with PowerShell scripting. As you advance, you’ll get to grips with faster app innovation, improved Windows security measures, and hybrid cloud environments. After you’ve explored the functions available to provide remote network access to your users, you’ll cover the new Hyper-V enhancements. Finally, this Windows Server book will guide you through practical recipes relating to Azure integration and important tips for how to manage a Windows Server environment seamlessly. By the end of this book, you’ll be well-versed with Windows Server 2019 essentials and have the skills you need to configure Windows services and implement best practices for securing a Windows Server environment. What you will learnGet up and running with Windows Server 2019’s new featuresInstall, configure, and administer Windows Server 2019 effectivelyConfigure the server to host any enterprise applicationDiscover ways to manage a server without a GUISafeguard your virtual machines in the event of server failureExplore new ways to integrate Windows Server with Microsoft AzureDeploy Windows containers using DockerWho this book is for This Windows Server 2019 book is for system administrators and IT professionals who have basic experience in Windows environments and are interested in acquiring the skills and knowledge needed to manage and maintain the core infrastructure required for a Windows Server 2019 environment.

Conquer SharePoint 2013—from the inside out! You’re beyond the basics, so dive right into SharePoint 2013—and really put your business collaboration platform to work! This supremely organized reference packs hundreds of timesaving solutions, troubleshooting techniques, and workarounds. It’s all muscle and no fluff. Discover how the experts facilitate information sharing across the enterprise—and challenge yourself to new levels of mastery. Efficiently manage documents throughout the enterprise Build team sites and collaborate with Microsoft OneNote and SkyDrive Design workflows with SharePoint Designer and Microsoft Visio Produce e-forms using Microsoft InfoPath and Access Manage community sites using business social features Connect SharePoint to external data and business systems Create business intelligence dashboards and key performance indicators Customize and control Sharepoint enterprise search