Books in the Inside Out series

This well-organized reference packs hundreds of timesaving solutions, tips, and workaroundsGÇôall students need to make the most of ExcelGÇÖs most powerful tools for analyzing data and making better decisions. Renowned Excel expert Bill Jelen offers a complete tour of Excel 2019 and Excel in Office 365, from efficient interface customizations to advanced analysis, visualizations, and dashboards. Discover how experts tackle todayGÇÖs key tasksGÇôand challenge yourself to new levels of mastery.

Inside Out Human Body guides kids on an exciting journey into the human body with a layered die-cut model that takes them from head to toe, from one cell to an entire system.

Inside Out Medieval Castle takes readers on a fascinating tour of a medieval castle via a die-cut model that reveals the ins and outs of defense, offense, and daily life, layer by layer!

Inside Out T-Rex explores the king of the dinosaurs through a die-cut model that reveals scientists’ most groundbreaking theories about T. rex, from the inside out!

Conquer SQL Server 2022 and Azure SQL administration from the inside out! Dive into SQL Server 2022 administration and grow your Microsoft SQL Server data platform skillset. This well-organized reference packs in timesaving solutions, tips, and workarounds, all you need to plan, implement, deploy, provision, manage, and secure SQL Server 2022 in any environment: on-premises, cloud, or hybrid, including detailed, dedicated chapters on Azure SQL Database and Azure SQL Managed Instance. Nine experts thoroughly tour DBA capabilities available in the SQL Server 2022 Database Engine, SQL Server Data Tools, SQL Server Management Studio, PowerShell, and much more. You'll find extensive new coverage of Azure SQL Database and Azure SQL Managed Instance, both as a cloud platform of SQL Server and in their new integrations with SQL Server 2022, information available in no other book. Discover how experts tackle today's essential tasks and challenge yourself to new levels of mastery. Identify low-hanging fruit and practical, easy wins for improving SQL Server administration Get started with modern SQL Server tools, including SQL Server Management Studio, and Azure Data Studio Upgrade your SQL Server administration skillset to new features of SQL Server 2022, Azure SQL Database, Azure SQL Managed Instance, and SQL Server on Linux Design and implement modern on-premises database infrastructure, including Kubernetes Leverage data virtualization of third-party or non-relational data sources Monitor SQL instances for corruption, index activity, fragmentation, and extended events Automate maintenance plans, database mail, jobs, alerts, proxies, and event forwarding Protect data through encryption, privacy, and auditing Provision, manage, scale and secure, and bidirectionally synchronize Microsoft's powerful Azure SQL Managed Instance Understand and enable new Intelligent Query Processing features to increase query concurrency Prepare a best-practice runbook for disaster recovery Use SQL Server 2022 features to span infrastructure across hybrid environments

Conquer Microsoft 365 administration, from the inside out! Dive into Microsoft 365 administration and harness the full power of cloud scaling, automation, and availability in Microsoft 365! This supremely well-organized reference packs hundreds of time-saving solutions, tips, and workarounds; all you need to continually enhance organizational agility, productivity, and security. Three Microsoft insiders help you fully leverage Microsoft Purview, Microsoft Enterprise Mobility + Security (EMS), Azure AD, Exchange Online, Microsoft Teams, SharePoint Online, OneDrive for Business, and more. Discover how experts tackle todays key tasks and challenge yourself to new levels of mastery. Plan deployment, understand downstream impacts, and avoid pitfalls Prepare your environment, establish governance, and enforce compliance Assess and improve security posture with Microsoft 365 Secure Score Move to identity-based security with Microsoft Enterprise Mobility + Security (EMS) Plan identity types, authentication, identity federation, and AAD Connect deployment Replace costly premises infrastructure with cloud-based Azure synchronization Manage complex Azure AD scenarios such as mergers, acquisitions, and divestitures Automate Azure to improve consistency, security, and standardization Prepare for Exchange Online cloud-only deployments, hybrid coexistence, and migration Move mailboxes and public folders to Exchange Online Understand Microsoft Teams concepts, architecture, and user interface Support meetings, webinars, and live events Deliver full-featured telephony solutions with Teams Phone System Implement telephony scheduling, room collaboration, automation, and IVR Use SharePoint Online to manage content and extend it with analytics and dashboards For IT Professionals and Consultants Your role: You have, or will have, responsibilities for deploying, migrating to, or managing some or all of a Microsoft 365 environment Prerequisites: For individuals at any stage of their cloud journey

Renowned Excel experts Bill Jelen and Paul McFedries offer a complete tour of Excel in Office 365, from efficient interface customizations to advanced analysis, visualizations, and dashboards.Topics include: Customizing the Excel workspace Best practices for designing and managing worksheets Creating formulas and functions Performing statistical, what-if, and other data analysis Core to advanced charting techniques Using graphics and sparklines Managing databases and tables Automating Excel with macros and custom functions Collaborating in Excel online, in the cloud, and more Extending Excel

Dive into Windows Server 2019—and really put your Windows Server expertise to work. Focusing on Windows Server 2019's most powerful and innovative features, this exceptionally well-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's 2019 new capabilities for the cloud-first era, Microsoft technology expert Orin Thomas thoroughly covers improvements ranging from security to hybrid cloud environments, faster app innovation to Hyper-Converged Infrastructure (HCI). New or expanded coverage in this edition include the Cloud Shell, Azure software updates, Azure Security Center, VM extensions, VM backup/recovery, Azure Site Recovery updates, Azure nested virtualization, the Windows Subsystem for Linux, the Storage Migration Service, Linux Containers, Kubernetes, Azure Container Options and Repositories, WSSD storage, and more. Coverage includes: Optimizing the full Windows Server 2019 lifecycle, from planning and configuration through rollout and administration Ensuring fast, reliable upgrades and migrations Seamlessly delivering core DNS, DHCP, file, print, storage, and Internet services Centrally managing all enterprise DNS and DHCP infrastructure Achieving dramatic improvements in storage utilization Building flexible cloud and hybrid environments with advanced container and VM features Seamlessly integrating Azure IaaS services with Windows Server 2019 Slashing resource usage and improving availability with Nano Server installations Improving configuration management with Desired State Configuration and Chef Delivering Active Directory identity, certificate, federation, and rights management services Protecting servers, clients, assets, and users with advanced Windows Server 2019 security features

This supremely organized reference packs hundreds of timesaving solutions, troubleshooting tips, and workarounds for Windows Server 2012 R2 - with a focus on infrastructure, core services, and security features.