First, I'd recommend you use this maintenance script. Lots of expert DBAs have reviewed it and they like it: http://sqlfool.com/2009/06/index-defrag-script-v30/

Second: This is not necessarily good advice.

after ur rebuild index/reorganize, you...

They should, and I've asked for this to be fixed. It's logged as a bug, but a low priority one. That page doesn't get many reads.

Ed has good suggestions for you.

I might also schedule a job that checks for new objects in the primary filegroup every night. Let it run and email you if there...

I would actually like to get new articles written, and then add a note in the article to link to the new one as a "better" way.

Don't forget that finding...

Took the kids to the mint this past summer. It was a near trip and we got to see pennies being minted. The tour said they've worked hard to reduce...

john.richter (1/12/2011)

---

I'm afraid this misses the point: 'Avoiding "the cloud" because it's "less secure" assumes that your local servers/computers are completely secure.'

...

This is the reason that vaults...

Robert Hermsen (1/12/2011)

---

we had a perfect experience the other day that should cause some concern for those wanting the cloud. Verizon lost a core router in our area and...

As my friend Jeff would say, Bwaa-haa-haa

I can't afford Benjamins. We're in a recession, so you have to make do with Jacksons.

If you want to work for a half hour, I am happy to email some...

I think that green is an appropriate color for the US

Thanks for the note.

I edited this to reflect SSMS, which is what I think you mean. It's Management Studio. Note that this isn't an instance. SSMS on your machine does...

That's in the "them" section of the world map, isn't it?

this says no: http://msdn.microsoft.com/en-us/library/ms143393.aspx

You can compare integer and varchar in some cases. An implicit conversion may occur, but it...

Chances are if you have your SQL Server allowing remote connections, it is exposed.

In the firewall, you want to allow connections to 1433 TCP on your SQL Server, ONLY from...