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,348 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: )

1,704 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

350 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

4,649 reads

Blogs

Setting Up Always Encrypted

By

In this post we're going to go through the steps to set up Always...

Using Azure Automation and Runbooks to Run Azure SQL Database Maintenance Tasks

By

I’ve been using Azure SQL Database for quite some while and have set up...

Create and Verify Microsoft Fabric Capacity

By

From June 1, 2023, Microsoft Fabric (preview) capacities are available via the Azure portal....

Read the latest Blogs

Forums

how to determine if we can delete the index can be removed

By 892717952

In SQL Server database, there is a table InventDim with two indexes: Idx1 with...

how to determine if we can delete the index can be removed

By 892717952

In SQL Server database, there is a table InventDim with two indexes: Idx1 with...

how to determine if we can delete the index can be removed

By 892717952

The table InventDim has some indexes, we create one index idx1 which has index...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

Refresh Limits

See possible answers