Directfrom Microsoft, this Exam Ref is the official study guide for the new MicrosoftDP-300 Administering Microsoft Azure SQL Solutions certification exam.
2025-05-27 (first published: 2023-12-10)
1,899 reads
Build efficient and scalable batch and real-time data ingestion pipelines, DevOps continuous integration and deployment pipelines, and advanced analytics solutions on the Azure Data Platform. This book teaches you to design and implement robust data engineering solutions using Data Factory, Databricks, Synapse Analytics, Snowflake, Azure SQL database, Stream Analytics, Cosmos database, and Data Lake Storage Gen2.
2025-05-27 (first published: 2023-07-13)
9,633 reads
In this newly updated and expanded edition of the bestselling The Phoenix Project, co-author Gene Kim includes a new afterword and a deeper delve into the Three Ways as described in The DevOps Handbook.
2025-05-27 (first published: 2024-02-20)
2,389 reads
Adapted from the acclaimed bestselling book, The Phoenix Project Graphic Novel Volume 1 introduces readers to a stalwart cast of characters as they are challenged by the four types of work that impact complex workflows.
2025-05-19 (first published: 2024-12-05)
2,645 reads
Use the graph table features in Azure SQL that were introduced in SQL Server 2017 and further refined in SQL Server 2019. This book shows you how to create data structures to capture complex connections between items in your data. These connections will help you analyze and draw insights from connections in your data that go beyond classic relationships.
2025-05-14 (first published: 2023-08-18)
1,570 reads
Data fabric, data lakehouse, and data mesh have recently appeared as viable alternatives to the modern data warehouse. These new architectures have solid benefits, but they're also surrounded by a lot of hyperbole and confusion. This practical book provides a guided tour of these architectures to help data professionals understand the pros and cons of each.
2025-05-05 (first published: 2024-02-29)
5,661 reads
Master Transact-SQL's fundamentals, and write correct, robust code for querying and modifying data with modern Microsoft data technologies, including SQL Server 2022, Azure SQL Database, and Azure SQL Managed Instance.
2025-04-28 (first published: 2024-02-20)
4,576 reads
In a world dominated by data, organizations heavily rely on business intelligence tools like Power BI for deriving insights and informed decision-making. Yet, as data volumes grow and user demands increase, achieving optimal performance becomes challenging.
2025-04-21 (first published: 2025-03-26)
538 reads
Know how to track changes and key events in your SQL Server databases in support of application troubleshooting, regulatory compliance, and governance. This book shows how to use key features in SQL Server ,such as SQL Server Audit and Extended Events, to track schema changes, permission changes, and changes to your data. You’ll even learn how to track queries run against specific tables in a database. ss
2025-03-05 (first published: 2023-05-08)
7,622 reads
Refactoring has proven its value in a wide range of development projects–helping software professionals improve system designs, maintainability, extensibility, and performance.
2025-02-17 (first published: 2024-09-18)
3,653 reads
By Brian Kelley
Back in June I blogged about pig butchering and the amount of reported losses...
By Kevin3NF
“SQL Server is slow.” We’ve all heard it. But that doesn’t always mean SQL...
By Steve Jones
It’s just a few weeks until the PASS Summit on Tour in New York...
Comments posted to this topic are about the item Critical Data and Insomnia
Comments posted to this topic are about the item Data recovery from an Index
Comments posted to this topic are about the item Working with Indexes on SSMS
Is it possible to recover data from a non-clustered index on the firstname and lastname columns in case of corruption?