If are a sysadmin on the SQL Server instance, then you can setup a SQL Profiler or Extended Event trace for connections.

Alessandro Alpi (6/16/2015)

---

Eric M Russell (6/16/2015)

---

Just out of curiosity, does anyone here use SYNONYMNs as part of your database refactoring? If so then what unexpected limitations or quirks did you...

Just out of curiosity, does anyone here use SYNONYMNs as part of your database refactoring? If so then what unexpected limitations or quirks did you encounter?

Hacking databases has become so common, it's as if the people doing the hacking are some of the same people who develope the networking infrastructure, applications, and database systems in...

Jeff Moden (6/12/2015)

---

I have a different suggestion than the others... why is...

If what you need is to grant execute permission on ALL procedures and visibility on ALL objects, then you can use the following database level commands. However, as Jack suggested,...

Jeff Moden (6/12/2015)

---

Eric M Russell (6/12/2015)

---

Also build up a cash emergency fund enough to cover three months of basic living expenses. You may end up needing that to pay bills...

I don't use tools to generate DDL scripts, so writing T-SQL to do things like adding non-null columns, or dropping unnamed constraints and re-adding a named constraint, that's all situation...

DanMcClain (6/12/2015)

---

I think its great that Microsft does the early (not always perfect) for us early adopters. We have SQL 2014 in production utilizing Column store index, filetables, and In-memory....

jasona.work (6/11/2015)

---

Steve Jones - SSC Editor (6/10/2015)

---

Personally I have just let employers know when I'm looking. Nothing wrong with that. If I'm not happy or want something else, I'm open....

It sounds like your regular (no-sysadmin) login may have had access removed from it's default database or some DENY operation was used to remove permissions to something basic like listing...

I believe you should update statistics on all tables after a restore from backup migration. That's not done automatically.

jwbart06 (6/11/2015)

---

Last night at our PASS Chapter user group we had a gentleman that has moved many of his servers to 2014 and he did a great talk on the...

ericpap (6/11/2015)

---

Eric M Russell (6/11/2015)

---

Somehow I feel we're missing a lot of the back story; does this level of anarchy really happen in the IT departments of corporate or government...

Somehow I feel we're missing a lot of the back story; does this level of anarchy really happen in the IT departments of corporate or government world? I'm guessing it's...