We use SQL Sentry and are very satisfied with it. We were going through the same exercise of trying to find one and this came recommended by a speaker...

In your linked server definition, you specify the login that should be used in the connection to the remote server. On the linked server itself, that login has to...

Jeff Moden (2/3/2014)

---

L' Eomot Inversé (2/3/2014)

---

Revenant (1/27/2014)

---

I wish that MSFT introduces a T-SQL construct like this:

RUN ON THREAD a

(some T-SQL)

RUN ON THREAD b

(another T-SQL)

AWAIT a AND b

(runs after both a...

Linked

Maybe I'm missing something here, but your second approach worked fine for me. I did notice that in some statements you're ALTERing the student table and in others you're...

Misapply

i can vouch for the performance of Jeff's DelimitedSplit8K function. I know the article contains performance benchmarking that looks too good to be true, but it is true. ...

The only thing I can think to ask is if you checked the database in the top list and then checked the db_datareader database role in the bottom list for...

I have not played with LINQ to SQL much at all and admit I don't know the OR designer. I have seen some of the SQL it generates and,...

Good question that's always on point. Nice way to end the week.

Pandamic

I especially like Kimberly's article Luis posted here. Sean, this may be...

Pervasive

Jeff Moden (1/30/2014)

---

rodjkidd (1/30/2014)

---

Company has out sourced prod DBA team. Been up and running since start of year, so some things are still falling through the cracks. So don't know...

Jeans