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
How to Backup and Restore your Azure Database for MySQL – Flexible Server workload
Backup and restore is the cornerstone for any enterprise’s business continuity and disaster recovery plans. The backup functionality offered by Azure Database for MySQL Flexible Server serves as a doomsday vault safeguarding your data. On the other hand, the restore functionality serves as a life jacket protecting from accidental data deletions and data corruption. In […]
Read More
Seven tips in seven minutes for the SQL Developer | Data Exposed: MVP Edition
Come learn seven quick tips that will make you a better SQL developer in this episode of Data Exposed: MVP Edition with Anna Hoffman and Ike Ellis. Whether you use SSMS or Azure Data Studio, you will find value in this session. In seven minutes, you’ll learn tips to be a more productive developer.
Read More