Cláudio Silva

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

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

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

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

571 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,021 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

29 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,003 reads

Scripting SQL Server objects with dbatools – Beyond default options

• by Cludio-Silva

• Cláudio Silva

Probably you had the need to script out some objects from a SQL Server instance/database and this is quite easy. You just need to right click on the object...

2019-05-29 (first published: 2019-05-15)

831 reads

Access is denied – Using DTCPing utility between two Windows Server 2016

• by Cludio-Silva

• Cláudio Silva

Few days ago a client requested the configuration of MSDTC (Microsoft Distributed Transaction Coordinator). NOTE: If you want to know more about it here is a nice FAQ from...

2019-05-21 (first published: 2019-05-10)

1,179 reads

SSMS GUI not working? Try to use T-SQL!

• by Cludio-Silva

• Cláudio Silva

One of the good things, when we have new clients, is that sometimes they have needs that you never heard before. This does not necessarily mean that they are...

2019-04-11 (first published: 2019-03-29)

995 reads