Click here to Skip to main content

Articles by Dave C Andrews (Technical Blogs: 6)

Technical Blogs: 6

RSS Feed
No articles have been posted.

Average blogs rating: 4.80

Mobile Development
BlackBerry
Posted: 31 Dec 2011   Updated: 31 Dec 2011   Views: 18,226   Rating: 5.00/5    Votes: 2   Popularity: 1.51
Licence: The Code Project Open License (CPOL)      Bookmarked: 3   Downloaded: 0
How to access the Internet from a Blackberry simulator.
Database
General
Posted: 3 Jan 2012   Updated: 3 Jan 2012   Views: 8,340   Rating: 4.50/5    Votes: 2   Popularity: 1.51
Licence: The Code Project Open License (CPOL)      Bookmarked: 6   Downloaded: 0
You can have your tables make computations themselves, without running through a view.
SQL
Posted: 5 Jan 2012   Updated: 5 Jan 2012   Views: 15,329   Rating: 0.0 / 5    Votes: 0   Popularity: 0.0
Licence: The Code Project Open License (CPOL)      Bookmarked: 2   Downloaded: 0
Count the records in a table which are of a certain type.
SQL Server
Posted: 31 Dec 2011   Updated: 31 Dec 2011   Views: 168,508   Rating: 4.91/5    Votes: 22   Popularity: 6.58
Licence: The Code Project Open License (CPOL)      Bookmarked: 20   Downloaded: 0
Use ROW_NUMBER() to enumerate and partition records in SQL Server.
SQL Reporting Services
General
Posted: 27 Jan 2012   Updated: 27 Jan 2012   Views: 16,335   Rating: 0.0 / 5    Votes: 0   Popularity: 0.0
Licence: The Code Project Open License (CPOL)      Bookmarked: 2   Downloaded: 0
Today I had to create a Linq-To-SQL query which joined two tables. These tables had compound primary keys (table simplified for example): Table Referrers ServerID (PK) ReferrerID (PK) Value 1 1 My value 1 1 2 My value 2 1 3 My value 3 Table ReferrerInfo ServerID (PK) ReferrerID (PK) Value 1 1 More i
Reviews on Third Party Products and Tools
General
Posted: 31 Dec 2011   Updated: 31 Dec 2011   Views: 13,076   Rating: 0.0 / 5    Votes: 0   Popularity: 0.0
Licence: The Code Project Open License (CPOL)      Bookmarked: 2   Downloaded: 0
A quick review of Google Music.
No tips have been posted.
No reference articles have been posted.

Dave C Andrews
Software Developer (Senior) LBMC Technologies
United States United States
I've been developing software since I was 9 years old, in BASIC on a Precomputer 2000. OK, that's a stretch, but hopefully some of the stuff that I learned from that little toy have helped my professional career.
 
I have a bachelors degree in computer science from MTSU. Currently, I am employed as a senior software developer for LBMC in Nashville, TN. We serve as consultant developers for clients across the southeastern United States, developing mostly in Microsoft .Net with Microsoft SQL Server.
 
I greatly enjoy my job and my hobbies lie in open source software and in teaching others how to be better programmers. I have a beautiful wife, 2 dogs (a dachshund and an olde-english bulldog) and a cat.
Follow on   Twitter


Advertise | Privacy | Mobile
Web03 | 2.8.140826.1 | Last Updated 27 Aug 2014
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid