|
|
Eddy Vluggen wrote: but seriously, this won't work for most of the kids, and he's not going to take responsibility for any failures.
I know... that's exactly the reason of both messages of mine in this thread, a bit of joking but saying the same as you.
M.D.V. 
If something has a solution... Why do we have to worry about?. If it has no solution... For what reason do we have to worry about?
Help me to understand what I'm saying, and I'll explain it better to you
Rating helpful answers is nice, but saying thanks can be even nicer.
|
|
|
|
|
Eddy Vluggen wrote: .. this won't work for most of the kids, and he's not going to take responsibility for any failures
So.. then.. just like normal public school in the US.
|
|
|
|
|
This is no better than what the current set of politicians are doing. They continually gut the school budget. With this in mind and if Elon has his way, why even have school, other that a convenient baby/child sitting service for the parents.
Its too bad, because when the education level is low for the people, the country's people become more dependent on social services than on their own strength.
We should strengthen education and put more money into public education to preserve our future. We need more tax paying citizens so that we old geezers can get our social security. We supported our parent's generation, those young ones can support us.
|
|
|
|
|
I was looking for a reason why application that is working fine most of the time all of a sudden showing this odd timeout errors and discovered that people are actually getting on to the production SQL Server box and building SSRS and Power BI reports. PowerBI is the main culprit chewing up all the CPU ( hitting 100% ) and very large amount of memory. Only reason they don't want to do dev work somewhere else is they don't want to spend money for new server or upgrade current one with more resource. It is speced for SQL server and not for development. They are happy to pay for support while we investigate and re run same steps as application from backend but don't want to spend on upgrade.
I am worried some day someone will kill that box...
Zen and the art of software maintenance : rm -rf *
Maths is like love : a simple idea but it can get complicated.
|
|
|
|
|
Sounds to me like the access and permissions to that production server need to be restricted to read only access and a new instance spun up for the devs.
Although even that is being generous, if you restore production instance to the dev instance each night the devs should never need to go anywhere near the production server.
Given your current setup, it's a given that someone is going to commit some change to production that will require a full restore.
It's just a case of when.
“That which can be asserted without evidence, can be dismissed without evidence.”
― Christopher Hitchens
modified 3-Aug-20 9:51am.
|
|
|
|
|
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
|
|
|
|
|
Unfortunately it's not just a theory it's a reality of how I and all the other devs I work with develop.
In terms of losing work it just means that we have to be very organised to save our work outside of the database in the form of scripts.
We also have local databases which persist and are very cut-down versions with regards to data that we can work on but much of the time the data in the local databases is not sufficient for proper testing.
“That which can be asserted without evidence, can be dismissed without evidence.”
― Christopher Hitchens
|
|
|
|
|
Their rational for not doing it is because there is some government agency data in that application and putting that on a different server means getting few approvals from suits. I still think its worth the pain to get approval once but company thinks otherwise and gave dev direct access to that server.
Zen and the art of software maintenance : rm -rf *
Maths is like love : a simple idea but it can get complicated.
|
|
|
|
|
So they are more concerned with the effort involved in getting approval than with the security risks of devs having access to live data  ?
“That which can be asserted without evidence, can be dismissed without evidence.”
― Christopher Hitchens
|
|
|
|
|
virang_21 wrote: I am worried some day someone will kill that box...
Raspberry Pi's can host SQL Server these days. Under $75, per user, each getting their own dedicated server.
I could help, but need to be on location for that.
Bastard Programmer from Hell 
If you can't read my code, try converting it here[^]
"If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.
|
|
|
|
|
Why the hell do devs need real time data, oh wait this is a hardware issue, you are missing a box. No amount of tweaking, backups, schema setups is going to help you if your company is too tight to get a dev box.
Prepare your I told you so email now.
Never underestimate the power of human stupidity -
RAH
I'm old. I know stuff - JSOP
|
|
|
|
|
Power BI excels (see what I did there?) at importing data from various sources and working off of its own copy. The people (mis)using it need to learn how to do it correctly and not hit SQL on every freakin' mouse click.
|
|
|
|
|
Amazing to watch.
Then again, if I were them, I would have stayed on the ISS. 
|
|
|
|
|
I dunno - just how difficult is it to social distance up there? And if they run out of masks, hand sanitiser, and TP it's a bl**dy long way to the nearest shops...
"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
"Common sense is so rare these days, it should be classified as a super power" - Random T-shirt
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
OriginalGriff wrote: just how difficult is it to social distance up there?
What social distancing? If someone is confirmed ill, they simply kick him out the airlock!
Freedom is the freedom to say that two plus two make four. If that is granted, all else follows.
-- 6079 Smith W.
|
|
|
|
|
I wonder if they'll have to do 2 weeks quarantine?
Not for our sake, for theirs!
I'm not sure how many cookies it makes to be happy, but so far it's not 27.
JaxCoder.com
|
|
|
|
|
Finally jumped on the bandwagon. So far, I like it.
|
|
|
|
|
I've had it for a while but not really used it much. But it is kinda nice!
I'm not sure how many cookies it makes to be happy, but so far it's not 27.
JaxCoder.com
|
|
|
|
|
[Apologies OG - Can we consider it's on your behalf only?] 
Quote: “When a flower doesn’t bloom, you fix the environment in which it grows, not the flower.”
-Alexander Den Heijer
|
|
|
|
|
Why don't you petal our discontent elsewhere and leaf us sprout of your problems.
| Ravings en masse^ |
|---|
| "The difference between genius and stupidity is that genius has its limits." - Albert Einstein | | "If you are searching for perfection in others, then you seek disappointment. If you seek perfection in yourself, then you will find failure." - Balboos HaGadol Mar 2010 |
|
|
|
|
|
That doesn't seem to be the case these days!
I'm not sure how many cookies it makes to be happy, but so far it's not 27.
JaxCoder.com
|
|
|
|
|
Most people are terrible gardeners.
If you can't laugh at yourself - ask me and I will do it for you.
|
|
|
|
|
Rather than carry a candle, it is much easier to curse the darkness.
And also more fun.
Freedom is the freedom to say that two plus two make four. If that is granted, all else follows.
-- 6079 Smith W.
|
|
|
|
|
My AV runs out at the end of the month, so I'm looking to renew it. And I find on Amazon that one supplier has three different delivery options:
"Frustration free" packaging, sent by Prime next day.
"Standard" packaging, sent by Prime next day.
"Activation code", sent by email.
Now, I'd expect the pricing to reflect that order: most expensive at the top, least expensive at the bottom.
But...
Quote: [DELETED] 2020 | 5 Devices | 1 Year | Antivirus and Secure VPN Included | PC/Mac/Android | Activation Code by Post
Activation Code in Frustration Free Packaging
£23.99
FREE One-Day
Get it Tomorrow, Aug 3
More buying choices
£21.00 (7 new offers)
Activation Code by Email
£3.99 delivery
Activation Code in Standard Packaging
£24.86
FREE One-Day
Get it Tomorrow, Aug 3
It's more expensive to sell me a an electronic code, shipped electronically, than to stock a physical item, and physically deliver it to me? 
And frustrating packaging costs more than frustration free?
Are most of this companies customers masochists? 
"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
"Common sense is so rare these days, it should be classified as a super power" - Random T-shirt
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
