Technical analysis advising against using Basic and Standard (S0 & S1) tiers in Azure SQL Database, citing performance, permissions, and feature limitations.
Analysis of Database Scoped Configuration changes in SQL Server and Azure SQL Database for the year 2020, noting new options and stability.
Azure Elastic Job Agent, a long-awaited SQL Agent alternative for Azure SQL Database, is approaching General Availability after years in preview.
Explores the availability and configuration of Columnstore Indexes across various Azure SQL Database tiers, including General Purpose, Serverless, and Hyperscale.
Announcement for a full-day workshop on SQL Server Columnstore Indexes at SQLSaturday Vienna 2020, covering practical techniques across multiple versions.
Explains the new Resumable TDE Scan feature in SQL Server 2019 and Azure SQL Database, detailing its commands and benefits for system availability.
Explains Closeness Centrality, a key graph analysis metric, and demonstrates its calculation using SQL Server 2019's graph database features.
A proposal for a new "Optimize for Analytics" database configuration option in SQL Server and Azure SQL Database to enhance performance for data warehousing workloads.
A detailed overview of the new Database Scoped Configuration options introduced for SQL Server and Azure SQL Database in 2018, leading into 2019.
Explores MERGE DML statement support for Graph tables in SQL Server and Azure SQL Database, focusing on UPSERT operations for node and edge tables.
Explores new SQL Server 2019 & Azure SQL Database preview features for derived tables and views in Graph databases, focusing on heterogeneous nodes and edges.
Announcing a workshop on optimizing ETL processes for SQL Server and Azure SQL at the SQLBits 2019 conference.
Explains how to configure and use the Read Scale-Out feature for Azure SQL Database Premium tier to offload read workloads to secondary replicas.
Explores the new Edge Constraints feature in SQL Server 2019 and Azure SQL Database for enforcing data quality and directionality in graph database schemas.
Author's schedule and session highlights for the PASS Summit 2018, a major Microsoft Data Platform conference.
Explores Microsoft's Resumable Online Index Creation feature in Azure SQL DB, detailing its benefits for managing large databases without downtime.
Announcing four in-depth tech workshops on SQL Server, Git/GitHub, Cassandra, and Microsoft Azure at the Tuga IT 2018 Summer Edition conference.
Columnstore Indexes are now available on the Standard Tier of Azure SQL Database, enabling better compression and performance for data warehousing.
