Nov20
I have been meaning to post this for a while, but you know how work gets in the way….
This came out in some of the Microsoft newsletters and as a poster in SQL Server magazine: www.getonthecase.com
The sessions offered online are as follows:
Working with asynchronous data in SQL Server 2008
SQL Server 2008 and ADO.Net entity framework integration
Uncovering T-SQL on SQL Server 2008 ...
Posted by Sidney Atkinson on
Thursday, 20 Nov 2008 10:56.
Nov16
In my post, Why use aliases?, I spoke in favor of using a certain syntax in your SQL programming, particularly because SQL Server 2008 gives you almost no reason not to with integrated Intellisense.
One little note for those who may have run into a frustration while developing – Intellisense in SQL 2008 does not always refresh timely. This can be particularly annoying if you are in the middle...
Posted by Sidney Atkinson on
Sunday, 16 Nov 2008 10:53.
Nov14
This all started off in trying to help out a fellow SSIS enthusiast, and now I have made a complete project as a sample….. catch the MSDN forum thread here.
There are many reasons why you would want to remap source columns to destination at runtime – I would not necessarily recommend this type of solution for some of your larger and more impactful data imports, but there are many cases where ...
Posted by Sidney Atkinson on
Friday, 14 Nov 2008 10:53.
Nov7
I've been trying to be a good citizen and post more in the SQL Server section of the MSDN forums, and so I came across a question in the SQL Server > SSIS section about start-up performance that made me realize not a lot of people are aware of how a package initially executes.
Since Kirk Haselden was my original source for some of this information so I will point to his post, Caching in Th...
Posted by Sidney Atkinson on
Friday, 7 Nov 2008 10:52.