Click here to Skip to main content
15,903,685 members

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

Articles: 8, Tip/Trick: 1

RSS Feed

Average article rating: 4.72

Database Development
SQL Server
29 Jan 2010   Updated: 29 Jan 2010   Rating: 4.82/5    Votes: 7   Popularity: 4.07
Licence: CPOL    Views: 55,971     Bookmarked: 19   Downloaded: 159
Please Sign up or sign in to vote.
Working around issues when using SQL Server indexed views.
Programming Languages
C#
6 Feb 2010   Updated: 8 Feb 2010   Rating: 4.40/5    Votes: 7   Popularity: 3.72
Licence: CPOL    Views: 21,781     Bookmarked: 45   Downloaded: 0
Please Sign up or sign in to vote.
Building An O/R Mapper Step 1
16 Feb 2010   Updated: 18 Feb 2010   Rating: 5.00/5    Votes: 2   Popularity: 1.51
Licence: CPOL    Views: 32,783     Bookmarked: 28   Downloaded: 0
Please Sign up or sign in to vote.
Building an O/R Mapper: Step 2.
24 Jan 2010   Updated: 2 Apr 2014   Rating: 4.84/5    Votes: 34   Popularity: 7.21
Licence: CPOL    Views: 140,983     Bookmarked: 85   Downloaded: 1,596
Please Sign up or sign in to vote.
Simple code and explanations to enable secure password authentication.
C# 4.0
1 Feb 2010   Updated: 1 Feb 2010   Rating: 4.81/5    Votes: 30   Popularity: 7.04
Licence: CPOL    Views: 117,822     Bookmarked: 94   Downloaded: 0
Please Sign up or sign in to vote.
Correctly using provider factories to create database independant code
SQL
30 Jul 2011   Updated: 31 Jul 2011   Rating: 4.82/5    Votes: 19   Popularity: 6.05
Licence: CPOL    Views: 134,549     Bookmarked: 60   Downloaded: 0
Please Sign up or sign in to vote.
Building an O/R Mapper: step 3.
27 Jul 2011   Updated: 2 Aug 2011   Rating: 4.31/5    Votes: 20   Popularity: 5.51
Licence: CPOL    Views: 147,253     Bookmarked: 53   Downloaded: 0
Please Sign up or sign in to vote.
Design for data integrity, simplified SQL, and programming ease.
13 Jan 2010   Updated: 14 Jan 2010   Rating: 4.80/5    Votes: 7   Popularity: 4.06
Licence: CPOL    Views: 36,974     Bookmarked: 32   Downloaded: 0
Please Sign up or sign in to vote.
Using information from the .NET DataProvider to improve dynamic SQL and allow the use of multiple databases

Average blogs rating:

No blogs have been submitted.

Average tips rating: 5.00

GPedit
17 Feb 2010   Updated: 17 Feb 2010   Rating: 0.00/5    Votes: 0   Popularity: 0.00
Licence: CPOL    Views: 22,921     Bookmarked: 4   Downloaded: 0
Please Sign up or sign in to vote.
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. ...
Programming Languages
SQL
19 Feb 2010   Updated: 19 Feb 2010   Rating: 5.00/5    Votes: 2   Popularity: 1.51
Licence: CPOL    Views: 7,830     Bookmarked: 0   Downloaded: 0
Please Sign up or sign in to vote.
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....

Average reference rating:

No reference articles have been posted.

Average project rating:

No projects have been posted.
Architect Pengdows
United States United States
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.