Good luck next year, Ray.....losing to the way0utwest Cowboys

Bits is great and there was a post on their Facebook page hinting that a contract was sent back today.

I'd guess they'll announce something in the next week

Are you saying you can add data to the partitions that are marked as read-only in the filegroups? It's possible there is a bug here wtih the partitions that doesn't...

roughly a page.

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...