DataScramble - Randomizing data rowshttps://joellipman.com/articles/database/t-sql/datascramble-randomizing-data-rows.html

07 December 2012 @CurrLen int; DECLARE @LoopCt int; DECLARE @Rand int; DECLARE @RandString varchar(max); -- for dates/times DECLARE @MinYear int; DECLARE @MaxYear int; DECLARE @RandYear int; DECLARE @RandMonth int; DECLARE @RandDay int; DECLARE @RandHour int; DECLARE...

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

SSIS Convert a string into a datehttps://joellipman.com/articles/microsoft/ssis/ssis-convert-a-string-into-a-date.html

14 March 2013 the data in that column is not consistent? This made sense as I need to parse the string to extrapolate the date, month and year. How? I used two "Derived Column" tasks for this after giving up with a "Data Conversion" task. I then parse the date, month...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Integration Services
• Language: en-GB

Write a Calendar in Autohotkeyhttps://joellipman.com/articles/automation/autohotkey/write-a-calendar-in-autohotkey.html

27 January 2010 ; Haven't found anyone who calculates how many days there are in a month so this is a crude solution ; This checks if this year is a leap year Check1:=Mod(A_YYYY,4) Check2:=Mod(A_YYYY,100) Check3:=Mod(A_YYYY,400) if (Check1=0) AND...

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

MySQL Data Type Reference Tablehttps://joellipman.com/articles/database/mysql/mysql-data-type-reference-table.html

15 February 2010 HH:MM:SS' 8 bytes "0000-01-01 00:00:00" to "9999-12-31 23:59:59" Date/Time TimeStamp 19700101000000 to sometime in the year 2037 4 bytes Date/Time Year 'YYYY', 'YY' Range "1901" to "2155" 1 byte

• 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 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 the error...

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

Creating a Profile Plugin for Joomla 1.6https://joellipman.com/articles/cms/joomla/creating-a-profile-plugin-for-joomla-16.html

27 April 2011 JOELLIPMAN_BOOLEANNO="No" JOELLIPMAN_ALLERGYTIMEOPTION0="Less than 6 months" JOELLIPMAN_ALLERGYTIMEOPTION1="Less than a year" JOELLIPMAN_ALLERGYTIMEOPTION2="1 year" JOELLIPMAN_ALLERGYTIMEOPTION3="5 years" JOELLIPMAN_ALLERGYTIMEOPTION4="10 years+"...

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

Excel PivotTable Filter List Orderinghttps://joellipman.com/articles/microsoft/excel/excel-pivottable-filter-list-ordering.html

05 September 2011 If any new values come along then they get added to the bottom of the list... This is the problem. For example, if the year dropdown has a list of 2010, 2011, 2013; then if you add an entry which has year 2012, then the dropdown list will be in the...

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

Call to a member function mark() on a non-object in Joomla CMShttps://joellipman.com/articles/cms/joomla/call-to-a-member-function-mark-on-a-non-object.html

17 November 2013 files! The images and database were unaffected in our case and could be left as they were. Our last file backup was over a year old but we only needed the core files, a working system, and then we could proceed with a standard Joomla update. I suspected...

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

GoDaddy Apache cPanel: Install SSL Certificatehttps://joellipman.com/articles/linux/cpanel/godaddy-apache-cpanel-install-ssl-certificate.html

07 April 2022 A quick reference for myself as I found that with GoDaddy, a purchased SSL certificate seems to require re-installing each year despite it's expiry in a couple years time. The first time I did it, there were more steps; the second time I just did as per...

• Type: Article
• Author: Joel Lipman
• Category: cPanel
• Language: *

Google Event Ilustrations aka Flairshttps://joellipman.com/articles/google/google-event-ilustrations-aka-flairs.html

05 December 2024 bookclub: book club, reading bowling: bowling breakfast: breakfast, breakfasts, brunch, brunches camping: camping chinesenewyear: chinese new year, chinese new years, chinese new year's cinema: cinema, movies clean: cleaning, clean the house, clean the...

• Type: Article
• Author: Joel Lipman
• Category: Google
• Language: *

Add "Command prompt from here" to right-click context menuhttps://joellipman.com/articles/microsoft/windows-os/add-command-prompt-from-here-to-right-click-context-menu.html

27 January 2010 to: Microsoft Windows XP How? I keep having to do this every year as I reghost all my machines (=restore to sorta factory settings), so instead of googling it and going through other websites that work and don't; I thought I might as well post the way I...

• Type: Article
• Author: Joel Lipman
• Category: Windows OS
• Language: *

Remove write-protect from USB pen in Windowshttps://joellipman.com/articles/microsoft/windows-os/remove-write-protect-from-pen-in-windows.html

13 April 2010 will corrupt the pen. BTW I don't use the "remove device safely" rubbish as my old pen never did and it was fine for over a year. The default setup in windows XP is that it doesn't need it. Bulletproof, waterproof, fireproof, shockproof BUT NOT...

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

Joe's Unduplicater (JUD)https://joellipman.com/component/content/article/joes-unduplicater.html?catid=40

12 July 2010 Basically this is the third time I wrote this program, simply because I reghost all my computers (Home & Work) each year and can't be bothered to retrieve accidentally deleted programs from my backup drives. I downloaded a load of media files (all...

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• Language: *

SQL Calendar in Business Intelligence Development Studiohttps://joellipman.com/articles/database/t-sql/sql-calendar-in-business-intelligence-development-studio.html

14 January 2011 to return the month containing that date: I'm going to change the header from "Reinventing the wheel" to the Month and Year based on this parameter: Note that I've asked it to return the full date of the parameter, this is because I will format it via...

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

Joes FREE Website Thumbnailer (JWT)https://joellipman.com/component/content/article/joes-free-website-thumbnailer.html?catid=40

28 June 2011 I then upload the images to my server and this Joomla! CMS uses them. Maybe I'll run this program again in a month, maybe a year. My websites don't depend on real-time screenshots and the sites I link to don't generally change their website design...

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• Language: *

Joes Bug Tracker (JBT)https://joellipman.com/component/content/article/joes-bug-tracker-jbt.html?catid=40

07 July 2011 I have needed a replacement for the download component managers for Joomla! CMS. I've tried all the following for about a year each and these are my reviews/opinions: Phoca Download Good compatibility and actively developed. Unfortunately hacked on more...

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• Language: *

AutoHotkey Format Date and Format Secondshttps://joellipman.com/articles/automation/autohotkey/autohotkey-format-date-and-format-seconds.html

20 September 2011 60) IfInString, ThisSecs, . ThisSecs:=SubStr(ThisSecs, 1, InStr(ThisSecs, ".")-1) If ThisDays>0 { If ThisDays>365 { ThisYears:=ThisDays/365 IfInString, ThisYears, . ThisYears:=SubStr(ThisYears, 1, InStr(ThisYears, ".")-1) Grammar:=(ThisYears=1) ? "" :...

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

Proposed Budget i3 PC under £200https://joellipman.com/hardware/proposed-budget-i3-pc-under-200.html

26 January 2013 workstation upgrade running Windows 7 So another year gone and our workstations running Windows 7 are somewhat lagging when opening too many apps. The recent release of Windows 8 has led to a review of our developer's equipment and the verdict is that...

• Type: Article
• Author: Joel Lipman
• Category: IT Support
• Language: *

AwStats Data Parser (ADP)https://joellipman.com/component/content/article/awstats-data-parser-adp.html?catid=40

03 April 2013 Infographic for Joomla (JIJ) need? Summary Period Report (details on your awstats report) Monthly History (per month per year) Days of Month (per day this month) Days of Week (per day this month) Hours (per hour this month) Countries (Top 25 this month)...

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• Language: *

Client Services: Website Development Agreementhttps://joellipman.com/static-items/client-services-website-development-agreement.html

15 November 2013 until these add up to 1 hour. Housing the production and 2 development websites and email system as permanent host is £120/year (or £10/mo). This includes keeping the servers up-to-date and running with the latest technologies. You are welcome to find...

• Type: Article
• Author: Joel Lipman
• Category: Static Items
• Language: *