T-SQL: Parse an XML value
This took me a while to find so I've posted an article below detailing how to parse or extract values from a string containing XML code.
Knowledge base / Since 1999
Scripts, systems & field notes.
Practical solutions and technical notes from CRM platforms, workflow automation, APIs, databases and the systems around them.
Advanced search342 entries / matching Data
Clear filters
SSRS: Performance Improvements: SELECT TOP
This article details a method we used on a search form in a SQL Server Reporting Services (SSRS) environment. The requirement (amongst others) was that the report ran in less than a few seconds. Analyzing the report through the ReportServer databases (internal auditing) only showed how long the SQL query would take to...
Export Joomla Users script
Somebody said I could pay to get an export list of my Joomla users. I said Joomla is a FREE OpenSource system,
Registered Users Cannot Login - Super Users Can
This article is a note on how I fixed an issue on a client site. The website had a redirect on the login which would go to a page accessible by "registered" users but only "Super Users" could actually login. "Registered" users would not be able to login, despite their status in the admin panel saying "enabled" and "act...
MS-DOS: Copy folders without overwriting files
A quick note on how to copy files and folders over without overwriting existing files. It's easy to say "Yes" and replace all files. What I need is something that synchronizes files on an internal hard drive to an external one. I wanted it to copy only the files that were new in the original folder and only copy those...
Regular Expressions in SQL
Practice makes perfect. Or in my case, any practice is a start. This article serves as a quick note on how to use regular expressions within SQL statements: How? For the following examples, I am pretending to select rows from a table called `STUDENTS`.
Joes Password Analyzer (JPA)
What is Joe's Password Analyzer? Joe's Password Analyzer is an online tool that quickly checks any password you might want to try using and suggests variations on this. Simply type a word or phrase in the input field and let it do the rest. Background Joe's Password Analyzer is a Joomla 2.5.x component which simply dis...
Generate a Timesheet in MySQL
This article is to remind me how to create a blank weekly timesheet which reads the duration of events from a database and auto-completes your timesheet.
Oracle: order by subquery missing right parenthesis
A quick note on how I got round one this one.
Loading more notes...
No more notes to load.