Have no experience with realtime replication. How realtime is it (ns, ms, minutes...). Is it realtime part oneway (oracle+msql) to ms sql server?

Triggers have a disadvantages

Great article, Chaos Monkey went opensource

Honeypot accounts may be easier to implement

Hopefully MS finds something.

Oracle Net services tuning (buffers).

Have you checked that offload/chimney on the nic is off? Can cause troubles.

For sqlplus you might have to check the fetch/arraysizes

SQLPlus tuning...

Congratulations Wayne and Jason with your MCM

Hello Nicolas,

Where does the condition GROUPED.TOTAL_DURATION = AL3.DURATION come from?

You could also try to use a "WITH clause"

WITH mysubquery AS

(SELECT ...)

SELECT EXTRA.*

FROM EXTRA

INNER JOIN mysubquery on extra.X=mysubquery.Y

My attempt to an...

Does the oracle universal installer mentions that the odbc-driver is installed?

What version of the 11g driver did you install 32-bit or 64-bit, instantclient vs full client?

*

Search this forum on SSIS...

Nice selection of questions. Got busted on 3,10 & 12

We had a strange cause oracle transactions failing after sometime.

It was fixed with a reboot of the server after an installation of the 11.2 client (for the post reboot...

if the oracle is 11.2 or later you can use recursive WITH-sql instead of connect by

Did the oraclemts service stop running? Do you have the latest oracle client?

Depends on more than just the size. Was the size given in GB ram, GB diskspace. What is the cpu usage and I/O consumption of each?

Which version of Hyper-V 2008...

Also verify that the user have read/write permissions. If they don't have write permissions, the lck file can't be created->exclusive mode

Good question.

The web showed some motherboard that support 32 GB ram and there are 8 gb ram modules available; may 2012 article[/url]. Processor of preference I7.

Or perhaps a secondhand...

a power supply swap is usually a good place to start