More PowerShell Remoting coverage in dbatools

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 of them, make use of the internal function Invoke-Command2 which uses New-PSSession when we run it against a remote computer. "Why have you changed it?" Let … Continue reading More PowerShell Remoting coverage in dbatools

Allow SQL Server Agent jobs management for non sysadmins

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 in an autonomous way. Any problem with that? It depends 😄 If you're not familiarized with the difficulty this can bring, let me share with you … Continue reading Allow SQL Server Agent jobs management for non sysadmins

“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! NOTE: I also thought about SSMS "Import/Export Data". And this is ok when someone says "it's to run just once, just now". When you … Continue reading “Ups…I have deleted some data. Can you put it back?” – dbatools for the rescue

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 you have it. But have … Continue reading Scripting SQL Server objects with dbatools – Beyond default options

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

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 Microsoft blogs - MSDTC Recommendations on SQL Failover Cluster? The client has 2 machines: one an application server and one a database server. Both run on … Continue reading Access is denied – Using DTCPing utility between two Windows Server 2016

SQL Server Operations Studio and VSCode: The wrong default datetimeoffset format

This post is to answer the question: "You are used to seeing in the format of yyyy-MM-dd right?" that I have raised on my blog post Don’t cutoff yourself with dates in T-SQL – Did you know…. As you could see from that blog post, my screen shots were from VSCode and in this case … Continue reading SQL Server Operations Studio and VSCode: The wrong default datetimeoffset format

Triggers: The hidden logic that will strike back – TSQL Tuesday #106

This month’s T-SQL Tuesday is brought by Steve Jones (b | t) and he wants to know if triggers causes headaches or happiness to us. This is the 106nd edition of TSQL2sDay - an Adam Machanic (b | t) brainchild.   Triggers are those kind of database objects that sometimes are the best bet but … Continue reading Triggers: The hidden logic that will strike back – TSQL Tuesday #106

I will be speaking @ SQLSaturday #795 Porto

On 29th September we will have SQL Saturday Porto and I’m proud to announce that I will be speaking! I will be speaking about dbachecks PowerShell module - dbachecks - Checking SQL Server environments with PowerShell. The event will be held at ISEP, Rua Dr. António Bernardino de Almeida, 431, 4249-015 Porto, Portugal and you … Continue reading I will be speaking @ SQLSaturday #795 Porto