How-To, Samples, and Such (RSS)

How-To, samples, and other examples that I do write ups on.

TDD, Architecture and Testing Code in Isolation :: Part 2

Navigate back to Part 1 of this series of entries. The next steps I undertook are some of my various clean ups.  Create respective test classes for each of the pieces of the database that will have respective entities, methods, or objects to test.

TDD, Architecture and Testing Code in Isolation :: Part 1

Just a few examples here.  First we'll setup the basic architecture from the lowest common denominator - the database - bounce up to the first layer, and test in isolation and test in integration.  These examples are simply the easiest ways

TeamCity Build Notification Tools

For the .NETters that use TeamCity there are two primary notification tools.  The first is a tray icon tool and the second is a VS.NET plug-in. Both of these notification tools can be found on the TeamCity Build Server Site.  Go to the user
posted by adron | 1 Comments
Filed Under:

Team City Continuous Integration Build Server and VS.NET VCS Integration

Starting a new project always requires a certain amount of setup, one of the primary goals of any development group these days should be continuous integration.  This is something that is not expensive or time consuming to setup.  Recently for

Smugmug and Windows Live Writer Plugin, via Teamprise Source Client

I officially joined the effort for the Windows Live Writer called smugmug4writer for Smugmug, currently maintained by Chris Patterson.  I've found myself using the plugin so much while writing entries that I finally decided I'd contact him and see

WebTrends Account Setup and Configuration

I got my WebTrends Account Welcome E-mail with all of the information needed to get connected and start working with the On Demand Analytics Web Application. At some point I want to get a Visitor Intelligence Cube/OLAP Reporting Web Application setup

HTML is What It's About!

I've never had to actually utilize the custom extension build provider or http handler in .NET since way way back pre-2.0.  Well that came up again and I went to messing with it and came to the conclusion that it is slightly different now. 
posted by adron | 0 Comments
Filed Under:

Creating and Building Indexes

Just a few Index 101 type points of advice. When creating an index on an existing table, that has populated data, keep in mind that it could take a long time.  If it takes too long and is initiated via the SQL Management Studio the result is very
posted by adron | 0 Comments
Filed Under:

Index, Fragmentation, Statistics - A List

This entry is going to be a collected list of practices for index, fragmentation, statistics, and general VLDB table and view maintenance. First off, a few obvious index practices. If a non-clustered index is not used, toss it.  When a table has

The Oncoming Microsoft ASP.NET MVC - Part 1

The ASP.NET MVC is officially released in the .NET 3.5 Extensions CTP.  This is part one of a multi-part series I'm going to do on getting a basic application up and running with good practice and solid test driven development process.  Enjoy. First we'll

Kick Ass Table Variables in T-SQL

Table variables are another "tool belt" item that one must have when really digging into various SQL tasks.  Oracle and other real databases also have this capability, but I'm going to, as usual, discuss the Microsoft SQL variant of the table variable

Finding A Week in T-SQL :: Tip o' The Day

Recently I needed to identify a week within a T-SQL Query.  First off I figured I would want to know what day it is, then I could easily figure out a week time frame. To verify what day you have selected, use the following code: IF DATENAME(weekday,

CodePlex Time

Over the weekend I made several attempts to download the BlogEngine on CodePlex by Mads Kristenson several times.  The problem, was that the site kept timing out.  I'm not sure if the local Comcast Service was having another issue or if the

Keeping Up With ASP.NET MVC Framework

In my always continuing efforts to keep up with the coolest frameworks, architecture, and other tidbits, I rolled into these "must review/read" how-to entries from Scott Hanselman, Scott Guthrie, and Brad Abrams.  If you are planning to do any ASP.NET/C#

T-SQL Date Range Usage :: Tip o' The Day

Often times a date range is used in a where clause with a start date and an end date that are the same.  The dates however are entered with the intention of getting that single day worth of data.  By default T-SQL will look at that but not give
More Posts Next page »