Howard is right. You shouldn't need to release space. Set the log to be the largest batch based on the year/month you are doing. After each commit, the space will...

create a database, with filegroups and files, and then copy over the schema. You can move tables one by one and specify on which filegroup they work on.

You can't necessarily judge someone by their points, but if they aren't very knowledgeable, likely they'll never get to 1000 posts. They'll get constantly berated or second guessed, and likely...

Any changes to databases? renames?

The solution will work, I'm not sure what you're worried about. The web login is only as secure as the web server. Ideally you'd set up a web login in...

Closing this thread.

A few things.

first, writing to the file system, sending emails, etc. in a trigger is a bad idea. If there's an issue, or it's slow, it delays or confuses the...

A few other links for you on this site:

http://www.sqlservercentral.com/articles/Administration/thevalueofadba/1806/

http://www.sqlservercentral.com/articles/Administration/dbaroles/517/

http://www.sqlservercentral.com/articles/Editorial/62865/

I think outsourcing inside the US can work, especially in rural communities that are changing people from other low-skilled jobs.

Outsourcing is a partnership, and if your partner doesn't perform well,...

We've used Password Safe to store the passwords, and the current password isn't a big deal. It's the rotation of passwords that gets confusing. I suppose you could just add...

Brian is the expert, and he's correct. For example, just like the domain administrator account cannot be locked out, the SA account cannot be locked out.

You might start here: http://msdn.microsoft.com/en-us/library/bb500348.aspx

It's worth understanding how this works before you set it up. It's pretty simple to set up with the wizard, but you want to know what...

Bruce,

Go for it. We're always trying to get some done, and it's a struggle. Get a good series going, and it might even turn into a book!

The enforcement should be based on the base OS.

If you are working with Windows Auth and SQL Auth, there're not related.

That would work, but you'd switch your then and else clauses.