I guess the real questions at this point is not "how to I recover a dropped database?" but rather "how do I recover a deleted file?".

How Volume Shadow...

Programmers have it a lot easier than doctors. We have the luxery of practicing on test subjects, before moving on to the real thing, and even when we get stuck...

Eric M Russell (8/19/2015)

---

OUTER APPLY (

SELECT...

One more thing. If there are any domain groups (like MyCorp\DBA) or local Windows server accounts (like BUILTIN\Administrators) that are members of SYSADMIN database server role, then confirm that this...

hurricaneDBA (8/20/2015)

---

Thanks for the reply everyone. The contractor requested to have db owner privs hence was the reason I asked about hiding the security folder. When I tried it with...

jckfla (8/19/2015)

---

Eric M Russell (8/19/2015)

---

So, I'm guessing SOX regulators required them to have an alternate business continuity process on standby. In...

Below is a link to a 15 line sample Powershell script that prompts for input parameters, and then connects to SQL Server and executes stored procedure using those parameters.

It...

Not unless there is a SSMS AddIn out there to hide or disable certain menu options and object explorer details. When you consider all the sysadmin related functionality that's in...

Just make sure the contractor has access to only the specific database they need. They can't grant themselves role membership or permissions at server level or another database, unless you...

OUTER APPLY (

SELECT items

FROM dbo.SplitString(ISNULL(DAV.Value1, ''),...

The next time the SAN goes down, I'm just going to take a week PTO while the vendor straightens the mess out. My personal backyp plan will be a couple...

So, I'm guessing SOX regulators required them to have an alternate business continuity process on standby. In the event the application...

Steve Jones - SSC Editor (8/18/2015)

---

Stuart Davies (8/18/2015)

---

I don't think it is a straight forwards as it would be for a photographer for example. Confidentiality and copyright could come into...

Perhaps the following:

Create a string variable to hold the SQL command, and have it's value derived from a dynamic Expression. On the OLE DB Source, set Data Access Mode to...

Like I said earlier, if estimating is part guesswork, then the business should be the one providing the guesses. The business should define what is a Sale and then estimate...