SQL Server

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

Brent Ozar Answers Your Questions About SQL Server from Reykjavik Harbor

The one and only Brent Ozar answers your SQL Server questions about SQL Server from Reykjavik Harbor.

Read More
Linux SQL Server

SQL Server on Linux Storage Secrets

SQL Server object disks on Windows Server can be expanded at any time with no issues, but Linux doesn’t quite work like that by default. In a situation where you run out of space, you’re out of luck, unless you know some secrets about Linux. The mysterious Linux Logical Volume Manager must be used before […]

Read More
Data SQL Server

Understanding the Benefits of Intelligent Query Processing

In this episode of Data Exposed, Kate Smith will take you through the basics of why query processing matters, what it does, and how Intelligent Query Processing makes your workloads faster and more efficient. Resources: The Positive Impact of Intelligent Query Processing – Microsoft Tech Community Intelligent query processing in SQL databases

Read More
Azure SQL SQL Server

Storage 101 for Azure SQL and SQL Server Engineers

Learn how storage impacts the performance of your database solution. In this episode with MVP Argenis Fernandez, go over the basics of I/O, what the different access patterns are for the database engine and how to tell when there is an issue with underlying storage for your database. Resources: Argenis’ blog on IO Block Size […]

Read More