‘Tips / HowTos’ Articles

Recursively Copy Files During Build Using the Task in MSBuild

C# .Net Temperature Struct Code for Fahrenheit and Celsius Manipulation

C# Helper Class For Indexed Property Access Without Using Subclasses

A C# helper class featuring lambdas that allows for indexed property without using subclasses.

Property Precendence in SSIS Config File for FTP Connection Manager Components

What is the Property Precendence in SSIS Config File for FTP Connection Manager Components in cases where both the ConnectionString property and the ServerName, ServerPort property combinations are populated with values ?

C# Dependency Injection and Inversion of Control Containers Explained

A new approach to understanding Dependency Injection and Inversion of Control Design Patterns in the C# environment. The author, fossmo

How To Select Rows From Table Based On Time Value in DateTime Column

T-SQL code snippet for selecting rows from a database table based on time values in the datetime field.

T- Sql To Concatenate A Table Column’s Values Into A Csv String

1 line T-Sql code snippet to concatenate a table column’s values into A csv string

Fix For Error: The Requested FTP Command Is Not Supported When Using HTTP Proxy

Fix for the Error “System.InvalidOperationException: The requested FTP command is not supported when using HTTP proxy.”

Where is ildasm.exe (MSIL Disassembler) located ?

How to find ildasm.exe on your developer machine. Also includes links to tutorial and ildasm.exe usage documentation.

Get the Number of CPUs on a ‘SQL Server’ Machine

Script to get the number of physical and logical CPUs (processors) on a ‘SQL Server’ Server Machine.

Get Row Counts, Column Counts, Data Sizes For All Tables

T-SQL Script to get the row counts, column counts and data sizes for all the tables in a database.

Truncate All Tables In Database Using sp_MSforeachtable

1 line script to truncate all tables in a database

Safest, Most Efficient Way To Clear A StringBuilder Variable

The safest and most efficient way to clear a StringBuilder variable is as follows.

Get The Number Of Days In The Current Month

T-SQL (SQL Server) code snippet to get the number of days in the current month.

How To Restore The Security Tab in Windows XP Pro Folders

If you right clicked a folder in your Windows XP Professional file explorer to grant rights to specific users, and