Monthly Archives: May 2011

.Net Implicit Casts

Casts A cast is a conversion of data from one type to another, for example from an integer to a float. Implicit Casts An implicit cast is a conversion from one type to another that is automatically assumed by the … Continue reading

Posted in C#, VB.Net | Leave a comment

SQL Server: Example Naming Convention

An example of a SQL Server naming convention I have encountered: Tables tcTableName (e.g. tcAsset) for core tables, i.e. tables that contain regularly changing data and have insert/update/delete queries run against them. trTableName (e.g. trAssetType) for reference tables, i.e. tables … Continue reading

Posted in SQL Server | Leave a comment

What Makes Technology Popular?

It is easy to assume that technology becomes popular simply because it is better than the competition. But as the saying goes, “that ain’t necessarily so”. In fact, the history of innovation is replete with examples of inferior technologies capturing … Continue reading

Posted in Uncategorized | Leave a comment

C#: How to Clone a Generic List

Found on StackOverflow, this is a tidy example of an generic extension method that uses LINQ: [sourcecode language=”c#”] static class Extensions { public static IList Clone( this IList listToClone) where T: ICloneable     {     return listToClone.Select(item => … Continue reading

Posted in C# | Leave a comment

How to Improve Service and Lower Costs

Focus on the systems that provide value How you view a problem is the key to the way you solve it. If our focus is on anything but the systems that provide value we will be driving waste into our … Continue reading

Posted in Best Practice, Leadership | Leave a comment

Improving the Information Service

A grab bag of ideas: Focus on business value Nothing else matters. Provide a great interface At these levels: Technically Personally It should be: Easy to access Responsive Reliable Make people feel good Build a solid, agile infrastructure You’re going … Continue reading

Posted in Leadership | Leave a comment

.Net Conditional (Tenary) Operator

C♯ 1.0 C♯ 1.2 C♯ 2.0 C♯ 3.0 C♯ 4.0 ✓ ✓ ✓ ✓ ✓ VB.Net 7.0 VB.Net 7.1 VB.Net 8.0 VB.Net 9.0 VB.Net 10.0 x x x ✓ ✓ The conditional operator  takes three operands. It tests the result … Continue reading

Posted in Uncategorized | Leave a comment

Windows Textbox Shortcuts

Form Navigation Tab Move to the next input area on a form Shift + Tab Moves to the previous input area on a form Moving the Caret Right Arrow Moves the caret one character to the right Left Arrow Moves … Continue reading

Posted in Uncategorized | Leave a comment

Best Practice: Foundations

When I became a full-time developer, I determined to be the best developer I can be. I set out to learn what best-practice means in my chosen profession, and then to learn to apply it to my practice. Thus far, … Continue reading

Posted in Best Practice | Leave a comment

SQL Server: Disable All Constraints

To disable all constraints on all tables in a database: [sourcecode language=”sql”] EXEC sp_msforeachtable “ALTER TABLE ? NOCHECK CONSTRAINT all” [/sourcecode] To enable all constraints on all tables in a database: [sourcecode language=”sql”] exec sp_msforeachtable @command1=”print ‘?'”, @command2=”ALTER TABLE ? … Continue reading

Posted in SQL Server | Leave a comment