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
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
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
Real-world Demo of Microsoft Intelligent Data Platform
-
Frank
- August 18, 2022
- Analytics
- Azure
- azure active directory
- azure purview and power bi
- azure purview data governance
- azure sql database
- Azure Synapse
- Azure Synapse Link
- built in AI
- Cloud Defender
- cosmos db
- database
- Governance
- intelligent data governance
- intelligent data platform
- intelligent data services
- Machine Learning
- Microsoft Sentinel
- Power BI
- power bi data modeling
- power virtual agent
- predictive AI
- SQL
- SQL Server
- Synapse
- Synapse Analytics
Sharieff Mansour, a leader on the Data and AI team at Microsoft, joins Jeremy Chapman for a closer look at how databases, analytics, machine learning, and governance come together in the Intelligent Data Platform. See how you can use these integrated services to build powerful new apps or modernize your current ones.
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
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
Azure SQL & SQL Server 2022: Intelligent Database Futures
Azure SQL DB and SQL Server introduced ground-breaking query performance enhancements under the Intelligent Query Processing family in the past few years. These make up the latest on Microsoft’s mission to make critical parallel workloads improve when running at scale while remaining adaptive to the constantly changing world of data! Learn more in this episode […]
Read More
How to Use Azure Monitor Metrics to Track VM Cache Health
Azure Monitor is a technology used to collect telemetry data from your Azure and on-premises environments. You can use Azure Monitor to improve performance and support the stability of your applications by identifying issues quickly. Azure Monitor includes Azure Metrics and Azure Logs to store telemetry data and track data in real-time and for historical […]
Read More
How Azure SQL Enables Real-time Operational Analytics (HTAP) – Part 1
Azure SQL enables hybrid transactional/analytical workloads for real-time operational analytics scenarios through a mix of in-memory and columnar database technologies. In the first episode of this three-part series with Silvano Coriani, explore Azure SQL capabilities to run a mix of transactional and analytical queries on the same underlying data store.
Read More%20–%20Part%201){kind=link}
How to Troubleshoot Elastic Jobs in Azure SQL Database
In the final episode of this six-part series with Kate Smith, she walks us through some basic troubleshooting tasks related to Elastic Jobs in Azure SQL Database.
Read More