Know-how von Experten für Experten

BI & Big Data Blog

Technical Value
Check multiple table usage in SSIS packages with Powershell
In my last post about checking table usage in SSIS packages with Powershell I explained how to use Powershell to find out the SSIS packages that access one table (or any other object like a view or a stored procedure… Weiterlesen
Technical Value
Check table usage in SSIS packages with Powershell
In BI projects you sometimes want to rename a database table or move a database table to a different database schema. There are several reasons why you might want to do this, the rules for naming objects may change,… Weiterlesen
Technical Value
Find disabled SSIS-tasks using Powershell, part 1
SSIS provides a functionality which is a really helpful and dangerous at the same time: Disabling of Control Flow tasks. It is really helpful during development, because you can disable all the tasks you don't need for… Weiterlesen
Technical Value
Hohe Datenqualität erfordert Mix aus Software und Best Practices
Der Aufwand für die Qualitätssicherung der Daten in Business-Intelligence- und Big-Data-Projekten wird oft unterschätzt. Ein Mix aus Software-Tools und Best Practices ist erforderlich. Anhang: Hohe Datenqualität… Weiterlesen
Technical Value
Automated Data Quality checking
As mentioned in my previous article about the automated data quality checking in a Bi environment, I recently encountered the need to compare quite a number of sources with various restrictions / filters, but with very… Weiterlesen
Technical Value
How to detect the loss of data automatically before it's final destination
The transfer of a big amount of data usually is quite time consuming. Given the fact that in many cases the transfer is performed over several environments (e.g. prod. environment, stage and cube), the time required… Weiterlesen
Technical Value
We have a project featuring not only billions of data records but also huge amount of logic in ETL formed after years of development. In order to include principally new business logic and to optimize the performance… Weiterlesen
Technical Value
Creating test data with a script component in SSIS
In this article I would like to show you how to generate test data with a script component in SSIS. You often construct a data flow in SSIS and want to test it with sample data. Creating appropiate test data can be… Weiterlesen
Technical Value
Agile BI Tools - Implementing Feature Toggles in SSIS / SSDT
Reminding the values of the Manifesto for Agile Software Development: Individuals and interactions over processes and tools, working software over comprehensive documentation, customer collaboration over contract… Weiterlesen
Technical Value
PDW 2012 | SQL Server 2012 | SQL Server 2014 If your source data contains a subsequent number without gaps it’s relatively easy to find out if data rows are missing. The approach I’m showing here uses window functions… Weiterlesen
Technical Value
SQL Server 2005 | SQL Server 2008 | SQL Server 2008R2 Today we released the new version of BI.Quality on Codeplex . The new release contains many features from the wishlist (check the release notes for details):… Weiterlesen
Technical Value
SQL Server 2005 | SQL Server 2008 | SQL Server 2008 R2 There is a new testing suite for BI solutions named BI.Quality available at codeplex: . The suite is based on NUnit and supports… Weiterlesen

Newsletter Anmeldung

Abonnieren Sie unseren Newsletter!
Lassen Sie sich regelmäßig über alle Neuigkeiten rundum ORAYLIS und die BI- & Big-Data-Branche informieren.

Jetzt anmelden