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)

You rated this post out of 5. Change rating

2021-11-01

3,349 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)

You rated this post out of 5. Change rating

2021-06-21 (first published: )

1,707 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)

You rated this post out of 5. Change rating

2020-06-30

5,686 reads

Blogs

Parameter Sensitive Plan Optimization in SQL Server 2022. What is it and is it any good?

By

Parameter Sensitive Plan (PSP) optimization is a new feature in SQL Server 2022 that...

Azure chaos STUDIO

By

Chaos engineering is fun but especially important when building solutions in the cloud. It...

Announcing a New Book on SQL from 3Cloud Authors

By

I am proud to announce the launch of a new book, centered around the...

Read the latest Blogs

Forums

Azure DW default schema in a query / proc equal to "Search_Path" in AWS

By digdave7

I know you can't do this in MSSQL, but hoping DW has progressed more....

Call SQL Agent job using different account to one executing powershell

By Dave D

Hi Folks trying the below but having zero luck and was wondering if anybody...

Encrypt Varchar(max) column in SQL Server

By SatishAyyar

I have a varchar(max) column which has sensitive data and want to encrypt it....

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers