I used to be a strong believer in regular funding of my retirement account, but now I'm less likely to do so. The finances for the USA are in horrific...

From a work perspective, was I involved? Did I solve some problems? I think sometimes we forget, being non-customer facing, that we're still in the business of helping people.

In case anyone's looking at this, the issue in our environment was that the guest user didn't have connect rights into msdb (not sure why; we may have done this...

Yup, her default DB is the one I'm trying to get her into 😀

We do use Resource Governor whose classifier function references a table in master but not msdb.

Adding a user to the datareader role doesn't necessarily give them access to the database unless CONNECT has been granted at the database level. Permissions are inherited, and depending on...

Interesting that you'd push your brother into IT from where he came from. Hope it works out.

I'm in IT and I could jump into sales with no trouble if I...

As a general rule, don't do linked security in the way noted in the article as all connections will be executed remotely with this remote user regardless of the loacal...

Evil Kraig F (2/22/2012)

---

One other piece of discussion that noone's brought up yet.

WHERE isnumeric(score) = 1

This cannot be trusted to go first. It's quite possible to end up...

Ah, NOT LIKE '%[^0-9]%'. That's the one. I'm using between 1 and 10 in my example but I don't know that's the range for every question. Maybe there will be...

Steve Jobs was a marketing and sales genius who stole every technical idea he ever had, presented them successfully as innovation, and ended up with a company that's got more...

Thanks Lowell. That Cross Join is helpful.

Ken

Don't think I've seen this configuration yet:

SQL 2008 SP2 on an Itanium 64

Windows 2003 SP2

1st test-

132273 (wow)

8.02182

A test machine with nothing going on but a completely full data drive...

Revenant (2/3/2012)

---

We have very strict change management: first, there must be a triaged change request in TFS.

Developers make changes and check them into TFS, ops deploy the changes to test;...

Working as a freelance developer for over a decade I have worked for differing sized clients from multinationals to small local companies where you can keep your shoes on and...