How To Get To The Arbury Carnival

This blog pos covers a variety of transport options for getting to/from the Arbury Carnival. This event is held in King's Hedges in North Cambridge (UK) on the second Saturday in June each year.So where is it?The following Google Map shows the location of the Carnival.View Larger MapIf you want to search for the nearest postcode then the best one to pick is probably CB4 2LD. Campkin Road, the postal address for the Carnival, is actually quite long...

Read More

Oracle PL/SQL: Dropping All Objects In An Oracle Schema

This blog post provides a simple piece of PL/SQL which will delete every object owned by the currently logged in user.Here is the PL/SQL block;declare  v_ItemCount integer;begin  SELECT count(*)    INTO v_ItemCount    FROM ALL_OBJECTS AO   WHERE AO.OWNER = USER     AND AO.OBJECT_TYPE NOT IN ('INDEX')     AND AO.OBJECT_NAME NOT LIKE 'BIN$%';  while (v_ItemCount > 0) loop    for v_Cmd in (SELECT 'drop ' || AO.OBJECT_TYPE || ' ' || AO.OBJECT_NAME ||   ...

Read More

Deploying an ASP.NET Website to a Remote Server Running IIS 6

Probably the most important thing I can do first is to describe the environment I'm using; we have a global Active Directory forest with local domain controllers in each country. We have Windows 2003 servers running IIS 6 in both test and production - Developers (like myself) have a normal user account and a "Domain Administrator" account for working with remote servers. We use Kerberos for authentication (which requires a slight change to the process, see later).The website itself has been generated using Visual Studio 2008. It has a single label...

Read More

Opening Additional Mailboxes in Outlook 2007

A simple step-by-step guide for end users on how to open additional mailboxes (assuming you have been granted the appropirate permissions) using Outlook 2007 and Microsft Exchange Mailboxes in a Corporate Environment.Open Outlook 2007 as you would normallyAccess the “Tools” menu and select “Account Settings ...”Ensure that “Microsoft Exchange” is selected and click the button marked “Change...” just above and to the right of it.Click on “More Settings...

Read More

Oracle PL/SQL: Copying Column Comments From One View To Another

This blog post gives a piece of simple SQL that will allow you to automatically copy the comments from one database view to another. In the case of this example we are copying the column comments from a standard oracle view to a materialised view which has the same name except with "_MV" suffix.The PL/SQL block is;declare  v_ViewName varchar2(30) := 'XXX';begin  for v_Comment in (select acc.COLUMN_NAME, REPLACE(REPLACE(acc.COMMENTS, chr(13), ''), chr(10), '') comments                 ...

Read More

SSRS: Repeating Column Headings Not Appearing

This blog post covers how to make changes to your existing SQL Server Reporting Services Report to ensure that the Column Headings appear at the top of every page. The steps (and screen shots) below come from Report Builder 3 running against SQL Server 2008R2.Looking at a standard report the first thing you will have tried is to set the "Repeat Column Header" and "Repeat Row Header" on the table. For whatever reason this doesn't work and you'll then...

Read More

SSRS: Looking Up Values in Another Dataset

This blog post covers using Report Builder 3 (with Microsoft SQL Server 2008R2) to lookup a value in another dataset. Scroll straight to the bottom for the key function, the rest of the article is setup. NOTE: The back end of this example is an Oracle database but the solution will work for any database, you just will need to modify the SQL. Start Report Builder 3Select "Blank Report" from the New Report or Dataset wizard.Right click "Dataset"...

Read More

Apple TV (V1) unable to play Purchased Video (White Screen)

This blog post attempts to give a way of fixing the problem described above (which is related to account authorisation when using Multiple Apple ID's from iTunes not being correctly passed through to the Apple TV when you do a Sync).This fix will only be of use to you if you have just factory-resert your Apple TV, performed a new Sync of your videos, you actually use multiple Apple ID's (i.e. you and your partner have separate accounts), and you...

Read More

Oracle EBS: Repairing the "XXX is not a valid responsibility for the current user" error in Oracle

This Knol covers how to "fix" a problem that can occur in Oracle when you have granted a user access to a new web-based responsibility but the middle-tier application servers have not picked up this change.Below are detailed instructions on how to clear the cache on the middle-tier application server(s). As it says in the warning when you try and do it there will be a performance hit while it re-reads all the data from the database - use on Production...

Read More