75
votes
How can I discourage sharing internal API keys within a company?
In order to share those keys between teams, the teams need to talk to each other, agree to share, then share them. This takes time. So if a team can request API keys from you more quickly and more ...
- 39.3k
36
votes
Why Isn’t SQL More Refactorable?
Locking down the creation of database views is often done by organizations paranoid of performance problems in the database. This is an organizational culture issue, rather than a technical issue with ...
- 37.2k
25
votes
Accepted
Why Isn’t SQL More Refactorable?
I think the main problem is that not all databases support Common Table Expressions.
My employer uses DB/2 for a great many things. The latest versions of it support CTEs, such that I'm able to do ...
- 466
20
votes
How can I discourage sharing internal API keys within a company?
Good answers already, I just thought of a different approach which may or may not work for you.
Rather than issuing keys to be included you could require the header of requests to include the name of ...
- 18.4k
16
votes
How can I discourage sharing internal API keys within a company?
In short:
First: facilitation and benefits; If necessary: friction and police.
Some more words
Facilitation: First, make it easy for a team to get a new API key. For instance add a reminder in the ...
- 77.2k
12
votes
Why Isn’t SQL More Refactorable?
The thing that I think you might be missing from your question / point of view is that SQL executes operations on sets (using set operations etc.).
When you operate on that level you, naturally, give ...
- 249
9
votes
Are on-premise software solutions safe for the vendor? It seems the client can steal the code
I'm wary about on-premise solutions. It appears to me that the client has access to the source code
No. They have access to an executable that is semantically equivalent to the source code, but it ...
- 104k
9
votes
Accepted
How to avoid pushing Github Enterprise code to my personal Github account by mistake if both are configured in my work computer?
Git, on the client side, does not associate the authentication-method with the repository-address. Accidental pushes to personal repositories are thus NOT possible by simply changing the ssh-keys.
...
- 236
7
votes
How to ensure long-term enterprise software stability with changing frameworks / things going out of support?
The more you leverage Other Peoples Work TM the more your are at the whim of other people.
So there are four ways to handle this:
Pay a Not Inconsequential Amount of Money to develop and maintain ...
- 16.2k
6
votes
How can I discourage sharing internal API keys within a company?
Generally the easiest way to get developers to "do the right thing", is to make it easy for them to do so.
To that end I would suggest building a API key issuing web page/site.
In its simplest form ...
- 3,338
6
votes
Accepted
Is it a fallacy to say that system migrations don't suit an agile methodology as the requirements are known up front?
Yes, it's a fallacy.
What your Manager call: "requirements are known up front" falls into the category of Predictive Planning. "We know what to do, so it just takes to assign tasks to people and ...
- 14.6k
6
votes
Why Isn’t SQL More Refactorable?
I'm am going to focus on the "subqueries" in your example.
Why are they used so often? Because they use the natural way of thinking of a person:
I have this set of data, and want to do an action on a ...
- 13.2k
5
votes
Staging environment vs Production environment
As a web developer, there are mainly three environments to consider practically:
Production: The environment configured to host the final release version of a product targeting end users. It is ...
- 151
4
votes
Is it a fallacy to say that system migrations don't suit an agile methodology as the requirements are known up front?
Your question holds a bolder statement than the quoted manager's.
The quoted manager states it is not needed, as if it would require a bigger investment to do an agile project compared to a non-agile ...
- 18.4k
3
votes
Is it a fallacy to say that system migrations don't suit an agile methodology as the requirements are known up front?
Yes. The set of all requirements is never known at the start of a project. By proudly saying they are not using an agile methodology, it's as if they are saying "We reject the chance of having to ...
- 119
3
votes
Accepted
Why should you test for backward compatibility during sprint testing?
also test 'Sprint 9 frontend from production' against 'Sprint 10 backend from stage'
This is an important test case if you want to decouple the frontend and backend deployments which is necessary if ...
- 9,197
3
votes
Best practice on how can I change the structure of a live database without losing data inside
You need to write/generate scripts that have the changes you made in them. For example if you add a few columns to the table the SQL for this might be:
ALTER TABLE dbo.doc_exa ADD column_b VARCHAR(...
- 193
3
votes
The advice I've found is to use LTS tools for work, instead can start on a new version if I know the next LTS will come out before project completion?
The advantage of LTS projects is not the newness, but the length of time to get patches. Not all updates are created equal, and having access to patch-only releases can save time and reduce overall ...
- 82.7k
3
votes
How to ensure long-term enterprise software stability with changing frameworks / things going out of support?
Summary
Abstract dependencies that can be reasonably abstracted, so you're prepared for needing to swap them out in the future.
If you're relying on vendor support, vet your vendors and take a good ...
- 49.8k
2
votes
Why Isn’t SQL More Refactorable?
Segregation of duties
In the SQL spirit, the database is a shared asset that contains the company's data, and protecting it is of vital importance. Enters the DBA as guardian of the temple.
Creating a ...
- 77.2k
1
vote
The advice I've found is to use LTS tools for work, instead can start on a new version if I know the next LTS will come out before project completion?
What is LTS, and who does it benefit?
Some developers/companies chase the latest and greatest technology. Others try to stick with what they used at the time and settle down on this chosen version; ...
- 49.8k
1
vote
How can I discourage sharing internal API keys within a company?
How can we incentivise developers not to share API keys internally?
Generate keys as a result of self-service application registration.
Require a point of contact before keys become active.
And ask ...
- 14.7k
1
vote
Why Isn’t SQL More Refactorable?
Re points 1 & 3: Views aren't the only way. There are also temporary tables, marts, table variables, aggregated columns, CTEs, functions, stored procedures and possibly other constructs depending ...
- 9,815
1
vote
What are criteria for enterprise to have multiple databases (for new project)?
It can happen to require multiple databases, but generally this happens out of necessity, and not for design or performance reasons. The reasoning is that the usage of a database and its advantages/...
- 22.8k
1
vote
Best practice on how can I change the structure of a live database without losing data inside
You need three sets of scripts:
to prepare your database for migration
to perform the migration
to put your database back in a workable state
In preparing your database for migration, it is ...
- 111
1
vote
How to avoid pushing Github Enterprise code to my personal Github account by mistake if both are configured in my work computer?
I've participated in work environments where everything was open. I could surf wherever I wanted, install whatever I wanted on my work computer, use a private Github account, and access Facebook and ...
- 200k
1
vote
Accepted
test (or qa) vs staging environment - clarification on how staging env functions
Should staging be 100% identical to prod?
I believe that the answer to this question can vary significantly from company-to-company. You should discuss the specifics of your company's various ...
- 74
1
vote
Accepted
Enforcing constraints across databases
In general it's a bad idea to try to enforce this accross databases. You already said that each business unit has it's own architecture. So as long as every one knows who owns what piece of data then ...
- 460
1
vote
Is it a fallacy to say that system migrations don't suit an agile methodology as the requirements are known up front?
Depends. There are many types of migration.
In many cases, you will be migrating from one fully functional application to another fully functional application. Since the new application is a fully ...
- 26.5k
1
vote
Standard API Protocol for ECM Systems?
Content Management Interoperability Services (CMIS) was an attempt at standardization:
Ovum urges organizations to take a "solutions view" to ECM by thinking about their pain-points and then ...
Only top scored, non community-wiki answers of a minimum length are eligible