October 10, 2018 at 8:08 am
Steve Jones - SSC Editor - Wednesday, October 10, 2018 7:49 AMJason A. Long - Tuesday, October 9, 2018 10:35 AMThis whole idea of protecting PII is laughable, considering that the government makes it freely available to anyone that wants it...
Look yourself up here and see how many blood vesicles burst...
https://voterrecords.com/I wonder how much of that we consider PII. I've heard Address is PII, but this would indicate that I couldn't be prosecuted for retaining a name and address. Now, I didn't see DoB, or some of the other info I might consider PII myself. Addresses shouldn't be, as they're a known domain of values for any particular area. The ownership or residence is also public record for homeowners, which I find to be problematic and also important.
Less PII and more sensitive data. After all, if you can corollate address with other information, such as an account number or insurance policy, that very well leads to getting PII or becoming PII when it is together with that "other" data, depending on what that other data is and how it represents your uniqueness as an identifiable entity.
October 10, 2018 at 8:14 am
Beatrix Kiddo - Wednesday, October 10, 2018 7:42 AMMy current job is both the best and the worst one I've ever had. I never want to leave but also regularly feel like I need to quit :D.
This is my life.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
October 10, 2018 at 8:18 am
Eirikur Eiriksson - Wednesday, October 10, 2018 7:55 AMIs the challenge still there?
😎
Well, I think the best way to describe the job is "hours and hours of boredom, followed by minutes of sheer howling terror." Just not quite boredom and certainly not terror.
There's challenges, but they tend to be a little here, a little there. Right now my three biggest challenges are getting the backups under my direct control, getting ready for a big audit (unknown when exactly, this is happening,) and getting a SSIS package I created working right.
October 10, 2018 at 8:23 am
jasona.work - Wednesday, October 10, 2018 8:18 AMWell, I think the best way to describe the job is "hours and hours of boredom, followed by minutes of sheer howling terror." Just not quite boredom and certainly not terror.
There's challenges, but they tend to be a little here, a little there. Right now my three biggest challenges are getting the backups under my direct control, getting ready for a big audit (unknown when exactly, this is happening,) and getting a SSIS package I created working right.
I'm not sure I want to know why getting an SSIS package working is considered "minutes of sheer howling terror."
:hehe:
October 10, 2018 at 8:29 am
Sean Lange - Wednesday, October 10, 2018 8:14 AMBeatrix Kiddo - Wednesday, October 10, 2018 7:42 AMMy current job is both the best and the worst one I've ever had. I never want to leave but also regularly feel like I need to quit :D.This is my life.
I'm not alone!
October 10, 2018 at 8:32 am
Brandie Tarvin - Wednesday, October 10, 2018 8:23 AM:Whistling:
jasona.work - Wednesday, October 10, 2018 8:18 AMWell, I think the best way to describe the job is "hours and hours of boredom, followed by minutes of sheer howling terror." Just not quite boredom and certainly not terror.
There's challenges, but they tend to be a little here, a little there. Right now my three biggest challenges are getting the backups under my direct control, getting ready for a big audit (unknown when exactly, this is happening,) and getting a SSIS package I created working right.I'm not sure I want to know why getting an SSIS package working is considered "minutes of sheer howling terror."
:hehe:
"hours of head-banging frustration", perhaps? :Whistling:
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
October 10, 2018 at 8:32 am
Brandie Tarvin - Wednesday, October 10, 2018 8:23 AMjasona.work - Wednesday, October 10, 2018 8:18 AMWell, I think the best way to describe the job is "hours and hours of boredom, followed by minutes of sheer howling terror." Just not quite boredom and certainly not terror.
There's challenges, but they tend to be a little here, a little there. Right now my three biggest challenges are getting the backups under my direct control, getting ready for a big audit (unknown when exactly, this is happening,) and getting a SSIS package I created working right.I'm not sure I want to know why getting an SSIS package working is considered "minutes of sheer howling terror."
:hehe:
:hehe:
It's not, it's just a minor challenge in the grand scheme of things.
If anything, the sheer, howling terror is when I take a minute to think about what my supervisor has said he has as a vision for me in particular, down the road...
Head of a US-wide team of DBAs supporting SQL Server for a lot of sites...
:blink::ermm:
Ah well, if / when that comes to pass, it'll sure push me out of my comfort zone...
(which isn't necessarily a bad thing, really, just a bit frightening)
October 10, 2018 at 8:32 am
I normally wouldn't post this here but I am pretty excited and I think some of the people here may be as well.
I just (finally) finished my first "feature-length" article on my website, SQLServerFast.com: "Anatomy of a spool". It describes the exact internal details of how SQL Server stores worktables when an execution plan uses a Table Spool or Index Spool operator. It also details how I found out, and how I proved that what very limited documentation MS provided on this is actually wrong!
Warning: it is a long read. I have made it available as a 24-page PDF, or you can read it entirely online.
Link: https://sqlserverfast.com/articles/
October 10, 2018 at 8:35 am
jasona.work - Wednesday, October 10, 2018 8:32 AM:hehe:
It's not, it's just a minor challenge in the grand scheme of things.
If anything, the sheer, howling terror is when I take a minute to think about what my supervisor has said he has as a vision for me in particular, down the road...
Head of a US-wide team of DBAs supporting SQL Server for a lot of sites...
:blink::ermm:
Ah well, if / when that comes to pass, it'll sure push me out of my comfort zone...
(which isn't necessarily a bad thing, really, just a bit frightening)
Take it! (Also a good pay rise.)
October 10, 2018 at 8:40 am
Beatrix Kiddo - Wednesday, October 10, 2018 8:35 AMjasona.work - Wednesday, October 10, 2018 8:32 AM:hehe:
It's not, it's just a minor challenge in the grand scheme of things.
If anything, the sheer, howling terror is when I take a minute to think about what my supervisor has said he has as a vision for me in particular, down the road...
Head of a US-wide team of DBAs supporting SQL Server for a lot of sites...
:blink::ermm:
Ah well, if / when that comes to pass, it'll sure push me out of my comfort zone...
(which isn't necessarily a bad thing, really, just a bit frightening)Take it! (Also a good pay rise.)
That would almost certainly be in the cards for said work, although right now I think it's probably still a couple years out. Of course, with how fast some things get done around here, I might be retired before it comes around...
(Think about how fast government gets anything done...)
October 10, 2018 at 9:39 am
I'm really beginning to wonder how long this discussion is going to go on for.
I've given uo asking for the actual query now (I think Grant has too), however, I really wish they would share it; I suspect that it's going to be just a (very) poorly written query (probably filled with NOLOCK and non-SARGable clauses in the WHERE), and fixing it will probably benefit the OP loads.
Of course, they might have really found an odd-ball performance issue. If that's the case, the amount the community could learn from it would be great.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 10, 2018 at 9:48 am
Brandie Tarvin - Wednesday, October 10, 2018 8:08 AMLess PII and more sensitive data. After all, if you can corollate address with other information, such as an account number or insurance policy, that very well leads to getting PII or becoming PII when it is together with that "other" data, depending on what that other data is and how it represents your uniqueness as an identifiable entity.
In my world, a lot of it is considered PII. It's classified as direct or indirect PII. Given enough indirect PII, you can narrow down the identity of a person so it's subject to rules. It's when you get into things like DOB, SSN, last 4 SSN, maiden name, etc. that things can get dicey because those are frequently "security questions" on different sites. Given that some of it is publicly available, it's even worse.
October 10, 2018 at 9:54 am
Thom A - Wednesday, October 10, 2018 9:39 AMI'm really beginning to wonder how long this discussion is going to go on for.I've given uo asking for the actual query now (I think Grant has too), however, I really wish they would share it; I suspect that it's going to be just a (very) poorly written query (probably filled with NOLOCK and non-SARGable clauses in the WHERE), and fixing it will probably benefit the OP loads.
Of course, they might have really found an odd-ball performance issue. If that's the case, the amount the community could learn from it would be great.
WOW!!!! That OP is a hot mess. Jobless and thinking that MS is going to pay him for finding some obscure bug that is only repeatable occasionally, on certain versions and with no details. Why did either you or Grant stick around that disaster so long? They don't want help figuring it out. They want validation of their "bug" so they can hopefully get some reward that doesn't exist. That person is chasing unicorns and you guys are leading them down the path.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
October 10, 2018 at 10:44 am
Sean Lange - Wednesday, October 10, 2018 9:54 AMThom A - Wednesday, October 10, 2018 9:39 AMI'm really beginning to wonder how long this discussion is going to go on for.I've given uo asking for the actual query now (I think Grant has too), however, I really wish they would share it; I suspect that it's going to be just a (very) poorly written query (probably filled with NOLOCK and non-SARGable clauses in the WHERE), and fixing it will probably benefit the OP loads.
Of course, they might have really found an odd-ball performance issue. If that's the case, the amount the community could learn from it would be great.
WOW!!!! That OP is a hot mess. Jobless and thinking that MS is going to pay him for finding some obscure bug that is only repeatable occasionally, on certain versions and with no details. Why did either you or Grant stick around that disaster so long? They don't want help figuring it out. They want validation of their "bug" so they can hopefully get some reward that doesn't exist. That person is chasing unicorns and you guys are leading them down the path.
That hurt to read...
It's a classic "I'm not going to tell you everything you need to know to fix my problem but fix it anyways and for free."
October 10, 2018 at 10:47 am
jasona.work - Wednesday, October 10, 2018 10:44 AMSean Lange - Wednesday, October 10, 2018 9:54 AMThom A - Wednesday, October 10, 2018 9:39 AMI'm really beginning to wonder how long this discussion is going to go on for.I've given uo asking for the actual query now (I think Grant has too), however, I really wish they would share it; I suspect that it's going to be just a (very) poorly written query (probably filled with NOLOCK and non-SARGable clauses in the WHERE), and fixing it will probably benefit the OP loads.
Of course, they might have really found an odd-ball performance issue. If that's the case, the amount the community could learn from it would be great.
WOW!!!! That OP is a hot mess. Jobless and thinking that MS is going to pay him for finding some obscure bug that is only repeatable occasionally, on certain versions and with no details. Why did either you or Grant stick around that disaster so long? They don't want help figuring it out. They want validation of their "bug" so they can hopefully get some reward that doesn't exist. That person is chasing unicorns and you guys are leading them down the path.
That hurt to read...
It's a classic "I'm not going to tell you everything you need to know to fix my problem but fix it anyways and for free."
Don't you mean:
"I'm not going to tell you everything you need to know to fix my problem but fix it anyways and for free, and I expect to get paid for it"
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/
Viewing 15 posts - 62,476 through 62,490 (of 66,000 total)
You must be logged in to reply to this topic. Login to reply