DataTumble - Randomize Data Rowshttps://joellipman.com/articles/database/t-sql/datatumble-randomize-data-rows.html

07 December 2012 What? This is a stored procedure I've nabbed from some consultants from my day job. It shuffles the records and matching data values: Before: ID Name DateOfBirth --------- ------------ ----------- 1 John Smith 1988-06-24 2 Fred Bloggs 1972-11-17 3...

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

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

07 December 2012 What? Along with my DataJumble function and DataTumble procedure which also help scramble database tables sent to suppliers/developers, this is a function which simply finds random characters and inserts these. I would recommend using the DataTumble...

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

Setup a copy of your Joomla websitehttps://joellipman.com/articles/cms/joomla/setup-a-copy-of-your-joomla-website.html

19 December 2012 What? More for others than for myself, but this article is for those who do not have development/test environments of their Joomla website. I have been doing this for years and still come across clients who have the one version of their website. They...

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

Upgrading a Joomla 1.5 module to Joomla 2.5https://joellipman.com/articles/cms/joomla/upgrade-a-joomla-1-5-module-to-joomla-1-6.html

11 February 2011 What? So this is a note to myself so that I have a checklist and can quickly update any extensions designed for Joomla 1.5.x and make these compatible with Joomla 2.5.x websites. In the past, I have only ever changed the words to but for more stability,...

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

Set up Desktop SlideShow in Windows 7https://joellipman.com/articles/microsoft/windows-os/set-up-desktop-slideshow-in-windows-7.html

22 January 2013 What? Applies to Windows 7. Requires a Vogonian environment of red tape and bureaucracy. This is an article to describe an alternative method then "right-clicking on the desktop", "selecting Personalize", "clicking on Desktop Background", "browsing to...

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

JDatabase: using the Joomla database with exampleshttps://joellipman.com/articles/cms/joomla/jdatabase-using-the-joomla-database.html

27 January 2013 What? Apologies for posting yet another article on how to access the Joomla Database using the Joomla classes but this is just a quick note for myself as a reference sheet. Plus the official documentation don't have enough examples in my view. Source:...

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

CharIndex Reverse - find occurrence starting from end of string in TSQLhttps://joellipman.com/articles/database/t-sql/charindex-reverse-find-occurrence-starting-from-end-of-string-in-tsql.html

28 January 2013 What? This is a quick note on finding the last occurrence of a string in a longer string. This has to be in Transact SQL for a SQL Server instance only and not filtered by other code. Why? I have a string such as the following (column positions added...

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

Access MySQL databases using Oracle SQL Developerhttps://joellipman.com/articles/database/mysql/access-mysql-databases-using-oracle-sql-developer.html

01 February 2013 What? So this is a quick article on how to install the mySQL add-on for Oracle SQL Developer v3.0.04. Why? I've used various mySQL administration tools to manage mySQL databases over the years, all freeware until someone expresses an interest in using...

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

Quickly update all content in mySQL database replacing a stringhttps://joellipman.com/articles/database/mysql/quickly-update-all-content-replacing-a-string.html

03 February 2013 What? This is an article on how to replace a string with another in all your joomla articles without modifying other data such as modified date and author. Why? I used to have a third-party plugin that would replace my HTML tags with . Not I want to...

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

Export/Import Database using MySQL Workbenchhttps://joellipman.com/articles/database/mysql/export-import-database-using-mysql-workbench.html

05 February 2013 What? This article isn't unique as there are other tutorials out there. This is meant to detail a process to export a database using MySQL Workbench and then to import it into another database. Why? If you're confined to use this product then this is...

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

Preg_Replace all strings between two tagshttps://joellipman.com/articles/web-development/php/preg-replace-all-strings-between-two-tags.html

07 February 2013 What? For those of you who use Preg_Replace. Preg_replace is a function that uses regular expressions to search and replace a string. Why? Because my understanding with regular expressions is shady and varies from language to language, I've written this...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: *

Restore MSSQL Error: Database is in usehttps://joellipman.com/articles/database/restore-mssql-error-database-is-in-use.html

08 March 2013 What? This is an article on how to do a restore from backup on a database but when you get the error: "... database is in use". -- SQL Server 2005 EXEC SP_WHO // details on who is logged in GO -- SQL Server 2008 EXEC SP_WHO2 // even more details GO --...

• Type: Article
• Author: Joel Lipman
• Category: Databases
• 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 What? Please note: the following article is not a solution but a page of various methods and date conversions which I try and use depending on the situation. This is a quick article on how I got time conversion working in an SSIS package which read from...

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

SSIS Skip Rows in Excel Source filehttps://joellipman.com/articles/microsoft/ssis/ssis-skip-rows-in-excel-source-file.html

04 April 2013 What? A quick article on how to skip rows or even specify a range to extract from the Excel file when using as the DataSource. Why? If you are simply using a text file as your data source, then the options in the connection manager will let you skip...

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

T-SQL Conversion failed when converting the varchar to data type inthttps://joellipman.com/articles/database/t-sql/t-sql-conversion-failed-when-converting-the-varchar-to-data-type-int.html

14 May 2013 What? A very quick note in case I forget this one. If you are trying to join two tables and receiving the error "Conversion failed when converting the varchar value 'B110' to data type int" then read on. How? So where does the 'B110' string come from,...

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

Autohotkey Count Number of Files/Folders in a Directoryhttps://joellipman.com/articles/automation/autohotkey/autohotkey-count-number-of-files-folders-in-a-directory.html

04 June 2013 What? So this is an article to list methods of retrieving the number of files in a folder/directory. Why? Why can't we just use a loop and file pattern native to the Autohotkey programming language: UserFolder:="C:" -- UserFolder := RegExReplace(...

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

Reorder Columns in a Tablehttps://joellipman.com/articles/database/reorder-columns-in-a-table.html

22 July 2013 What? Just a quick note to myself on how to reorder columns as I was having difficulty using a phpMyAdmin interface to do this. How? Taken from the best forum for programming Qs&As: http://stackoverflow.com/questions/4095481/easy-way-to-re-order-columns...

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

Compare two databases using T-SQLhttps://joellipman.com/articles/database/t-sql/compare-two-databases-using-t-sql.html

24 September 2013 to: MS SQL Server Management Studio 2008 Two Transact-SQL databases What? A quick article on how to compare two Microsoft databases using the tools provided with SQL Server and without having to download any third-party products. Why? I googled and...

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

SSIS Script: convert UPPERCASE to Mixed-Case using TitleCasehttps://joellipman.com/articles/microsoft/ssis/ssis-script-convert-uppercase-to-mixed-case-using-titlecase.html

04 October 2013 Development Studio (BIDS) Visual Studio 2008 Microsoft Windows 7 Microsoft .NET Framework 3.5 Microsoft Visual C# 2008 What? So like lots of people on the net, I've been given a datasource with names and addresses all in UPPERCASE. Initially, no one...

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

Joomla Component: Set default params on installationhttps://joellipman.com/articles/cms/joomla/joomla-component-set-default-params-on-installation.html

24 October 2013 What? I'm making a custom component for Joomla CMS 2.5.x which is restricted to registered users only. On installation, and by default, the menu item returns a 500 - Server Error because the parameters haven't been set. I need to go into the Joomla...

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