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
Protect your data from tampering with Azure SQL Database ledger
Establishing trust around the integrity of data stored in database systems has been a longstanding problem for all organizations that manage financial, medical, or other sensitive data. Ledger is a new feature in Azure SQL and SQL Server that incorporates blockchain crypto technologies into the RDBMS to ensure the data stored in a database is […]
Read More
How to Exporting Azure SQL DB BACPAC file to Azure with Azure Automation?
In this episode of Data Exposed: SQL Insider Series, Mike Bhatt and Anna Hoffman take a look at leveraging Azure automation for exporting to a BACPAC file which can be stored in Azure blob storage or in local storage on premise-location.
Read More