Search
-
Category: (General Joomla!)
... Panel Navigate to Global Configuration > Site > Site Settings > Feed Email = Site Email (check this is “Site Email”) Then go under Global Configuration > Server > Mail Settings > ...Created on 09 May 2013 -
Category: (Product Documentation)
... finish the project, I quickly created this program to extract all the data values from an AwStats report. Advanced Web Statistics or AwStats, is a reporting system for server logs. This gives data ...Created on 03 April 2013 -
Category: (Microsoft)
What? This is an article on how to do a restore from backup on a database but when you get the error: "... database is in use". -- SQL Server 2005 EXEC SP_WHO // details on who is logged ...Created on 08 March 2013 -
Category: (Oracle SQL)
Applies to: - MS Windows 7 Enterprise What? So I can ping the server the Oracle 11g database sits on. I've installed the Oracle 11g client tools and can connect using sqlplus. But if I tnsping ...Created on 04 March 2013 -
Category: (MS Windows)
... tick the checkbox Run with highest privileges. set "Configure For" to Windows 7, Windows Server 2008 R2 Under the Actions tab, Click on New... Leave "Action" as Start a program for Program/Script, ...Created on 25 February 2013 -
Category: (MySQL)
... We're going to go on the basis that you already setup a connection to your database under the SQL Development section. Export/Import happens under the Server Administration section: Let's create ...Created on 05 February 2013 -
Category: (SQL)
... I also need to use Oracle databases in my day job so the Oracle SQL developer is already a pre-approved software for our work computers. We have SQL Server Management Studio (SSMS) as well for our ...Created on 01 February 2013 -
Category: (Transact SQL)
What? This is a quick note on finding the last occurrence of a string in a longer string. This has to be in Transact SQL for a SQL Server instance only and not filtered by other code. Why? I ...Created on 28 January 2013 -
Category: (Joomla)
... on the server itself. (ie. Fast & Reliable) Compress/backup LIVE files to ZIP file. Export LIVE database to SQL file. (Export > Custom > Save output to file) Except for configuration.php, ...Created on 19 December 2012 -
Category: (Transact SQL)
... 1964-08-08 How? Precursor You will need to be able to create the following view to generate random numbers on SQL Server. -- Drop the view if it already exists IF OBJECT_ID ('vwRandom', ...Created on 07 December 2012 -
Category: (FTP)
... "my_ftp_host" is the hostname or IP of the server holding my site) Enter login credentials Type dir (lists files & folders in the current remote working directory) Type cd /path/to/my/website ...Created on 20 November 2012 -
Category: (MS SharePoint)
Applies to Microsoft Office Sharepoint 2007 What? I've been tasked with adding links to files located on some network shares. I want to use UNC paths such as \\myServer\myShare\myFile.doc. ...Created on 08 November 2012 -
Category: (Transact SQL)
... ** ** Link to other SQL Server collations: http://msdn.microsoft.com/en-us/library/ms180175.aspx ...Created on 26 October 2012 -
Category: (Transact SQL)
... 1 Title 2 Forenames 3 Surname Note the below example omits the ID column and just leaves VALUE. Why? Do we need a reason? How? For SQL Server 2005 or later, using ...Created on 26 October 2012 -
Category: (Transact SQL)
... the collation of the SQL Server being case-insensitive. What? End-users said that they could see the options "Data Not Yet Available" as well as "Data not yet available". These are obviously the ...Created on 11 October 2012 -
Category: (Transact SQL)
... eg. "Data not yet available". The final system (qlikview) was case-sensitive despite our server collation being case-insensitive. Furthermore, we now have the task of finding all the variations of ...Created on 10 October 2012 -
Category: (MS-Dos)
... forget to tell everyone else that they are no longer using the program when they are done. What? The program is on a server to which our standard credentials cannot use the "OPENFILES" command on ...Created on 14 August 2012 -
Category: (Transact SQL)
What? Some people have been suggesting you can use "CREATE OR REPLACE ... VIEW ... FUNCTION" but my SQL Server 2008 Management Studio doesn't like this and refuses to understand what I'm trying to do. ...Created on 03 August 2012 -
Category: (Transact SQL)
... Server Data" by John Magnabosco but tweaked for our purposes. NOTE that the following has only ever been run on development environments and I would not recommend running this on a production system as ...Created on 01 August 2012 -
Category: (MySQL)
... me to look at ways of reducing the load on the server and the solution was to separate both tables (activities and users) rather than trying to join these, and to let PHP do a bit more of the work: ...Created on 27 April 2012