DataBaseZone.com
Conrad Muller
Juneau, Alaska

Email: conrad at
databasezone
dot com

Code Examples and Developer Resources


NEW! There is a new and improved version of my Calendar database. There are twice as many holidays and improved descriptions.

A Brief Personal Exploration of Software Development Philosophy and Practice and The Software Development Team

A Brief Explanation of How Database Server Software Works

A Brief Explanation of Designing a Normalized Database

A Brief Explanation of the evolution of XML


SQL Server Scripts for Database Design and Maintenance


Designing the Calendar-Holiday Database Application


To improve access to data and encourage innovation, the United States Census Bureau has begun to provide API access to some data sets.

Obtaining Census Bureau data directly from the Census Bureau APIs


My posts on this site are just subjects that caught my attention for a moment. If you are looking for an organized approach to SQL Server database subjects try:

Joe Celko's Stairway to Database Design on SQLServerCentral.com

Robyn Page's SQL Server DATE/TIME Workbench from Redgate Software's simple-talk newsletter

Mark S Rasmussen's SQL Server Storage Internals 101 from Redgate Software's simple-talk newsletter


Older Resources
A few small JavaScript and jQuery functions
I have spent some time writing or finding JavaScript and jQuery string functions and dynamic formatting functions that provide maximum functionality with minimum code. If you are interested in the code, use view source (Ctrl+u).
A Simple Calendar Database you can Download
Pre-calculating business days and holidays simplifies all kinds of date calculations and makes it possible to access this data through normal data access code and business logic code. The calendar includes secular, Christian, and Jewish holidays. I would have included more Islamic holidays, but the major Islamic holidays are not computed, they are determined by astronomic observation each year. The vagaries of visual observation can cause the date of a holy day to vary by a day.
 
This calendar covers January 2010 through May 2032. There are over 8,000 dates and over 2,500 holidays.
A Database Schema for User info, Authentication, Authorization, and Managing Passwords and Login Attempts
This database schema is the final version as documented in one of my database course sections.
Adding Google Maps V3 to Iron Speed Designer 7.x through 9.x Web pages
Maps add both value and "sizzle" to applications. All of my recent projects have included interactive maps. If your site is publicly available at no charge, or if you can afford to buy a license, Google maps can be integrated into your Iron Speed Designer application in a few steps. This is a cut-and-paste do-it-yourself project, and is also published on the Iron Speed Designer Web site. ISD versions 10+ include a drag and drop map control, but you can still create a custom map if you wish.
 
If you are not using Iron Speed Designer, you can cut and past the code, and download the files into your own project. You might need to correct a few references to match your own directory structure. Other than that, there should be no problem.
 

Some links to resources for programmers.
 
SQL Server and t-SQL resources
Microsoft platform programming resources

Note: This page used to have dozens of resources, but I was too busy to keep all of the articles current. I have retained these articles because they are the most popular, and I could find time to maintain them.

Home | Resume | Project Portfolio | Writings | Developer Resources | Contact Form