If you are running SQL Server in an Azure VM, or are using Azure SQL Managed Instance, you can use the Agent but may have needs that are beyond its scope. Here's an example from one of our clients.

Joey on SQL Server. Top Tips To Make SQL Server Run Faster on Azure VMs. Storage and performance can be quite different in the cloud. It's important to choose the right VM size and configure your ...

The Azure SQL Database has always been similar to SQL Server, but, with Managed Instances (released in preview at Build), developers can now move applications to use Azure SQL Databases with no ...

To query any SQL database from PowerShell, you need to have the SQLPS module installed along with a few supporting packages. I am going to be focusing on the SQL Server 2012 packages in this article.

About 5,500 of the SQL Server faithful came out for the PASS Summit 2018 in Seattle last November. As usual, the event had the feel of a great big family reunion. It's always a fun time, with lots of ...

Microsoft today released SQL Server 2022, the latest version of its database software, which originally launched more than 33 years ago.Microsoft describes this release as the “most Azure ...

If you are an old hand at Microsoft SQL Server, you have probably used the SQL Server Agent (i.e., SQL Agent) service and MSDB database for the last 20 years. With a humble and largely unchanged ...

In Azure SQL Database you can also set a HISTORY_RETENTION_PERIOD (and should be able to do it in SQL Server 2017) to control how far back in time your history will extend. Converting Existing Table ...

Q&A. Get Started Using .NET Aspire with SQL Server & Azure SQL Database. By David Ramel; 01/23/2025; Microsoft unveiled .NET Aspire at the Build 2024 developer conference, describing it as an ...

Azure will default to the Standard pricing tier, but if you want to consider adding a higher-performance server for your SQL database, click the arrow to reveal Figure D. The basic pricing tier ...