Viewing 15 posts - 226 through 240 (of 267 total)
Hello,
Thanks. Your right about needing enough data to identify an individual. Postcode was just an example column of the columns.
I think always encrypted would give me...
October 18, 2017 at 10:21 am
Hello,
Thanks for the advice. I will take a look at disk encryption as well.
Part of my reason for thinking about column level encryption is that most...
October 18, 2017 at 9:08 am
Hello,
Thanks for your help on this (and on my other numerous questions 🙁 )
I'm also looking at that. I wanted to encrypt the live server data...
October 18, 2017 at 7:37 am
Thanks. That makes sense. I knew I'd missed something but couldn't work out what.
October 17, 2017 at 10:51 am
Hello,
Thank you for your help.
I completely missed the fact that TDE isn't in Standard.
Thanks
October 13, 2017 at 6:52 am
I haven't been using SSMS that long so I can't give a definite answer but I suspect this is an issue with the SSMS install, possibly user permissions or clash...
October 12, 2017 at 10:30 am
Hello,
Thanks, your example made me understand the issue. Logdate can't be referenced in the select (because, as you said, it's being used for the pivot) but I can...
October 11, 2017 at 6:24 am
Hello,
Thanks for your help. I hadn't thought of that.
However if I remove logdate from the select then it runs but there is no pivot. I just...
October 11, 2017 at 4:37 am
ChrisM@Work - Tuesday, October 10, 2017 8:19 AMLeft-pad the single-digit week numbers with '0'?
Thanks. That was the obvious solution I missed...
October 10, 2017 at 8:57 am
You are probably past this point so apologises for stating the obvious but just in case it's relevant:
If you are running the queries from a client it might...
October 4, 2017 at 12:05 pm
Hello,
Sorry, that wasn't intentional. I hadn't seen previous advice to disable SA so hadn't done it. I can see why it makes sense though so I will do...
October 2, 2017 at 2:33 pm
Jeff: Thanks.
Chris: Sorry I didn't see the notification for your post. Thanks, that's the account I thought it would use. Having re-checked the permissions that user doesn't have...
October 2, 2017 at 2:15 pm
Viewing 15 posts - 226 through 240 (of 267 total)