Cláudio Silva

dbatools - Exceptions

• by Cláudio Silva

• 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)

31 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)

257 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

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

14 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

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

141 reads

TSQL Tuesday #127 – Non SQL Tips and Tricks – Windows

• by Cláudio Silva

• Cláudio Silva

This month’s (#127) T-SQL Tuesday is brought by Kenneth Fisher (B | T) and he asked about Non SQL Tips and tricks. As a Windows user I know there...

2020-06-09

12 reads

TSQL Tuesday

• by Cláudio Silva

• Cláudio Silva

This month’s (#127) T-SQL Tuesday is brought by Kenneth Fisher (B | T) and he asked about Non SQL Tips and tricks. As a Windows user I know there...

2020-06-09

Backup your SQL instances configurations to GIT with dbatools – Part 2 – Add parallelism

• by Cláudio Silva

• Cláudio Silva

We have seen how we can export and save the results to a folder and commit them to a GIT repository on my last blog post Backup your SQL...

2020-06-22 (first published: 2020-06-04)

351 reads

Backup your SQL instances configurations to GIT with dbatools – Part 1

• by Cláudio Silva

• Cláudio Silva

Today I want to share how I’m keeping a copy of instances’ configurations using dbatools. Chrissy LeMaire (B | T) wrote about it before on the Simplifying disaster recovery...

2020-06-15 (first published: 2020-06-02)

634 reads