Friday, July 11, 2014
Text Size


Total: 51 results found.

Search for:
Search Only:

Page 1 of 3

  1. Category: (Transact SQL)

    ...  It might seem trivial but these little aesthetic changes done at the database level can save some time. Why? I have an Excel report which dynamically gets its content from a data source located ...
    Created on 07 July 2014
  2. Category: (MS Integration Services)

    What? This is an article to demonstrate a quick step-by-step on having an SSIS package loop through a directory/folder of files in order to populate a database table. We could add each file as a separate ...
    Created on 13 June 2014
  3. Category: (MS Integration Services)

    ... Visual Studio 2008, 2010 and 2012. VS2008 for our old SSIS packages and VS2010 for database solutions running against SQL Server 2008 R2. We can use VS2012 for both but this requires upgrading all the ...
    Created on 09 June 2014
  4. Category: (Transact SQL)

    ... N'FN') IS NOT NULL DROP FUNCTION ufn_ProperCase GO Method #2: Revised version This version will use a variable table but it could be adapted to feed off any database table. As before ...
    Created on 04 June 2014
  5. Category: (Transact SQL)

    ... in a database and rather than a separate file, it stores these in a row. How? Assuming the following data exists in the column "Event_XML" value of the table "XML_EVENTS": <?xml version="1.0" ...
    Created on 27 March 2014
  6. Category: (MS Reporting Services)

    ...  Analyzing the report through the ReportServer databases (internal auditing) only showed how long the SQL query would take to recover the data and present it in a report, which would average about ...
    Created on 07 March 2014
  7. Category: (General Joomla!)

    ... allows the passwords to be in MD5. All I want is a quick bit of code to get all the users out of a Joomla CMS. How? I could just type a query on the database and get the same result, but this script ...
    Created on 28 February 2014
  8. Category: (General Joomla!)

    ...  Restricted access to a component? A load of blab on ACL managers? How? In our case, the website had recently been migrated from Joomla 1.5.x to 2.5.x. I asked to examine the database and a quick ...
    Created on 26 February 2014
  9. Category: (Uncategorised)

    What? 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. Why? I'm being tasked to work with ...
    Created on 05 December 2013
  10. Category: (MS Reporting Services)

    ... "shared data source" to use). You might be able to get this working with a shared data source but in our case the shared data source didn't have the correct database (initial catalog) specified despite ...
    Created on 22 November 2013
  11. Category: (General Joomla!)

    ... the HOME folder - only check the subfolders. If they are, you've lost the Joomla CMS and you'll need to restore them from a backup. NOTE: Only restore the files! The images and database were unaffected ...
    Created on 17 November 2013
  12. Category: (SQL)

    ... Expressions With Oracle Database ...
    Created on 28 October 2013
  13. Category: (Joomla)

    ... using the Joomla! administrator panel to navigate to global configuration, does not work! How? It isn't in the configuration.php file prior to Joomla! v1.6.x but in the database. Open the database ...
    Created on 08 October 2013
  14. Category: (Transact SQL)

    Applies to: MS SQL Server Management Studio 2008 Two Transact-SQL databases What? A quick article on how to compare two Microsoft databases using the tools provided with SQL Server and without ...
    Created on 24 September 2013
  15. Category: (MySQL)

    What? Quick note on how to do this. I was tasked with cleaning up an english database by replacing all special alphabets (ë to e) and non-alphanumeric symbols with URL friendly characters. How? ...
    Created on 09 September 2013
  16. Category: (Transact SQL)

    ... needs permission to read the master database. If run by a service account, ask a DBA to emulate the user for testing. the Items column may vary from 1 and 10+. Not sure on why this ...
    Created on 23 August 2013
  17. Category: (SQL)

    ... and password login and demonstrates how to check against the database without including text that the website visitor submits. How? We're simply going to accept both the username and password, then ...
    Created on 19 August 2013
  18. Category: (SQL)

    What? This is an article to remind me how to modify a column in a database table the old fashioned way (as in stop making me use GUI interfaces so poorly programmed when even I've made better DBMS tools). ...
    Created on 24 July 2013
  19. Category: (Joomla! Tutorials)

    ... to words that are 1 or 2 letters mistyped. Grammar: Account for singular/plural, past/present, and noun/adjective/verb forms. Referencing: If this is a search system for a technical database, and ...
    Created on 07 May 2013
  20. Category: (Product Documentation)

    ... SQL to create a pre-populated table into a MySQL database. iana_ipv4_address_space_registry.csv: comma separated values list of all countries, regions and their respective IP ranges. ip_lookup.php: ...
    Created on 17 March 2013

Latest Posts

  • Joes Word Cloud (JWC)

    • Tue 17-Jun-14
      I'm using JE 3.1.19 stable.
    • Tue 17-Jun-14
      Ah good point. What version of jEvents are you using? I don't think I've tested it with any new ...
    • Tue 17-Jun-14
      The problem was caused by activating the option "Include JEvents content". Unfortunately I can't ...
    • Tue 17-Jun-14
      Hi Stefan, Thanks for your post but I was unable to see what the problem is. There is a "Debug Mode" ...
    • Tue 17-Jun-14
      Hi, Not at the moment as I never heard of the Frabrik component. Is it like K2? in which case I could ...