I will explain how you can use sp_MSforeachdb stored procedure against READ_WRITE database only. There are numerous articles on the web about excluding databases using database id or name. Recently I needed a script to run against databases that are part of Always On Availability Groups and in READ_WRITE status. I used the ‘Updateability’ properties […]
About two years ago, I was working on an update statistics solution for 15 TB OLTP database. The first thing I needed to know, is the status of statistics. With a google search, I landed into this blog post by Erin Stellato (blog | Twitter) from SQLskills. Which gave me a perfect head start. […]
There are multiple ways you can get free Azure credit, which can add up to $500 for one year. With a Microsoft account and one of these free credit options you can open an Azure account. You will be able to use this account for any Azure service based on your needs including, Virtual Machines, […]
I thank Kennie Nybo Pontoppidan (b|t) for hosting TSQL Tuesday #88. The topic for this month is the daily database-related WT……. Last week I was setting up a collection of wait statistics with five minutes interval using a while loop. I was wrapping up Paul Randal’s (b|t) code from this blog post in a loop […]
Last week I blogged about increasing retention of System Health session files. In this post I will show how you can open multiple files at once and work with the data as one set. If you select multiple System Health extended event files (with extension .xel) and click open each file will open in separate […]
Here is Judge Amy Coney Barrett explaining why it’s wrong to fill a SCOTUS vacancy during a presidential election ... year.
In an hour I will be presenting at room - 2
New features in Management Studio -- Performance Troubleshooting made ... easier!
https://www.sqlsaturday.com/1016/en-us/Sessions/Details/sid/108130
Hope to see you there.
#sqlsatSaoPaulo #sqlsat1016 #sqlpass #MVPBuzz
During my career at sea we called Vitoria, Rio Grande do Sul, Santos and Rio de Janeiro many times.
Who knew one day I ... will be speaking at #sqlsatSaoPaulo
Life is strange.
Good morning.
Reviewing my presentation for #sqlsat1016 in 2 hours.
Good luck to all speakers, organizers and ... volunteers. Appreciate attendees taking time out for advancing their career.
#sqlsat1016 #sqlsatsaopaulo #SQLPass
Republicans didn’t want the #TrumpUniversity deposition getting out. I guess this really is the video they don’t ... want you to watch and retweet. So let’s all watch and retweet! 😲
#TrumpTrainwreck #TrumpIsALaughingStock
cc @motherjones @DavidCornDC @donwinslow #Demcast
