Browse by Tags

• 70-445
• 70-446
• BIDS
• Exam
• Expressions
• Layout
• Lookup Transformation
• Matrix
• MCITP
• MCTS
• Microsoft Certified IT Professional
• Microsoft Certified Technology Specialist
• SQL Server 2005
• SQL Server Integration Services
• SQL Server Reporting Services
• SSIS
• SSIS Caching
• SSRS

• MCITP - I passed the 70-446 “PRO: Designing a Business Intelligence Infrastructure by Using Microsoft SQL Server 2005” exam!

  Today I passed the Microsoft IT Professional(MCITP) 70-446 “ PRO: Designing a Business Intelligence Infrastructure by Using Microsoft SQL Server 2005” exam. This makes me one of the 337(January, 2008) Microsoft Certified IT Professionals worldwide! (... Posted Mar 28 2008, 02:25 PM by jorg with | with 1 comment(s) Filed under: Microsoft Certified Technology Specialist, MCTS, 70-445, 70-446, MCITP, Exam, Microsoft Certified IT Professional, SQL Server 2005, Business Intelligence, BI

• SSIS – Lookup Transformation is case sensitive

  How can you safely use the lookup component…?... Posted Feb 12 2008, 04:34 PM by jorg with | with 3 comment(s) Filed under: SQL Server 2005, SQL Server Integration Services, Business Intelligence, BIDS, SSIS, BI, Lookup Transformation, SSIS Caching

• SSRS – Static column headers in a Matrix

  If you create a matrix with dynamic columns you can create one static heading column over top of your dynamic columns…... Posted Dec 12 2007, 04:36 PM by jorg with | with 1 comment(s) Filed under: SQL Server 2005, SQL Server Reporting Services, Business Intelligence, BIDS, Layout, SSRS, Matrix, Expressions, BI