Saturday, August 02, 2014
   
Text Size
Login

Search

Total: 51 results found.

Search for:
Search Only:

Page 1 of 3

  1. 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
  2. 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
  3. 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
  4. 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
  5. 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
  6. 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
  7. 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
  8. 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
  9. 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
  10. 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
  11. 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
  12. 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
  13. 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
  14. Category: (SQL)

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

Latest Posts