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

Articles: 8, Tip/Trick: 1

Articles
Technical Blogs
Tips and Tricks
Reference Articles
Projects

Average article rating: 4.72

Database Development
SQL Server	Working Around Issues When Using SQL Server Indexed Views 29 Jan 2010 Updated: 29 Jan 2010 Rating: 4.82/5 Votes: 7 Popularity: 4.07 Licence: CPOL Views: 55,801 Bookmarked: 19 Downloaded: 159 Please Sign up or sign in to vote. Working around issues when using SQL Server indexed views.
Programming Languages
C#	Load Any Object From Most Any Database 6 Feb 2010 Updated: 8 Feb 2010 Rating: 4.40/5 Votes: 7 Popularity: 3.72 Licence: CPOL Views: 21,691 Bookmarked: 45 Downloaded: 0 Please Sign up or sign in to vote. Building An O/R Mapper Step 1
	Using Custom Attributes to Map Database Tables and Columns to Classes and Fields 16 Feb 2010 Updated: 18 Feb 2010 Rating: 5.00/5 Votes: 2 Popularity: 1.51 Licence: CPOL Views: 32,623 Bookmarked: 28 Downloaded: 0 Please Sign up or sign in to vote. Building an O/R Mapper: Step 2.
	Secure Password Authentication Explained Simply 24 Jan 2010 Updated: 2 Apr 2014 Rating: 4.84/5 Votes: 34 Popularity: 7.21 Licence: CPOL Views: 139,869 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	Don't Hard Code Your DataProviders 1 Feb 2010 Updated: 1 Feb 2010 Rating: 4.81/5 Votes: 30 Popularity: 7.04 Licence: CPOL Views: 117,491 Bookmarked: 94 Downloaded: 0 Please Sign up or sign in to vote. Correctly using provider factories to create database independant code
SQL	Handling database connections more easily 30 Jul 2011 Updated: 31 Jul 2011 Rating: 4.82/5 Votes: 19 Popularity: 6.05 Licence: CPOL Views: 134,249 Bookmarked: 60 Downloaded: 0 Please Sign up or sign in to vote. Building an O/R Mapper: step 3.
	Database Design and Naming Conventions 27 Jul 2011 Updated: 2 Aug 2011 Rating: 4.31/5 Votes: 20 Popularity: 5.51 Licence: CPOL Views: 146,682 Bookmarked: 53 Downloaded: 0 Please Sign up or sign in to vote. Design for data integrity, simplified SQL, and programming ease.
	Using Information from the .NET DataProvider 13 Jan 2010 Updated: 14 Jan 2010 Rating: 4.80/5 Votes: 7 Popularity: 4.06 Licence: CPOL Views: 36,763 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
	Using the NTP Pool on Windows to Keep Your Clock Set, WITHOUT Additional Software [Tip/Trick] 17 Feb 2010 Updated: 17 Feb 2010 Rating: 0.00/5 Votes: 0 Popularity: 0.00 Licence: CPOL Views: 22,871 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	Get an Accurate Age by Date [Tip/Trick] 19 Feb 2010 Updated: 19 Feb 2010 Rating: 5.00/5 Votes: 2 Popularity: 1.51 Licence: CPOL Views: 7,810 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.

Alaric Dailey

Architect Pengdows

United States

This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.