Click here to Skip to main content
13,738,089 members

Articles by Alaric Dailey (Articles: 10, Tip/Trick: 1)

Articles: 10, Tip/Trick: 1

RSS Feed

Average article rating: 4.72

Database
ADO.NET
Posted: 30 Jul 2011   Updated: 31 Jul 2011   Views: 108,822   Rating: 4.82/5    Votes: 19   Popularity: 6.15
Licence: The Code Project Open License (CPOL)      Bookmarked: 55   Downloaded: 0
Building an O/R Mapper: step 3.
Data Access
Posted: 1 Feb 2010   Updated: 1 Feb 2010   Views: 92,663   Rating: 4.78/5    Votes: 29   Popularity: 7.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 95   Downloaded: 0
Correctly using provider factories to create database independant code.
General
Posted: 27 Jul 2011   Updated: 2 Aug 2011   Views: 109,414   Rating: 4.31/5    Votes: 20   Popularity: 5.57
Licence: The Code Project Open License (CPOL)      Bookmarked: 52   Downloaded: 0
Design for data integrity, simplified SQL, and programming ease.
Other databases
Posted: 10 Feb 2010   Updated: 17 Mar 2016   Views: 33,130   Rating: 4.86/5    Votes: 9   Popularity: 4.62
Licence: The Code Project Open License (CPOL)      Bookmarked: 10   Downloaded: 0
Using TABLE INHERITS in PostgreSQL to provide consistency
SQL
Posted: 13 Jan 2010   Updated: 14 Jan 2010   Views: 25,780   Rating: 4.80/5    Votes: 7   Popularity: 4.01
Licence: The Code Project Open License (CPOL)      Bookmarked: 32   Downloaded: 0
Using information from the .NET DataProvider to improve dynamic SQL and allow the use of multiple databases.
SQL Server
Posted: 29 Jan 2010   Updated: 29 Jan 2010   Views: 46,440   Rating: 4.82/5    Votes: 7   Popularity: 4.04
Licence: The Code Project Open License (CPOL)      Bookmarked: 19   Downloaded: 150
Working around issues when using SQL Server indexed views.
C#
Reflection
Posted: 6 Feb 2010   Updated: 8 Feb 2010   Views: 17,660   Rating: 4.40/5    Votes: 7   Popularity: 3.72
Licence: The Code Project Open License (CPOL)      Bookmarked: 45   Downloaded: 0
Building An O/R Mapper Step 1
Posted: 16 Feb 2010   Updated: 18 Feb 2010   Views: 24,970   Rating: 5.00/5    Votes: 2   Popularity: 1.51
Licence: The Code Project Open License (CPOL)      Bookmarked: 28   Downloaded: 0
Building an O/R Mapper: Step 2.
Cryptography & Security
Security
Posted: 24 Jan 2010   Updated: 2 Apr 2014   Views: 90,695   Rating: 4.84/5    Votes: 34   Popularity: 7.40
Licence: The Code Project Open License (CPOL)      Bookmarked: 82   Downloaded: 1,397
Simple code and explanations to enable secure password authentication.
Threads, Processes & IPC
Threading
Posted: 9 Jan 2010   Updated: 18 Jan 2010   Views: 13,350   Rating: 4.60/5    Votes: 4   Popularity: 2.77
Licence: The Code Project Open License (CPOL)      Bookmarked: 18   Downloaded: 0
Wait for multiple threads to complete.
No blogs have been submitted.

Average tips rating: 5.00

Internet / Network
General
Posted: 17 Feb 2010   Updated: 17 Feb 2010   Views: 17,340   Rating: 0.00/5    Votes:    Popularity: 0.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 4   Downloaded: 0
One thing that annoys me is huge companies that ignore time issues. Several of my clients have had huge networks across multiple timezones, and they wondered why logging times in the database were always off, everyone was logging in their local time, making it impossible to correlate logs. ...
Uncategorised Quick Answers
General
Posted: 19 Feb 2010   Updated: 19 Feb 2010   Views: 5,580   Rating: 5.00/5    Votes: 2   Popularity: 1.51
Licence: The Code Project Open License (CPOL)      Bookmarked: 0   Downloaded: 0
This would work too :)As an explanation, I use datediff to get the number of days, divide that by the correct number of days in a year (keeping track of leap years, there are only 97 in every 400 years) and then FLOOR the result, thus making sure it doesn't get rounded up accidentally....
No reference articles have been posted.
No projects have been posted.

Alaric Dailey
Software Developer (Senior) Pengdows
United States United States
Currently looking for new contracts in Omaha NE or telecommute opportunities.


Advertise | Privacy | Cookies | Terms of Service
Web04-2016 | 2.8.180920.1 | Last Updated 22 Oct 2018
Copyright © CodeProject, 1999-2018
All Rights Reserved.
Layout: fixed | fluid