In my last Thirsty Thursday post, I published my list of essential bar equipment for folks who are interested in making mixology their quarantine hobby. Hopefully these little detours from technology & career advice will help with your work-life harmony while we’re all working from … [Read More]
Stop shrinking your tempdb data files I recently wrote about growing, shrinking, and removing tempdb files. In that article I explained that SQL Server won’t move a page that contains an internal worktable object, and thus trying to shrink tempdb files can be futile. Today, … [Read More]
I recently came across a server where tempdb was breaking all the rules. Data files were all different sizes. I want all data files to be the same size so that proportional fill uses them evenly. There were 10 tempdb files, with 8 files on … [Read More]
I’m writing this post during the Coronavirus pandemic. Billions of people across the globe are isolating in their homes. Folks have started exploring new hobbies and interests as a way to pass the time and to keep their mind sharp. Folks are depending heavily on … [Read More]
There’s a lot of advice out there on the internet that suggests that you should not install SSMS on your database servers running SQL Server. This came up at work recently, where I was asked “Should we install SSMS on our database servers?” and my … [Read More]
Last week, I had the pleasure of participating in Redgate Streamed, a three-day virtual conference organized by my friends at Redgate. My session was Shortcuts from an impatient DBA–discussing a bunch of Management Studio tips & tricks for data professionals. The virtual conference was free … [Read More]
Copyright © 2024 | Andy Mallon | am2.co