Recently in one of our server row count in MSDB.DBO.SysJobHistory table exceeded 100 Million and looking at job history was slow via SSMS. It was impossible via the GUI. Because we had about 50 jobs that were running frequently (called from a listener mostly once in every 2 to 3 minutes). I was curious if […]
Recently at my work due to low free space on a LUN I was forced to rebuild few indexes on a different filegroup (which resides on a different LUN). I wanted to list all user objects belong to a single filegroup including size. I did not find a query online with everything I needed. So […]
We started collecting a count of all VLF across the enterprise and yes there were few with high counts. I know there are no SET guidelines on how many is too low or too high. After chatting with MVP Allen Kinsel (Blog|Twitter) and Kevin Conan (Twitter) I decided to fix using this threshold. You will […]
While troubleshooting unplanned SQL cluster failover few questions are asked commonly. When did the last failover occur? How frequently you failover (planned and unplanned)? Did this happen recently? All these questions can be answered by this query. Your output will depend on how frequently you recycle error log and retention of the error log. You […]
Database backup is one of the regular tasks DBA’s perform but few explore all the options that are built in the product. Instead of exploring and using built in switches I noticed DBA’s try writing custom scripts or buying third party tools. I explored some of the options and was able to do a full […]
Check out this awesome lineup of #speakers for #COVID19 fundraiser Lightup Virtual Conference! Register now: ... https://2020twenty.net/lightup/ cc @thetechplatform @mitul_rana @jpomfret @SQLStad @SqlWorldWide @yashkamdar391 @PabloJavier911 @darkicebeam @PabloDiLoreto
Folks, I'm excited to speak at the #LightUp conference next week, it's 24 hours of fun. You can catch my dbatools ... session on Wednesday morning (4am EDT, 9am BST)
I'm super thrilled & honored that my "Notebooks 101 for SQL People session" has been selected as part of UNICEF ... #COVID19 #Lightup fundraising event. Tune in on July 14 at 9PM EDT. Register & donate: https://events.unicefusa.org/event/lightup2020 🙏
Check out the schedule here:
https://www.2020twenty.net/lightup/
BREAKING: This chart. Devastating.
Do everything you can to prevent the spread.
From @nytimes who sued @cdc to ... get this data.
58 miles, two weeks in a row.
#selfcare
#sqlrun
