Get acquainted with SQL Server configuration tasks so that you can configure a Database Engine instance to meet performance and availability requirements. When a database is deployed into production ...

Remarks The stored procedure sysmail_help_configure_sp lists the current Database Mail configuration settings for the instance. When a @parameter_name is specified, but no output parameter is provided ...

I want to enable notifications for SQL Agent for my backup jobs.I configured database mail and that works, it sent me a test message.However, when I go to tell the SQL Agent to use it, it sees ...

When configuring the SQL Server for remote access, you must allow certain ports and programs through the firewall to ensure clients can connect to the database securely. Before we begin, make sure you ...

Part of the SQL Server 2022 blog series. We are excited to share that there are several Accelerated Database Recovery (ADR) enhancements in SQL Server 2022 that further improve the overall ...

Do you need to find out where the location of your SQL Server's database is? Here's a quick tip.

Today we’re announcing the release of SQL Server Management Studio (SSMS) 18.3. For this update, while we added some features, our focus was primarily on fundamentals such as stability, reliability, ...