Cláudio Silva

Who doesn’t like a good red and verbose exception? At PowerShell community we often call it a “sea of red” which we found as something that can be intimidating....

2022-06-27 (first published: 2022-06-07)

339 reads

dbatools - Rich Datatypes

by Cláudio Silva

Cláudio Silva

Some datatypes can be shown in so many different forms (think measurament units, dates with short/long forms, or regional settings) that can be difficult to have a standard. What...

2022-06-13 (first published: 2022-06-02)

278 reads

A (big) SQLPackage caveat

by Cláudio Silva

Cláudio Silva

Context I had a request to help with a database from a third-party vendor which uses a lot of FullText-Search (FTS) catalogs. I have to say that I just...

2021-12-29

7 reads

Recover database encrypted modules code with dbatools

by Cláudio Silva

Cláudio Silva

This article was initially posted on SQLServerCentral @ 2020-08-18. It was interesting some comments I read about it, mainly why people still use WITH ENCRYPTION when it's simple to...

2020-09-22

20 reads

When one of your DBA colleagues leaves the company, what is your checklist?

by Cláudio Silva

Cláudio Silva

Whether it’s in our personal lives or the professional one, we do have checklists for certain tasks. On the professional level, it can be purely technical like SQL Server...

2020-09-03

3 reads

Generate SQL Server Role Member Reports using dbatools and ImportExcel PowerShell modules

by Cláudio Silva

Cláudio Silva

This was initial posted on SQL Server Central articles. As one of dbatools' first members, I've been using it for years and it's really my goto tool. This task...

2020-07-31

160 reads