dbatools - new functions for Database Mail

Background The dbatools module is broadly used and is an ever-growing set of useful commands. While looking for some inspiration I checked the old issues logged on the GitHub repository. Finally, I found this one Remove-DbaDbMail Profile and Account · Issue #4990 · sqlcollaborative/dbatools (github.com). The issue was more than 2.5 years old (32 months). […]

Build and Automate a SQL Server Status Report on Server Restart or Scheduled

Do you know when a SQL Server instance restarts? When you manage many SQL Server instances you may not know when one restarts, so having an automated report emailed to you could be helpful to get an idea what's going on for that instance.

Sending table form HTML emails from a SQL Server database engine

The solution which helps to smiplify delivery of a table content in the HTML form using Database mail

Purging Old Database Mail Items

Are you purging the old database mail items stored in msdb? In this tip, Greg Larsen shows you how to purge database mail.

What Mail Items Have Been Sent With Database Mail

Have you ever wondered how much database mail you have sent in the past day or week? What about those database mail items that were not successfully sent. In this tip, Greg Larsen shows you how to review the database mail items that have been processed by SQL Server.

SP Send Query Result as HTML table using DBMail

Create a stored procedure that will send the result of a query as an html table from the database mail.

Changing database mail account SMTP servers

This will generate a script that drops and recreates existing db mail accounts and change the smpt server.

Have you configured Database Mail to utilize multiple SMTP Accounts ?

Lets start discussing about this subject by closely looking at the term Redundancy.  What is redundancy all about ?
Wikipedia defines redundancy as “In engineering, redundancy is the...

Enable Database Mail in 2012

MSDB Tables/Views