MiguelSQL (3/7/2012)

---

Hello,

Two things:

1- Restarting SQL in single mode (using the -m flag) will allow any person that is a member o the Windows Local Admin group to be automatically a...

Personally I like the DH and the offense it brings. With the specialization of pitchers hitting only once a week, it's almost like a wasted out in most cases and...

What browser/version?

You don't really "name" then the schema. I guess you reference them that way, but really you are grouping them, just like a role.

Objects have an owner, separate from the...

I prefer all feet to be kept away from my mouth.

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...