Author Archives: Kramii

.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

Book Summary: Practices of an Agile Developer

Review Note: This page is an ongoing project… Below is my summary of “Practices of an Agile Developer: Working in the Real World” by Venkat Subramaniam and Andy Hunt. In my view this is a 4-star book, well worth reading … Continue reading

Posted in Book Reviews, Books | Leave a comment

Best Practices: Variables

Notes from Code Complete 2: Chapter 10 Date Types Know your data types (10.1) Declaration and Naming Declare all variables (turn off implicit declarations) (10.2) Follow naming conventions (10.2) Initialization Initialize each variable as it’s declared (10.3) Declare and define … Continue reading

Posted in Best Practice, Progamming | Leave a comment

Visual Studio Extension: Browse Current Project

I’ve just published my first Visual Studio Extension. It is a very simple one-command extension that allows you to view the contents of the folder that contains the current project in the Visual Studio Browser. At the moment, only Visual … Continue reading

Posted in Visual Studio | Tagged , | Leave a comment

Visual Studio Fonts and Colors: Version 2

Some time ago I wrote about my chosen colour scheme for Visual Studio.  I’ve updated it several times since, so I’ve uploaded the latest version to StudioStyles. It looks like this: Unfortunately, StudioStyles doesn’t support all the styles for VB.Net, … Continue reading

Posted in Visual Studio | Leave a comment

SQL Server: Drop all Foreign Keys that Reference a Table

Introduction Before you drop a table in SQL Server, you must first drop all the foreign keys that reference that table. The following SQL scripts may help with this task. Step 1:  Run the following to create a Stored Procedure … Continue reading

Posted in SQL Server | Leave a comment

Design Pattern: Object Pool

Type Creational Patterns Name Object Pool AKA Resource Pool Motivation Performance can be an important consideration for applications. In some scenarios, object creation is a costly step. Intent Avoids cost of initializing objects by maintaining a pool of pre-initialized objects … Continue reading

Posted in Design Patterns | Leave a comment