2024-07-01
369 reads
Database Mail
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). […]
2021-11-01
3,631 reads
Enable SQL Server Agent Mail Profile
Learn how to configure SQL Server Agent to allow emails to be sent for job notifications and alerts.
2019-05-06
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.
2018-05-24
3,084 reads
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
2018-01-29
6,948 reads
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.
2017-09-21
3,011 reads
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.
2017-09-11
3,430 reads
Changing database mail account SMTP servers
This will generate a script that drops and recreates existing db mail accounts and change the smpt server.
2013-07-08 (first published: 2013-06-19)
797 reads
2012-11-07
2,033 reads
2012-03-06
2,300 reads
Blogs
AZ-900: Microsoft Azure Fundamentals – The Ultimate Beginner’s Guide to Cloud Mastery
By Rohit Garg
In an era where cloud computing drives innovation, understanding its fundamentals is no longer...
Moving to Rancher Desktop
By Steve Jones
I’ve been very happy with Docker Desktop for years, running it on both laptop...
Logging in Azure Data Factory data flows
By Rayis Imayev
(2025-June-15) Long gone are the days when a data engineer could simply focus on building...
Forums
Tracking changing prices and recalculating inventory value
I'm trying to figure out a how to do average costing over time in...
What is Between?
Comments posted to this topic are about the item What is Between?
Inside the Walls of Azure SQL MI
Comments posted to this topic are about the item Inside the Walls of Azure...
Question of the Day
What is Between?
I have a table of products in SQL Server 2022. There are sequential items in the table with ProductIDs of 1, 2, 3, 4, 5, 6, 7, 8, 9, 10. If I run this code, how many rows are returned?
SELECT * FROM dbo.Products WHERE ProductID BETWEEN 4 AND 7;See possible answers