Data Randomization Function in Oracle PL/SQLhttps://www.joellipman.com/articles/database/pl-sql/data-randomization-function-in-oracle-plsql.html

22 August 2012 the same length and the same type of data. Why? The joy of working with the plethora of applications out there result in me using MySQL, Oracle PL/SQL and Transact SQL in my day job. The equivalent functions have to be written up all in the name of...

• Type: Article
• Author: Joel Lipman
• Category: Oracle PL/SQL
• Language: en-GB

T-SQL example of Case-Sensitive Soundexhttps://www.joellipman.com/articles/database/t-sql/t-sql-example-of-case-sensitive-soundex.html

10 October 2012 Additional Note how this also picked up typos in the 4th value which is good as I didn't want to overcomplicate things using LEVENSHTEIN and DIFFERENCE: SOUNDEX('Data Not Yet Available') = SOUNDEX('Daat oNt EYt Avialable')

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

Stored Procedure to List Distinct Values and Countshttps://www.joellipman.com/articles/database/t-sql/stored-procedure-to-list-distinct-values-and-counts.html

26 October 2012 Yes you could just run a SELECT DISTINCT query along with collation to make it case-sensitive and/or accent-sensitive but using this stored procedure means I only specify the table and then the columns. How? IF...

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

Search a database for a value and count matching rowshttps://www.joellipman.com/articles/database/search-a-database-for-a-value-and-count-matching-rows.html

05 November 2012 value. ** ** NOTE: This script can be run separate to a stored procedure by ** ** declaring @p_Value and @p_Column and using only the code ** ** from the BEGIN to the END (exclusive) - allows you to run ** ** this against any table only changing the...

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

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

07 December 2012 V 0.01 ** ** Description: Stored Procedure to scramble Data in a column of a table. ** ** The process will mix the Data using a random function. ** ** Once the Data has been scrambled it won't be possible to get the original set of Data. ** ** ** **...

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

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

07 December 2012 sent to suppliers/developers, this is a function which simply finds random characters and inserts these. I would recommend using the DataTumble script over this one as this leaves data very difficult to work with: Before: StudentID StudentName...

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

Joes Revolver Map (JRM)https://www.joellipman.com/component/content/article/joes-revolver-map-jrm.html?catid=40

07 December 2012 or The Unique ID code would be "3sv7MUqXeMI" (without the double-quotes) How to do this without using this extension: Visit the website http://revolvermaps.com/?target=setup Configure the map to the settings you want. Copy the entire javascript code...

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

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

07 February 2013 Hello @World » Hello @World $string_formatted = preg_replace( '/@[a-z]+/i','$0', $string_original); -- METHOD #2: equivalent using preg_match_all $matches = null; preg_match_all('/(?!\b)(@\w+\b)/',$string_original,$matches); foreach ($matches as $match)...

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

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

08 March 2013 OK Searches ssms restore database in use Cannot drop database because it is currently in use Restoring a SQL Database Backup Using SQL Server Management Studio Unable to restore database "..because it is in use by this session." determine who is...

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

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

14 March 2013 two "Derived Column" tasks for this after giving up with a "Data Conversion" task. I then parse the date, month and year out using SUBSTRING: -- Assuming [This_Date]="21/03/2012" (DT_DATE)(This_Date) -- Assuming [This_Date]="20120321" (YYYYMMDD)...

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

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

03 April 2013 which allowed quicker reports then scanning entire website visitor logs. No installation and USB portable. Currently runs using either Windows XP or Windows 7. How to use: Save a frame of your Awstats page (so there isn't the menu on the left) Run...

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

SSIS Skip Blank Rows in Flat File Sourcehttps://www.joellipman.com/articles/microsoft/ssis/ssis-skip-blank-rows-in-flat-file-source.html

23 April 2013 This is a quick article to remind me on how to skip blank rows when using a Flat file as a data source. I would receive another Microsoft error as clear as mud: Error: The conditional operation failed. Error: SSIS Error Code...

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

Improve Default Joomla Search https://www.joellipman.com/articles/cms/joomla/improve-default-joomla-search-heuristics.html

07 May 2013 file is at /modules/mod_search/tmpl/default.php and I put it just before the closing form tag " ". Note that if you are using a 3rd-party template which has it's own login module, you will need to find the file specific to that template (eg....

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

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

14 May 2013 AS MyCount FROM DMExtractEmployeeTable e2 LEFT JOIN DMExtractReferenceTable r2 ON e2.CodeType=r2.MapIn -- THIS IS THE LINE CAUSING THE PROBLEM!!! WHERE e2.ID=e1.ID GROUP BY e2.ID,r2.MapIn ) AS MatchingRecordsCount FROM DMExtractEmployeeTable1 e1 LEFT...

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

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

04 June 2013 future use: ; if A_LoopFileAttrib contains H,R,S ; continue This works fine at home on your local host on a local drive. Try using this over a networked drive and more time will be spent counting the files then the actual processing (or whatever your...

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

Problem creating SSRS report subscriptionshttps://www.joellipman.com/articles/microsoft/ssrs/problem-creating-ssrs-report-subscriptions.html

11 November 2013 "New Data Source" Specify the details, especially the connection string (which the system account can use). Set "Connect Using" to "Credentials supplied by the user running the report". Browse to your report or upload it if it does not exist. Hover the...

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

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

15 November 2013 hours for these changes to cascade across my servers (average wait is 1 hour). JoelLipman.Com will develop the startup site using an Agile framework based on the initial requirements up to and including the User Acceptance Testing (UAT) date (not yet...

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

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

17 November 2013 or prior to updating the core Joomla CMS. Ticking both options and then updating re-created the error. I restored the files (using a backup to overwrite the existing PHP files), leaving the database and images folder unchanged. I updated just the Joomla...

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

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

05 December 2013 Thursday 11:00:00 11:50:00 -- 2013-12-05 Thursday 10:00:00 11:30:00 -- 2013-12-06 Friday 07:00:00 09:00:00 This example is using a small table with very little sample data so do not expect it to reconcile with the requirement example. Note that we have...

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

SSRS: Performance Improvements: SELECT TOPhttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-performance-improvements-select-top.html

07 March 2014 not working!?) and eventually would display circa 3000 matching results. If I attempted to check this in "preview" mode using Business Intelligence Development Studio (BIDS / VS2008), the IDE would crash and close without warnings or notifications. We...

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