Viewing 15 posts - 1 through 15 (of 32 total)
We've got a series of questions we go through whenever we are interviewing a new potential DBA (hasn't happened in awhile). There are a few "how would you do this"...
May 9, 2022 at 3:53 pm
Any service running on the local server as "Local System" trying to access databases will show up as "NT Authority/System" in the SQL logs.
In my experience the cause is usually...
May 2, 2022 at 5:16 pm
Over the 2016-2019 time period my company shut down five corporate datacenters and moved almost all of it to Azure or AWS via lift and shift IaaS methods. For scale,...
October 20, 2021 at 6:12 pm
When I was hired in the mid 90's I worked with a large number of IT employees with 20+ years of service. One guy on my team had been in...
September 29, 2020 at 6:29 pm
I guess I'm an outlier. I hit 25 years with my employer last spring which isn't a real rare thing here. Old company in an old industry where it's not...
September 29, 2020 at 5:00 pm
After decades of building my own personal desktop machines, last year I bought my first new personal laptop. It's far more powerful than the desktop it replaced, has just as...
August 12, 2020 at 11:23 pm
I've fought the server spec battle many times when migrating from physical to virtual or cloud servers. When moves like that are made there is often an effort by the...
July 24, 2020 at 5:02 pm
JJ B: I'd say you've ruled out a disk I/O issue. My rule of thumb is that the disk subsystem needs a closer look if you have a sustained disk...
July 22, 2020 at 8:02 pm
JJ B: Re-reading my post, I wasn't as clear as I should be. Sorry about that. What I was trying to say boils down to:
1.) Double check that the new...
July 22, 2020 at 5:11 pm
Is the new VM in Azure by any chance? How does the 2 core new VM compare to the old server (2 cores and 12GB seems small for a production...
July 22, 2020 at 4:03 pm
Another thing to check is to see if any other drives on the box are using volume shadow copy and storing them on your log drive. I've seen systems set...
July 17, 2020 at 3:56 pm
After my first PC purchased in the early 90's (386DX-25 with 4MB of memory and a 105MB hard drive), I built all my personal desktops. I don't think I saved...
July 15, 2020 at 5:16 pm
My best days as a DBA have always been times when I have shined in somebody else's crisis. Two in particular come to mind.
Sometime around 2004 I had an internal...
July 2, 2020 at 5:35 pm
Prior to our HQ office relocation a few years ago I had a 7-15 minute commute to a beautiful forested corporate campus. At the time I told people my commute...
June 11, 2020 at 4:42 pm
After six confirmed deaths in nearby Kirkland over the weekend, on Monday the company I work for closed the corporate HQ office in downtown Seattle for a minimum of a...
March 4, 2020 at 4:26 pm
Viewing 15 posts - 1 through 15 (of 32 total)