In order to understand how page/extent allocation works with in SQL Server for entities (objects) I was reading Paul Randal’s (B|T) blog. While reading different articles I thought of summarizing few critical information into a table. Which will help me consuming the information better and review easily when I need to. With Paul’s written consent […]
DBA team that I worked with manage 170+ SQL Servers. We do not enable notification on any SQL Agent job. We centrally monitor all jobs and send a notification based on the tier (Business-critical). Last night on-call DBA got paged for a job failed in the server we are doing proof of concept. By looking […]
Often times DBA’s (including myself at the beginning of my DBA career) struggle to find out what is causing the log files to grow. Or what is consuming all the space in my log files. I understand there are many factors that can impact the log file size besides all the active transactions. Such as: […]
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 […]
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
