March 27, 2025 at 5:25 pm
One of the many reasons I don't trust the so-called "AIs."
There's one hosted by my employer and one of my co-workers asked it a relatively straight-forward question, "how many Federal holidays fall on a Monday in 2025?" Should be easy to answer, right?
At the time, it confidently stated that Memorial Day fell on a Monday (so far, so good,) on the last Friday in May (wha??)
Having just asked it now the same question, it's actually getting it right so someone taught the system how to read a calendar.
March 28, 2025 at 4:32 pm
Don't you absolutely love it when someone has a problem but cannot elaborate on what the problem really is?
😎
See more: String or Binary Truncation Error Strange Behavior (SQL 2019)
March 31, 2025 at 2:17 pm
But, but, but... I DO have a problem.
My application isn't working. You know the one I'm talking about. Where I input information about the customer and it does ... schtuff.
It doesn't do the schtuff!
March 31, 2025 at 2:25 pm
And as of a few minutes ago, it's my turn up at bat for the long week of extra work, so I'm going to do an insane thing at the start and hope that removes the urge for insanity at the end of the week.
"Let's do the DBCC TIMEWARP() again...."
DANCE WITH ME!!!!
April 3, 2025 at 9:56 am
A little late for the preview of the SQL 2025 feature list:
https://www.brentozar.com/archive/2025/04/whats-new-in-sql-server-2025-2/
April 3, 2025 at 11:35 am
Well it's my own dang fault this happened...
The guy on our team responsible for managing our AVDs in Azure we (and the developers) connect to our servers from got an alert about the space on the drive for the VM. Being a pro-active guy, he went in and cleared out a couple profiles, one for someone who has left for greener pastures and one he wasn't sure who it was (our profiles are strings of numbers, you CAN find the names, but it's a PITA)
So this morning I came in to my suddenly empty desktop, SSMS missing my saved connections, where'd all my scripts go...
My own fault for not keeping stuff on the second drive, and nothing that can't be re-created with a bit of time and effort, but hopefully a backup of the drive can be restored and attached so I can copy files off (which has already been requested of our hosting provider)
Of course, the more annoying part of this is, it gave one of the other admins ammo in his "you should be using Git!" LoL
April 3, 2025 at 11:57 am
Two reason, both valid:
1. We don't have the level of access to do this (yeah, it's a weird hosting arrangement)
2. Larger disk = more $$$ = requires approval through our RFC process by the our team higher-ups and they had already left for the day
April 3, 2025 at 1:05 pm
jasona.work wrote:....Being a pro-active guy, he went in and cleared out a couple profiles...
Why didn't he simply expand the disk? 😎
Honestly, two reasons:
April 3, 2025 at 3:49 pm
A little late for the preview of the SQL 2025 feature list:
https://www.brentozar.com/archive/2025/04/whats-new-in-sql-server-2025-2/
This actually got me all excited. Then I remembered what day it was...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
April 3, 2025 at 3:56 pm
Eirikur Eiriksson wrote:jasona.work wrote:....Being a pro-active guy, he went in and cleared out a couple profiles...
Why didn't he simply expand the disk? 😎
Honestly, two reasons:
- We don't have the privileges in the environment to expand disks ourselves, it has to go through our hosting
- As larger disks cost more (yay cloud) it would have to go through our RFC process and the higher-ups that would have to approve were gone for the day
I have the same things to deal with. Getting more space requires divine intervention. We started combatting this by creating a database named "MT" on the servers. We size it to fill the drive. So, we can prove we are out of disk space.
The infrastructure folks created an arbitrary set of standards for free space. If you exceed those values, they will take away the drive and replace it with a smaller one. They set up notifications when the free space is below the percentage. Every time a server gets rebooted, they want to take away the tempdb drives.
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
April 3, 2025 at 5:46 pm
Yes, let's take away the tempdb drives. That's one way to (NOT) keep an instance running.
@=) @=)
April 3, 2025 at 6:45 pm
I have the same things to deal with. Getting more space requires divine intervention. We started combatting this by creating a database named "MT" on the servers. We size it to fill the drive. So, we can prove we are out of disk space.
Generally speaking, we don't get a lot of pushback if we ask for more space, although in the case of the virtual desktop the preference is to first try to remove unneeded files from peoples' profiles.
Servers, generally, unless we ask for something kinda crazy (like a 2TB volume) without a solid justification (say, if we don't increase to the next drive size up, which is 2TB, this application will fill the drive and then will stop working and then it'll be an emergency) we get approved as long as we go through the process. Emergency size increases can be approved with a quick chat with the boss and the paperwork done afterwards.
April 8, 2025 at 3:43 pm
This is a reason I've often put placeholders on drives (https://voiceofthedba.com/2014/12/01/creating-placeholder-files/) especially on servers. When I run low and we have a space argument or slow approval, I can get some back quickly.
Plus the storage people who might be checking drive space see more used.
Viewing 15 posts - 66,751 through 66,765 (of 66,815 total)
You must be logged in to reply to this topic. Login to reply