193 reputation
10
bio website members.virtualtourist.com/m/…
location Marbella, Spain
age 36
visits member for 11 months
seen yesterday
stats profile views 24

Developer, SQL addict, trying to get insights of DBA tasks, mountainbiker


May
2
revised Landed as BI, but databases are a big WTF, what to do?
added 555 characters in body
Apr
26
reviewed Reviewed Total Memory capped far below available memory
Apr
26
comment Landed as BI, but databases are a big WTF, what to do?
Backups, recovering, prevent data loss and similar issues are out of my hand for now. I must center on performance tuning, query optimization, creating new reports, etc.
Apr
26
revised Landed as BI, but databases are a big WTF, what to do?
added details about problems found to help clarifying the question
Apr
26
comment Landed as BI, but databases are a big WTF, what to do?
Thanks James. As for the size of the databases, I was just pointing out that they where big, not just a couple of gigs. I agree about the normalization issue and making friends, but for now that is not on the plan. As for all other issues, I'm updating the question.
Apr
19
comment Landed as BI, but databases are a big WTF, what to do?
I'm making up some kind of list like that, but sounds to me that my efforts will go end up on the bottom of some other pile of papers. I will try and update my question maybe tomorrow with some more detailed and accurrate questions, as I'm already been here for a month and a half and have better understanding of what is under the hood.
Mar
25
awarded  Commentator
Mar
25
comment Landed as BI, but databases are a big WTF, what to do?
I think too that this should be done at some point. But it's not my call @mrdenny. And we are in Málaga, Spain, maybe too far from you. Indeed these consultant tasks could be done remotely but I think it works better onsite, or not?
Mar
25
comment Landed as BI, but databases are a big WTF, what to do?
Got it! When re-reading the question after your first comment I understood that it could be more on the "political issues" on how to do my job instead of the technical poing of view. Need to rewrite it indeed. I'm at home now. Tomorrow will collect some accurate information at work and edit my question to make it more suitable.
Mar
25
comment Landed as BI, but databases are a big WTF, what to do?
Yes, I've read it again and indeed sounds like a career advice. You point out that there could be a good technical question, can you elaborate a bit more? Maybe I can edit my question and make it more specific.
Mar
25
asked Landed as BI, but databases are a big WTF, what to do?
Jan
5
comment Migrating development and production databases to AWS
Replication maybe?
Jan
4
comment Migrating development and production databases to AWS
I read about the outages they have had, one of it a couple of years ago made a known news aggregator Meneame.net to be offline for about a day and the owner/dba/developer carefully explained all the situation, it is really interesting to read about it. We can not afford to be offline so long, that is why we have backups both local and somewhere else (still discovering new things about our own architecture). Will keep looking for more information about the subject and start testing with the free tier, is a start
Jan
4
awarded  Scholar
Jan
4
accepted Migrating development and production databases to AWS
Jan
3
reviewed No Action Needed Why does SqlSentry Plan Explorer not give the duration of my queries?
Jan
3
awarded  Critic
Jan
2
awarded  Custodian
Jan
2
awarded  Student
Jan
2
asked Migrating development and production databases to AWS