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
How to Create Elastic Jobs in Azure SQL Database Using PowerShell
In this episode of Data Exposed, Kate Smith walks us through the process of how to create Elastic Jobs for Azure SQL using PowerShell.
Read More
The A to S of Azure Data Studio
With Azure Data Studio turning 3, it is maturing quite well. Azure Data Studio is a game-changer for all Data Professionals. Join Warwick Rudd as he shows you what Azure Data Studio has for Data Professionals and why it makes it easier for you to do your job.
Read More