James BI 園地

我想在技術人員上面有時候MSDN的資源是不足以讓自己更容易瞭解問題及解決方案的.因此為此我順便整理一下我所找的資源.

有關SQL技術的Topic可以找
http://sqlcat.com

有關SQL MSDN如下:
 http://technet.microsoft.com/en-us/sqlserver/bb331794.aspx.
 
有關SQL Sample,DB如下:
http://www.codeplex.com/

有關SQL 中文討論區如下:
http://forums.microsoft.com/TechNet-CHT/ShowForum.aspx?ForumID=1039&SiteID=23

有關SQL 英文討論區如下:
http://forums.microsoft.com/msdn/default.aspx?ForumGroupID=19&SiteID=1


相關的SQL SSIS的Blog文章.

Getting Optimal Performance with Integration Services Lookups

http://blogs.msdn.com/sqlperf/archive/2007/04/24/getting-optimal-performance-with-integration-services-lookups.aspx

OLEDB Source with Views 

http://blogs.msdn.com/sqlperf/archive/2007/04/29/set-up-ole-db-source-to-read-from-view-efficiently.aspx

BLOB and buffer temporary storage

http://blogs.msdn.com/sqlperf/archive/2007/05/01/set-blobtempstoragepath-and-buffertempstoragepath-to-fast-drives.aspx 

SSIS Performance Counters

http://blogs.msdn.com/sqlperf/archive/2007/05/01/something-about-ssis-performance-counters.aspx

Buffer size adjustments

http://blogs.msdn.com/sqlperf/archive/2007/05/11/adjust-buffer-size-in-ssis-data-flow-task.aspx

Parallel execution

http://blogs.msdn.com/sqlperf/archive/2007/05/11/implement-parallel-execution-in-ssis.aspx

 

 

 

 

 

請大家永躍參與Facebook MSBI 粉思團:http://www.facebook.com/#!/group.php?gid=303757165010