• Posts
    SQL Server PowerShell
  • About

Cláudio's Blog


SQL, PowerShell, and more from a SQL Server DBA

dbatools v1.0? It's available - Check it out!

Posted on June 19, 2019

Dear reader, before continue please open a PowerShell console and run the following command: Install-Module -Name dbatools [Read More]
Tags: community Contribute dbatools PowerShell SQLServer syndicated

'Ups...I have deleted some data. Can you put it back?' - dbatools for the rescue

Posted on May 17, 2019

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 the job! [Read More]
Tags: Copy Data dbatools PowerShell Scripting SMO SQLServer syndicated T-SQL

Scripting SQL Server objects with dbatools - Beyond default options

Posted on May 15, 2019

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 (well…not on every single one, try it with an Availability Group :-), no script option available) select “Script XXXX as” and... [Read More]
Tags: Automation dbatools PowerShell Scripting SMO SQLServer syndicated T-SQL

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

Posted on May 10, 2019

[Read More]
Tags: Access is denied Cluster Documentation Firewall MSDTC RPC Rules SQLServer syndicated Windows Server 2016 WSFC

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

Posted on March 29, 2019

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 complex. As a matter of fact, they can be really simple..now the question is..are they doable? :-) [Read More]
Tags: Agent Documentation Schedule SQLServer SSMS syndicated
  • ← Newer Posts
  • Older Posts →
  • RSS
  • GitHub
  • Twitter
  • LinkedIn

Cláudio Silva  •  2022

Theme by beautiful-jekyll