Guide to automating administrative tasks across multiple Azure SQL Databases using the newly GA Elastic Jobs feature.
Learn how to view and update user/group roles in Azure SQL Database using Azure Data Studio's preview features.
A guide on using PowerShell to automate key security tasks for Azure SQL Databases, including firewall rules, encryption, and auditing.
Explains Azure SQL Database's AI-powered Automatic Tuning feature, detailing how it optimizes performance and provides a step-by-step tutorial.
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.
A guide to using scheduled autoscaling for Azure SQL Database and Azure Analysis Services to reduce cloud costs, with updated open-source scripts.
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.
