thedonkeycentrehalf
Retired
- Jul 7, 2003
- 8,625
Whitbreads own Costa - not Wetherspoons.
Got something to say or just want fewer pesky ads? Join us... 😊
[Finance] Thread for IT geeks and club administrators
- Thread starter Publius Ovidius
- Start date
Whitbreads own Costa - not Wetherspoons.
Publius Ovidius
Well-known member
- Thread starter
- #22
They can 'opt out' in that way for customer data but they'll still need to conform for their employee data ( and that of potential [CVs] or ex-employees [Personnel Records] ).
And their CCTV data....
BBassic
I changed this.
- Jul 28, 2011
- 12,319
Brent Ozar did a really good write up, from a SQL Server perspective, on how easy it is for PII to be spread around:
https://www.brentozar.com/archive/2017/12/personally-identifiable-information-gets-around/
Worth a read if you're interested in that side of it. I'm a SQL guy myself and I was surprised at some of the stuff he pointed out.
https://www.brentozar.com/archive/2017/12/personally-identifiable-information-gets-around/
Worth a read if you're interested in that side of it. I'm a SQL guy myself and I was surprised at some of the stuff he pointed out.
maffew
Well-known member
I
I've met Brent and contributed a snippet on sp_blitz (which is my first and easiest port of call when auditing a server)
BBassic
I changed this.
- Jul 28, 2011
- 12,319
Oh excellent. I've used sp_blitz on many occasions myself. Not had the chance to meet Brent but their 6 month DBA training plan is a resource I constantly go back to.
maffew
Well-known member
Met him at PASS and SQLBits top team there (DR and HA leaders IMO) 2nd only for different reasons to Paul Randalls mob at SQLSkills, **** me a more clever guy you will never meet. I wanna go on SQLCruise for training
BBassic
I changed this.
- Jul 28, 2011
- 12,319
Would love to do SQLCruise at least once. No way I can afford it though and I highly doubt my firm will cover it either
maffew
Well-known member
OT what versions (I assume SQL server) are you still running, finding it hard to keep up with the new lifecycle and a bit fruitless
maffew
Well-known member
Would love to do SQLCruise at least once. No way I can afford it though and I highly doubt my firm will cover it either
Thing is its actually relatively cheap for a training program, just companies see it as a skive/free holiday a bit like working from home for some
BBassic
I changed this.
- Jul 28, 2011
- 12,319
We've got some 2008 R2 boxes knocking around but majority are 2012 / 2014.
Sure appreciate that, but they HAVE to deal with that info. Given how valuable marketing data is (say - £200 per customer) I find it interesting that retailer would decide to give up on dealing with those details, maintaining a mailing list etc.
maffew
Well-known member
2008R2 is my favourite lol. Last year I was still administering/programming some SQL 7 and SQL2k boxes on NT4 and W2003, mostly cos of legacy DTS packages that I could be arsed to migrate to SSIS
BBassic
I changed this.
- Jul 28, 2011
- 12,319
I'm still reasonably new to the game; cut my teeth on 2012. Whippersnapper!
maffew
Well-known member
JCL ha. been on it since 99, weirdly had to get into MySQL the last coupla years which I enjoy far less (the programming side is not disimilair but I dont like the admin side, old dog new tricks and all that)