Passwords: Did-you-knowhttps://joellipman.com/hardware/passwords-did-you-know.html

15 November 2010 (source: NirSoft Recovery Tools 01/2008) 4 main techniques used in getting your password: Steal It (by looking over someone's shoulder), Guess It, Brute Force (=try every combination), Dictionary Attack (=try every combination starting with words that...

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

SQL Queries for Statisticshttps://joellipman.com/articles/database/mysql/sql-queries-for-statistics.html

13 December 2010 (VisitorUAgent), the User ID (VisitorID, 0 if not logged in) and of course the Timestamp (DateTimeStamp). Here is a page of some MySQL queries I can do based on just those 5 columns: MediaWiki: number of unique guests, students and staff by month. Also...

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

Connection Strings for SQL Serverhttps://joellipman.com/articles/microsoft/sql-server/connection-strings-for-sql-server.html

05 January 2011 is available from Connector/NET version 5.0.3. In earlier versions, this option has no effect. Using encryption, alternative Some reported problems with the above one. Try replacing the key "Encryption" with "Encrypt" instead....

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

Accessing a MySQL Database with Business Intelligence Development Studiohttps://joellipman.com/articles/database/mysql/accessing-a-mysql-database-with-business-intelligence-development-studio.html

05 January 2011 5.1 Driver" > Finish Data Source Name (should be system name followed by Live/Test/Dev for reference) Description can be some long winded text that very few will ever use TCP/IP Server is the server name (without the DNS suffix) or the IP address of the...

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

Merge the content of two similar tables in MySQLhttps://joellipman.com/articles/database/mysql/merge-the-content-of-two-similar-tables-in-mysql.html

11 January 2011 standard SQL we can combine the contents of two tables with a CROSS JOIN, (BTW these are not instructions to create some table I'll never use again unlike the rest of the solutions I found on the web). In MySQL, I only know how to do this with a UNION...

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

Room with a view E.M. Forsterhttps://joellipman.com/articles/_other-misc/room-with-a-view-em-forster.html

04 February 2011 Taking a break from website migrations. Thought I'd share some thoughts I was reminiscing of: "We cast a shadow on something wherever we stand, and it is no good moving from place to place to save things; because the shadow always follows. Choose a...

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

MySQL: Find records in one table that are not in another.https://joellipman.com/articles/database/mysql/mysql-find-records-in-one-table-that-are-not-in-another.html

25 February 2011 I find myself writing increasingly complex SQL scripts and it's at the stage where we need to optimize the queries because some scripts are noticeably slow (as observed by the customer...) and then others not. The What I'm going to run these benchmark...

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

SSRS Hide results table if emptyhttps://joellipman.com/articles/microsoft/ssrs/ssrs-hide-results-table-if-empty.html

29 March 2011 dataset) =IIF(Sum(Fields!Counter.Value, "Equipment") send to back), the expression for visibility on the textbox should be something like: =IIF(Sum(Fields!Counter.Value, "Equipment")>0, True, False) If you're bugged by the warning "Overlapping report...

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

CSS keeping the footer at the bottomhttps://joellipman.com/articles/web-development/css/css-keeping-the-footer-at-the-bottom.html

25 April 2011 this by including a div push layer which clears both (even though i had clear:both on the css for my #right div layer). For some reason, it has a more forceful effect in its own separate layer. In a joomla CMS template though, I wanted the "left" div to...

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

Newbies guide to be the local computer guyhttps://joellipman.com/hardware/newbies-guide-to-be-the-local-computer-guy.html

28 April 2011 Ask local businesses if you can post a flyer in their window or on their cash wrap. Initially, charge a nominal fee…maybe something like $30/hour just to build up a client base and get some referalls. Put up a Web site describing your services. It makes...

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

What's the problem? Amusing computer issueshttps://joellipman.com/articles/web-development/whats-the-problem-amusing-computer-reports.html

28 April 2011 and could only see the users screen. Three Webdevelopers phone in to say their computers can't view a website properly "Can someone have a look at our computers because we recently received the new corporate template for our website and it's not...

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

Could not instantiate mail functionhttps://joellipman.com/articles/cms/joomla/could-not-instantiate-mail-function.html

09 May 2011 is an incorrectly setup mail system. Here is a list of rules that must be followed: I took this from Direct Admin but it has some useful guidelines for these kind of issues: How to setup the Mail System 1) hostname must not match any domain that is...

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

SSRS / MDX Date Querieshttps://joellipman.com/articles/microsoft/ssrs/ssrs-mdx-date-queries.html

03 August 2011 endlessly as I've been working in SSRS. The below is derived from a collection of various sources across the web as well as some of my own. These are what worked in my environment: WinXP, BIDS (vs2008), TFS (vs2010), SSRS 2008 R2. The following examples...

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

Joes Network Transmission Detector (JTD)https://joellipman.com/component/content/article/joes-network-transmission-detector-jtd.html?catid=40

29 September 2011 includes the AHK file for you to modify and play with (Hooray for OpenSource) so you can style it to your own taste. Here's some pictures of it on an XP machine with a dark grey desktop background: In Development Read data packets without causing...

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

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

14 December 2011 part of my SQL query is because I had to match the datatype used by our reporting server for the ItemID field which is some sort of hexadecimal ID value that Microsoft are so very fond of. You will need to use your own head to match the datatypes for...

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

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

15 January 2012 submit an Active Directory (AD) username and receive a student ID number instead, all with the aim to improve performance on some SSRS queries which accept either an ID number or an AD name as user parameters. Syntax: CREATE [OR REPLACE] FUNCTION...

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

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

27 April 2012 list, within the loop run the activities query and replace the string "STRING_TO_REPLACE_PER_ITERATION" with the User ID. Something like: $result=mysql_query($user_list_query); while($row=mysql_fetch_assoc($result)) { $this_user_id=$row['UserID'];...

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

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

19 July 2012 to list. Instead of C:\windows\system32\cmd.exe, I could have used %Comspec% or even %windir%\system32\cmd.exe but with some group policies, you will get an "access denied" message. If you don't have a C:\windows folder, then find your "cmd.exe" program...

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

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

17 August 2012 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 outside of the MVC structure, we need them to use the existing...

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

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

20 August 2012 to it; obviously you may want to tidy this up but the more basic the receiving data the better. In my example, I'm returning some HTML but for security and stability, you will want this to use an XML file depending on the level of detail you want back....

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