1 min read
SQL Database in Microsoft Fabric: Deep Dive
SQL Database in Fabric brings enterprise-grade transactional capabilities to the unified data platform, with seamless integration to analytical workloads…
SQL Database
10 articles
1 min read
Azure SQL Bindings for Azure Functions
Azure SQL bindings simplify serverless database applications significantly.
1 min read
Data-tier Applications (DACPAC) for Azure SQL
DACPACs provide reliable, repeatable database deployments for enterprise applications.
1 min read
Row-Level Security in Azure SQL Database
RLS uses security policies with predicate functions to filter rows transparently. Users see only the rows they're authorized to access without any…
1 min read
Dynamic Data Masking in Azure SQL Database
DDM is a policy-based security feature that hides sensitive data in query results. The data in the database is not modified, making it ideal for scenarios…
1 min read
Always Encrypted in Azure SQL Database
Always Encrypted uses column encryption keys (CEKs) protected by column master keys (CMKs) to encrypt sensitive columns. The database engine never has…
1 min read
Ledger Tables in Azure SQL Database
Ledger tables maintain a complete history of all changes with cryptographic hashes, making it possible to verify that data hasn't been tampered with.
1 min read
Azure SQL Database Updates - September 2022
Azure SQL Database's continuous improvements make it an excellent choice for cloud-native applications requiring robust, scalable database capabilities.
2 min read
SQL Database Indexing with Azure Cognitive Search
Azure SQL to Cognitive Search is a combination I've set up half a dozen times, and the reason it keeps appearing is that most enterprise organisations…
1 min read
Azure SQL Elastic Pools: Cost-Effective Multi-Tenancy
Elastic pools are ideal for SaaS multi-tenancy where tenant databases have varied, unpredictable loads.