π’ DBA VUG β Part 3 of 4
π Dec 10 | 12β1 PM EST | Virtual
π€ Jordan Sassi β SQL Server DBA @ Boston Beer Co.
Topic: Dbachecks β Automate Your SQL Health Checks
β
PowerShell + Power BI
β
No prior experience needed
RSVP π www.meetup.com/dbavug/event...
#SQLServer #Dbachecks #DBAVUG #Automation
In a cliΓ«nt call this morning. Client asks about sql jobs because monitoring is hard. Introduced them to #dbatools #dbachecks. I saw a happy face. Thank you @robsewell.com for the amazing work on the checks and the people on all the tools (too many to tag)
I reconfigured the email system on my SQL Servers to support a forthcoming migration. The next day I had to fix my #dbachecks configuration because I forgot that it checks SQL Database Mail Profile names.
Tested on pwsh on Windows and Linux and on 5.1 and released to the PowerShell Gallery as a preview #dbachecks
All the props to @TracyBoggiano the CIS #dbachecks project is complete
Anybody interested in test driving the introductory @AzureDataStudio Notebooks for #dbachecks can find them here. You will need to have Docker installed and ADS obviously.
github.com/SQLDBAWithABeard/Present...
Doing this also means that there is a new #dbachecks version out there :-) Update-Module dbachecks Get-DbcReleaseNote -Latest www.powershellgallery.com/packages/dbachecks/1.2.2... Thank you to @TracyBoggiano
New Version of #dbachecks 1.2.15 www.powershellgallery.com/packages/dbachecks/1.2.1... New Default File Path check Update-Module dbachecks
Thank you for your contributions to #dbatools and #dbachecks Gareth, glad you changed your mind about PowerShell! twitter.com/gazeranco/status/1181614...
I love seeing things like this :-) #dbachecks
#dbatools in PowerShell in @AzureDataStudio SQL Notebooks for creating the containers and restoring the #dbachecks historical database for running queries in :-) Getting ready for presentation for #DataGrillen
Running #dbachecks in #AzureDataStudio against #dbatools docker containers :-)
#PowerShellInADSFTW
A new #dbachecks release hits the @ThePSGallery Update-Module dbachecks Released live at Yorkshire PowerShell User Group Thank you @cl www.powershellgallery.com/packages/dbachecks/1.1.1...
Tee Hee. I like to live on the edge.
Tonight, tired Rob will live release @cl PR for #dbachecks twitter.com/MikeyBronowski/status/10...
A new #dbachecks release 1.1.168 Update-Module dbachecks Get-DbcReleaseNote -Latest Thank you @SOZDBA and @jwmoss https://buff.ly/2RpWQUN
A new #dbachecks release Thank you @ClaudioESSilva Update-Module dbachecks www.powershellgallery.com/packages/dbachecks/1.1.1...
Love using the #dbachecks PowerBi dashboard with clients to automate Morning Checks "Hey look! My boss can really see the work that I have been doing this week and I can see where to focus my energy in the morning" PowerShell Automation FTW
#dbachecks π
A New #dbachecks release hits the @ThePSGallery Update-Module dbachecks
Get-DbcReleaseNote -Latest powershellgallery.com/packages/dbachecks/1.1.1... #powershell #sqlserver #pesterallthethings
A brand new release of #dbachecks hits the @ThePSGallery Update-Module dbachecks https://t.co/04GeVe2QFk Added Checks for CLR Enabled, Cross Database Ownership Chaining, Database Mail XPs, Ad Hoc Distributed Queries & Tag for security Released live at #PolarConf this am :-)
A new #dbachecks release 1.1.140 arrives Update-Module dbachecks www.powershellgallery.com/packages/dbachecks/1.1.1...
We had such fun presenting about #DbaChecks At #sqlgrillen Thank you for coming along.
With thanks to @fatherjack we now have two more checks in #dbachecks
Disk Allocation and CPU Prioritisation (which is set to not run by default)
This checks that the CPU is prioritised for Services and not UX
Update-Module dbachecks
www.powershellgallery.com/packages/dbachecks/1.1.1...
This makes me happy. All of the people who have contributed to #dbachecks deserve a huge amount of thanks for creating another useful open source tool
A new release of #dbachecks hits the PowerShell Gallery with a new check for trusted FKs by @ClaudioESSilva and better descriptions for the checks in Get-DbcCheck output
Update-Module dbachecks
www.powershellgallery.com/packages/dbachecks/1.1.1...
Now over 3000 downloads :-)
Ready for another day of #SQLDay Looking forward to presenting about #dbachecks on Sala A
New #dbachecks release - PowerBi order by failed by @ClaudioESSilva Reset-DbcConfig by @michalinwales and Configs matched to Checks in Get-DbcCheck www.powershellgallery.com/packages/dbachecks/1.1.1...
Another new release of #dbachecks going through the @vsts right now.
This one brings the ability to check job owners against an array of users instead of just one suggested by frank687
Please don't forget to
Update-Module dbachecks
to get all the latest goodness :-)
So pleased we can begin to start talking about this :-) #dbachecks is going to be another awesome open-source community driven PowerShell module for SQL DBAs twitter.com/psdbatools/status/950683...