Microsoft Press Store :: Titles > SQL Server https://www.microsoftpressstore.com/store/rss/sql-server The latest titles from Microsoft Press Store en-us Title :: SQL Server 2022 Administration Inside Out 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 Title :: T-SQL Fundamentals 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 Title :: SQL Server 2019 Administration Inside Out 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 Title :: T-SQL Window Functions: For data analysis and beyond 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 Title :: Definitive Guide to DAX, The: Business intelligence for Microsoft Power BI, SQL Server Analysis Services, and Excel 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 Title :: SQL Server 2017 Administration Inside Out 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/23/2018 12:00:00 AM https://www.microsoftpressstore.com/store/sql-server-2017-administration-inside-out-9781509305254 Title :: SQL Server 2017 Administration Inside Out (Video) 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 Title :: Exam Ref 70-765 Provisioning SQL Databases 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 Title :: Exam Ref 70-767 Implementing a SQL Data Warehouse 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 Title :: Exam Ref 70-764 Administering a SQL Database Infrastructure 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 Title :: MCSA SQL Server 2016 Database Development Exam Ref 2-pack: Exam Refs 70-761 and 70-762 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. It focuses on the specific areas of expertise modern database professionals need to succeed with T-SQL database queries. 6/13/2017 12:00:00 AM https://www.microsoftpressstore.com/store/mcsa-sql-server-2016-database-development-exam-ref-9781509306657 Title :: Exam Ref 70-768 Developing SQL Data Models 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-9781509305186 Title :: Tabular Modeling in Microsoft SQL Server Analysis Services 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 Title :: Exam Ref 70-761 Querying Data with Transact-SQL 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 Title :: Exam Ref 70-762 Developing SQL Databases 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-9781509304943 Title :: T-SQL Fundamentals 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 Title :: T-SQL Querying 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 Title :: Windows Azure SQL Database Step by Step 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 Title :: Microsoft SQL Server 2012 Internals 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 Title :: Microsoft SQL Server 2012 Reporting Services 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 Title :: Microsoft SQL Server 2012 Step by Step 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 Title :: Microsoft SQL Server 2012 Integration Services 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-9780735665835 Title :: Microsoft SQL Server 2012 Analysis Services: The BISM Tabular Model Build agile and responsive Business Intelligence solutions Analyze tabular data using the BI Semantic Model (BISM) in Microsoft SQL Server 2012 Analysis Services--and discover a simpler method for creating corporate-level BI solutions. Led by three BI experts, you'll learn how to build, deploy, and query a BISM tabular model with step-by-step guides, examples, and best practices. 7/15/2012 12:00:00 AM https://www.microsoftpressstore.com/store/microsoft-sql-server-2012-analysis-services-the-bism-9780735658172 Title :: Microsoft SQL Server 2012 T-SQL Fundamentals 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 2012. 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. 7/15/2012 12:00:00 AM https://www.microsoftpressstore.com/store/microsoft-sql-server-2012-t-sql-fundamentals-9780735658134 Title :: Microsoft SQL Server 2012 High-Performance T-SQL Using Window Functions Apply powerful window functions in T-SQL--and increase the performance and speed of your queries Optimize your queries--and obtain simple and elegant solutions to a variety of problems--using window functions in Transact-SQL. Led by T-SQL expert Itzik Ben-Gan, you'll learn how to apply calculations against sets of rows in a flexible, clear, and efficient manner. 4/15/2012 12:00:00 AM https://www.microsoftpressstore.com/store/microsoft-sql-server-2012-high-performance-t-sql-using-9780735658356