Cláudio Silva

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

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

108 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

8 reads

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)

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

521 reads

Replicate permissions to new Login/User with dbatools

• by Cláudio Silva

• Cláudio Silva

Continuing to share tips and tricks using dbatools like the Refresh databases that belongs to availability group using dbatools posted a few days ago, today I will share a...

2020-06-12 (first published: 2020-05-28)

447 reads

Export Deadlocks to file from system_health Extended Event using PowerShell

• by Cláudio Silva

• Cláudio Silva

Just a quick post as may help any of you searching for this. Scenario Client wants to analyze most recent deadlocks that happened on a specific instance. They asked...

2020-06-09 (first published: 2020-05-25)

354 reads

Refresh databases that belongs to Availability Group using dbatools

• by Cláudio Silva

• Cláudio Silva

Few days ago I was surfing on Twitter when dbatools asked about how it’s PowerShell module changed the way people work. We're looking to highlight how dbatools has changed...

2020-06-03 (first published: 2020-05-20)

508 reads

T-SQL Copy & Paste Pattern – Increasing a performance problem

• by Cláudio Silva

• Cláudio Silva

Disclaimer: The title is my assumption because I saw it in the past happening this way. This blog post aims to make you remember something: something that is obvious...

2020-02-26 (first published: 2020-02-21)

766 reads

Change Outlook sender mailbox with PowerShell – A workaround

• by Cláudio Silva

• Cláudio Silva

The idea of this blog post, like many others I write, is to document a workaround solution to my problem. Hopefully I can also help someone that may be...

2020-02-21 (first published: 2020-02-12)

677 reads