SQL Server

Azure SQL Blockchain SQL Server

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
Azure SQL SQL Server

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 Server

System Page Latch Concurrency Enhancements (Ep. 6) | Data Exposed

The Concurrent GAM Updates feature in SQL Server 2022 adds the concurrent GAM and SGAM updates With GAM and SGAM contention being addressed, customer workloads will be much more scalable and will provide even better throughput.

Read More
Data SQL Server

SQL Server 2022 Storage Engine Capabilities

In this episode of Data Exposed with David Pless and Anna Hoffman, take a walk through a quick overview of the storage engine improvements that improves performance and scalability such as tempdb improvements, advances in capacity management and maintenance, and enhancements to SQL Server scalability for systems with large memory and processing power.

Read More
Azure SQL Server

How to Leverage Centrally-managed Azure Hybrid Benefit to Save Money, Manage Cost and Stay Compliant

Centrally-managed Azure Hybrid Benefit provides the billing administrators with a tool to manage the software costs of SQL Server applications on Azure for a subscription or the entire billing account. They can track their license utilization, increase or reduce the license assignments for the selected scope as needed without any risk of compliance violation. Watch […]

Read More
Azure Synapse SQL Server

How to Export your SQL Server data and Upload to Azure Storage

Learn how to use the bulk copy program utility (BCP) to export your SQL Server data and upload to Azure Storage.

Read More
SQL Server

Azure SQL VM: Optimally Configure SQL Server on Azure Virtual Machines with SQL Assessment

Wouldn’t it be great if there was a way to learn if your SQL Server on Azure Virtual Machines was configured optimally? Do you have the right options set? Do you have your tempdb on the right disk? Can your queries perform better? All these and more can be answered using the new Azure portal […]

Read More
Azure SQL SQL Server

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
Data SQL Server

Intelligent Query Processing in SQL Server 2022

SQL Server 2022 introduces new ground-breaking query performance enhancements under the Intelligent Query Processing family. 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! Join us to find out what’s coming next in this new intelligent […]

Read More
Data SQL Server

How to Use Citus to Shard Postgres, for Performance & Scale | Data Exposed

If you’re looking to scale your Postgres database, the Citus open-source extension to Postgres makes sharding simple. And Citus is available on Azure as a managed service, too. Join Claire Giordano on the Citus team to learn about how Citus uses the Postgres extension APIs to shard Postgres—and the best way to get started with […]

Read More