Skip to main content
Tweeted twitter.com/StackDBAs/status/986543349271269376
Removed "Edit" ( see https://meta.stackexchange.com/a/127655 ).
Source Link
MDCCL
  • 8.5k
  • 3
  • 31
  • 62

Best practices on dealing with devs that want to use XP_CMDSHELL to BCP OUT

This is not a technical question. I would like to know the best practice to use in a place where devs want to have SA for everything.

The most recent event is:

Devs want to use BCP OUT to export data to a txt file really fast.

What should I think about it? Should I say "why you need this to be THIS fast?"

I'm sure there's a lot of alternatives to export data to .TXT file. they can be slower but it does the job.

We don't use Windows login here, only logins, so I can't create a proxy account (I'm reading something about this).

EditNote: They use Delphi to write application program code.

Best practices dealing with devs that want to use XP_CMDSHELL to BCP OUT

This is not a technical question. I would like to know the best practice to use in a place where devs want to have SA for everything.

The most recent event is:

Devs want to use BCP OUT to export data to a txt file really fast.

What should I think about it? Should I say "why you need this to be THIS fast?"

I'm sure there's a lot of alternatives to export data to .TXT file. they can be slower but it does the job.

We don't use Windows login here, only logins, so I can't create a proxy account (I'm reading something about this).

Edit: They use Delphi to code.

Best practices on dealing with devs that want to use XP_CMDSHELL to BCP OUT

This is not a technical question. I would like to know the best practice to use in a place where devs want to have SA for everything.

The most recent event is:

Devs want to use BCP OUT to export data to a txt file really fast.

What should I think about it? Should I say "why you need this to be THIS fast?"

I'm sure there's a lot of alternatives to export data to .TXT file. they can be slower but it does the job.

We don't use Windows login here, only logins, so I can't create a proxy account (I'm reading something about this).

Note: They use Delphi to write application program code.

added 34 characters in body
Source Link
Racer SQL
  • 7.5k
  • 14
  • 73
  • 136

This is not a technical question. I would like to know the best practice to use in a place where devs want to have SA for everything.

The most recent event is:

Devs want to use BCP OUT to export data to a txt file really fast.

What should I think about it? Should I say "why you need this to be THIS fast?"

I'm sure there's a lot of alternatives to export data to .TXT file. they can be slower but it does the job.

We don't use Windows login here, only logins, so I can't create a proxy account (I'm reading something about this).

Edit: They use Delphi to code.

This is not a technical question. I would like to know the best practice to use in a place where devs want to have SA for everything.

The most recent event is:

Devs want to use BCP OUT to export data to a txt file really fast.

What should I think about it? Should I say "why you need this to be THIS fast?"

I'm sure there's a lot of alternatives to export data to .TXT file. they can be slower but it does the job.

We don't use Windows login here, only logins, so I can't create a proxy account (I'm reading something about this).

This is not a technical question. I would like to know the best practice to use in a place where devs want to have SA for everything.

The most recent event is:

Devs want to use BCP OUT to export data to a txt file really fast.

What should I think about it? Should I say "why you need this to be THIS fast?"

I'm sure there's a lot of alternatives to export data to .TXT file. they can be slower but it does the job.

We don't use Windows login here, only logins, so I can't create a proxy account (I'm reading something about this).

Edit: They use Delphi to code.

deleted 6 characters in body; edited title
Source Link

Best praticespractices dealing with devs that want to use XP_CMDSHELL to BCP OUT

This is not a technical question. I would like to know the best praticepractice to use in a place where devs want to have Sys_AdminSA for everything. 

The most recent event is:

Devs want to use BCP OUT to export data to a txt file , really fast.

What should I think about it? Should I say" whysay "why you need this to be THIS fast?"

i'mI'm sure there's a lot of alternatives to export data to .TXT file. they can be slower but it does the job.

We don't use Windows login here., only logins, Soso I can't create a proxy account ( I'mI'm reading something about this  ).

Best pratices dealing with devs that want to use XP_CMDSHELL to BCP OUT

This is not a technical question. I would like to know the best pratice to use in a place where devs want to have Sys_Admin for everything. The most recent event is:

Devs want to use BCP OUT to export data to a txt file , really fast.

What should I think about it? Should I say" why you need this to be THIS fast?"

i'm sure there's a lot of alternatives to export data to .TXT file. they can be slower but it does the job.

We don't use Windows login here. only logins, So I can't create a proxy account ( I'm reading something about this  ).

Best practices dealing with devs that want to use XP_CMDSHELL to BCP OUT

This is not a technical question. I would like to know the best practice to use in a place where devs want to have SA for everything. 

The most recent event is:

Devs want to use BCP OUT to export data to a txt file really fast.

What should I think about it? Should I say "why you need this to be THIS fast?"

I'm sure there's a lot of alternatives to export data to .TXT file. they can be slower but it does the job.

We don't use Windows login here, only logins, so I can't create a proxy account (I'm reading something about this).

Source Link
Racer SQL
  • 7.5k
  • 14
  • 73
  • 136
Loading