Re: Also, what kind of database query returns a 100TB result??
Sorry, and forgive me if i'm wrong, but I think that 100TB data mark refers to the amount of data that those queries consume in order to get a result.
40 publicly visible posts • joined 7 Aug 2020
Generally speaking (and with a grain of salt since MS SQL Server fill my fridge) I've found that the achilles heel in this GPL DBs is the official Admin client. Lack of features, lack of consistent look and feel, slow.
I do disagree when the solution to that is the use a 3rd party tool as the Admin interface.
A real computer wizzard should also know that your computer at work is a part of a bigger structure that need to be maintained, supported and upgraded. So, even if he always knew the solution it must report it because:
1) Is part of the rules
2) Can retrofeed or spot a more general problem
3) Somebody else is being paid for that
4) etc
Of course, being empathetic implies that if you have the required knowledge, you should help isolating the issue, gather extra information to help the diagnose, even change something and test the porpose solution, and so on.
I'd been working as a senior BI consultant but made redundant. Decided to live and work in my home city (pre remote working days), could only fine jobs as a DBA (semi senior because of my age)... I got a job and I assumed that I'll be joining a DBA team so I was confident that I coul cop with the new role. But what I found was that the previous DBA almost died in a car accident and the replacement was anxious to leave the position, so after the first 2 days he went on vacations and never returned, so I was left alone with all the duties and of course nobody in IT knows a thing about DBs except installing them....first think I tried to discover was how the heck the backup system was working and if I have a way to restore something in case of a disaster.
The problem with this is that the suppliers of such "cheap" services trivializes the migration and operation efforts, as the changes that developers must take into account when switching RDBMS technologies. And all of the managers buy that without the slightest shade of doubt and the risks involved.
In the short term they all look almost the same (all of them can manage a SELECT * FROM TABLE and adhere to the ANSI standards ) but then the issues arise and the lack of proper skills in the "free" DBs is enormous when you get into troubles.
As a teenager, after three broken membranes of a ZX Spectrum clone, I'd decided (and of course due to the lack of budget) to construct my own wooden keyboard made of wood, a bunch of screws and a sheet of bronze in order to make the key contacts.
Worked like a charm except for an strange flickering of my black and white TV set. At that moment I didn't know too much about electronics, filters, capacitors and things like that.
As an extra embellishment I made two DB9 ports connected in parallel with certain keys of the matrix in order to resembled a Cursor joystick and connect an old Atari joytick to it.
Unluckily I've lost it and have no photos.... I sincerely hope that as a last homage it made part of a barbecue in my parents house.
Andrés
PS: Since I'm from Argentina, the barbecue is the correct way to incinerate old memories :-)
Apple has already patented an iDog, which is a device in the shape of a classic dog (with rounded corners, of course) in order to detect the attack and alert the owner with iBarks . Until now they couldn't manage to solve the issues with Siri ordering tonnes of dog food with each complain of the puppy.
AFAK, there is no management and administrive tooling as the one for SQL Server Databases. I'm working also with MySQL, Redshift, MongoDB and no client get no even close to that.
I've to agree that in this new days of Devops methodologies the way to go is go back to scripting all, but for certain task, having the managements tools, both graphical and text, provided by the main vendor should be a must.
(and yes, I'm old enough and definitively not fond of this new shiny web consoles)
20 years ago I've really enjoyed when a TCP/IP IBM redbook came to me just by luck.
I just don't know is they were the most accurate/precise/whatever but, for me, was the first time I've read a technical book both complete and also well writen.
Then 10 or so years later I've found another Redbook about Data Warehousing (my topic of interest) and again the same sensation of good quality reading arised.
(please forget my grammar, no native english here)
yeah.... When I'd finally decided to use a password vault, I've faced the problem of accesing and synching from multiple devices. Google Drive (because is there for free) work like a charm between my both PC and phones.
(using KeePassDX in the phones downloaded from Druidics, not from GooglePlay)
It can be helpful to see the correlation between the 2 questions in the poll.
Eventhough currently the bast mayority is working exclusively from home (question 2) I'd like to know what percentage of the people not working enterily from home now, accept their current conditions or prefer others.