Monday, February 06, 2006 - Posts

SSIS Performance Whitepaper

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/SSIS Performance Whitepaper
The new RSS feed is here

Came across this whitepaper by Microsoft and Unisys on SQL Server Intergration services.

If interested is can be found here

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/SSIS Performance Whitepaper

posted Monday, February 06, 2006 11:07 AM by SimonSabin with 1 Comments

UPPER JOIN and LOWER JOIN syntax

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/UPPER JOIN and LOWER JOIN syntax
The new RSS feed is here

I was looking at some posts recently talking about Integration services and how to be able to do imprecise lookups. The solution was to use a SQL based lookup. The situation is an employe with a history of departments they have been in, you need to find the department at a particular point in time. To do this you need something like

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/UPPER JOIN and LOWER JOIN syntax

posted Monday, February 06, 2006 5:28 PM by SimonSabin with 1 Comments

Vb to C# Addin for Visual Studio

I posted a while ago (august last year) on a converter of VB code to C#. Well now it appears there is an addin available for Visual studio to allow you to copy VB and paste C#.

How cool

posted Monday, February 06, 2006 3:10 PM by SimonSabin with 0 Comments

SSIS Performance Whitepaper

Came across this whitepaper by Microsoft and Unisys on SQL Server Intergration services.

If interested is can be found here

posted Monday, February 06, 2006 11:07 AM by SimonSabin with 0 Comments

SQL Express Advanced Edition

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/SQL Express Advanced Edition
The new RSS feed is here

Microsoft are looking for beta testers of an enhanced version of sql express, this includes reporting and full text search.

You can find the detail for registering for the beta at

http://blogs.msdn.com/sqlexpress/archive/2006/02/02/ExpressBeta.aspx

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/SQL Express Advanced Edition

posted Monday, February 06, 2006 6:34 AM by SimonSabin with 1 Comments

CTRL ALT DEL in Terminal Services

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/CTRL ALT DEL in Terminal Services
The new RSS feed is here

I can never remember what the terminal services equivalent key strokes are for the local key strokes, i.e. CTRL+ALT+DEL. This location gives a good list http://www.sessioncomputing.com/keyboard.htm

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/CTRL ALT DEL in Terminal Services

posted Monday, February 06, 2006 6:25 AM by SimonSabin with 1 Comments