Azure SQL Database: Non-blocking transactions
-
Frank
- August 8, 2022
- 2PC
- ALTER
- atomicity
- autocommit
- azure friday
- azure sql database
- azure sql db
- batch-scoped
- blocked
- COMMIT
- committed data
- concurrent data access
- consistency
- database
- Davide Mauri
- default behavior
- distributed transactions
- durability
- dynamic locking
- isolation
- Lara Rubbelke
- locked
- locking
- logging
- long-running transaction
- Mars
- MS DTC
- multiple active result set
- non-blocking transactions
- queued
- row versioning
- snapshot
- SQL Server
- transactions
- two-phase commit
- waiting
Managing concurrent access to a resource, be it a row, a table, or a single value, is easy if no one is trying to modify the underlying data. But what happens if someone changes data while someone else is reading it? Even better, what could happen if two or more users try to change the […]
Read More
Microsoft Cloud Adoption Framework for Azure Part 2
The Microsoft Cloud Adoption Framework for Azure guides customers through their cloud journey, to use and adopt cloud services with confidence and in control. In this video, Scott Bockheim shows Lara Rubbelke the tools, templates, assessments, and resources to implement the guidance from this framework in different stages and steps of the cloud journey. Related […]
Read More
Microsoft Cloud Adoption Framework for Azure
The Microsoft Cloud Adoption Framework for Azure guides customers through their cloud journey, to use and adopt cloud services with confidence and in control. In this episode, Scott Bockheim explores the guidance and documentation of the framework with Lara Rubbelke to provide an overview of all the components and elements included. Microsoft Cloud Adoption Framework […]
Read More
How to Set Up a Direct Interconnection Between Azure and OCI
Romit Girdhar, Microsoft (@romitgirdhar) and Chinmay Joshi, Oracle join Lara Rubbelke to explain how to interconnect Microsoft Azure and Oracle Cloud Infrastructure. The Microsoft Azure and Oracle Cloud interoperability partnership enables you to migrate and run mission-critical enterprise workloads across both clouds, seamlessly connecting Azure services, like Analytics and AI, to Oracle Cloud services, like […]
Read More
Expediting Container Startup with Project Teleport and Azure Container Registry
Container startup time is the price of admission, but startup time is also an inhibitor for many serverless scenarios. Steve Lasker joins Lara Rubbelke to show how Project Teleport eliminates the download and decompression of layers by directly mounting expanded layers, potentially unlocking many new scenarios. Related Links Azure Container Registry Adds Teleportation blog post […]
Read More
Azure Monitor Action Groups
Azure Monitor action groups enable you to define a list of actions to execute when an alert is triggered. In this episode, we demonstrate how to configure a Service Health alert to use an action group. Create and manage action groups in the Azure portal Service Health Azure Monitor overview Azure Monitor docs Create a […]
Read More
Deploy WordPress with Azure Database for MariaDB
In this episode of Azure Friday, learn how to deploy WordPress backed by Azure Database for MariaDB. It is the latest addition to the open source database services available on the Azure platform and further strengthens Azure’s commitment to open source and its communities. The service offers built-in high availability, automatic backups, and scaling of […]
Read More
Rerun Activities Inside Azure Data Factory Pipelines
Data integration is complex with many moving parts. It helps organizations to combine data and complex business processes in hybrid data environments. Failures are very common in data integration workflows. This can happen due to data not arriving on time, functional code issues in your pipelines, infrastructure issues, etc. A common requirement is the ability […]
Read More
Overview of Azure Data Explorer
Manoj Raheja joins Lara Rubbelke (@sqlgal) to demonstrate Azure Data Explorer (ADX) and provide an overview of the service from provisioning to querying. ADX is a fast, fully managed data analytics service for real-time analysis on large volumes of streaming data. It brings together a highly performant and scalable cloud analytics service with an intuitive […]
Read More
Azure Data Factory Visual Tools Now Integrated with GitHub
Gaurav Malhotra joins Lara Rubbelke to discuss how you can associate a GitHub repository (public & enterprise) to your Azure Data Factory for collaboration, versioning, source control. For more information, see: Azure Data Factory Visual tools now support GitHub integration (blog post) Visual authoring in Azure Data Factory – Author with GitHub integration (docs) Azure […]
Read More