‘Tips / HowTos’ Articles

SQL Server SSIS : List Of All System Variables And Their Scope

SQL Server SSIS : List Of All System Variables And Their Scope (as found on MSDN.com)

10 SSIS Best Practices for Package Development

Kuldeep Chauhan (Kuldeepc) lists 10 best practices for SSIS Package Development.

  • by Kuldeep Chauhan (MSFT) @ blogs.msdn.com
  • 0
  • Tips / HowTos
  • 24.Nov.2009

The magic rule of seven (and the banality of alphabetical order)

Two really good UI Design tips for software developers, from the marketing guru Seth Godin.

Unit Tests Should Not Rely On External Resources

Query To Select Top X Random Rows From A Table

How To Verify If A SQL Server Connection Is Encrypted

Use Debuggerdisplayattribute In Visual Studio 2008 To Improve Debugging Experience For Types

LINQ – How To Use Enumerable.Select To Map / Transform Collections

Top 30 Tweaks , Enhancements , Secrets in Windows 7

Guidelines For Code Comments – Do’s And Don’ts

C# 4.0 Tutorial – Taking Advantage Of Parallel Computing For Multiple Cores

C# 4.0 tutorial with code snippets that shows you how to carry out parallel processing in .Net 4.0 on machines

How To Create A Dynamic Xml Reader In C# 4.0

A detailed tutorial on Creating a dynamic Xml Reader In C# 4.0. Includes downloadable source code in a zip file

Select From One Table For Data That Doesn’t Exist In Another Table

Five different ways to query data from one table for data that doesn’t exist in another table.

Import Data Files In a Folder That Have Not Been Processed Yet Into Database

A detailed SSIS walk-through on how to import data files in a Folder into SQL Server, but only load the files that have not been processed yet.

Recursively Copy Files During Build Using the Task in MSBuild