May the 4th be with Azure SQL May 2023 AMA | Data Exposed Live
Get the latest May Azure SQL news and updates in this “May the 4th be with you” Data Exposed Live – and “Ask Me Anything” with Anna Hoffman, Kate Smith, Muazma Zahid, Pam Lahoud, Umachandar Jayachandran, Erin Stellato, and John Morehouse (MVP).
Read More
Bring your SQL expertise to the Data Lake with Serverless SQL Pools
Big data analytics is within easy reach of SQL developers and analysts by using Synapse Analytics Serverless SQL Pools. Data stored in Azure Data Lake can be analysed at scale by using this new data processing engine built by Microsoft. In this session with Andy Culter, we’ll see how SQL developers can bring their expertise […]
Read More
Capturing Query Metrics in Azure SQL Database | Data Exposed: MVP Edition
While Azure SQL Database is different than SQL Server in some ways, when it comes to gathering query metrics, a lot of the tools are the same. In this episode of Data Exposed: MVP Edition with Rie Merrit and Grant Fritchey, they will give you a quick rundown of the various ways you can see […]
Read More
SQL Server 2022: Built-in Query Intelligence [Ep. 3] | Data Exposed
In this episode of Data Exposed with Anna Hoffman and Bob Ward, take advantage of performance and availability for faster queries and to help ensure business continuity. Accelerate query performance and tuning with no code changes required with new Intelligent Query Processing scenarios and Query Store enhancements.
Read More
Azure SQL VM: Azure Backup & restore for SQL Server on Azure Virtual Machines
In the next episode in the Azure SQL VM series, join Anna Hoffman, Logan Carrington, and Kartik Pullabhotla as they discuss various options for Azure Backup and restore on SQL Server on Azure Virtual Machines.
Read More
Understanding Connectivity issues in SQL Database
In this episode with Anna Hoffman and Subbu Kandhaswamy, we will cover recommended steps to identify connection failures to your database and best practices to handle these failures using resources & tools available for Azure SQL Database. The connections established to Azure SQL Database from applications or client tools may be unexpectedly terminated and impact […]
Read More
Announcing Azure Arc-enabled SQL Managed Instance Landing Zone Accelerator
In the episode of Data Exposed with Anna Hoffman and Lior Kamrat, we will be talking about the newly announced Azure Arc-enabled SQL Managed Instance Landing Zone Accelerator and the Jumpstart ArcBox flavor – “ArcBox for DataOps.”
Read More
Overview of the Table Designer feature in Azure Data Studio
In this episode of Data Exposed with Timi Oshin and Anna Hoffman, get an introductory demo to the Table Designer feature in Azure Data Studio, and how you can easily use it to create and manage full database schemas on a Graphical User Interface with no need for T-SQL knowledge.
Read More
How to Protect your sensitive data using Azure SQL DB | Data Exposed
In this episode of Data Exposed: SQL Insider Series with Manish Kumar and Anna Hoffman, Manish will show how to run through the most important and key security considerations for cloud databases. You’ll learn how the security features integrated within Azure SQL database can help you to achieve your compliance requirements and keep your sensitive […]
Read More
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