Click here to Skip to main content
13,631,113 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: 106,342   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: 90,023   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: 106,834   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: 32,260   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: 24,940   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: 45,080   Rating: 4.82/5    Votes: 7   Popularity: 4.04
Licence: The Code Project Open License (CPOL)      Bookmarked: 19   Downloaded: 149
Working around issues when using SQL Server indexed views.
C#
Reflection
Posted: 6 Feb 2010   Updated: 8 Feb 2010   Views: 17,220   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,470   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: 87,565   Rating: 4.84/5    Votes: 34   Popularity: 7.40
Licence: The Code Project Open License (CPOL)      Bookmarked: 82   Downloaded: 1,385
Simple code and explanations to enable secure password authentication.
Threads, Processes & IPC
Threading
Posted: 9 Jan 2010   Updated: 18 Jan 2010   Views: 13,110   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: 16,780   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,400   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.

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
Web03 | 2.8.180712.1 | Last Updated 20 Jul 2018
Copyright © CodeProject, 1999-2018
All Rights Reserved.
Layout: fixed | fluid