SSIS Data Conversion Performance Today I ran a very good article on the SQL CAT about performance differences between the different possibilities for converting data types in SSIS. Integration Services | Tuesday, May 25, 2010 Read More | Report SQL2008 R2 Launch Party Yesterday was the day. Microsoft has in Neuss, Germany, officially SQL2008 gelaunched R2. Through speakers and Steffen Krause and none other than Donald Farmer were the highlights of this release to the room filled expanded considerably announced. Other | Thursday, April 22, 2010 Read More |
How do I create a time dimension? Time Dimension date dimensions as useful when you want features of a time record for a certain fact. For example if you want to sell the time of a register save your time not in fact a record, but turn the key to the time dimension record. T-SQL | Wednesday, April 21, 2010 Read More | Grats R2 SQL2008 Book Microsoft has released a free eBook which are very useful things about SQL Server 2008 R2. Other | Friday, April 16, 2010 Read More |
Managing Data Warehouse ETL jobs within ETL jobs to a data warehouse to enable you to apply various ways. You can create an SSIS ETL packages underneath all calls. You can also create an SSIS package that all stored procedures for ETL process calls. Finally, you can create a Stored Procedure that calls all ETL jobs. The call to the ETL job can be a SQL agent job, a cmd file that a T-SQL script aanschopt or a stored procedure that does the work directly. BI and Datawarehousing | Wednesday, April 14, 2010 Read More | SQL 2008 R2 Launch Event On April 21, 2010, Microsoft will officially release SQL Server 2008 R2. This will be done in a preconference of the European Conference Pass at Neuss in Germany which will take place. Costs for the launch party: 199 Euro with your gift as a Technet Plus subscription (worth 199 euros ...) so that you receive after the launch- days equal to the current home can use Office 2010, SQL 2008 R2 and Sharepoint 2010. http://www.microsoft.com/germany/events/sqlserverlaunch/default.aspx See for more information. Are you there?! Other | Friday, April 9, 2010 Read More |
Script all databases and objects Following on a previous article about scripting your database objects, I created a stored procedure that automatically for your database scripts and the script writes to a folder. This script is created in SQL Server 2005. This is useful because now all objects such as tables, stored procedures, views and functions in a script it. T-SQL | Wednesday, March 3, 2010 Read More | Metadata - Table Growth in Data Warehouses During the drafting of the management of metadata (metadata storage in a database) for our data warehouse was part 'table growth' forward. In a data warehouse, it is useful to know how many tables and how the growth of these tables is developed. BI and Datawarehousing | Tuesday, March 2, 2010 Read More |
ETL Tool or SQL In a previous article I wrote about the advantage of dealing with changes within a dimension using the Slowly Changing Dimension Type 2 Kimball principle, creating a new row within a dimension. It explained the benefits of this method and how it works. Below is described the advantages of using T-SQL scripts against an ETL tool for updating a dimension. BI and Datawarehousing | Monday, December 14, 2009 Read More | Historical Staging Area HSA in a DWH project In Datawarehouse projects there is always the question of what architecture can best be deployed. Each architecture has its own advantages and disadvantages. What I think is important for an architecture is that it should be a flexible and scalable. In other words, it should be easily adaptable to new needs of the business and it should be "infinity" can be extended without restriction. The Datawarehouse project I now cooperating features a so-called "HSA" (Historical Staging Area). I think an HSA in any data warehousing project comes in handy. Below I give some advantages that I have encountered in practice to describe the HSA. BI and Datawarehousing | Friday, October 30, 2009 Read More |
Why not just type 2? Slowly Changing Dimension in a scenario is normally determined by field or a Type 1, Type 2 or Type 3 field concerned. In a Type 1 record is overwritten with the new value in a type 2, a new record is created and a type 3 the old value stored as an additional column in the dimension. Why not treat everything as Type 2? BI and Datawarehousing | Tuesday, September 8, 2009 Read More | Dimension Lookup Optimization For updating the dimension / fact must determine whether a record exists. This is normally done by looking at the key business (natural key) in the dimension. If not found, it is a new record and it should be you-insert. If this is found and it has changed the record should be updated (Type 1) or should a new record to be created (type 2). I am what the expirementeren been to the process of doing a lookup to accelerate. Here my findings so far. BI and Datawarehousing | Wednesday, August 12, 2009 Read More |
Decrypt Stored Procedures, Views, Functions in SQL Server 2005 I had just one item in my database that was encrypted. There are various tools on the Internet for sale to decrypt the whole thing but I found a free script that does the job. This script can Stored Procedures, Functions, Triggers and Views decrypt. Below the script! T-SQL | Tuesday, June 30, 2009 Read More | SSIS Configurations Working with SSIS packages can sometimes cause problems if in different environments must be developed. Dougbert.com has a blog postje what entries to put the SQL MVPs describe how one can tackle this problem using SSIS Package Configurations. Integration Services | Thursday, April 9, 2009 Read More |
MSc Business Intelligence DNV Academy CIBIT in 2010 the first Dutch opleidingsinstituur begin with an official Master of Science Business Intelligence training. On March 12 this was an information about where they announced what the training will take approximately. BI and Datawarehousing | Friday, March 13, 2009 Read More | Checkpoints in SSIS The Control Flow Integration Services provides control and oversight over the various tasks in which your package will be implemented. But if one of these tasks, however wrong you will not often that the previous steps again performed. Maybe you have something that is not implemented 2 times can be executed (INSERT, or DELETE a script for example) or take a few hours for the previous steps. Checkpoints are the solution. Integration Services | Wednesday, March 11, 2009 Read More |
SSIS Export Data to Excel 2007 A brief description of how you can make a connection from SSIS with Excel 2007. Integration Services | Wednesday, March 4, 2009 Read More | Exporting more than 65,000 rows to Excel From the Report Manager allows you to export reports to Excel. Excel 2003 can only 65.000 rows in each tab. With this trick you can easily omzijlen this problem. Reporting Services | Tuesday, March 3, 2009 Read More |
SQLBI Methodology I ran from the week at an interesting piece of information about a methodology for BI and Data Warehouse solutions. As the most well known theories are the largest in the BI market that Kimball and Inmon, with a small third the Data Vault of Dan Linstedt. The methodology that this goes on is a more practical nature. The name of the beast: "SQLBI Methodology". CI and Datawarehousing | Thursday, February 26, 2009 Read More | |
More in: Other , Other , Analysis Services , Reporting Services , Integration Services , Integration Services , T-SQL , BI and Datawarehousing
| |
100% - + 10 Show options | |
-
Are 3-day training MDX according to the guide support, material or spicy but very interesting. Review will follow on sqlblog
-
http://sqlblog.nl/Artikelen/Integration-Services/data-conversie-performance-ssis.html
-
@ HansGeurtsen Yes MDX next week training in Utrecht.
Login
Tags
64bit SQL Active Directory Analysis Services Architecture Business Intelligence Common Table Expression CTE Data Analysis Datawarehouse Excel 2007 Expressions Integration Services Joomla Linked Server Metadata OLAP Reporting Services SCD Slowly Changing Dimension SQL SSAS SSIS SSRS Stored Procedures Templates Views Virtual PC Virtualization
