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,504 reads
Learn how to configure SQL Server Agent to allow emails to be sent for job notifications and alerts.
2019-05-06
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
The solution which helps to smiplify delivery of a table content in the HTML form using Database mail
2018-01-29
6,654 reads
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
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
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)
745 reads
2012-11-07
2,026 reads
2012-03-06
2,293 reads
Use Powershell and SMO to quickly and easily enable and configure database mail in nine steps.
2011-08-15
5,516 reads
By Will Assaf
I recently reviewed, worked on, and added a similar example to the DATETIMEOFFSET Microsoft...
Database administrators (DBAs) are the backbone of data-driven organizations. If you're looking to break...
By Brian Kelley
Another security fundamentals topic is authentication versus authorization. For those who have a clear...
I have a SQL Server 2019 Enterprise Edition on CU 25. It has in-memory...
Experts, I am learning some skills so I can troubleshoot some performance-related issues. I...
What happens when I run this code:
SELECT p.ProductName , p.ProductCategory FROM dbo.Product AS p WITH (NOLOCK, TABLOCK);See possible answers