How to Display Report Execution Time in SSRS (milliseconds)https://www.joellipman.com/articles/microsoft/ssrs/how-to-display-report-execution-time-in-ssrs.html

17 November 2011 How to Display Report Execution Time in SQL Server Reporting Services 2008 R2 So there are other articles out there but I was looking to display in milliseconds the execution time it took for a particular report (which searches for results matching the...

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

Joes DNS Correction (JDC)https://www.joellipman.com/component/content/article/joes-dns-correction2.html?catid=40

25 November 2011 by the following third parties: * AutoHotkey v1.0.48.05 -- http://autohotkey.com/ * Joes Brains v0.1 alpha -- http://joellipman.com/ Future Considerations: Any suggestions? Send them to...

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

Performance Report - Background colors based on dataset valueshttps://www.joellipman.com/articles/microsoft/ssrs/green-red-background-colors-based-on-dataset-values.html

02 December 2011 Why? I've recently written a report for SQL Server Reporting Services 2008 R2 (SSRS) which will compare up to 4 reports and will compare the time taken for each one. The breakdown or what I was able to measure with the default installation are the times...

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

SSRS Dropdown parameter cannot be blank!https://www.joellipman.com/articles/microsoft/ssrs/ssrs-dropdown-to-allow-blank-values.html

14 December 2011 What? I have created an SSRS report which can compare 4 reports side by side and brings up their latest execution times to the nearest millisecond. The report has 4 parameters. Each parameter is a dropdown populated by a list of all available reports....

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

Getting the mysql where in delimited string to workhttps://www.joellipman.com/articles/database/mysql/getting-the-mysql-where-in-delimited-string-to-work.html

02 January 2012 What? I have a mySQL database table of room assets that has a field containing the ID numbers of images relevant to this room. The Problem? When I select specifying the statement "WHERE IN (c.RoomImages)", this is interpreted as a string and when...

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

Basic Oracle Function Structurehttps://www.joellipman.com/articles/database/pl-sql/basic-oracle-function-structure.html

15 January 2012 What? I need to refer to how to create a function in Oracle PL/SQL and sites on the net just attempt to overcomplicate everything and have forgotten how it is to be new to Oracle. I need a function in it's simplest form and if I want to torture my...

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

Collin Consulting Ltdhttps://www.joellipman.com/component/content/article/collin-consulting-ltd.html?catid=33

29 June 2014 Joe did a really superb job for me on this. My website crashed and I had no idea how to fix it. My hosting service were no help at all. Worse, I hadn't backed up my website for 18 months so even if Joe managed to retrieve it I expected most of my data...

• Type: Article
• Author: Webmaster
• Category: Portfolio
• Language: *

Basic Oracle Stored Procedure Structurehttps://www.joellipman.com/articles/database/pl-sql/basic-oracle-stored-procedure-structure.html

16 January 2012 Previously For a basic Oracle function, visit my article Basic Oracle Function Structure. For a more advanced version which uses cursors to work with SSRS, see my article Oracle Stored Procedures in SSRS. What? I asked someone for a simple, easy and...

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

Returning Oracle Stored Procedure Resultset in SSRShttps://www.joellipman.com/articles/microsoft/ssrs/returning-oracle-stored-procedure-resultset-in-ssrs.html

19 January 2012 What? So I've spent a fun time googling and binging but still haven't found a simple and complete example of getting a resultset from an Oracle stored procedure and displaying this in SQL Server Reporting Services (SSRS). Well "non-productive" more than...

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

No rows returned in Oracle causes SP to failhttps://www.joellipman.com/articles/database/pl-sql/no-rows-returned-in-oracle-causes-sp-to-fail.html

24 January 2012 Why? We have a stored procedure which contains two select queries. The first query will retrieve a student ID number where the input parameter is the student's username. The second query will return data using the student ID number found in the first...

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

How to change local folder for TFShttps://www.joellipman.com/articles/microsoft/tfs/how-to-change-local-folder-for-tfs.html

08 March 2012 What? I installed Business Intelligence Development Studio 2008 (BIDS) and connected it to a Team Foundation Server 2010 (TFS) instance and set my working local folder to my home directory. When the rest of my colleagues installed it however, they...

• Type: Article
• Author: Joel Lipman
• Category: Team Foundation Server
• Language: *

MySQL: Display Users and Duration in Matrix Timesheethttps://www.joellipman.com/articles/database/mysql/mysql-display-users-and-duration-in-matrix-timesheet.html

27 April 2012 Given Data Activities by employees with start dates and end dates in a mySQL database. Objective User Mon Tue Wed Thu Fri Sat Sun Total --------------- ------- ------- ------- ------- ------- ------- ------- --------- Me 09:00 07:30 08:00 07:00 06:00...

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

Migrate JComments from Joomla 1.5.x to Joomla 2.5.xhttps://www.joellipman.com/articles/cms/joomla/migrate-jcomments-from-joomla-15x-to-joomla-25x.html

07 June 2012 Thought I'd add the migration script I've been using to test my JComments migration from my Joomla CMS site version 1.5.20 to Joomla CMS site version 2.5.6. DISCLAIMER I do not work for either Joomla or JoomlaTune (Jcomments) This script is provided as...

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

Prefix Line Numbers in a Text Filehttps://www.joellipman.com/articles/automation/ms-dos/prefix-line-numbers-to-a-text-file.html

18 July 2012 Intro Prefixing lines with their respective line number in a text file using a Microsoft Windows Operating System... I've just googled this as I couldn't remember how I did this last time and a number of people showing off their MS-DOS batch skills have...

• Type: Article
• Author: Joel Lipman
• Category: MS-DOS
• Language: *

Print Directory Contents to a Filehttps://www.joellipman.com/articles/microsoft/windows-os/print-directory-contents-to-a-file.html

19 July 2012 Why? A friend asked me if there was a quick way to simply right-click on a folder in Windows Explorer and it would generate a text file with the contents of the directory he right-clicked. What? We can do this by adding an entry to the context menu...

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

The Mermaidhttps://www.joellipman.com/articles/_other-misc/the-mermaid.html

24 July 2012 'Twas a Friday morn when we set sail And our ship not far from land, We there did espy a fair pretty maid, With a comb and a glass in her hand, Her hand, her hand, With a comb and a glass in her hand. While the raging seas do roar, And the stormy winds...

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

DataJumble - Shuffling characters in a data valuehttps://www.joellipman.com/articles/database/t-sql/data-shuffling-function.html

01 August 2012 This was called a Data-Scrambling Function but it depends on what you mean by "scrambling". This is a function which merely uses the same characters but switches their order randomly, so I've renamed it DataJumble as opposed to my article on...

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

Copy a table with structure and data into a temporary tablehttps://www.joellipman.com/articles/database/t-sql/copy-a-table-with-structure-and-data-into-a-temporary-table.html

03 August 2012 Why? Hmm... I was writing a stored procedure that will scramble data given a table as a parameter. Because I only want to update a temporary table and not the original (source) table, I needed the following stored procedure (or part of). What? This will...

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

Connect to Joomla database in standalone scripthttps://www.joellipman.com/articles/cms/joomla/connect-to-joomla-database-in-standalone-script.html

17 August 2012 APPLIES TO Joomla 2.5.x Why? I'm building a Joomla component which is to be compatible with Joomla versions 1.6.x to 2.5.x. Because I use dynamic scripts running in the background (mootools), some of these need to connect to the database but as they sit...

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

Basic Joomla 2.5 Mootools Formhttps://www.joellipman.com/articles/cms/joomla/basic-joomla-25-mootools-form.html

20 August 2012 1.6.x - 2.5.x: Out-of-the-box template: -- add subfolder if this is not in the root of the domain: -- eg. http://demo.joellipman.com/joomla25/ has file in -- -- also note that this form can work with simply the core mootools script -- but does not...

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