Monthly Archives: May 2011

.Net Implicit Casts

Posted on May 24, 2011 by Kramii

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

Posted on May 24, 2011 by Kramii

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?

Posted on May 18, 2011 by Kramii

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

Posted on May 18, 2011 by Kramii

Found on StackOverflow, this is a tidy example of an generic extension method that uses LINQ: static class Extensions { public static IList<T> Clone<T>( this IList<T> listToClone) where T: ICloneable     {     return listToClone.Select(item => (T)item.Clone()).ToList(); } … Continue reading →

Posted in C# | Leave a comment

How to Improve Service and Lower Costs

Posted on May 16, 2011 by Kramii

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

Posted on May 13, 2011 by Kramii

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

Posted on May 12, 2011 by Kramii

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

Posted on May 11, 2011 by Kramii

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

Posted on May 3, 2011 by Kramii

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

Posted on May 3, 2011 by Kramii

To disable all constraints on all tables in a database: EXEC sp_msforeachtable "ALTER TABLE ? NOCHECK CONSTRAINT all" To enable all constraints on all tables in a database: exec sp_msforeachtable @command1="print '?'", @command2="ALTER TABLE ? WITH CHECK CHECK CONSTRAINT all"

Posted in SQL Server | Leave a comment