Tag Info

New answers tagged

0

I think NOW() is what should be stored into a TIMESTAMP. As it is stored, the time is modified according to the timezone, and UTC is stored in the table. Upon retrieving, the reverse modification is performed. (This, of course, assumes the system has the 'correct' timezone established. See SHOW VARIABLES LIKE '%zone%';.) That way, if you have users ...


0

Using @a1ex07 answer, I used this query: SELECT TABLE_NAME, COLUMN_NAME, DATA_TYPE, IS_NULLABLE, COLUMN_DEFAULT FROM INFORMATION_SCHEMA.COLUMNS WHERE (table_schema, DATA_TYPE) = ('my_schema', 'timestamp') AND COLUMN_DEFAULT IS NOT NULL; That showed that many were using CURRENT_TIMESTAMP instead of UTC_TIMESTAMP.


0

Zerothly, you need to test your backups and have a recovery plan if your not doing that. Lets talk about some quick win performance first of all. Here are some options. Google can help flesh these out more. Are their multiple named instances on the box? Have you set max memory? Have you set the number of files for tempdb? If its at all possible, put the ...


0

How about using INSERT ... ON DUPLICATE KEY UPDATE or REPLACE INTO on master itself?


0

You can : Method1 1) Create a trigger, in case if its the concern for a single table that user A should be not be conflicting. Therefore you can create the trigger which should restrict user A from the current permission it have , that you would like to restrict. 2) Once done with creating trigger, you will need to create an SQLAgent job which enables ...


2

I've discovered my education as a DBA and as an IT professional came in three tiers. What I learned on my own. Basically from each job I was hired for, I learned how each shop operated, listened to business requirements and learned on my own how to complete the assignments. A lot of reading the manual (now Googling) and trial-and-error is involved but it's ...


0

Best teaching is the school of hard knocks and the college of life. I have no formal qualifications, no degree of any kind. Academic qualifications in my view are no better than experience, probably less valuable than experience. You can take the relevant Microsoft or Oracle or whoever exams but it doesn't make you a good DBA, its a start but again it's ...


0

No. RMAN is aware of that possibility, hence why it creates a snapshot controlfile before performing backup. Rman needs to access control file to map objects to be backed up, and as controlfile is always in use, snapshot is used for that specific point in time. When you restore a backup, you're simply telling oracle to place those files from the backup back, ...


4

NOT an answer - but too long for a comment. [opinion] Faced with (luckily for you) a choice between MySQL and PostgreSQL, I would unhesitatingly go with PostgreSQL. CHECK constraints - silently ignored by MySQL. Incredibly reported as a bug 8 years ago - at least it's documented! :-( "The CHECK clause is parsed but ignored by all storage engines". CTEs ...


1

first question are what are the requirements for all you know it could be a BigData project next Question should always be RPO/RTO I would then question required throughput estimated users typical usage scenario Peak usage scenario also what the Data Access Layer the Developers are using direct sql calls or some form of ORM then evaluate the ...


2

Just an addition to the accepted answer, but it would be to long to comment and I'm not sure if @hbrock would like to have his answer edited. ;-) This is more or less a addition to the list above but on a bit more interactive way. Instead of reading books hours and hours maybe without typing anything on your own (which I won't suggest), these courses are ...


4

I will try to help you. First if you want to work an BI and DBA Dev you need to learn: T-SQL if your with SQL Server or (PL / SQL) if you are working with Oracle. T-SQL Query is a great book to learn T-SQL. Learn to design databases this includes tables, typing the correct data type for the columns, table relationships, and so on. Beginning Database ...



Top 50 recent answers are included