Author Archives: David Bauernschmidt

David Bauernschmidt

About David Bauernschmidt

I live in the historical triangle of Virginia where I am married with two daughters. I have spent over 13 years working for a Fortune 500 company in the computer area. I started in VB 6.0 and by the time I ended my employment I was supervising a development team where we built many web applications. When my first daughter was born I wanted to spend more time with her so I left and became a programmer analyst for local government as well as launch my own company. Since then I have grown James River Webs into a profitable web design and application company helping small businesses create a big presence on the internet. As an employee I have created web application used by citizens and other companies. I enjoy fly fishing, and spending time with my family. I also enjoy learning new approaches and development tools when it comes to developing applications.

Using Specific ConnectStrings in Applications

If you have built any application you know that a large part of an application is saving and retrieving data from some sort of storage. This storage comes in a …

Tags: , , , , , , , , , , , , , | Posted under ASP .NET 4.0, Programming/Coding | Leave a comment

SQL Server NULLIF Function

If you are like me when it comes to developing SQL solutions, you will inevitably use ISNULL function but did you know about NULLIF function. This function is almost the opposite …

Tags: , , , , , , | Posted under Programming/Coding | Leave a comment

Calculating Percent of Total in a SQL Select Statement

I am always amazed at how SQL server provides a lot of calculations and logic built right into a select statement. Most of the time (if you are like me) …

Tags: , , , , , , , , | Posted under Programming/Coding | Leave a comment