https://www.microsoftpressstore.com/store/rss/sql-server The latest titles from Microsoft Press Store en-us 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/13/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 SQL Server 2017 Inside Out is the authoritative in-depth reference for every working database administrator responsible for planning, implementing, or managing SQL Server in any production environment -- on-premises, cloud, or hybrid. 2/19/2018 12:00:00 AM https://www.microsoftpressstore.com/store/sql-server-2017-administration-inside-out-9781509305216 About the Book Prepare for Microsoft Exam 70-765 and help demonstrate your real-world mastery of provisioning SQL Server databases both on premise and in SQL Azure. 1/12/2018 12:00:00 AM https://www.microsoftpressstore.com/store/exam-ref-70-765-provisioning-sql-databases-with-practice-9781509306381 About the Book Prepare for Microsoft Exam 70-761 and help demonstrate your real-world mastery of SQL Server 2016 Transact-SQL data management, queries, and database programming. 1/12/2018 12:00:00 AM https://www.microsoftpressstore.com/store/exam-ref-70-761-querying-data-with-transact-sql-with-9781509303724 About the Book Prepare for Microsoft Exam 70-764 and help demonstrate your real-world mastery of skills for database administration. This exam is intended for database administrators charged with installation, maintenance, and configuration tasks 1/12/2018 12:00:00 AM https://www.microsoftpressstore.com/store/exam-ref-70-764-administering-a-sql-database-infrastructure-9781509305759 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 About the Book:Prepare for Microsoft Exam 70-762, Developing SQL Databases -and help demonstrate your real-world mastery of skills for building and implementing databases across organizations 10/30/2017 12:00:00 AM https://www.microsoftpressstore.com/store/exam-ref-70-762-developing-sql-databases-with-practice-9781509303731 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 About the Book:Prepare for Microsoft Exam 70-768--and help demonstrate your real-world mastery of Business Intelligence (BI) solutions development with SQL Server 2016 Analysis Services (SSAS), including modeling and queries. 8/1/2017 12:00:00 AM https://www.microsoftpressstore.com/store/exam-ref-70-768-developing-sql-data-models-with-practice-9781509305599 Direct from Microsoft, this Exam Ref is the official study guide for the new Microsoft 70-768 Developing SQL Data Models certification exam, the second of two exams required for MCSA: SQL 2016 Business Intelligence Development certification. Authored by Microsoft Data Platform MVP Stacia Varga, Exam Ref 70-768 Developing SQL Data Models offers professional-level preparation that helps candidates maximize their exam performance and sharpen their skills on the job. 5/5/2017 12:00:00 AM https://www.microsoftpressstore.com/store/exam-ref-70-768-developing-sql-data-models-9781509305155 Direct from Microsoft, this bundle contains the following two study guides at a $15 discount: Exam Ref 70-761 Querying Data with Transact-SQL, 9781509304332, offers professional-level preparation that helps candidates maximize their exam performance and sharpen their skills on the job. 4/13/2017 12:00:00 AM https://www.microsoftpressstore.com/store/mcsa-sql-server-2016-database-development-exam-ref-9781509303656 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 Direct from Microsoft, this Exam Ref is the official study guide for the new Microsoft 70-762 Developing SQL Databases certification exam, the second of two exams required for MCSA: SQL 2016 Database Development certification. Exam Ref 70-762 Developing SQL Databases offers professional-level preparation that helps candidates maximize their exam performance and sharpen their skills on the job. 1/17/2017 12:00:00 AM https://www.microsoftpressstore.com/store/exam-ref-70-762-developing-sql-databases-9781509304912 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. 7/3/2014 12:00:00 AM https://www.microsoftpressstore.com/store/microsoft-azure-sql-database-step-by-step-9780735679429 Dive deep inside the architecture of SQL Server 2012 Explore the core engine of Microsoft SQL Server 2012--and put that practical knowledge to work. Led by a team of SQL Server experts, you'll learn the skills you need to exploit key architectural features. Go behind the scenes to understand internal operations for creating, expanding, shrinking, and moving databases--whether you're a database developer, architect, or administrator. 11/15/2013 12:00:00 AM https://www.microsoftpressstore.com/store/microsoft-sql-server-2012-internals-9780735658554 Use your SQL Server skills to create and manage key data reports Deliver interactive business intelligence reports using SQL Server 2012 Reporting Services, and help facilitate real-time decision making throughout the enterprise. SQL Server expert Stacia Misner shows you in detail how to design, manage, and access custom reports that capture data from multiple sources 4/15/2013 12:00:00 AM https://www.microsoftpressstore.com/store/microsoft-sql-server-2012-reporting-services-9780735658196 Your hands-on, step-by-step guide to building applications with Microsoft SQL Server 2012 Teach yourself the programming fundamentals of SQL Server 2012--one step at a time. Ideal for beginning SQL Server database administrators and developers, this tutorial provides clear guidance and practical, learn-by-doing exercises for building database solutions that solve real-world business problems. 2/15/2013 12:00:00 AM https://www.microsoftpressstore.com/store/microsoft-sql-server-2012-step-by-step-9780735663862 Ace your preparation for Microsoft Certification Exam 70-463 with this 2-in-1 Training Kit from Microsoft Press. Work at your own pace through a series of lessons and practical exercises, and then assess your skills with online practice tests--featuring multiple, customizable testing options. 12/15/2012 12:00:00 AM https://www.microsoftpressstore.com/store/training-kit-exam-70-463-implementing-a-data-warehouse-9780735666092 Ace your preparation for Microsoft Certification Exam 70-461 with this 2-in-1 Training Kit from Microsoft Press. Work at your own pace through a series of lessons and practical exercises, and then assess your skills with practice tests on CD-featuring multiple, customizable testing options. 12/15/2012 12:00:00 AM https://www.microsoftpressstore.com/store/training-kit-exam-70-461-querying-microsoft-sql-server-9780735666054 Build and manage data integration solutions with expert guidance from the Microsoft SQL Server Integration Services (SSIS) team. See best practices in action and dive deep into the SSIS engine, SSISDB catalog, and security features. Using the developer enhancements in SQL Server 2012 and the flexible SSIS toolset, you'll handle complex data integration scenarios more efficiently--and acquire the skills you need to build comprehensive solutions. 9/15/2012 12:00:00 AM https://www.microsoftpressstore.com/store/microsoft-sql-server-2012-integration-services-9780735665859