Replicate permissions to new Login/User with dbatools

• by Cludio-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-05-28

6 reads

Export Deadlocks to file from system_health Extended Event using PowerShell

• by Cludio-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-05-25

6 reads

Refresh databases that belongs to Availability Group using dbatools

• by Cludio-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-05-20

90 reads

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

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

743 reads

Change Outlook sender mailbox with PowerShell – A workaround

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

401 reads

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

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

670 reads

More PowerShell Remoting coverage in dbatools

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

636 reads

Allow SQL Server Agent jobs management for non sysadmins

• by Cludio-Silva

• Cláudio Silva

I don’t know about your experience when it comes to SQL Server Agent jobs but often I receive requests to grant permission so that clients can handle their jobs...

2019-08-22 (first published: 2019-08-13)

1,125 reads

dbatools v1.0? It’s available – Check it out!

• by Cludio-Silva

• Cláudio Silva

Dear reader, before continue please open a PowerShell console and run the following command: If you are doing this on the date of this blog post, you have just...

2019-06-19

39 reads

“Ups…I have deleted some data. Can you put it back?” – dbatools for the rescue

• by Cludio-Silva

• Cláudio Silva

Few days ago I received a request to restore a dozen of tables because someone have deleted more data than it was supposed. I immediately thought about dbatools for...

2019-06-04 (first published: 2019-05-17)

1,035 reads