- 4.2k
Gratis E-Book: Introducing Microsoft SQL Server 2012
Gratis e-book van Microsoft te download op deze website: Friends, the final and complete version of Introducing Microsoft SQL Server 2012 , by Ross Mistry ( @RossMistry ) and Stacia Misner ( ...
- 9.7k
Datawarehouse and Datamart - Empty Strings or NULL Values?
I was wondering what's the best method to store empty fields from source systems in a datawarehouse. For example;a customer record without a first name stored in the database. When loading this ...
- 3.7k
Tablix filter with the LIKE operator
The LIKE operator in Reporting Services works a little differently than in SQL. You would expect to use a %. Nothing could be further from the truth. So much for consistency.
- 5.3k
Calculating running totals
A lot has been written about it on the internet already, but I thought it was worth posting an article about calculating running totals in Microsoft SQL Server 2005 / 2008. There are ...
- 9k
How do I create a Period Dimension?
This blog covers the period dimension. It looks a lot like the date dimension discussed earlier (and indispensable in every data warehouse), but its function is a little different. The power of ...
- 7.5k
Data Vault AdventureWorks Example
There are many articles on the internet about the Data Vault. It is a method/data model to design a data warehouse. What strikes me is that there are no good examples (yet) of the ...
- 4.8k
One Single Version of the Truth does not exist
This week I went to a seminar at Logica called Guru4Pro. The subject was: “Best Practices in Data Vault”, and the Godfather of Data Vault, Dan Linstedt, was one of the speakers.
- 3.7k
SSRS Best Practice II - Use Stored Procedures
I did some research on the internet into which source is better for a Reporting Services report. Below are the advantages of using Stored Procedures.
- 7.8k
Data conversion performance in SSIS
Today I came across a very good article by the SQL CAT team about the performance differences between the different ways to convert data types in SSIS.
- 4.6k
How do I create a time dimension?
Time dimensions, like date dimensions, are useful when you want to store the properties of a point in time for a fact. If you want to record the time of a sale, for example, you store ...
- 7.6k
Controlling ETL jobs in a Data Warehouse
There are several ways to start the ETL jobs of a data warehouse. You can create an SSIS package that calls all underlying ETL packages. You can also create an SSIS package that ...
- 3.9k
Script all databases and objects
Following an earlier article about scripting your database objects, I made a stored procedure that scripts all databases for you automatically and writes the script to a ...
- 6.2k
Metadata – Table growth in data warehouses
While working out how to manage metadata (stored in a metadata database) for our data warehouse, the topic ‘table growth’ came up. In a data warehouse it is useful to know ...
- 7.3k
ETL Tool or SQL
In an earlier article I wrote about the advantage of handling changes in a dimension with the Kimball Slowly Changing Dimension Type 2 principle, creating a new ...
- 8.7k
Updating a dimension in a data warehouse
In an earlier article I wrote about the benefit of handling changes in a dimension with the Kimball Slowly Changing Dimension Type 2 principle: creating a new ...
- 5.9k
Historical Staging Area HSA in a DWH project
In Data Warehouse projects there is always the question of which architecture works best. Every architecture has its own pros and cons. What I find important in an architecture ...
- 4.9k
Why not just Type 2?
In a Slowly Changing Dimension scenario you normally decide per field whether it is a type 1, type 2 or type 3 field. With a type 1 the record is overwritten with the new value, with ...
- 4.1k
Dimension lookup optimization
To update the dimension/fact, you must find out if a record already exists. Normally you do this by looking at the business key (natural key) in the dimension. If it is not ...
- 6.2k
Decrypt Stored Procedure, Views, Functions in SQL Server
Last week I had a stored procedure in my SQL database which was encrypted. On the internet, you can find a lot of (payed) tools to decrypt a stored procedure but I also found this script. This script ...
- 4k
SSIS Package Configurations
Working with SSIS packages can cause problems when you have to develop across different environments. Dougbert.com links to some SQL MVPs in a short blog post ...
- 3.7k
MSc Business Intelligence
In 2010 DNV Academy CIBIT will be the first Dutch training institute to start an official Master of Science programme in Business Intelligence. On 12 March there was an information evening about it ...
- 3.8k
Checkpoints in SSIS
The Control Flow in Integration Services gives you control and an overview of the tasks that run in your package. But when one of these tasks fails, you often do not want ...
- 3.9k
Exporting SSIS data to Excel 2007
Below is a short description of how to connect to Excel 2007 from SSIS.
- 4.3k
Exporting more than 65,000 rows to Excel
From Report Manager you can export a report to Excel. But Excel 2003 can only handle 65,000 rows per sheet. With this little trick you can get around this problem easily.
- 4k
SQLBI Methodology
This week I came across an interesting piece of information about a methodology for BI and data warehouse solutions. As most people know, the biggest theories in the BI market ...
(25 rows affected)
Completion time: