Thanks, Eric!

We have no true DR site, though our leadership is currently looking into one. We run a lot of high availability clustering, specifically through HP ServiceGuard on our UNIX...

SQLDBA360 (4/17/2012)

---

I was thinking of becoming bilingual so asked one of our Oracle guys, he reccomended the following books as a starting point:

Oracle Database 11g DBA Handbook (Oracle Press) -...

Thanks for the advice, Pablo.

I already have a couple of Virtualbox VMs on my local machine running Oracle environments for playing in - these have been very helpful.

I am also...

We run a lot of clustered instances and virtual servers, though with Database Engine and Reporting Services mainly. I'm willing to share what I have learnt relating to Reporting Services...

It turned out to be the result of Windows Server 2008 R2's firewall rules. After adjusting the firewall settings I am now able to connect using the cluster name.

I'm in a position where I cannot make changes until later in the day. I'll let you know what I find when I try later.

Thank you for your input. Your point has been taken into consideration. You are indeed correct regarding licensing as a serious consideration, in addition to other factors.

My original question is...

Thanks for your help. SQLArcher is correct - Installing SSIS...

If you don't mind and are able to share, I'd be interested to hear what they have to say to you. Since we have the VM hosts per-processor licensed for...

We run a few SQL 2008R2 instances on Server 2008 R2 VMs in Hyper-V. It's not ideal to use dynamic memory presently (Denali promises better support), but if you absolutely...

Check the Recursive Triggers Enabled option on your database.

http://msdn.microsoft.com/en-us/library/ms190739.aspx

You should be able to trigger deactivating the company on condition that all products are deactivated.

This won't reduce your file sizes now, but it may help avoid problems in the future:

I would recommend making sure your auto-growth settings are appropriate to your database size and...