Tuesday, September 30, 2014
   
Text Size
Login

Search

Total: 51 results found.

Search for:
Search Only:

Page 1 of 3

  1. Category: (SITS:Vision)

    ... article on how to get data out of SITS, up to running the monitors and populating an OUTPUT table in the SITS database. Note that this does not include steps thereafter in the Staging or Target destination ...
    Created on 21 August 2014
  2. Category: (SITS:Vision)

    ... the XET export and you should get something like: <stu_codc>5826|England</stu_codc> Almost! If the code and it's short name/full name exist in the database, this works accordingly. ...
    Created on 12 August 2014
  3. Category: (MS Integration Services)

    ... to "Male", "Prof" to "Professor"). Why? Our extract phase in the SSIS package takes data from a source database and puts it in staging in the exact form it came through. Our transform package will ...
    Created on 05 August 2014
  4. Category: (MySQL)

    Applies to: MySQL Database v5.0.45 MySQL Workbench v6.0.8.11354 build 833 What? This is a quick article on how to get around the problem of backing up your MySQL database when attempting to ...
    Created on 28 July 2014
  5. Category: (General Joomla!)

    What? A quick article on how to use the where clause in a joomla database query. Why? In response to a member, I use the old form where I can include the whole SQL statement: $db->query('SELECT ...
    Created on 16 July 2014
  6. 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
  7. 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
  8. 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
  9. Category: (Transact-SQL)

    ... 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 it capitalizes words ...
    Created on 04 June 2014
  10. 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
  11. 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
  12. 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
  13. 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
  14. 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
  15. 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
  16. 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
  17. Category: (SQL)

    ... Expressions With Oracle Database ...
    Created on 28 October 2013
  18. 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
  19. 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
  20. 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

Latest Posts