Software Listing of Author : "Sql Lion"
- Duplicate Remover for SQL Server 2005
- License: Shareware
- Price:


Cleaned and error free data: this is the common phrase that we normally listen from most of the data warehouse users. So to make this statement true, SQL Lion team has come up with a tool named Duplicate Remover.
The Duplicate Remover was designed to search for the presence of duplicate records (redundancy in tables at record level) as per the selected databases and tables from SQL Server instance, and list them. After checking the redundant tables, the user can customize the delete operations to limit the deletion to certain tables.
- Platform: Win2000, WinOther, WinServer, WinVista
- Duplicate Remover for SQL Server 2008
- License: Shareware
- Price:


Cleaned and error free data: this is the common phrase that we normally listen from most of the data warehouse users. So to make this statement true, SQL Lion team has come up with a tool named Duplicate Remover.
The Duplicate Remover was designed to search for the presence of duplicate records (redundancy in tables at record level) as per the selected databases and tables from SQL Server instance, and list them. After checking the redundant tables, the user can customize the delete operations to limit the deletion to certain tables.
- Platform: Win2000, WinOther, WinServer, WinVista
- Expert Logger
- License: Freeware
- Price: 0.00


SSIS provides a unique feature to track the execution of the packages so that it can be utilized for debugging or analyzing performance later. Here the application provides an ultimate way to set the logging features of the packages batch wise i.e. set log features to all the packages at a time.
Functionalities:
Supports Flat File logging only.
Supports packages stored in hard drives only.
Supports 18 types of logging.
Logs up to 7 types of information regarding the package.
Compatible user interface.
Visit
[http://www.sqllion.com/2009/05/expert-logger/]
for more information SSIS logging. Expert Logger | SQL Lion. Batch logging of all the SSIS DTS packages.
- Platform: Win2000, Windows Server, Windows Vista, WinOther
- Expert Logger for SQL Server 2005
- License: Freeware
- Price: 0.00


SSIS provides a unique feature to track the execution of the packages so that it can be utilized for debugging or analyzing performance later.
Expert Logger is an an utility which provides a great solution to set the logging features of the packages batch wise i.e. set log features to all the packages at a time.
Here are some key features of "Expert Logger":
* Supports Flat File logging only.
* Supports packages stored in hard drives only.
* Supports 18 types of logging.
* Logs up to 7 types of information regarding the package.
* Compatible user interface.
- Platform: Win2000, WinOther, WinServer, WinVista
- Expert Logger for SQL Server 2008
- License: Freeware
- Price: 0.00


SSIS provides a unique feature to track the execution of the packages so that it can be utilized for debugging or analyzing performance later.
Expert Logger is an an utility which provides a great solution to set the logging features of the packages batch wise i.e. set log features to all the packages at a time.
Here are some key features of "Expert Logger":
* Supports Flat File logging only.
* Supports packages stored in hard drives only.
* Supports 18 types of logging.
* Logs up to 7 types of information regarding the package.
* Compatible user interface.
- Platform: Win2000, WinOther, WinServer, WinVista
- Extreme Catalog Pro
- License: Shareware
- Price: 9.80


The program catalogs, contents of your media, imports descriptions and thumbnails, and makes it available for offline browsing and searching. Extreme Catalog Pro is ideal to handle your downloaded programs, magazine CD-ROMs or DVD-ROMs, music collections like MP3s or audio CDs, graphics collections, documents and all other types of files. You can access the contents of your collection from the cataloged database, even if the media itself is not available on the system - you can browse lists of files and folders, search by any criteria, use descriptions, thumbnails, categories, flags, etc. Extreme Catalog Pro is very user friendly and easy-to-use software for cataloging disks, folders and files. Have you ever had to look through dozens of CDs, trying to find some file or song? With Extreme Catalog Pro you will never waste your time...
- Platform: Win2000, Windows Server, Windows Vista, WinOther
- SSIS Component Explorer 2005
- License: Shareware
- Price: 38.00


"SSIS Component Explorer" is the best utility to develop SSIS package programmatically in C# .net with more ease and effectiveness. This auto generates backend code for all the components in SSIS. Moreover it describes all the components and their relative properties like Creation Name, Component ClassId, etc required to develop a package. Download Now. In the world of data warehousing, SQL Server Integration Service (SSIS) is a popular platform for building high performance data integration solutions including Extraction, Transformation and Load (ETL) packages for data warehousing. But programming Integration Service has become more popular in between SSIS developers recently. So to help SSIS developers for boosting their programming abilities, SQL Lion team has come up with a unique tool called "SSIS Component Explorer". This tool...
- Platform: WinOther
- SSIS Component Explorer for SQL Server 2008
- License: Freeware
- Price: 0.00


In the world of data warehousing, SQL Server Integration Service (SSIS) is a popular platform for building high performance data integration solutions including Extraction, Transformation and Load (ETL) packages for data warehousing.
But programming Integration Service has become more popular in between SSIS developers recently. So to help SSIS developers for boosting their programming abilities, SQL Lion team has come up with a unique tool called "SSIS Component Explorerd-deDt. This tool can be used as a Swiss Army Knife, to hunt down critical problems while developing SSIS package programmatically.
SSIS Component Explorer is an easy-to-use tool which describes all the components and their relative properties like Creation Name, Component ClassId, etc required to develop a package. It includes the below...
- Platform: Win2000, WinOther, WinServer, WinVista
- SSIS Remove redundancy
- License: Freeware
- Price: 0.00


Here comes one more challenging yet interesting topic to tide over. The requirement goes something like this: You have some sources, let it be some sales data or some Call center data coming from different sources. Data can be of different media. But you are able to load it in your staging tables i.e. one staging database you are maintaining like StageDB for storing these incremental data. So, here we have both master i.e. Dimensional data and Detail i.e. Fact data in our stage database. But before processing further and loading it into our Mart or Data warehouse, we need to check if there is any redundancy at the row level for each of these tables in the staging database. Here comes the main problem, what if you don't know how many tables are there in the staging database and how many columns are there for each table in the staging...
- Platform: WinOther