Maintenance plans have worked for me in the past, but I like Ola's script as a more flexible solution.

Create the login, then the user. I would set the login default database to the one in which you create the user. The login will have connect rights.

Then grant your...

ditto. Just saw that come through.

Thanks, I think that was a forum post, so it's hard to screen those out, but I'll see what we can do.

First you need to connect locally as an administrator. Local Windows admins usually have default rights, or the account that installed Express.

to add other accounts, use CREATE LOGIN: http://msdn.microsoft.com/en-us/library/ms189751.aspx

Most books have some practice questions in there, but publishing any of the exam questions or very similar ones is a violation of the NDA.

My advice is to go...

The only feature difference is in StreamInsight, with the amount and latency of events you capture.

The rest is CPU, RAM, and licensing.

I was surprised, but a quick test shows that a diff actually does reset the log chain.

Note that I took a full in simple, then added rows, then switched to...

Belated congratulations.

I thought it was 1-2%, which Paul doesn't dispute here: http://www.sqlservercentral.com/Forums/Topic663009-266-1.aspx

I do agree with Gail. If you cannot tune the queries, analyze them and send back information and suggestions to...

My apologies for the delays in responding. This has gotten a little out of hand, and it's become an argument on advice rather than an answer to a question. I...

I wouldn't pay for a report, and there are numerous ones out there, as Leeland noted. I also always participate in salary surveys, mostly just to get a copy of...

TravisDBA (7/5/2011)

---

Good article Steve! When it comes to ethics, I think Mr. Price Pritchett said it best: "You can't put someone else in charge of your morals. Ethics is a...

not a bad idea, but that would mean I'd have to make 2-3 levels of forums. I'm trying to keep things listed at two. So I have main forums for...

It's not that we will have 100k articles on some topic, but we will have some, and it wouldn't be necessary to read them all. Some will be outdated and...