https://www.microsoftpressstore.com/store/rss/sql-server The latest titles from Microsoft Press Store en-us 7/22/2025 12:00:00 AM https://www.microsoftpressstore.com/store/mastering-business-intelligence-with-dax-power-bi-and-9780135407042 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 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 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 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 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