Cláudio Silva

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

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

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

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

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

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

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

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

478 reads

Temporarily enable TLS 1.0/1.1? – Be sure you check this keys

• by Cláudio Silva

• Cláudio Silva

There are some actions that we know that will have to be repeated from time to time, but the surprise comes when it’s time to do so and the...

2020-02-07 (first published: 2020-02-04)

1,044 reads

More PowerShell Remoting coverage in dbatools

• by Cláudio Silva

• Cláudio Silva

Starting on dbatools version 1.0.31 we introduced better coverage for commands that make use of PowerShell Remoting. Which commands? Commands like Get-DbaComputerCertificate, Get-DbaPrivilege, Get-DbaClientAlias, just to mention a few...

2019-08-29 (first published: 2019-08-20)

661 reads