|
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!
|
|
|
|
|
If you're running Windows, you don't need to pay for an AV program. Windows Defender is now rated as highly as the paid ones. I also run Malwarebytes Premium, which is a paid subscription. I've never had a problem, and on several occasions Malwarebytes has intercepted attempts to access websites that contain Trojans. A couple of those links were actually from would-be articles on this site.
|
|
|
|
|
Defender annoyed the heck out of me last time I used it: no matter how I configured it, it insisted on doing a full scan at 14:00 every damn day. So every afternoon, my computer moved like a stunned slug on Mogadon.
And I want it to cover PC and android devices: Herself is starting to use the internet (only Google News and the weather forecast so far, but ... baby steps) and I'd rather she didn't stumble into something nasty. Using the same software across all five devices (two Android and three PC) just makes my life easier, is all.
"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!
|
|
|
|
|
Similar to above, there is one more variation in prices. Respective websites would sell the AV's in almost more than double the prices that are there on e-commerce sites like Amazon.
|
|
|
|
|
Sandeep Mewara wrote: Respective websites would sell the AV's in almost more than double the prices that are there on e-commerce sites like Amazon.
Unless there are legal restrictions on the maximum price, it's not illegal to sell something at higher than the going rate. It's up to you to ensure that you are actually getting the lowest price.
Freedom is the freedom to say that two plus two make four. If that is granted, all else follows.
-- 6079 Smith W.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
