Viewing 15 posts - 466 through 480 (of 604 total)
Interesting topic!
Well the UK market depends a lot on where you are. You can earn between £25k & £60k a year in London. The further north you go,...
June 25, 2003 at 4:56 am
I think this really boils down to the size of the database.
If it's a small database, I'd just detatch it and copy it to the new server and reattatch it....
June 25, 2003 at 4:15 am
Hi Lauri,
Unfortunately, the users will need the relevent SELECT, INSERT, DELETE, UPDATE permissions in the production databases. This is because the ownership chain has been broken. If the...
June 17, 2003 at 2:44 am
Query Tuning. I'd like to see questions relating the the Execution Plan!
Clive Strong
June 9, 2003 at 10:36 am
I agree with Frank. I think it's ideal if project managers do have some experience in coding. I think it better helps them understand problems that developers have!
Ireland...Mmmmm...
June 2, 2003 at 10:20 am
Hey,
Your posting is a bit vague. It's a bit hard to give you a decent answer unless you have a specific question....But I'll get the ball rolling with a...
June 2, 2003 at 10:11 am
Yeah, an example would help. Franks example would work if the id field is sequential. If you delete a couple rows then the code wouldn't work.
Clive Strong
May 27, 2003 at 4:24 am
Hey,
Although we don't use Oracle, we do read and write from JDE (which runs on DB2) using SQL Server.
We use a DTS within SQL. However, a lot of the...
May 27, 2003 at 3:05 am
That is so true, especially of the 2nd pic of Steve.
Interesting life style. The DBA role in the US sounds far more interesting than that of the UK!!
May 26, 2003 at 3:49 am
Excellent idea!!
Need to brush up on my security (Doh!!) knowldge about roles & BUILTIN/Admin!
Great idea to find weak spots...
Clive Strong
May 21, 2003 at 10:54 am
BCP is one way or if you have sample data in another format, such as Access, Excel, Oracle etc, then you can move data into SQL using DTS.
Clive Strong
May 21, 2003 at 10:25 am
If you want to stop people logging in and gaining admin rights through the BUILTIN\Administrators, you can remove the login from the Sysadmin server role.
Clive Strong
April 29, 2003 at 9:34 am
April 11, 2003 at 3:26 am
I guess it's down to how each the development manager oversees the interaction between Application development and the DBA role. Where I work it's nice and clear. Mainly...
April 2, 2003 at 8:03 am
Viewing 15 posts - 466 through 480 (of 604 total)