Next 

I have started working with Oracle and I was recently tasked with importing a data pump export to a different schema. Once all the required roles were created and the correct REMAP_SCHEMA option was sorted out* I was left with one interesting problem. Everything remapped properly except triggers. The trigger name was remapped correctly but the target table still referenced the old schema.

Failing sql is: CREATE TRIGGER "NEW_SCHEMA"."TRIGGER_NAME" BEFORE INSERT ON OLD_SCHEMA.TRIGGER_NAME ...

I'm surprised that something this obvious would go unfixed.

**note Multiple schema remaps are done as follows:

REMAP_SCHEMA=(OLD_SCHEMA1:NEW_SCHEMA1,OLD_SCHEMA2:NEW_SCHEMA2)
Ok, I know Microsoft isn't big on following laid out standards, but it doesn't stop it from causing headaches. Today I found out that a simple column rename in SQL server is not possible with standard, well documented SQL. alter table tablename change oldname newname varchar (10); Instead I have to use some sort of SQL Server procedure sp_rename sp_rename 'TableName.ColumnName', 'NewColumnName', 'COLUMN'

Here's a tip for copying a database in SQL Server 2008 (maybe other versions) via the Copy Database wizard.

When I initially tried the wizard it failed with Message: Access to the path 'E:DataMicrosoft SQL ServerMSSQL10_50.MSSQLSERVERMSSQLDATANEWDATABASENAME.mdf' is denied.

In this case the NETWORK SERVICE was not able to create the new MDF file. I had to do add this user with FULL CONTROL to the MSSQLDATA directory and the wizard ran with no complications.

  1. Navigate to data folder
  2. Right click -> Properties
  3. Click the Security tab
  4. Click the Edit button to change permissions
  5. Click the Add button to add a new group or user
  6. Search for "NETWORK SERVICE" and click Add
  7. Click the Full Control checkbox for the newly added user

In case you're trying to find the wizard, right click the database, pick tasks, then Copy Database.

I want to switch accounts on my Galaxy Note 10.1, so my wife can use it on a trip she's taking, but I want to re-install the same apps. Since it's not rooted at the moment, I have to reset to factory defaults to switch Google accounts which would erase everything I have installed

In order to restore my installed apps and data after resetting, I'm using ADB (Android Debug Bridge) to backup my device. The backup command looks like this: adb backup -apk -shared -all -f galaxynote.ab For this particular device, if I didn't enter a password it would create an empty backup file.

Once this is done, I can reset the tablet and then run: adb restore galaxynote.ab And my apps are back but using a different Google account.

My plan is to eventually flash the Note 10.1 with Android 4.2 so we can have multi-users but that will have to wait for another day.