Click here to Skip to main content
15,867,488 members

Welcome to the Lounge

   

For discussing anything related to a software developer's life but is not for programming questions. Got a programming question?

The Lounge is rated Safe For Work. If you're about to post something inappropriate for a shared office environment, then don't post it. No ads, no abuse, and no programming questions. Trolling, (political, climate, religious or whatever) will result in your account being removed.

 
GeneralRe: Elon, leave us kids alone ! Pin
Nelek3-Aug-20 7:32
protectorNelek3-Aug-20 7:32 
GeneralRe: Elon, leave us kids alone ! Pin
Eddy Vluggen3-Aug-20 7:50
professionalEddy Vluggen3-Aug-20 7:50 
GeneralRe: Elon, leave us kids alone ! Pin
Nelek3-Aug-20 7:56
protectorNelek3-Aug-20 7:56 
GeneralRe: Elon, leave us kids alone ! Pin
patbob4-Aug-20 6:20
patbob4-Aug-20 6:20 
GeneralRe: Elon, leave us kids alone ! Pin
James Lonero5-Aug-20 13:52
James Lonero5-Aug-20 13:52 
GeneralWhen development is getting done on production SQL server.... Pin
virang_212-Aug-20 13:59
virang_212-Aug-20 13:59 
GeneralRe: When development is getting done on production SQL server.... Pin
GuyThiebaut2-Aug-20 20:43
professionalGuyThiebaut2-Aug-20 20:43 
GeneralRe: When development is getting done on production SQL server.... Pin
#realJSOP2-Aug-20 23:31
mve#realJSOP2-Aug-20 23:31 
GuyThiebaut wrote:
if you restore production instance to the dev instance each night the devs should never need to go anywhere near the production server.


That's a nice theory. The problem with the backup/restore idea is that you can't say "just backup the tables". You get the entire database, and that will overwrite views, functions, and stored procs that the devs may be working on. And that's assuming they're not working on tables (adding/removing columns, keys, and/or constraints).

The only recourse is to be able to re-sync the code from a database source project after a restore happens, but that also has dangers because devs are forced to check-in code that possibly doesn't work, unless there's a "work" database on the server where transient procs are developed and then moved to the actual database project when they are finished.
".45 ACP - because shooting twice is just silly" - JSOP, 2010
-----
You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010
-----
When you pry the gun from my cold dead hands, be careful - the barrel will be very hot. - JSOP, 2013

GeneralRe: When development is getting done on production SQL server.... Pin
GuyThiebaut3-Aug-20 0:30
professionalGuyThiebaut3-Aug-20 0:30 
GeneralRe: When development is getting done on production SQL server.... Pin
virang_213-Aug-20 12:45
virang_213-Aug-20 12:45 
GeneralRe: When development is getting done on production SQL server.... Pin
GuyThiebaut3-Aug-20 20:23
professionalGuyThiebaut3-Aug-20 20:23 
GeneralRe: When development is getting done on production SQL server.... Pin
Eddy Vluggen3-Aug-20 6:50
professionalEddy Vluggen3-Aug-20 6:50 
GeneralRe: When development is getting done on production SQL server.... Pin
Mycroft Holmes3-Aug-20 13:05
professionalMycroft Holmes3-Aug-20 13:05 
GeneralRe: When development is getting done on production SQL server.... Pin
dandy724-Aug-20 10:44
dandy724-Aug-20 10:44 
GeneralSplashdown confirmed. Dragon Endeavour, Doug Hurley and Bob Behnken are back on Earth. Pin
Marc Clifton2-Aug-20 8:56
mvaMarc Clifton2-Aug-20 8:56 
GeneralRe: Splashdown confirmed. Dragon Endeavour, Doug Hurley and Bob Behnken are back on Earth. Pin
OriginalGriff2-Aug-20 9:00
mveOriginalGriff2-Aug-20 9:00 
GeneralRe: Splashdown confirmed. Dragon Endeavour, Doug Hurley and Bob Behnken are back on Earth. Pin
Daniel Pfeffer2-Aug-20 10:00
professionalDaniel Pfeffer2-Aug-20 10:00 
GeneralRe: Splashdown confirmed. Dragon Endeavour, Doug Hurley and Bob Behnken are back on Earth. Pin
Mike Hankey2-Aug-20 10:12
mveMike Hankey2-Aug-20 10:12 
GeneralWindows Terminal Preview Pin
Bassam Abdul-Baki2-Aug-20 8:27
professionalBassam Abdul-Baki2-Aug-20 8:27 
GeneralRe: Windows Terminal Preview Pin
Mike Hankey2-Aug-20 10:16
mveMike Hankey2-Aug-20 10:16 
GeneralThought for the day... Pin
Sandeep Mewara2-Aug-20 4:06
mveSandeep Mewara2-Aug-20 4:06 
GeneralRe: Thought for the day... Pin
W Balboos, GHB2-Aug-20 5:19
W Balboos, GHB2-Aug-20 5:19 
GeneralRe: Thought for the day... Pin
Mike Hankey2-Aug-20 6:50
mveMike Hankey2-Aug-20 6:50 
GeneralRe: Thought for the day... Pin
DRHuff2-Aug-20 7:06
DRHuff2-Aug-20 7:06 
GeneralRe: Thought for the day... Pin
Daniel Pfeffer2-Aug-20 7:20
professionalDaniel Pfeffer2-Aug-20 7:20 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.