December 15, 2017 at 6:10 am
Luis Cazares - Thursday, December 14, 2017 12:14 PMBrandie Tarvin - Thursday, December 14, 2017 5:48 AMSo this article hits a little close to home (the references to poverty are so true).So how do we (the "Olds") fix this?
My opinion is that you need to make healthcare and higher education affordable again.
I don't understand how college costs are so high and continue to rise, but the quality of graduates keeps decreasing. I studied in private (bilingual) elementary and middle schools, and moved to the public education when starting high school. My college was one of the worst in the city, but I could afford it with a half-time job. I never had to worry about student debt as they do here for 10+ years. However, I prepared myself further than college education and I'm now earning a six figures salary in a foreign country and was even thinking on buying a house after 2 years of being here. I'm also married and under 35.
I can't understand either, how you pay a good amount of money on health insurance and still have to pay more than what you earn in an hour for a 15 minutes appointment with a doctor. One more thing is that people from the US are fanatics of going to the doctor for every minor issue.
It's not that you're not earning enough, is that you're paying an absurd amount of money just to have a decent life.
I agree 100%. In the UK, most health-care costs are covered by the state but one can go for non-state health care to get earlier treatment if there are delays in the state system and you can afford to pay for non-state care - that can cost a lot, and health insurance to cover non-state care also costs a lot. In the state system, people between 16 and 60 years old are required to pay for their medication - the current rate is £8.60 per drug for 8 weeks supply (with the option of insuring against drug costs through a state-provided insurace scheme, paying either £29.10 to cover all drugs prescribed with a 3 month period or £104 for a full year's cover) but don't pay for hospital treatment or medical appoiontments. So mostly people don't worry much about medical costs. BUT that's changing, as the curent government is intent on cutting backon health spending, and has done enough in the last few years to reduce the state hopspitals effectiveness quite a lot: a few years ago a significant proportion of hospitals met the targets for waiting time for routine operations - but this year not a single state hospital in England, Wales, or Northern Island has met the targets. The Scottish hospitals are doing somewhat better solely because the devolved Scottish government has been putting money into them to partly offset the cuts exposed by the UK government. It's also quite clear that the UK government is forcing more cuts on hospitals in Scotland and in teh North of England than it is in the South of England, presumably because the South of England is where they win most of their seats in parliament since there's no valid reason for the distribution of cuts to favor the south.
The state also provides dental care but it's rather expensive, not much cheaper than non-state dental care, and most dentists don't want anything to do with the state system anyway.
Education is pretty much a mess. And a typical student ends up around £50k or £60k in debt after doing a three-year degree (except Scottish students at Scottish universities, who get a much better deal - a large majority of Scots voted for the party that said it would raise income tax levels in Scotland in order to protect students from massive debts and maintain a decent hospital service; voting to keep education costs down was of course natural for the countrymen of Adam Smith, who reckoned that one function of government was to make it inexpensive to do things that would benefit the nation's economy while making it expensive to do things that would be detrimental to the economy). The UK government has recently seen the light and decided to reduce the cost of a university education in England, Wales, and Northern Ireland, I'm not sure when this reduction comes into effect (maybe it already has this academic year).
Tom
December 15, 2017 at 7:18 am
We've been interviewing candidates for a BI/Reporting position. Same things, 30 years of senior level experience and they can't get the system date and time.
But, the astounding thing is that out of 6 candidates we have interviewed, only ONE had any understanding of the upcoming GDPR regulations.
The other 5 had never even heard of it. Wait, you mean to tell me you are an IT professional, and you have never even hears of this???
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
December 15, 2017 at 9:43 am
Michael L John - Friday, December 15, 2017 7:18 AMWe've been interviewing candidates for a BI/Reporting position. Same things, 30 years of senior level experience and they can't get the system date and time.But, the astounding thing is that out of 6 candidates we have interviewed, only ONE had any understanding of the upcoming GDPR regulations.
The other 5 had never even heard of it. Wait, you mean to tell me you are an IT professional, and you have never even hears of this???
I can't say that I'm surprised, can you?
December 15, 2017 at 3:18 pm
Michael L John - Friday, December 15, 2017 7:18 AMWe've been interviewing candidates for a BI/Reporting position. Same things, 30 years of senior level experience and they can't get the system date and time.But, the astounding thing is that out of 6 candidates we have interviewed, only ONE had any understanding of the upcoming GDPR regulations.
The other 5 had never even heard of it. Wait, you mean to tell me you are an IT professional, and you have never even hears of this???
I'm glad I no longer have to find people that are fit to be employed to do real work with computers and data. I retired 8 years and a few months ago, but I still keep up with things like data protection regulations, and keep my eyes open for ny interesting work opportunities, but even now i can say with certainty that if I were working there would be no imaginable way I could contemplate hiring a data professional who didn't have a very clear grasp of the available information about GDPR and its introduction timescale. Especially not someone with 30 years senior level experience. GDPR is quite a big thing, and not conforming will be extremely painful for anyone operating in the EU (or in Britain after it leaves the EU, if it actually does next year).
Incidentally, in the current safe-harbor replacement agreement the US administration has committed itself to enforce EU citizen's rights about data on them held and/or processed in the USA as it would be enforced in the EU if it was held and processed there - so database people on the American side of the Atlantic had better learn about GDPR pretty soon, as the administration will come down on them like a ton of bricks to ensure that a data regulator in an EU country will not find that the agreement is not being honoured and will not deliver a formal decision that European PID cannot be allowed to be held or processed in the USA (or by an American company, even one operating in the EU, if the Supremes decide that MS must give the justice department the Irish data it is asking for, since Irish law - and EU law generally - says that that data can't be handed over unless a court order is issued by the Irish courts as a result of evidence being given that demonstrates that one of the essential exceptions to protection applies - and as the justice department has so such evidence it's not going to get that order from an Irish court).
Unfortunately, none of the intelligence services anywhere in the world can be trusted to pay any attention at all to GDPR, except perhaps to use it to help them hide evidence of them faking intelligence.
Tom
December 15, 2017 at 9:40 pm
Something odd happened: my daily message from expressio.fr described an idiom I recognised as something used (in its English form) in connection with computers a long time ago. The idiom was "un lit de Procruste", so in English "a Procrustean bed". The English idiom led to the concept of "procrustean assignment" in the computing world fairly early on (I first came across some time in the academic year beginning in autumn 1966 when I was a maths research student who occassionally played with computers) and later on that term got into the user manuals for Sinclair computers and into FOLDOC). But this was the first time I ever saw someting with even marginal computing relevance on or from expressio.fr.
SQL uses procrustean assignment for strings - ie it pads to increase the length or truncates to reduce the length when copying into a fixed length string (char(<length>) or nchar(<length>), but it doesn't call it procrustean assignment. Perhaps SQL not using that term is a result of the RDBMS development team at IBM being cut off during the early development of Sequel from the old style grammar school and Oxbridge-educated Brits Codd (IBM management decision) and Date (he was in IBM Europe in the early 70s, so nowhere near the relational database team) and consisting wholely of people with no knowedge of classical myths and the vocabulary that those myths had added to English.
Tom
December 16, 2017 at 6:06 am
Michael L John - Friday, December 15, 2017 7:18 AMBut, the astounding thing is that out of 6 candidates we have interviewed, only ONE had any understanding of the upcoming GDPR regulations.
The other 5 had never even heard of it. Wait, you mean to tell me you are an IT professional, and you have never even hears of this???
Why should they have?
GDPR is rather legal subject, with very little relevnce to technical implementations. It's a company lawer which must understand it, not a report developer.
And - do you have such an understanding yourself?
Can you give a definition for "data subject"?
Is it a EU citizen, as described in one part of the legislation, or a EU resident, as described in another part?
After it's clarified - how can you tell that a customer record in your database contains personal data for such a "data subject"? How do you or your BI developer should know if a record with a dodgy family name belongs to a EU citizen, or to a contractor residing in an EU country for a limited time, or a gastarbeiter from Ukraine on a work permit with no residential rights?
How DBA's in Ali Express suppose to know which personal records in their database belong to citizens of which EU countries? Did you ever submit your citizenship information when buying something online? And even if you did - how a vendor suppose to verify correctness of such information? Get direct access to Intenal Affairs databases of every EU country???
Right-to-be-Forgotten.
What if I want to be forgotten by a Police department?
What about a private investigator database? Their normal operations definitely "require regular and systematic monitoring of data subjects". So, according to GDPR, I must be able to force them to "forget me".
It's also interesting how they plan to enforce this right for the private information of EU citizens collected by FSB (better known as KGB) or CIA?
And if FSB could not be forced to open their data collections for inspections by EU authorities, why Facebook must be any different? Especially - there is no solid proof that the personal records held by Facebook are of actual EU citizens.
_____________
Code for TallyGenerator
December 18, 2017 at 5:27 am
Sergiy - Saturday, December 16, 2017 6:06 AMMichael L John - Friday, December 15, 2017 7:18 AMBut, the astounding thing is that out of 6 candidates we have interviewed, only ONE had any understanding of the upcoming GDPR regulations.
The other 5 had never even heard of it. Wait, you mean to tell me you are an IT professional, and you have never even hears of this???Why should they have?
GDPR is rather legal subject, with very little relevnce to technical implementations. It's a company lawer which must understand it, not a report developer.And - do you have such an understanding yourself?
Can you give a definition for "data subject"?
Is it a EU citizen, as described in one part of the legislation, or a EU resident, as described in another part?
After it's clarified - how can you tell that a customer record in your database contains personal data for such a "data subject"? How do you or your BI developer should know if a record with a dodgy family name belongs to a EU citizen, or to a contractor residing in an EU country for a limited time, or a gastarbeiter from Ukraine on a work permit with no residential rights?
How DBA's in Ali Express suppose to know which personal records in their database belong to citizens of which EU countries? Did you ever submit your citizenship information when buying something online? And even if you did - how a vendor suppose to verify correctness of such information? Get direct access to Intenal Affairs databases of every EU country???Right-to-be-Forgotten.
What if I want to be forgotten by a Police department?
What about a private investigator database? Their normal operations definitely "require regular and systematic monitoring of data subjects". So, according to GDPR, I must be able to force them to "forget me".
It's also interesting how they plan to enforce this right for the private information of EU citizens collected by FSB (better known as KGB) or CIA?
And if FSB could not be forced to open their data collections for inspections by EU authorities, why Facebook must be any different? Especially - there is no solid proof that the personal records held by Facebook are of actual EU citizens.
No matter what country passes whatever regulations, do you honestly think the KGB or CIA is going to open up anything to inspection by anyone? The CIA employees sometimes don't even know what the person in the next office is working on. Do you think any government is going to make an exception for any government?
December 18, 2017 at 6:03 am
Ed Wagner - Monday, December 18, 2017 5:27 AMNo matter what country passes whatever regulations, do you honestly think the KGB or CIA is going to open up anything to inspection by anyone? The CIA employees sometimes don't even know what the person in the next office is working on. Do you think any government is going to make an exception for any government?
I don't think you can find a relevant disclosure stetement in any part of GDPR.
_____________
Code for TallyGenerator
December 18, 2017 at 6:19 am
Michael L John - Friday, December 15, 2017 7:18 AMWe've been interviewing candidates for a BI/Reporting position. Same things, 30 years of senior level experience and they can't get the system date and time.But, the astounding thing is that out of 6 candidates we have interviewed, only ONE had any understanding of the upcoming GDPR regulations.
The other 5 had never even heard of it. Wait, you mean to tell me you are an IT professional, and you have never even hears of this???
That horrifies me, but it doesn't surprise me at all. I've only really been on top of GDPR for the last 6 months. I talk about it a lot and very few people outside of Europe know about it. A shockingly small number of people inside of Europe know about it. I think one or two large organizations are going to get chewed on very thoroughly by the EU for violating this thing.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 18, 2017 at 6:44 am
Michael L John - Friday, December 15, 2017 7:18 AMBut, the astounding thing is that out of 6 candidates we have interviewed, only ONE had any understanding of the upcoming GDPR regulations.
The other 5 had never even heard of it. Wait, you mean to tell me you are an IT professional, and you have never even hears of this???
Why should they have?
GDPR is rather legal subject, with very little relevnce to technical implementations. It's a company lawer which must understand it, not a report developer.
It depends on what function your're applying to, and whow you profile yourself. If you are a junior report writer, you may get away with not knowing this. But if you are a data professional (and I consider every database-related job at medior and higher level to ALSO include being a data professional), then you should be aware. If not to keep your management out of jail, then at least to protect yourself. You do not need all the fine details (that's what legal departments are for), but you should know the general idea of the GDPR.
See article 4, definitions:
‘personal data’ means any information relating to an identified or identifiable natural person (‘data subject’); an identifiable natural person is one who can be identified, directly or indirectly, in particular by reference to an identifier such as a name, an identification number, location data, an online identifier or to one or more factors specific to the physical, physiological, genetic, mental, economic, cultural or social identity of that natural person;
Your question on EU citizen or not is because the scope is declared to be as wide as possible. Article 3, translated in clear text: the GDPR applies to all personal data for companies in the EU, and for companies outside the EU it applies if they offer services or goods in the EU, to the EU citizens. It does not apply to Russian companies doing business with Chineze citizens, or to EU citizens buying things in a US store during their US holiday.
For a EU company, citizenship of the customer is irrelevant.
For a non-EU company, I'd say either use a business model where you will never offer goods or services in the EU (practically, this means no webshop and no EU sales offices), or just comply with the GDPR.
"How DBA's in Ali Express suppose to know which personal records in their database belong to citizens of which EU countries? Did you ever submit your citizenship information when buying something online? And even if you did - how a vendor suppose to verify correctness of such information? Get direct access to Intenal Affairs databases of every EU country???"
(sorry, somehow the interface here breaks when I split the post-quote in too many parts)
Ali Express ships packages to their customers. That means they need a shipment address. Granted, a shipment address in a EU country is not a 100% guarantee of EU citizenship, but it's a pretty damn strong indication. If Ali Express wants to ship to EU countries without having to abide by GDPR, the onus is on them to make sure they only supply to non-EU citizens that happen to be living here. Alternatively, they can simply refuse to ship to the EU. (And don't tell me this is a silly notion, it is not. I've been sitting on an Amazon gift card for years now that I cannot use because everytime I see something that I really want to order, Amazon tells me they are not allowed to ship that specific item to my country. That has nothing to do with EU laws, it is either becuase of USA laws or because of limitations imposed by the manufacturer)
"Right-to-be-Forgotten.
What if I want to be forgotten by a Police department?"
Article 2, point 2.d:
2. This Regulation does not apply to the processing of personal data:
(d) by competent authorities for the purposes of the prevention, investigation, detection or prosecution of criminal offences or the execution of criminal penalties, including the safeguarding against and the prevention of threats to public security.
"private investigators"
They will definitely have to consult their legal advisors. Based on my (limited) understanding of GDPR, this might be agrey are.
"And if FSB could not be forced to open their data collections for inspections by EU authorities, why Facebook must be any different? "
Becasuse Facebook is not a competent authority for the purposes of of the prevention, investigation, detection or prosecution of criminal offences or the execution of criminal penalties, including the safeguarding against and the prevention of threats to public security.
Facebook is a commercial company that tries to make money by offering their services to (also) EU citizens. That means they are subject to EU law.
"there is no solid proof that the personal records held by Facebook are of actual EU citizens."
1. I have a Facebook account (registered to my personal email, so this falls under the definition of identifiable natural person.
2. I am a EU citizen
Based on the two verifiable facts above, the obvious conclusion is that I have now given solid proof that Facebook holds personal recorrds of at least one EU citizen. They will need to follow GDPR.
December 18, 2017 at 6:45 am
(Sorry for the truly messed-up formatting in the previous post. I blame the forum software)
December 18, 2017 at 7:03 am
1. I have a Facebook account (registered to my personal email, so this falls under the definition of identifiable natural person.
2. I am a EU citizen
Based on the two verifiable facts above, the obvious conclusion is that I have now given solid proof that Facebook holds personal recorrds of at least one EU citizen. They will need to follow GDPR.
What course of actions you'd suggest me to take to verify these 2 "verifiable facts"?
_____________
Code for TallyGenerator
December 18, 2017 at 7:18 am
Sergiy - Monday, December 18, 2017 7:03 AM1. I have a Facebook account (registered to my personal email, so this falls under the definition of identifiable natural person.2. I am a EU citizenBased on the two verifiable facts above, the obvious conclusion is that I have now given solid proof that Facebook holds personal recorrds of at least one EU citizen. They will need to follow GDPR.
What course of actions you'd suggest me to take to verify these 2 "verifiable facts"?
Can verify it by going and signing up for a Facebook account
Your asked for your name, email, date of birth. Once done you can add in your current country of residence, hometown etc. All that would constitute a "data subject".
There does seem to be a lot of "grey" in GDPR at the moment and nothing crystal "Black and White" standards while they have provided guidelines it does seem to be open to interpretation and companies will implement it differently. It's not like its PCI-DSS or SoX compliance where there are hard fast rules you have to follow, but I guess this is to come with GDPR.
December 18, 2017 at 7:20 am
Sergiy - Monday, December 18, 2017 7:03 AM1. I have a Facebook account (registered to my personal email, so this falls under the definition of identifiable natural person.2. I am a EU citizenBased on the two verifiable facts above, the obvious conclusion is that I have now given solid proof that Facebook holds personal recorrds of at least one EU citizen. They will need to follow GDPR.
What course of actions you'd suggest me to take to verify these 2 "verifiable facts"?
I'm sure a huge bureaucracy will develop around it to "verify facts" and other activities. From what Hugo posted, it looks like the scope is wide enough to suppose that they really want the law to apply to everyone in the world. After all, I presume at least 1 EU citizen lives outside the EU. The "competent professionals" clause sounds like a legal loophole they'll use to apply the law how the governing body sees fit.
December 18, 2017 at 7:37 am
On a side note is there some particular reason that the EU is doing this? Or is just an overly paranoid idea?
Viewing 15 posts - 60,691 through 60,705 (of 66,749 total)
You must be logged in to reply to this topic. Login to reply