Browse by Tags

• BI
• BIDS
• BIDS Helper
• HOLAP
• Hybrid Online Analytical Processing
• Latency
• MOLAP
• Multi dimensional Online Analytical Processing
• Relational Online Analytical Processing
• ROLAP
• SQL Server 2005
• SQL Server 2008
• SQL Server Integration Services
• SQL Server Reporting Services
• SSAS Storage types
• SSIS
• SSRS

• Start / Stop SQL Server, SSIS, SSAS, SSRS and SQL Server Agent at once with a batch file

  A lot of developers have SQL Server and its different services running on their PC or notebook to develop or test BI solutions. Unfortunately this slows down your system quite a lot. To speed things up when not using SQL Server, I used to stop and start... Posted Jan 06 2009, 08:02 PM by jorg with | with 4 comment(s) Filed under: SQL Server 2005, SQL Server Integration Services, SQL Server Analysis Services, SQL Server Reporting Services, SSAS, SSRS, SSIS, BI

• SSAS – MOLAP, ROLAP and HOLAP storage types

  In SSAS 2005 there are 3 basic OLAP storage types. What are the advantages and disadvantages of those types and how do they behave…... Posted Mar 27 2008, 03:33 PM by jorg with | with 1 comment(s) Filed under: SQL Server Analysis Services, SSAS, SSAS Storage types, MOLAP, ROLAP, HOLAP, Latency, Multi dimensional Online Analytical Processing, Relational Online Analytical Processing, Hybrid Online Analytical Processing

• 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