Links for 2008-09-01

MSDN Webcast: Introducing SQL Server Integration Services for SQL Server 2005—Level 200

MSDN Webcast:Extending SQL Server Integration Services Through Custom Tasks (Level 200)

 

M2795: designing and develop ETL solutions

 

Designing an ETL Solution Architecture Using Microsoft SQL Server 2005 Integration Services

 

Microsoft SQL Server 2005 Business Intelligence – Implementation and Maintenance

 

Course 2943: Updating Your Data Integration Skills to Microsoft® SQL Server™ 2005 Integration Services

 

Preparation Guide for Exam 70-446
PRO: Designing a Business Intelligence Infrastructure by Using Microsoft SQL Server 2005

 

SQL Server Customer Advisory Team - SQL Server Best Practices

 

TechNet: SQL Server 2005 – Integration Services

 

Links for 2008-08-29

Comparing WSS 3.0 and MOSS 2007

 

SSIS on MSDN

 

CodeGuru:SSIS and ETL

Struggling with IIS 6.0

Last week I was investigating a problem on a webserver. During the travel, I found some interesting links on the internet related to IIS 6.0.

To get an overview of IIS 6.0 I suggest the Internet Information Services (IIS) 6.0 Technical Library on Technet.

Also the IIS 6.0 Resource Kit is very usefull, containing the LogParser which is handy when analysing IIS logfiles.

Here is an example of the usage of LogParser:

List all occurences of a specified URL in the iislogfile:

"C:\Program Files\IIS Resources\Log Parser\LogParser.exe" "select date,time,cs-uri-stem,c-ip from c:\ex*.log where cs-uri-stem='/yourdomain/myfile.aspx'"

Other nice links:

System and Application Performance Counters for ASP.NET (IIS 6.0)

http://www.iisanswers.com

http://www.iislists.com

http://www.iisfaq.com

http://www.iis.net

Utilities for TFS

A nice link to tools for TFS:

http://blogs.microsoft.co.il/blogs/srlteam/archive/2006/10/22/Team-System-Utilities.aspx

Interesting trial VPCs

Today I bumped into some interesting VPC images on the net:

Internet Explorer Application Compatibility VPC Image (also Vista)

Visual Studio® Team System 2008 Team Foundation Server and Team Suite VPC Image (Trial)

Visual Studio 2008 Rhythm Training Virtual PC (Windows Server 2003)

Visual Studio 2008 Rhythm Training Virtual PC (Vista)

Configuring different diff/merge tools for Team Foundation Version Control

On this blog, I found how to configure a different diff tool. I prefer WinMerge, so I configured this one.

Adapt IE7 Search to use Dutch Google

In Internet Explorer 7 you can set Search Providers. I do use the Google Search provider. When the Search Provider is set, you can enter your search criteria in the Instant Search box and press ENTER. By default the UK Google is used for this.

As a Dutch, I however prefer the Dutch Google. I found that this can be done by editing the registry. Just search the registry key: HKCU\Software\Microsoft\Internet Explorer\SearchScopes

Here you find the entries for the currently available Search Providers in your Internet Explorer 7.0.  Now look into the subkey containing the Search Provider with the DisplayName "Google" and adapt the URL to your preferred Google setting. In my case:

Before:

http://www.google.com/search?q={searchTerms}&rls=com.microsoft:{language}&ie={inputEncoding}&oe={outputEncoding}&startIndex={startIndex?}&startPage={startPage}

After:

http://www.google.nl/search?hl=nl&q={searchTerms}&meta=

Now you can use the custom Search Provider in Internet Explorer 7.0