To the experts of DBCC TIMEWARP

Why can't system databases be restored "with move" like the others?

Example: RESTORE database model with move -> The system database cannot be moved by RESTORE

I would start them in this order

1.SSRS Server

2.SharePoint SQL (no connection errors to reports)

3.SharePoint Web (no connection errors to SharePoint sql)

Great story

You need a rendering extrension for SSRS, 3th party or write it yourself

Contact support?

I once tricked HP dataprotector by modifying the host-file of the HP backup server so dns calls would render the IP of target server instead of the Original server.

Target...

Install the oracle client

I recommend you start applying them after some testing.

Haven't tried it yet, but why would you want to access Oracle as sysdba through linked server?

Isn't it possible to grant the user the specific rights for their needs?

Start reading the oracle concepts

and DBA 2 day course

As above, talk to your manager about priorities and stop taking work to home.

If possible get some training time so you won't have to do training in personal time, so...

SQL Server days (2 days) just passed and was great. How do you prepare for pass summit with 5 days of awesomeness?

source data is on another server ?

More like a linked server setup (run package on server A to access data from server B)?

I have something like this

/****** Object: ProxyAccount [proxySSIS] Script Date: 8/09/2015 16:12:43 ******/

IF NOT EXISTS (SELECT name FROM msdb.dbo.sysproxies WHERE name = N'proxySSIS')EXEC msdb.dbo.sp_add_proxy @proxy_name=N'proxySSIS',@credential_name=N'SSISProxyCredentials',

@enabled=1,...

localhost\instancename

localhost\port

(see ms sql server configuration manager)

is ms sql server browser service running?

Check on runtime settins like dateformat for datetime string conversions?

What is the output format of the report? html vs excel ...