You can have users from another domain as long the server domain trusts the user domain.

Brandie, also got the Stairway to U-SQL twice today

Great article

Could you change the where-clauses to use proper date-variables instead of strings

WHERE CalendarDate BETWEEN convert(date,'2/27/2016',101) and convert(date,'3/1/2016',101)

instead of

WHERE CalendarDate BETWEEN '2/27/2016' and '3/1/2016'

If you can't join them in the database, you can use the Lookup function.

As attendee 150 km or a 2 hour drive in Belgium

As it is a virtual server. Is the memory for the VM fixed or dynamic? (ballooning)

3) Mostly logs about performance, execution, ...

We cut it to 90 days after the catalog grew to half a terabyte. It will also save time when you have to patch...

Congratulations

The connectstring seems to be wrong (MSORA are the old MS oracle drivers).

Should be something like

Provider=OraOLEDB.Oracle;Data Source=MyOracleDB;User Id=myUsername;

Password=myPassword;

More info on the connectstring[/url]

It's a bit difficult without a testcase (tablescript, indexscript, data).

Points of interest:

The use of distinct bo.MedRecReviewID : why distinct

The inner joins in the upper select: can be replaced with...

No holiday either, next one is in july.

You will be needing the connect information for a linked server configuration.

In-house it would be through OracleOleDb and an Oracle Client on the MS SQL Server.

For within the instance you can use resource governor[/url]

For multiple instances you'll probably go with cpu affinity per instance

You downloaded the 64-bit version

You might want the 32-bit version (X86)

instead of ToString("MM/dd/yyyy")

you can add the hours, minutes ...

ToString("MM/dd/yyyy hh:mi:ss")

*Have yet to lookup the correct formatting string