Good evening everyone
Developers and Data analyst both write queries on the production servers. The developer writes entity framework while the analysts query the live database for ad-hoc request, create tables and sometimes create store procedures.
This obviously is not a best practice. We are looking to separate the developer role with data analysts. My initial guess is to have a new instance of server or database. The issues here, how do I make sure that the data analyst data is up to date and 24 hours behind. Any idea will be appreciated.