What schedule is set for the SQL Agent job that runs the snapshot?

How about using the same backups to log ship to your staging server and on the last log backup you restore use the with Standby option?

For example to...

Threw this together quickly so may not be 100% but hopefully gives you a start:

SELECTCASEWHEN f.UsedQT < COALESCE(s1.AvailableQT, s2.AvailableQT) THEN COALESCE(s1.AvailableQT, s2.AvailableQT) - f.UsedQT

WHEN f.UsedQT = COALESCE(s1.AvailableQT, s2.AvailableQT) THEN...

Having done the SQL 2012 MCSA prior to these changes I agree the warehouse exam is pretty tough if you don't work in a warehousing environment. But as a DBA...

This would be a start for the monitoring of the services:

http://it-erate.com/monitoring-service-failures-powershell/

Which of the resources are you talking about? i.e. just the SQL Services or more than that?

For example if the cluster failed over, SQL server and the...

robin.pryor (7/14/2014)

---

I'm pretty weak on networking concepts. I'll say that up front. Hopefully I can ask my question intelligently enough for someone to understand and know the answer.

We have a...

Prior to reading the book \ sitting the exam I had developed a few relatively basic SSIS packages, but as a production DBA supporting our Data warehouse I regularly investigate...

Content wise I found the book OK, certainly enough to pass the exam. However there is a few mistakes but it gave me the opportunity to figure it out...

When you say cloud what do you mean? A DBA that administers instances hosted on a cloud platform, someone that manages the cloud platform, one of another many types...

essue006 (4/16/2014)

---

Hi

I passed OCA DBA 11g exams. I have some experience with Oracle, but zero experience with SQL Server.

For me was OCA DBA 11g exams very hard. I learned 2...

Do you have the option of upgrading to SQL 2012 and utilising Always on Availability Groups?

gilalig (4/29/2014)

---

Hi,

Would appreciate any help in implementing a solution for the following:

Source server: sql server 2008 r2 enterprise

Target server: sql server 2012 on DMZ

We need to replicate...

I may have missed some information as this is a long thread but I noticed that you have not set a MAXDOP value when creating your index, if the MAXDOP...

Personally I would say you are better defining what you want to do and then looking at what each provider can offer to suit your requirements.

For example even just within...