Denny Lee

Ramblings of a data dork: from BI and Big Data to Travel and Food

Pros/Cons of deploying #SSIS with the SQL engine server

I was asked a pretty good question recently on what are the pros and cons of deploying SQL Server Integration Services packages on the same server that has your SQL … Continue reading

Rate this:

January 10, 2010 · 5 Comments

Designing and Tuning for Performance your SSIS packages in the Enterprise (SQL Video Series)

For all of those whom are interested in SSIS performance, we have posted a new SQL video series about how to design and tune your SSIS packages for performance. Measuring … Continue reading

Rate this:

May 12, 2009 · Leave a Comment

Designing and Tuning for Performance your SSIS packages in the Enterprise (SQL Video Series)

For all of those whom are interested in SSIS performance, we have posted a new SQL video series about how to design and tune your SSIS packages for performance. Measuring … Continue reading

Rate this:

May 11, 2009 · 97 Comments

The Ultimate SQL Data Loading Performance Guide

For all of you whom wanted to know about how to load data within SQL Server, please refer to the "Ultimate" SQL Data Loading Performance Guide at: http://sqlcat.com/whitepapers/archive/2009/02/15/the-data-loading-performance-guide-2008.aspx   This … Continue reading

Rate this:

February 15, 2009 · Leave a Comment

Top 10 SQL Server Integration Services Best Practices

Check out my latest paper: Top 10 SQL Server Integration Services Best Practices.  We had written this paper based on the many enteprise SSIS issues we encountered and we should have … Continue reading

Rate this:

October 3, 2008 · Leave a Comment

Top 10 SQL Server Integration Services Best Practices

Check out my latest paper: Top 10 SQL Server Integration Services Best Practices.  We had written this paper based on the many enteprise SSIS issues we encountered and we should have … Continue reading

Rate this:

October 2, 2008 · 86 Comments

SSIS Processing Tips: Bulk Insert many files to a database

In the process of building a set of SSIS packages that would process an immense amount of data, below are some learnings that have been determined in the process. The … Continue reading

Rate this:

December 27, 2006 · 100 Comments

SSIS global variables and execute process task

Within SQL Server 2000, if you wanted to execute a command line task (e.g. execute a BCP statement within DTS such as "bcp <arguments>"), a common task would be to … Continue reading

Rate this:

May 12, 2006 · 100 Comments

Professional Microsoft SQL Server 2012 Analysis Services with MDX and DAX

Analysis Services Multidimensional and Tabular Reference all in one handy book!

@dennylee

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 2,002 other followers

Copyright

Copyright © 2012 Denny G Lee - All Rights Reserved
Follow

Get every new post delivered to your Inbox.

Join 2,002 other followers