Mostly sqlservercentral, blogs including other technologies, and yearly ms community days

Skip items included...

Welcome Erland,

Agreed the CTP-forums had their time now.

About sql 2012, it is fairly new, runs best (?) on windows 2012 (also new) and above all had its licensing changed (cores...

Have a pleasant stay in Afghanistan Lynn

We install manually after the blank os on the virtual machine has been provided. Usually takes two weeks to a month before it gets planned in. Bigger items a year...

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?