It is because they are successful. DBA aren’t skillful enough to take it to that level and develop an installer or whatever is needed so they are no...

A key is a key whether it is implemented using a PRIMARY KEY constraint, UNIQUE constraint or other means. Referential integrity is something else because not all keys are...

The way I handle this situation is if I trust the vendor, I give them the permissions they specify, if I don't trust the vendor, I don't use their program.

You...

Better than mine!

https://security.stackexchange.com/questions/19969/encryption-and-compression-of-data

• This reply was modified 6 years, 4 months ago by x. Reason: mispelled "Ralph"

"A weekend of heavy drinking Patrick? I'd lay off a couple of weeks if I was you. :-p"

Heh, I get it, I'm one of those pesky "don't misappropriate my terminology"...

THERE HAVE BEEN MULTIPLE WARNINGS ON SSC AGAINST THIS CONSTRUCT!!!!!!!!!!!!!!!!!

UPDATE EmployeeTable

SET EMailAddress = otherTable.EMail

WHERE EmployeeTable.FieldX = OtherTable.FieldY

DO THIS INSTEAD!!!!!!!!!!!!!!!!!!!!!

UPDATE E

SET E.EmailAddress = S.Email

FROM EmployeeTable E

JOIN OtherTable S

ON E.FieldX = S.FieldY

(credit...

• This reply was modified 6 years, 4 months ago by x. Reason: misspelled column name, changed "best pal" to "arch nemisis"
• This reply was modified 6 years, 4 months ago by x. Reason: changed "arch nemisis" to "some poster called"

For these sorts of problems, I just allocate according to whatever formula I would ordinarily use to allocate amongst the recipients of the allocations. Then if they do not allocate...

Never thought of that, thanks for the follow up!

Yes, its the default behavior. You have to take an extra step to send that parameter as a comma delimited string to your data source (which would be a stored...

• This reply was modified 6 years, 5 months ago by x.

Grant, well said... Having worked with cloud and SQL DBA work, I found learning Powershell is a must. Anyone deals with cloud and managing different flavors of RDMS...

• This reply was modified 6 years, 5 months ago by x.

yeah I hate newer web site incarnations. This one isn't bad at all in particular though, but in general I'm not all into the new mobile first thing. At least...

specifically talking about the editorial topic list we see when going to the link:

https://www.sqlservercentral.com/forums/forum/sqlservercentral-com/editorials

The nice thing tho is that the "oops" page you land on from a google search includes a search box itself, then putting the same search term in gets you...