Browse by Tags

• 70-445
• 70-446
• Asynchronous components
• BI
• BIDS
• BIDS Helper
• Buffers
• Business Intelligence
• Code
• Convert String date
• Exam
• Expressions
• Fully-blocking components
• Iif()
• InScope()
• Layout
• Lookup Transformation
• Matrix
• MCITP
• MCTS
• Microsoft Certified IT Professional
• Microsoft Certified Technology Specialist
• Non-blocking components
• Performance tuning
• Rendering reports
• Row height
• Script Task
• Semi-blocking components
• SQL Server 2008
• SQL Server Analysis Services
• SQL Server Integration Services
• SQL Server Reporting Services
• SSAS
• SSIS
• SSIS Caching
• SSRS
• Subtotal
• Synchronous components
• Threads
• Transformations
• VB .NET

• SSIS - Convert various String date formats to DateTime with the Script Task

  The script below is really nice if you need to convert String dates that come in different (unexpected) formats. Just copy and paste the code in your Script Task (paste the function outside Main() ) and it works right away. Supported date formats: YYMMDD... Posted Jun 12 2008, 02:01 PM by jorg with | with 1 comment(s) Filed under: SQL Server 2005, SQL Server Integration Services, SSIS, Script Task, VB .NET, Convert String date, Code

• 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 – Non-blocking, Semi-blocking and Fully-blocking components

  How can you recognize these three component types, what is their inner working and do they acquire new buffers and/or threads?... Posted Feb 27 2008, 04:59 PM by jorg with | with 3 comment(s) Filed under: SQL Server 2005, SQL Server Integration Services, SSIS, SSIS Caching, Non-blocking components, Semi-blocking components, Fully-blocking components, Synchronous components, Asynchronous components, Buffers, Threads, Transformations, Performance tuning

• 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

• SSRS - Custom expressions for subtotals in a matrix

  If you want custom expressions for your subtotals in a matrix, for example to calculate an average instead of the default sum, you need to use the InScope() and Iif() functions in your data field…... Posted Dec 06 2007, 03:14 PM by jorg with | with 5 comment(s) Filed under: SQL Server 2005, SQL Server Reporting Services, Business Intelligence, BIDS, Layout, SSRS, Matrix, Expressions, InScope(), Iif(), Subtotal

• SSRS – Invalid row heights, BUG?

  It seems that SSRS renders row heights of matrices wrong when a row contains one or more empty cells. This can be solved by changing the padding property…... Posted Nov 19 2007, 10:56 PM by jorg with | with no comments Filed under: SQL Server 2005, SQL Server Reporting Services, BIDS, Rendering reports, Layout, Row height, SSRS

• SSAS 2005 - Visualize Attribute Relationships

  SQL Server 2008 has a new feature that visualizes your attribute relationships in SSIS. This feature is also available for SQL Server 2005 with BIDS Helper…... Posted Nov 16 2007, 01:03 PM by jorg with | with 1 comment(s) Filed under: SQL Server 2005, SQL Server 2008, SQL Server Analysis Services, BIDS, BIDS Helper, SSAS