SQLServerCentral Article

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). […]

4.8 (5)

You rated this post out of 5. Change rating

2021-11-01

3,618 reads

SQLServerCentral Article

Implement Azure SQL Elastic Jobs with PowerShell

In this article, I will work you through the process of creating elastic jobs in Azure using PowerShell. The elastic jobs are similar to regular agents jobs in SQL Server although they add extra functionality like for example dedicated target groups that can be used in the job step level. Currently, the elastic jobs are […]

5 (2)

You rated this post out of 5. Change rating

2021-06-21 (first published: )

2,003 reads

SQLServerCentral Article

How to Restore an Agent Job that was Dropped

Once upon a time, you had one job, well actually two jobs. The first SQL Server agent job was important, the other was a test. You have decided you do not need the test agent job. Quick right-click on a job name, remove, confirm, done. When you refreshed the list, the test job was still […]

You rated this post out of 5. Change rating

2021-02-02

585 reads

SQLServerCentral Article

How to Restore an Agent Job that was Dropped

Once upon a time, you had one job, well actually two jobs. The first SQL Server agent job was important, the other was a test. You have decided you do not need the test agent job. Quick right-click on a job name, remove, confirm, done. When you refreshed the list, the test job was still […]

5 (5)

You rated this post out of 5. Change rating

2021-02-02

6,744 reads

Blogs

Speaking at the NYC Lunch and Learn DevOps Devour Hour

By

This Friday is the NYC DevOps Devour hour, which is actually 3 hours. Plus...

What’s new in SQL Server 2025 CTP 2.0

By

Three years ago, when the first public preview of SQL Server 2022 (CTP 2.0)...

Monday Monitor Tips: Beyond SQL Server

By

Redgate Monitor works with more than SQL Server. Some big changes were announced recently,...

Read the latest Blogs

Forums

SQL 2022 upgrade issues

By Lapchien

We're about to upgrade our SQL 2017 Standard to 2022 standard.  We have 1...

Script-Drop Orphan users from SQL Server Database

By Srinivas Merugu

Comments posted to this topic are about the item Script-Drop Orphan users from SQL...

The Hidden Cost of Ignoring Software Bugs

By danishtariq1

Every expert knows you can't make perfect software that never crashes or has bugs....

Visit the forum

Question of the Day

The Minimal Linked Server

What is the minimal number of parameters to add a linked server with sp_addlinkedserver?

See possible answers