SQL Server Business Intelligence

How to Import Data from Microsoft Office Excel 2007 to SQL Server 2005

SSIS Developers often come across a scenario where they need to import data from a Microsoft Office Excel 2007 Spreadsheet. This article provides a step by step guide on how to import data from a Microsoft Office Excel 2007 Spreadsheet to a SQL Server 2005 database. The first step is to go to Start and select Run and […]

How to Export Data to Microsoft Office Excel 2007 Using SQL Server 2005

SSIS Developers often come across a scenario where they need to export data to a Microsoft Office Excel 2007 spreadsheet. This article provides a step by step guide on how to export data to Microsoft Office Excel 2007. The first step is to go to Start | Run | CMD and type DTSWIZARD. The welcome to SQL Server Import and […]

Slowly Changing Dimension in SQL Server 2005 – Part 2

Introduction Having discussed type1 slowly changing dimensions (SCD) in Part 1 of this article, this article will talk about further on SCDs and how we can implement them in SQL Server 2005. What is Type2 SCD A Type 2 SCD writes a record with the new attribute information and preserves a record of the old dimensional […]

Slowly Changing Dimensions in SQL Server 2005

Introduction Slowly changing dimensions (SCD) are very useful in data warehouses. Even though they are useful, it is very difficult to implement slowly changing dimensions with most of ETL tools. In case of SQL Server 2000 it was difficult to implement SCD’s as there was no direct way of implimenting them.  As you are aware there […]

Same Report but Different Methods in SQL Server Reporting Services

Introduction SQL Server Reporting Services (SSRS) in SQL Server 2005 has given users many options to on how to create a report. This article describes several methods that can be used to develop the same report. In addition, we will analyse the performance of each method so that we know the pros and cons of each option. […]

Building Cubes with SQL Server 2005 Analysis Services

I admit that when it comes to SQL Server Analysis Services (SSAS), I found plenty of reasons to not get started. I have enough to do on a daily basis and I was just not very interested in learning about how to build cubes. Also, there is not much of a demand for cubes where […]

Script Component as Data Source

Introduction If you were asked what are the data sources that you can use as a data source for SQL Server Integration Services (SSIS), you may say list the out of the box data sources such as, SQL Server Oracle, DB2 etc and flat files such as Text files and CSV files or Excel. If […]

Check List for Performance Optimisation in SQL Server Analysis Service 2005

Introduction No matter what your platform or the tools that you are using, performance is almost always the number one feature that customers require.  In the case of SQL Server Analysis Service (SSAS), there are four areas where we can improve the performance. They are database design, processing, querying and configuring SSAS.  Key Attribute For […]

Analysis Services in High Data Volume Business scenarios

Executive Summary The realization of the importance of data warehouses coupled with ever decreasing price of hardware and advanced computing options has resulted in datawarehouses of thousands of gigabytes over the last few years. This in turn has paved way for OLAP solutions that store detail and aggregate data for optimally answering complex business queries […]

Create Local Cubes with Microsoft SQL Server 2000 and Microsoft Office

As the number of people who are conducting business from outside the corporate workplace increases, the need to access corporate databases using devices such as mobile phones and portable computers also increases. The corporate world invests considerable resources in capturing volumes of data. Online Analytical Processing (OLAP) is a popular technology used to collate and […]
Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |