Runs the consulting firm IN2BI (www.in2bi.com) dedicated to helping companies get the most out of their investment in Microsoft Business Intelligence tools. His field of interest is broad and ranges from presenting relevant information in dashboards and reports to efficiently collecting data in data warehouses.
He is the architect behind the following BI products:
- Webdashboard from his previous company In Summa (www.insumma.nl)
- Het DWH Deck from IN2BI.
|
This is the second post in a series on on logging in SSIS. In the first post I described logging package and tasks within a package by using an event handler. In this post I’ll describe a second method: Logging Package Execution in the control flow. It’s a very common pattern: At the start of ...
|
|
The project deployment model in SSIS (2012) offers great default logging functionality. However you may find yourself in need of additional functionality, especially if you use the package deployment model or an earlier version of SQL Server. In this series on logging I dive into 3 methods: ...
|
|
Best practice dictates that we use a separate server for each of these SQL Server Services. And this seems logical because otherwise these services will compete over server resources. In IT we call this competition: contention. However there are some great reasons to put these services on one box: ...
|
|
I’m a big fan of Stephen Few who has written some nice books on data visualization and dashboard design. What I dislike in his writings (and that of a lot of other business intelligence practitioners) is the overemphasize on bad performance. The winner and runner-up of the recently held ...
|
|
In an earlier post I described the necessity to drop non-clustered indexes before loading data in your data warehouse and rebuilding them afterwards. Later I found a better approach: Instead of dropping the indexes you can just disable them with: ALTER INDEX <IndexName> ON <TableName> ...
|