Dear reader, before continue please open a PowerShell console and run the following command:
Install-Module -Name dbatools
[Read More]
'Ups...I have deleted some data. Can you put it back?' - dbatools for the rescue
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]
Scripting SQL Server objects with dbatools - Beyond default options
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]
Access is denied - Using DTCPing utility between two Windows Server 2016
SSMS GUI not working? Try to use T-SQL!
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]