GBimberg (2/27/2014)

---

If you could alter tables the way you suggest, it would appear that you could also change the column order and type.

Accidently changing the column order and type...

paul.knibbs (2/27/2014)

---

I would assume it's because of memory issues (human ones, not SQL ones)--for instance, if I have a 60-column table that I want to add a single column to,...

Not GoDaddy, I hope. They lost my wife's DNS records and I had to play tech support guy for a day.

No good links.

If you look here: http://msdn.microsoft.com/en-us/library/ms187798%28v=sql.100%29.aspx

and here: http://msdn.microsoft.com/en-us/library/ms187798%28v=sql.110%29.aspx

you'll see length differences.

Same for Hashbytes in BOL. I'm surprised they didn't add this to the "What's New", but it's a...

Yeah, we need better disclosure on the "repair" strategy being bad.

I wish this was a TF enabled item and not just something people can run

Certificate length increased, hashing algorithms improved. I don't think the Symmetric algorithms changed, and it looks like the asymmetric ones are the same.

In terms of testing, building some setup harnesses for FK data shouldn't be too hard. It's also reuseable work, so that doesn't seem to be a valid argument for anything...

USE msdb

GO

SELECT * FROM dbo.sysssispackages

That's where they are. To run them, or edit them, you'll need BIDS/SSDT

There is stronger encryption, but you can implement better algorithms using the CLR, so that might not be a reason.

Overall, I'm not sure there are compelling reasons outside of Audit,...

FYI: http://blogs.msdn.com/b/jenss/archive/2008/05/06/obfuscation-is-not-a-security-feature-spoofing-the-app-name.aspx

You can search for some scripts here, but you'd need a separate trigger for each table. The fields copied over would vary, so your trigger scripts need to account for...

If I have

LookupID LookupValue

====== =========

1 Red

2 ...

tmlink99 (2/23/2014)

---

This is why I suggested doing both. Seeing what the OP has found is the best for their situation doesn't preclude seeing what's voted as best by the...

rodjkidd (2/24/2014)

---

On Saturday I went to the Classic Rock Society awards. Fairly small run outfit, but well respected.

It was being hosted by one of my musical heroes - Fish, he...

I meant write code that looks for

count(lookup value) = count(*)

for a table. Also, look for items in your text fields like "<script language=js>"

We've seen both of these hacks here on...