Archive for

SQL SERVER – Download SQL Server 2014 CTP2 and Related Downloads

  SQL Server 2014 CTP2 was announced quite a while ago. With the pending release of SQL Server 2014 RTM, I figured it was a good time to make sure you got the free versions of SQL Server 2014 CTP2 downloaded just in case. Below are few of the downloads related to SQL Server 2014. … Continue reading

Top 10 Best Practices for Building a Large Scale Relational Data Warehouse

    Top 10 Best Practices for Building a Large Scale Relational Data Warehouse Building a large scale relational data warehouse is a complex task. This blog post describes some design techniques that can help in architecting an efficient large scale relational data warehouse with SQL Server. Most large scale data warehouses use table and … Continue reading

SSIS Execute SQL Task – “Parameter name is unrecognized”

Ever see this “Execute SQL Task] Error: Executing the query “XYZ” failed with the following error: “Parameter name is unrecognized.”. Possible failure reasons: Problems with the query, “ResultSet” property not set correctly, parameters not set correctly, or connection not established correctly”. This is one of those often overlooked errors resulting from forgetting to override the … Continue reading

What is ETL Mapping Document ?

In my travels I get questioned a lot regarding the importance of the ETL mapping document and do I have any good examples. Throughout my career I have developed many ETL mapping documents of various formats. I have taken a few minutes to outline the basics here. What is ETL Mapping Document :The ETL mapping … Continue reading