While data warehouses and cloud-native architectures have grown rapidly, business users are still finding it difficult to reach enterprise data. Even as dashboards and query tools become easier to ...

A new SQL Server 2025 feature lets organizations run vector-based semantic searches on their own data, connecting to local or cloud-hosted AI models without relying on massive general-purpose LLMs.

A step-by-step guide to deploying, configuring, and testing a multi-AZ, multi-region SQL Server FCI in the Azure cloud, complete with a PowerShell script that handles the networking configuration.

Working of the SQL Server Change Data Capture First, let us understand the workflow of the SQL Server Change Data Capture. This feature tracks changes made to tables created by users which are then ...

Executing `sp_pdw_log_user_data_masking` without parameters returns the current state of transparent data encryption (TDE) log user data masking on the appliance as a scalar result set.

The application of data masking is diverse. It can be applied to PII, PHI, and IP—all crucial to remain compliant with GDPR, HIPAA, PCI DSS, and CCPA. Understanding the different types of data masking ...

Data masking is fast becoming vital for data security as breaches grow in scale and cost. A nuanced understanding of data masking techniques helps organizations mask.

Dynamic data masking (DDM) is a powerful data-security technique for protecting personal and other sensitive information in databases from unauthorized access. A DDM can be used to mask or obfuscate ...

Part of the SQL Server 2022 blog series. Time series data is a set of values organized in the order in which they occur and arrive for processing. Unlike transactional data in SQL Server, which is not ...