Community driven SQL Server PowerShell module. Works on Windows, Linux and Mac.
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
My latest blog on Parameter Sensitive Plan Optimization in SQL Server 2022 is up at https://www.sqljared.com/blog/parameter-sensitive-plan-optimization/. My next post will be on this subject as well, discussing an issue that may affect your Query Store scripts! #sqlfamily #sqlblog
Install-DbaMaintenanceSolution now supports auto-scheduling Ola Hallengren's agent jobs! Read more on @cl's blog #dbatools #sqlserver #powershell https://blog.netnerds.net/2023/05/install-dbamaintenancesolution-now-supports-auto-scheduling/
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/2022/12/01/creating-a-user-for-a-stonith-resource-in-vsphere/
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
After 5 months of hard work, #dbatools 2.0 is finally here! Tons of improvements (and a few breaking changes). You can read more on GitHub #PowerShell #SQLServer
Today I've been playing around with the @dbatools PowerShell module. Whilst the native SQLServer module can do a lot, dbatools takes it to another level
@richinsql k! Should be working again. Thanks for the notification.
@richinsql we’ll fix it! One moment please
Beware of transient IDisposables in the #dotnet DI container! https://github.com/dotnet/runtime/issues/36461 Let's just say that the next version of #PowerShell Universal won't be so leaky....
Speaking tonight (in about 4 hours) online about @dbatools
https://www.meetup.com/southampton-data-platform-and-cloud-group/
Thanks @dbatools for this writeup (https://blog.netnerds.net/2022/11/alias-mastodon-github-pages/) on setting up an alias to Mastodon via GitHub Pages. Now anyone can find me at @shellsharks! Cool stuff.
After presenting about #PowerShell for #Oracle #DBAs at the #DOAG2022 in september, I recorded a video about that topic in english. As it has reached more than 50 views, let my share the link: https://www.youtube.com/watch?v=tEcc05YlKsY&ab_channel=AndreasJordan
I published a new release of HardeningKitty 🚀😺
It is now official a PowerShell module, for all other changes see https://github.com/0x6d69636b/windows_hardening/releases/tag/v.0.9.0
I've been migrating some jobs, logins, databases recently at work and I know I've said it before but @dbatools is the best!
It makes this stuff SOOO easy!
Hey friends, I have a BIG CHRISTMAS SURPRISE for you! Yes, it's a holiday miracle, a Podcast with @nova! Enjoy and boost: https://www.hanselminutes.com/872/hachyderms-kris-nova-on-running-a-mastodon-server
@claudioessilva @Jpomfret @dhmacher @bweissman @robsewell Happy birthday, Beard! 🎊
Help Wanted: #dbatools 2.0 https://github.com/dataplat/dbatools/discussions/8696
