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-03-26 (first published: 2024-02-29)
4,979 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-03-26 (first published: 2024-02-20)
3,509 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.
2024-10-04 (first published: 2024-02-20)
2,375 reads
Know how to use the new capabilities and cloud integrations in SQL Server 2022. This book covers the many innovative integrations with the Azure Cloud that make SQL Server 2022 the most cloud-connected edition ever. The book covers cutting-edge features such as the blockchain-based Ledger for creating a tamper-evident record of changes to data over time that you can rely on to be correct and reliable.
2024-09-16 (first published: 2023-01-12)
3,634 reads
This in-depth look at the encryption tools available in SQL Server shows you how to protect data by encrypting it at rest with Transparent Data Encryption (TDE) and in transit with Transport Level Security (TLS). You will know how to add the highest levels of protection for sensitive data using Always Encrypted to encrypt data also in memory and be protected even from users with the highest levels of access to the database. The book demonstrates actions you can take today to start protecting your data without changing any code in your applications, and the steps you can subsequently take to modify your applications to support implementing a gold standard in data protection.
2024-07-10 (first published: 2023-01-12)
3,123 reads
Troubleshoot query performance issues, identify anti-patterns in your code, and write efficient T-SQL queries with this guide for T-SQL developers
2024-06-26 (first published: 2024-02-29)
2,557 reads
Troubleshoot slow-performing queries and make them run faster. Database administrators and SQL developers are constantly under pressure to provide more speed. This new edition has been redesigned and rewritten from scratch based on the last 15 years of learning, knowledge, and experience accumulated by the author. The book Includes expanded information on using extended events, automatic execution plan correction, and other advanced features now available in SQL Server.
2024-04-08 (first published: 2023-01-12)
9,142 reads
By Steve Jones
We recently published an article on CHOOSE at SQL Server Central. I thought it...
Introduction Treating your data catalog like a “data museum”—a static collection where information quietly...
Low-code solutions often accelerate development and make tasks accessible to people who can’t or...
Hello, I'm tasked with setting up a 2 node server cluster that will host...
Comments posted to this topic are about the item Microsoft Power BI Performance Best...
I am learning DbaTools in Powershell, and my current project is exporting a CSV...
What is returned from this code in SQL Server 2022?
DECLARE @value INT = NULL; SELECT ISNULL(@value, 100.5) AS Result;See possible answers