Include a carriage return in a column headinghttps://joellipman.com/articles/microsoft/sql-server/include-a-carriage-return-in-a-column-heading.html

07 July 2014 gets its content from a data source located on a database on the other side of the world. I want the header in the column "Academic Week" to break across two lines so that the column doesn't expand to the width of "Academic Week" and instead expands to...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server
• Language: *

Generate Academic Calendar using MySQLhttps://joellipman.com/articles/database/mysql/generate-academic-calendar-using-mysql.html

27 November 2012 We have a specific timetabling system for academic institutions and all our staff/students follow academic week numbers as opposed to calendar week numbers. Why? The aim of this article is to quickly generate a calendar for a full academic year for...

• Type: Article
• Author: Joel Lipman
• Category: MySQL
• Language: en-GB

Inserting incremental weeks in MySQLhttps://joellipman.com/articles/database/mysql/inserting-incremental-weeks-in-mysql.html

15 April 2011 unfamiliar with this system, the reason week numbers are different to normal people's week numbers is because these are academic week numbers. So I can't use the built-in functions. The current structure looks similar to this: ID SetID WeekNumber...

• Type: Article
• Author: Joel Lipman
• Category: MySQL
• Language: en-GB

Developer's Checklist: Taking over a projecthttps://joellipman.com/articles/web-development/developers-checklist-taking-over-a-project.html

01 March 2011 accurately describe what the system was for and what it does. The developer had created the system to only last during one academic year, and the system itself only just about understood academic years (required tweaking twice a year). Then there were...

• Type: Article
• Author: Joel Lipman
• Category: Web-Development
• Language: *