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
SQL Insider Series: Restoring a backup from LTR in Azure SQL DB | Data Exposed
In this episode of Data Exposed: SQL Insider Series, Laura Grob and Anna Hoffman will take a look at how you can restore an Azure SQL DB database from the long-term retention (LTR) backups when the logical server and online database have been deleted.
Read More
Azure SQL April 2022 New Updates
Get the latest April news and updates in the world of data with Anna Hoffman, Cheryl Adams, Claire Giordano, Marisa Brasile, and Abhiman Tiwari.
Read More
SQL 911: A DBA’s Guidebook using Notebooks in Azure Data Studio
Did you know that Jupyter Notebooks can help you manage your SQL Server enterprise no matter how large or small? In this episode of Data Exposed, Kevin Warren demo’s a Jupyter Notebook in Azure Data Studio that was created to be a DBA’s handbook of resources, knowledge, code, troubleshooting tips, and step-by-step examples on how […]
Read More