Click here to Skip to main content
15,917,951 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: 56,091     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,881     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,933     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: 142,103     Bookmarked: 85   Downloaded: 1,597
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: 118,152     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,769     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,783     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: 37,134     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,991     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,840     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.