dbatools

SQLServerCentral Article

dbatools - new functions for Database Mail

  • Article

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)

2021-11-01

3,146 reads

SQLServerCentral Article

Implement Azure SQL Elastic Jobs with PowerShell

  • Article

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)

2021-06-21 (first published: )

1,433 reads

SQLServerCentral Article

Generate Role Member Reports using dbatools and the ImportExcel PowerShell modules

  • Article

Being able to get information and save it on a Excel as a report can be a common and tedious task. What if we could join dbatools and ImportExcel PorwerShell modules to accomplish this in a easier and fast way? We will see how to export roles and its' member and save that info on a multi spreadsheet Excel file with handy tables ready to be explored.

5 (2)

2020-06-30

5,179 reads

Blogs

The book that made me love goal-setting

By

Pete Wilkinson’s book “Unstoppable” finally made visualizations and goals make sense to me. Here's a...

Daily Coping 16 Aug 2022

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

SQL Server Query Tuning and Optimization by Benjamin Nevarez

By

I was recently asked to review SQL Server Query Tuning and Optimization by Benjamin...

Read the latest Blogs

Forums

How to use PowerShell to set secure SA passwords for bulk servers

By Vincent92

Comments posted to this topic are about the item How to use PowerShell to...

Substitute 0 and 1 values in 1 column

By pedroccamara

Hello everyone, Hi have this column named Sex and it only has value 0...

Finding difference in two databases/tables

By yrstruly

I have compared two tables with the same data in two different databases(aslo the...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers