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
SQL Querying for Beginners Tutorial
-
Frank
- January 7, 2022
- connect to SQL database
- elearning SQL
- free SQL training
- free SQL tutorial
- how to use SQL
- installing SQL server
- learn sql
- query
- SQL
- SQL data
- sql database
- SQL export
- SQL expressions
- SQL functions
- SQL guide
- SQL joins
- SQL keyword command language
- SQL programming language
- SQL query
- SQL querying data
- SQL range of values
- SQL scripting
- SQL Server
- SQL Server 2019
- SQL server substring
- SQL statement
- SQL table variable
- SQL tips and tricks
- sql tutorial
SQL Querying for Beginners Tutorial
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