Know Your Toolset

Using XML as an Input Parameter to Stored Procedures in Favor of table-valued-parameters

Mar 30, 2015 · 5 min read · .NET ADO.NET C# SQL ·

A common challenge with stored procedures is how to pass in multiple rows to a single stored proc call — especially when you know all of the new / updated rows at a single time. Doing so can save on round trips as well as (sometimes) making transaction handling easier. Failed Attempt 1: Just use flat parameters If you …

Guiding Principles for Programmers

Mar 20, 2015 · 10 min read · Development ·

Share on:

Having some guiding principles (rules, if you will) that you follow when performing tasks can help you be more effective when doing those tasks. Here are some of the prgramming rules I follow. The SOLID principles are worth knowing as well.

Know and leverage your toolset Be aware of the framework(s) that you are …

Put a Silver Background on Your Comments

Mar 11, 2015 · 1 min read · Development ·

Share on:

Put a Silver Background on Your Comments

Putting a silver color background on your comments is a quick and easy productivity booster for me. It may seem subtle but I’ve found it way easier to visually recognize comments with the silver background than if I just leave it white. I do this both within Visual Studio and SQL Server Management Studio for SQL …

Supporting Multiple Environments with a single XML Configuration file

Feb 17, 2015 · 7 min read · C# .NET ·

Share on:

Abstract Provide a technique for setting up configuration files that can support multiple environments (e.g. staging and production) and allow for central deployment without having to update config files on the fly during deployment. Benefits of the approach described: config files are not touched during deployment …