Lohn Solutions

Here’s what I’ve been working on this week:

Staging Enviroment

Deployed new rev to Staging
A couple issues with Archive server deploy, four part names, linked servers, etc.  Resolved so be dynamic
Deadlock investigation – two types showing up, one fixed with code logic, investigation continues on the other

Prod Staging Environment

Deployed stable rev to Prod Staging
Service Pack 3 applied

Issues [...]

Here’s what I’ve been working on this week

We’ve added a new SQL server to our staging environment that has a database for archived data. 

Spent a bit of time troubleshooting the deployment process of this.
Added four part names to synomyns that need to use a linked server to get to the archived data
Identified and disabled triggers [...]