Lohn Solutions

Here’s this week’s weekly challenges…1. Custom Web App #1 Rolled out2. Cognos Changes – realignment – historic data realigned and promoted – new model with tightened security and changes for realignment – testing client on Oracle hosted site – changed process that triggers [...]

Here’s this week’s weekly challenges…

1. Audit data pulls – Had to export entire table for auditors – Came up with function for Julian date2. New Cognos group – New group of developers getting started with Cognos – Going against hosted oracle servers3. Cognos [...]

Here’s this week’s weekly challenges…

1. Audited on Cognos again, this time by an external Auditor on: – Server security – Change process

2. Custom web app – Security issues were actually database security issues (service account didn’t have rights to execute new login procedure) – DNS got updated, so now there is a user [...]

Here’s this week’s weekly challenges…

1. Disaster recovery documentation updated – Had to write a SQL 2000 install checklist – I’ve only installed MSDE and SQL2005 here, so I wrote it on the fly – Used this site as a guide

2. ETL and cube builds [...]