https://www.microsoftpressstore.com/store/rss/servers The latest titles from Microsoft Press Store en-us Over 9 hours of video content In this course, Michiel Rozema and Madzy Stikkelorum help you understand the core concepts of DAX and how to design, build, debug, and optimize DAX calculations. Overview: Since its launch, Power BI has quickly become the leading platform for business intelligence. With powerful self-service capabilities and integrated data preparation, analytics, and visualization features, Power BI enables business users to gain insights like no other. 7/22/2025 12:00:00 AM https://www.microsoftpressstore.com/store/mastering-business-intelligence-with-dax-power-bi-and-9780135407042 8+ Hours of Video Instruction Learn how to configure Windows Server services to deliver secure access to on-premises apps, services, and resources. This self-paced video course is designed to provide learners with both the knowledge and skills required to administer Windows Server in an Active Directory on-premises environment. 1/8/2025 12:00:00 AM https://www.microsoftpressstore.com/store/complete-guide-to-administering-windows-server-video-9780135418512 10 Hours of Video Instruction The complete guide to empower frontline helpdesk staff to support and troubleshoot their users Windows desktop devices. This self-paced video course has been designed to provide learners with both knowledge and the skills required to support and troubleshoot Windows 11 devices in a workplace environment. 8/30/2024 12:00:00 AM https://www.microsoftpressstore.com/store/complete-guide-to-supporting-and-troubleshooting-windows-9780135380215 Conquer SQL Server 2022 administrationfrom the inside outDive into SQL Server 2022 administrationand really put your SQL Server DBA expertise to work. This supremely organized reference packs hundreds of timesaving solutions, tips, and workaroundsall you need to plan, implement, manage, and secure SQL Server 2022 in any production environment: on-premises, cloud, or hybrid. 4/5/2023 12:00:00 AM https://www.microsoftpressstore.com/store/sql-server-2022-administration-inside-out-9780137899883 Starting with the background to T-SQL querying and programming, including: logical query processing, book-querying constructs (single table queries, joins, subqueries, table expressions, set operators, data analysis), data modifications, temporal tables, transactions and concurrency, SQL Graph (completely new to this edition), as well as programmatic T-SQL constructs 2/27/2023 12:00:00 AM https://www.microsoftpressstore.com/store/t-sql-fundamentals-9780138102104 Direct from Microsoft, this Exam Ref is the official study guide for the new Microsoft AZ-801 Configuring Windows Server Hybrid Advanced Services certification exam.Exam Ref AZ-801 Configuring Windows Server Hybrid Advanced Services offers professional-level preparation that helps candidates maximize their exam performance and sharpen their skills on the job. 10/17/2022 12:00:00 AM https://www.microsoftpressstore.com/store/exam-ref-az-801-configuring-windows-server-hybrid-advanced-9780137729494 Direct from Microsoft, this Exam Ref is the official study guide for the new Microsoft AZ-800 Administering Windows Server Hybrid Core Infrastructure certification exam.Exam Ref AZ-800 Administering Windows Server Hybrid Core Infrastructure offers professional-level preparation that helps candidates maximize their exam performance and sharpen their skills on the job 8/31/2022 12:00:00 AM https://www.microsoftpressstore.com/store/exam-ref-az-800-administering-windows-server-hybrid-9780137729265 Dive into Windows Server 2019--and really put your Windows Server expertise to work. 5/26/2020 12:00:00 AM https://www.microsoftpressstore.com/store/windows-server-2019-inside-out-9780135492277 Conquer SQL Server 2019 administration-from the inside outDive into SQL Server 2019 administration-and really put your SQL Server DBA expertise to work. This supremely organized reference packs hundreds of time-saving 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. 4/16/2020 12:00:00 AM https://www.microsoftpressstore.com/store/sql-server-2019-administration-inside-out-9780135561089 Most T-SQL developers recognize the value of window functions for data analysis calculation. But window functions can do far more than that, and optimizations in recent versions of SQL Server have made them more powerful than ever. 11/4/2019 12:00:00 AM https://www.microsoftpressstore.com/store/t-sql-window-functions-for-data-analysis-and-beyond-9780135861448 This comprehensive and authoritative guide will teach you the DAX language for business intelligence, data modeling, and analytics. Leading Microsoft BI consultants Marco Russo and Alberto Ferrari help you master everything from table functions through advanced code and model optimization. You'll learn exactly what happens under the hood when you run a DAX expression, how DAX behaves differently from other languages, and how to use this knowledge to write fast, robust code. 7/20/2019 12:00:00 AM https://www.microsoftpressstore.com/store/definitive-guide-to-dax-business-intelligence-for-microsoft-9781509306978 8+ Hours of Video Instruction A comprehensive guide to provisioning, managing, and securing SQL Server 2017 databases Overview In this video, database analyst and trainer Eric Johnson gives you the tools you need to manage SQL Server in your environment. You learn about the new features in SQL Server 2017, including running SQL Server on Linux. You also learn how to provision and secure Azure databases, design SQL Server tables, and tune and optimize SQL. 1/23/2018 12:00:00 AM https://www.microsoftpressstore.com/store/sql-server-2017-administration-inside-out-video-9781509307838 Direct from Microsoft, this Exam Ref is the official study guide for the new Microsoft 70-765 Provisioning SQL Databases certification exam, the second of two exams required for MCSA: SQL 2016 Database Administration certification. 12/1/2017 12:00:00 AM https://www.microsoftpressstore.com/store/exam-ref-70-765-provisioning-sql-databases-9781509303816 Direct from Microsoft, this Exam Ref is the official study guide for the new Microsoft 70-767 Implementing a SQL Data Warehouse certification exam. Exam Ref 70-767 Implementing a SQL Data Warehouse offers professional-level preparation that helps candidates maximize their exam performance and sharpen their skills on the job. It focuses on the specific areas of expertise modern IT professionals need to successfully build modern data warehouses to support advanced business intelligence solutions 11/9/2017 12:00:00 AM https://www.microsoftpressstore.com/store/exam-ref-70-767-implementing-a-sql-data-warehouse-9781509306473 Direct from Microsoft, this Exam Ref is the official study guide for the new Microsoft 70-764 Administering a SQL Database Infrastructure certification exam, the first of two exams required for MCSA: SQL 2016 Database Administration certification. 9/18/2017 12:00:00 AM https://www.microsoftpressstore.com/store/exam-ref-70-764-administering-a-sql-database-infrastructure-9781509303830 Delve inside Windows architecture and internals - and see how core components work behind the scenes. This classic guide has been fully updated for Windows 8.1 and Windows Server 2012 R2, and now presents its coverage in three volumes: Book 1, User Mode; Book 2, Kernel Mode; Book 3, Device Driver Models. In Book 1, you'll plumb Windows fundamentals, independent of platform - server, desktop, tablet, phone, Xbox. 5/5/2017 12:00:00 AM https://www.microsoftpressstore.com/store/windows-internals-part-1-system-architecture-processes-9780735684188 With SQL Server Analysis Services 2016, Microsoft has dramatically upgraded its Tabular approach to business intelligence data modeling, making Tabular the easiest and best solution for most new projects. In this book, two world-renowned experts in Microsoft data modeling and analysis cover all you need to know to create complete BI solutions with these powerful new tools. 4/12/2017 12:00:00 AM https://www.microsoftpressstore.com/store/tabular-modeling-in-microsoft-sql-server-analysis-services-9781509302772 Direct from Microsoft, this Exam Ref is the official study guide for the new Microsoft 70-761 Querying Data with Transact-SQL certification exam, the first of two exams required for MCSA: SQL 2016 Database Development certification. 3/31/2017 12:00:00 AM https://www.microsoftpressstore.com/store/exam-ref-70-761-querying-data-with-transact-sql-9781509304332 The Exam Ref is the official study guide for Microsoft certification exams. Featuring concise coverage of the skills measured by the exam, challenging Thought Experiments, and pointers to more in-depth material for the candidate needing additional study, exam candidates get professional-level preparation for the exam. The Exam Ref helps candidates determine their readiness for the exam, and provides Exam Tips to help maximize their performance on the exam. 8/19/2016 12:00:00 AM https://www.microsoftpressstore.com/store/exam-ref-70-345-designing-and-deploying-microsoft-exchange-9781509302079 Gain a solid understanding of T-SQL--and write better queries Master the fundamentals of Transact-SQL--and develop your own code for querying and modifying data in Microsoft SQL Server 2016. Led by a SQL Server expert, you'll learn the concepts behind T-SQL querying and programming, and then apply your knowledge with exercises in each chapter. Once you understand the logic behind T-SQL, you'll quickly learn how to write effective code--whether you're a programmer or database administrator. 8/3/2016 12:00:00 AM https://www.microsoftpressstore.com/store/t-sql-fundamentals-9781509302000 Active Directory has been thoroughly transformed to reflect the industry's breakneck shift to the cloud, modern authentication/authorization protocols such as OAuth2 and OpenId Connect, and new today's new mobile, SaaS, and single-page application paradigms. Now, there's an authoritative, start-to-finish guide to building Active Directory authentication solutions for these radically new environments. 1/4/2016 12:00:00 AM https://www.microsoftpressstore.com/store/modern-authentication-with-azure-active-directory-for-9780735696945 Updating both Inside Microsoft SQL Server 2008 T-SQL Querying (Microsoft Press, 2009) and parts of Inside Microsoft SQL Server 2008 T-SQL Programming (Microsoft Press, 2009), the book gives database developers and administrators a detailed look at the internal architecture of T-SQL and a comprehensive programming reference. Tackle the toughest set-based querying and query tuning problems--guided by an author team with in-depth, inside knowledge of T-SQL. 3/6/2015 12:00:00 AM https://www.microsoftpressstore.com/store/t-sql-querying-9780735685048 Your hands-on guide to Azure SQL Database fundamentals Expand your expertise--and teach yourself the fundamentals of Windows Azure SQL Database. If you have previous programming experience but are new to Azure, this tutorial delivers the step-by-step guidance and coding exercises you need to master core topics and techniques. 6/24/2014 12:00:00 AM https://www.microsoftpressstore.com/store/windows-azure-sql-database-step-by-step-9780133989397 Fully updated for Windows Server 2012 R2! Designed to help enterprise administrators develop real-world, job-role-specific skills - this Training Guide focuses on core infrastructure administration for Windows Server 2012 R2. Build hands-on expertise through a series of lessons, exercises, and suggested practices - and help maximize your performance on the job. 6/1/2014 12:00:00 AM https://www.microsoftpressstore.com/store/training-guide-administering-windows-server-2012-r2-9780735684690 Delve inside Windows architecture and internals--and see how core components work behind the scenes. Led by three renowned internals experts, this classic guide is fully updated for Windows 7 and Windows Server 2008 R2--and now presents its coverage in two volumes. As always, you get critical insider perspectives on how Windows operates. 9/15/2012 12:00:00 AM https://www.microsoftpressstore.com/store/windows-internals-part-2-9780735665873