To answer today’s questions from https://pollgab.com/room/brento, I strapped on my Apple Vision Pro and recorded my persona as if we were on a FaceTime or Zoom call together. It’s delightfully creepy, as if I’m AI Brent from the Future.
Here’s what we covered:
- 00:00 Start
- 00:44 Rushabh Shah: I have a question regarding the DBCCSHRINKFILE command. Is it advisable to run the DBCCSHRINKFILE for the NDF file to the target site, leaving 10% free space? Do we need to consider any impact on HA/AG with 4 nodes? How to stop the DBCCSHIRNKFILE operation safely?
- 01:41 SQLPadawan: hey Brent, asking for a friend: if you were an employee/freelancer DBA or DB developer again, how would you future-proof your career these days with lots of layoffs and AI?
- 02:49 Walt Kowalski: Is ‘cranky’ a justified stereotype for the average DBA? Was Brent a cranky DBA during his working days?
- 03:39 Marcus-The-German: Hi Brent, what is your recommendation regarding unlimited autogrowth? Right now I use to limit autogrowth but may rethink this setting.
- 04:56 RollbackIsSingleThreaded: Hi Brent! I reduced the number of logical reads for one query from 306 thousand to 11200. The second query is only ~200ms faster (1.329ms vs 1.124). Is it worth it?
The video is creepy, although the audio’s quite good. No, I won’t be recording too many Office Hours with this technique/technology, hahaha. The only times I’ll use it for Office Hours is if I need to record a session, but I’m not in a visually appealing place or I don’t have my camera gear. For example, I can imagine recording with it in a hotel room in a less-than-glamorous location.
In case you missed it, I also recorded a video showing what I see when I use SSMS in the Vision Pro. I do love the heck out of it, but not for office usage – just for travel.
4 Comments. Leave new
First, not offense meant by this: the face was not bad – had a “Second Life” feel to it. The hand looked like something from Nintendo WII.
Thanks for the 500 level “Be known as the guy who does ____________”
Looking forward to seeing how Avatar is set up. Do you wear the Apple goggles and talk into an empty room ?
One bit of feed back. My shop is 80% vendor solutions. I’m not really allowed to change much. For a large system like PeopleSoft there is a long 12 step change management. (ok not 12 steps but five) When I do get to change something I’m happy. (sigh) Yes I should be happy [and grateful] everything is working and there is nothing to fix but that dies after three months. I may understand where “RollbackIsSingleThreaded” is coming from.
Ghost of Brent comes to us from the future to answer questions during an Office Hours seance.
Not a fan of that format; it is distracting. Your regular format for Office Hours is much better!
Pretty wild, eh? I totally agree – it’s disturbing. I’ll only use it for situations where I can’t use my regular camera gear and I need to get an Office Hours out for some urgent reason. I don’t see that happening often.