Microsoft Certified Technical Specialist for SQL Server

I am officially a Microsoft Certified Technical Specialist for SQL Server. I passed the MCTS exam, Microsoft SQL Server 2005 Implementation & Maintenance on Tuesday.

Cognos 8 Authoring and Modeling FastTrack – All my Links

Here are all the links for the Cognos 8 Authoring and Modeling FastTrack class in one spot:

Acronym’s and Terms used in Cognos 8 Authoring and Modeling FastTrack
Overview of the entire Cognos 8 Environment
Day 1 notes
Day 2 notes
Day 3 notes
Day 4 notes
Day 5 notes

This was my weekly challenge as well.

Cognos 8 Authoring and Modeling FastTrack – Day 5

Here are my notes on Day 5.

The class was very good, I wish I would have taken it before I was thrown into the fire. Actually, I wish I would have taken the class and then worked more with the developers to model the data in a different way. I think I [...]

Overview of C8 Process Diagram

Here’s an overview of the entire Cognos 8 Environment (click here for larger picture):

Acronym’s and Terms used in Cognos 8 Authoring and Modeling FastTrack

Here’s my list so of acronym’s and terms used in Cognos 8 Authoring and Modeling FastTrack

Some of the standard onesMDX – Multidimensional ExpressionsOLAP – Online analytical processingSQL – Structured Query LanguageXML – Extensible Markup LanguageDMR – Dimensionally Modeled Relational DatabaseETL – Extract, Transform and Load

Cognos SpecificLCB – List Column BodyMUN – Member unique name (in [...]

Cognos 8 Authoring and Modeling FastTrack – Day 4

Today things started to all come together at training. Some of the set up stuff made since while were were doing it, but the big picture all came together on why were were doing it. Here’s the notes.

One more thing that caught my eye that’s pretty simple is idea.

Cognos 8 Authoring and Modeling FastTrack – Day 3

Another day in training. Here are my notes from Day 3.

Cognos 8 Authoring and Modeling FastTrack – Day 2

Another day in training. Here are my notes from Day 2.

Cognos 8 Authoring and Modeling FastTrack – Day 1

I’m taking the class Cognos 8 Authoring and Modeling FastTrack this week. Here are my notes from Day 1.

Weekly Challenges 11/02/07

1. Centerfield Technology Homerun package Training- Used tools in production for troubleshooting AS400 and Cognos locks- Similar to MSSQL management software I’m used to

2. Tracing Cognos servers during month end processing for troubleshooting AS400 and Cognos locks- Every hour on the hour ran traces- Traces locked up servers twice as it uses lots of memory

3. [...]