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 [...]
Here’s this week’s challenges….
1. Ran SQLIOStress test on all servers in one environment – here’s an overview of what it does – I did graph the results and found that although the configurations where nearly the same on two of our top end servers – the speed was slightly better on one. [...]
Here’s this week’s weekly challenges….
New release went out last Friday, 4/18/08 – lots and lots of SQL servers
Two SQL 2005 Clustered 64 bit
Two SQL 2005 64 bit Log Shipping servers
Three SQL 2005 Utility servers
Eight SQL 2005 Express servers
One SQL 2000 utility server
I spent most of the week in in the “War” room with a consultant [...]
Here’s this week’s challenges:
- Installed and configured SQL 2005 Reporting Services on two Servers.- I kept getting an error when installing SQL 2005 on a different server. The source was a network drive that had the install on it. It would get to VSS writer and then bomb every time. [...]
This was another fun filled week with new SQL issues I hadn’t experienced in smaller environments.
1. I installed the wrong version of SQL on a server. It was a miscommunication between the network guy and myself as I read the OS column which was supposed to be Enterprise – I assumed it was [...]
It’s been a heckuva week…At my previous job, I went from working with one big beefy 64 bit, dual processor, with 4 GB of RAM and about 200 GB of total space. This week, I installed and configured SQL 2005 64 bit edition on two two-node clusters and three single node clusters. All [...]
I haven’t forgotten about this site – I’ve got a new job. I’ve gone out on my own and am starting a consulting company. At this point, it’s all SQL based. That will be the primary focus. It’s been two weeks since I left AMS and so far so good. [...]
Here’s this week’s challenges:
2008 Objectives
Applications Group Objectives – led group meeting to brainstorm department direction
Personal – most interesting are:
Take Dale Carnegie Class
To meet expectations MCITP: Database Administrator
To Exceed – MCITP: Database Developer Certification
Issues with Teleforms
Studying for 70–443 MS SQL Test – brushing up on test taking skills
Datamart planning
Hardware Architecture
Project planning
Coming up next week:
Cognos development environment [...]
Here’s this week’s weekly challenges…
Cognos GL Datamart planning- Cognos 8.1 vs upgrading to 8.3- Positives are performance and administration enhancements- Business case for datamart is to improve performance- Adds risk of missing timeline as 8.3 changes touch everythingETL changes moved to QA- Everything involved in our ETL was touched from DTS packages, to Cognos packages [...]