Azure SQL August 2023 AMA
Get the latest August news and updates in the world of data and join us for an “Ask Me Anything” with Anna Hoffman and guest speakers.
Read More
What’s new in SQL Server Data Tools (SSDT)?
The latest version of SQL Server Data Tools (SSDT) [Version 17.6 GA] was released in May 2023. In this episode of Data Exposed with Anna Hoffman and Subhojit Basak, they’ll highlight the latest features that are being added to SSDT and give a sneak peek on the features coming next.
Read More?){kind=link}
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
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
With SQL Server 2012/2008/2008R2 Reaching End of Support, What are Customers Options Now 
In this episode of Data Exposed with Anna Hoffman, Logan Carrington, and Perry Skountrianos, we discuss the end of support for SQL Server 2012 as of July 12, 2022 and what your options are as you migrate and modernize your existing workloads for your business environment.
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 News Update | Data Exposed Live @SQLBits 2022
In this session, join the live audience of a session that is being live-streamed from SQLBits 2022. Receive the latest updates containing all things SQL Server and Azure SQL.
Read More