Eric M Russell (3/5/2012)

---

So you're saying that the project requirements should include a document or Excel sheet that explicitly list what accounts / roles should be deployed in production and...

@eric, not knocking your process in terms of what it does. I'm more concerned with the issue of actually understanding what permissions are granted and potential holes. Comparing against a...

Slightly confused.

The maintenance task should be in an SSIS/Maintenance plan package. It isn't a job. The job would be the item that schedules and runs the package/plan.

Also, what changes did...

Eric M Russell (3/5/2012)

---

Databases have a much smaller surface area for security breaches than do Web applications. For a database, you're basically concerned with how accounts, role membership, or object...

Someone said last week that every Saturday until Oct will now have baseball.

First scrimmage yesterday. Good to be back on the field. Misjudged a deep fly in the wind, got...

Please don't ask for copyrighted material that is for sale. This is illegal and immoral. Invest in your career if you want the resources.

Not a bother at all, and good questions.

Here's how I see things:

1. If the Oracle DB connects to your SQL Server, 1 CAL needed. If SQL Server connects to Oracle...

I would worry about corruption, but do any of these help?

http://blog.sqlauthority.com/2007/08/02/sql-server-fix-error-945-database-cannot-be-opened-due-to-inaccessible-files-or-insufficient-memory-or-disk-space-see-the-sql-server-error-log-for-details/

http://sqlblog.com/blogs/jonathan_kehayias/archive/2009/01/22/error-945-severity-14-state-2-database-mssqlsystemresource-cannot-be-opened.aspx

Sounds like a good plan.

Did you allow for the backups themselves? They take space. Typically I would be moving the fulls to tape (or another server) ASAP, and then I'd...

GSquared (3/2/2012)

---

a) There are a lot of people looking for work, many of whom have valid credentials/qualifications for the field they work in, and many of whom have been a...

Then they didn't want to be there and they weren't good fits. Or you're...

TravisDBA (3/2/2012)

---

...

Actually, I am more interested in going to 2012 for the "Contained Databases' feature than the "AlwaysOn" feature because remapping logins/users and permissions has always been a pain...

16 cores meaning a 4x4 or are they more dense than quad cores? If you have more...

I hesitate to post the kb, because I don't believe in it, but there is a trace flag that bypasses the network drive check.

I don't have a 2000 instance to...

Correct, this is a security issue. The service account is the one that gets them ACL'd. You need to change that, carefully, to allow an admin to see them.

Make...