Master advanced DAX in Power BI and Microsoft Fabric to build scalable semantic models, solve complex business problems, and deliver high-impact analytics using real-world scenarios and proven techniques.
2026-06-26 (first published: 2026-06-22)
227 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.
2026-06-22 (first published: 2023-01-12)
3,612 reads
A step-by-step guide to harness the power of Microsoft Fabric in developing data analytics solutions for various use cases
2026-06-08 (first published: 2024-11-25)
14,172 reads
A new era of SQL Server is here, and this latest edition of Grant Fritchey’s best-selling dive into SQL Server query performance can ensure your queries keep up.
2026-05-25 (first published: 2026-02-04)
3,438 reads
Ready to simplify the process of building data lakehouses and data pipelines at scale? In this practical guide, learn how Delta Lake is helping data engineers, data scientists, and data analysts overcome key data reliability challenges with modern data engineering and management techniques.
2026-05-04 (first published: 2026-02-03)
1,137 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.
2026-04-20 (first published: 2024-02-29)
6,534 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.
2026-04-17 (first published: 2025-03-26)
2,478 reads
This practical book provides a comprehensive overview of troubleshooting and performance tuning best practices for Microsoft SQL Server. Database engineers, including database developers and administrators, will learn how to identify performance issues, troubleshoot the system in a holistic fashion, and properly prioritize tuning efforts to attain the best system performance possible.
2026-02-02 (first published: 2025-10-14)
3,189 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.
2026-01-26 (first published: 2024-12-05)
2,969 reads
For anyone else who needs to write queries or develop T-SQL code for SQL Server, Azure SQL Database, or Azure SQL Managed Instance
2026-01-21 (first published: 2025-10-14)
3,402 reads
By Brian Kelley
Yesterday, July 27, 2026, Microsoft announced a new cybersecurity effort called Project Perception. Included...
By Steve Jones
If you’ve wanted a SQL Server MCP server for your databases, it’s available. The...
Introducing azsql-migration-test, a small open-source CLI that validates your Azure SQL Database migrations against...
Comments posted to this topic are about the item Symmetric Key Encryption
Comments posted to this topic are about the item The “Successful Login” Dilemma: Why...
Comments posted to this topic are about the item Building Your Own Software
If I run this statement in SQL Server 2025, how is the password encrypted?
CREATE SYMMETRIC KEY MySymmetricKey WITH ALGORITHM = AES_256, KEY_SOURCE = 'My secret key source passphrase', IDENTITY_VALUE = 'My secret identity value' ENCRYPTION BY PASSWORD = 'S&perS#cretP@ssword7'; GOSee possible answers