thanks for listening Andy! Appreciate the reference as well. great article!

Dangit I had this idea for a blog post idea.

Anyway, I agree with the article and the analysis. You shouldn't not use cursors just because it's taboo or because...

Dammit I clicked too fast and I knew the answer too.

Great article and I agree. I've also heard the saying that "a good DB is a bored DBA". Basically the idea behind that is you've designed systems and...

I found this question kinda funny. Dropping the database gets rid of anything in a database, so even if one of the other answers was right, dropping the database...

I love security questions; I've run into this very situation several times, usually with a rogue login outside of my team's active directory group where they've setup database mirroring and...

Nice question.

Every parent I talk to I tell them to get their kids interested in tech. There's a shortage, even today, of quite simply, _resources_.... much less quality resources across...

I love schema collections in SQL Server. Very under-utilized by web developers who also use sql server, since they like to do everything with .NET, java, whatever.

At my last...

Bill (DBAOnTheGo) (4/16/2014)

---

Personally I'd like to make sure this is out there. Francis Apel, we do appreciate the article and you writing here. Not everyone will agree and in honesty...

Nice post about clustering and I agree on the nice points of it, but I disagree about clustering everything. Even in production. I like clustering as an HA...

I like this article if anything for the West Point, MS reference.

as usual, i read the question too fast and made assumptions

It's poorly worded because it asks how you can grant the ability to TRUNCATE, and by using the principle of least privilege, that is done by granting ALTER on the...

I think there could be some better practices surrounding the table definition as well. Why have Numeric(1,0) NULL columns? Can you not have a value that specifies that...