Slightly wide eyed
- Visitors can check out the Forum FAQ by clicking this link. You have to register before you can post: click the REGISTER link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. View our Forum Privacy Policy.
- Want to receive the latest contracting news and advice straight to your inbox? Sign up to the ContractorUK newsletter here. Every sign up will also be entered into a draw to WIN £100 Amazon vouchers!
Should DBA know to check theres no DB connections before performing a data update
Collapse
X
-
Should DBA know to check theres no DB connections before performing a data update
28Yes39.29%11No21.43%6No, you should tell them28.57%8AndyW mum is always connected10.71%3 -
Why would he be expected to check something like that given that
a) he'll need a connection to do the update
b) a large percentage of the complexity in a database system is there because they support multiple concurrent users all of whom can update data simultaneouslyWhile you're waiting, read the free novel we sent you. It's a Spanish story about a guy named 'Manual.' -
Surely a DBA has to understand that if he is performing a data update, he can't have users in the system? So surely, he has to check no one is connected, before updating business data?Comment
-
Should DBA know to check theres no DB connections before performing a data update
select machine from v$session; ?
Just about the only useful SQL I know!Comment
-
-
I would have thought their knowledge any data upload fails if there is locks on tables, will mean they check for users.
With this data, you cannot have simultaneous users accessing it.
It's business data, so it's important. It was also on a test system.
Gob smacked the department has been asked to provide, in a deployment note, please remember to check for locks on the database, to a DBA. Gobsmacked.Comment
-
Originally posted by Old Hack View PostSurely a DBA has to understand that if he is performing a data update, he can't have users in the system?While you're waiting, read the free novel we sent you. It's a Spanish story about a guy named 'Manual.'Comment
-
Originally posted by Old Hack View PostI would have thought their knowledge any data upload fails if there is locks on tables, will mean they check for users.While you're waiting, read the free novel we sent you. It's a Spanish story about a guy named 'Manual.'Comment
-
I get the feeling you are using words you dont really know what they mean. A data update? What? An update query, updating data?
Sigh.
Obviously trying to blame someone for doing something you dont understand. If you are so good, do it yourself next time eh?Comment
-
Old Hack is correct. The DBA should have dropped all of the users first without telling them & then run the update.What happens in General, stays in General.You know what they say about assumptions!Comment
- Home
- News & Features
- First Timers
- IR35 / S660 / BN66
- Employee Benefit Trusts
- Agency Workers Regulations
- MSC Legislation
- Limited Companies
- Dividends
- Umbrella Company
- VAT / Flat Rate VAT
- Job News & Guides
- Money News & Guides
- Guide to Contracts
- Successful Contracting
- Contracting Overseas
- Contractor Calculators
- MVL
- Contractor Expenses
Advertisers
Contractor Services
CUK News
- Streamline Your Retirement with iSIPP: A Solution for Contractor Pensions Sep 1 09:13
- Making the most of pension lump sums: overview for contractors Sep 1 08:36
- Umbrella company tribunal cases are opening up; are your wages subject to unlawful deductions, too? Aug 31 08:38
- Contractors, relabelling 'labour' as 'services' to appear 'fully contracted out' won't dupe IR35 inspectors Aug 31 08:30
- How often does HMRC check tax returns? Aug 30 08:27
- Work-life balance as an IT contractor: 5 top tips from a tech recruiter Aug 30 08:20
- Autumn Statement 2023 tipped to prioritise mental health, in a boost for UK workplaces Aug 29 08:33
- Final reminder for contractors to respond to the umbrella consultation (closing today) Aug 29 08:09
- Top 5 most in demand cyber security contract roles Aug 25 08:38
- Changes to the right to request flexible working are incoming, but how will contractors be affected? Aug 24 08:25
Comment