This is a brief post about how to fix "The certificate chain was issued by an authority that is not trusted" error when using @dbatools

https://vladdba.com/2023/07/29/fix-certificate-authority-that-is-not-trusted-when-using-dbatools

#sqlserver #dba #mssqlserver #mssql #sqlserverdba #powershell #dbatools

First thing I do nowadays when I get access to a SQL Server. Add my SQL instances to Registered Servers then:

Get-DbaRegServer | Export-DbaInstance

This will export a bunch of objects including logins, jobs, database backup scripts, sp_configure, server roles, database mail and more #SQLServer #PowerShell

Looking at SQL Server on Linux? I have a few posts on setting up availability groups with pacemaker....

Check them out: -

https://dbafromthecold.com/2021/12/01/building-a-pacemaker-cluster-to-deploy-a-sql-server-availability-group-in-azure/

https://dbafromthecold.com/2022/11/03/creating-a-stonith-resource-for-a-pacemaker-cluster-on-vmware-virtual-machines/

https://dbafromthecold.com/2022/12/01/creating-a-user-for-a-stonith-resource-in-vsphere/

#sqlserver #linux

Get-DbaAgentJob -sqlinstance $sqlinstance |
? nextrundate -lt $(get-date).addminutes(15) |
? nextrundate -gt $(get-date) |
select name, nextrundate

#Powershell to show what #sqlserver agent jobs are running in the next 15 minutes, using the #dbatools module

🎊Launch Party!🎊

Join Andreas & Michael Wittig for an #AWS party.

May 2nd, tune-in to discover the story behind the book & enter a raffle to win a free copy of AWS in Action!

@andreas @michael #serverless #amazonwebservices #cloudcomputing

https://www.youtube.com/watch?v=LAEQ4_TlGu0&ab_channel=cloudonaut