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

22 January 2013 desktop", "selecting Personalize", "clicking on Desktop Background", "browsing to the Picture Location". The problem happens when browsing to the picture location and it doesn't seem to remember which folder you selected. At home, this would be a...

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

Proposed Budget i3 PC under £200http://mail.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: *

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

05 February 2013 this is how to do it. Personally, even a web-based app such as PhpMyAdmin would fare better. How? So this is the HOME tab when you open MySQL Workbench. We're going to go on the basis that you already setup a connection to your database under the SQL...

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

Administrator Program Shortcut without Prompthttp://mail.joellipman.com/articles/microsoft/windows-os/administrator-program-shortcut-without-prompt.html

25 February 2013 Ultimate (VS2010) and Business Intelligence Development Studio (BIDS), require elevated or administator rights/privileges when run. This is so that these programs can write back and forth to our C drive. If we don't run them as local administrators on...

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

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

08 March 2013 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 -- Run as...

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

Country Lookup by IP address CSVhttp://mail.joellipman.com/articles/database/mysql/country-lookup-by-ip-address.html

17 March 2013 IP ranges and their allocated country. Our use here was to create a refreshable country by IP address list that we can use when parsing our website logs to check where visitors were from. Note: we also use and love Advanced Web Statistics (awstats) but...

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

Parse a HTML Table into a ListViewhttp://mail.joellipman.com/articles/web-development/html/parse-a-html-table-into-a-listview.html

30 March 2013 of the extract, and a third string (2a) to specify the closing position of the extract. NeedleMarker is the offset and means when this function is used for several tables, the Needlemarker tells the function to start from where it last found a table and...

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

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

04 April 2013 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 rows and...

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

T-SQL concatenate an incremental row numberhttp://mail.joellipman.com/articles/database/t-sql/t-sql-concatenate-an-incremental-row-number.html

24 May 2013 with an ORDER BY which seems to work somewhat. But using the code above still produces an error which can only be seen when using more records and more employees. PARTITION BY So a sort of "group" action will allow this if we add "PARTITION BY" to the...

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

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

22 July 2013 phpMyAdmin So in the phpMyAdmin interface, apparently, you can drag the columns by clicking and holding on the headers when viewing a table structure... Though maybe this is derived from a template and depending on if you are using MS Internet...

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

Regular Expression Basic Usage Exampleshttp://mail.joellipman.com/articles/web-development/regular-expression-basic-usage-examples.html

28 October 2013 one character would otherwise be allowed. For example, you can use this operator to ensure that the collating sequence 'ch', when defined in a locale such as Spanish, is treated as one character in operations that depend on the ordering of characters....

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

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

17 November 2013 bad news is you have lost your site. The good news is that it's only the core files and component files. Here are some tips when restoring the site to return it to as it was. The error refers to a function used by the core framework. Comment it out and...

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

Generate a Timesheet in MySQL http://mail.joellipman.com/articles/database/mysql/generate-a-timesheet-in-mysql.html

05 December 2013 any date, and the system returns the timesheet for the week that date occurs in. How? The example below shows how to do this when your weeks being/commence on Monday. It also uses the current date in the form of NOW() but this example has to work with...

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

ReCaptcha alternative: Integrate PlayThru in JComments 2.3 for Joomla 2.5http://mail.joellipman.com/articles/cms/joomla/recaptcha-alternative-integrate-playthru-in-jcomments-for-joomla.html

24 March 2014 comments. How? So I have come up with what I consider a pretty stable solution. I adapted it from various legacy solutions when using Google's ReCaptcha. Note: There is a Joomla plugin for AYAH and this works for the user registration form. I installed...

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

301 Redirect using htaccess filehttp://mail.joellipman.com/articles/web-development/301-redirect-using-htaccess-file.html

03 April 2014 a 301 site gets removed from the Google directory and true to form Google have removed it. Not sure why nobody believed me when I raised the alarm but hey-ho. How? I'm going to show you how to do this with a .htaccess file: Upload a text file to the...

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

ReCaptcha alternative: Integrate PlayThru in JComments 3.0 for Joomla 3.2http://mail.joellipman.com/articles/cms/joomla/recaptcha-alternative-integrate-playthru-in-jcomments-3-0-for-joomla-3-2.html

27 April 2014 visitors. How? So I have come up with what I consider a pretty stable solution. I adapted it from various legacy solutions when using Google's ReCaptcha. Note: There is a Joomla plugin for AYAH and this works for the user registration form. I installed...

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

SSIS: How to loop through multiple flat files as data sourceshttp://mail.joellipman.com/articles/microsoft/ssis/ssis-how-to-loop-through-multiple-flat-files-as-data-sources.html

13 June 2014 ForEach Loop Container to your "Control Flow" (NB: This did not exist in my data flow ssis toolbox - if you do not see it when you are under the "Control Flow" design tab, then select Tools > Choose Toolbox Items > SSIS Control Flow Items > Tick the...

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

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

07 July 2014 Format the cells in Excel containing the header under "Alignment" to "Wrap Text". The difference the above does, is that when you refresh the data, it will retain the carriage return in the column headings. Additional: Only appears obvious in SQL Server...

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

SITS: Export field code and namehttp://mail.joellipman.com/articles/web-development/xml/sits-export-field-code-and-name.html

12 August 2014 for the error to come through the XSLT but watch your datatypes Notes: We did not find a way to return the code when the lookup failed, only an alternative message "*LookupFailed*".

• Type: Article
• Author: Joel Lipman
• Category: Extensible Markup Language
• Language: *

Add attribute xsl:nil=true on empty elements using XSLThttp://mail.joellipman.com/articles/web-development/xml/xslt/add-attribute-xsl-nil-true-on-empty-elements-using-xslt.html

18 August 2014 attribute of the element so that it's tag displays "xsi:nil=true". If...then...else... will be emulated by the XSLT choose...when...test...otherwise: true true -- yields: assuming value of DATE_OF_BIRTH is blank or null yields Done!

• Type: Article
• Author: Joel Lipman
• Category: XML Stylesheet Language Transformations
• Language: *