October 5, 2017 at 8:01 am
ZZartin - Thursday, October 5, 2017 7:51 AMguh.... I just had a senior DBA type person ask, after breaking a file extract in prod.What difference does the order of the fields make?
:crying::crying:
So I'm guessing that you don't build import routines which can accept any number of columns, with any datatypes, in any order? Amateur! 🙂
The absence of evidence is not evidence of absence.
Martin Rees
You can lead a horse to water, but a pencil must be lead.
Stan Laurel
October 5, 2017 at 2:28 pm
Phil Parkin - Thursday, October 5, 2017 8:00 AMZZartin - Thursday, October 5, 2017 7:51 AMguh.... I just had a senior DBA type person ask, after breaking a file extract in prod.What difference does the order of the fields make?
:crying::crying:
So I'm guessing that you don't build import routines which can accept any number of columns, with any datatypes, in any order? Amateur! 🙂
To be honest, that's exactly what I do because most data providers are just exactly that... amateurs. For those that have good track records for data consistency, etc, then I'll remove the overhead of doing the full blown hail mary but that's more of a rarity than I care to admit or have happen.
--Jeff Moden
Change is inevitable... Change for the better is not.
October 5, 2017 at 2:30 pm
p.s. Kick the slats off that DBA. (S)he should bloody well know better not to develop in production and that code should be thoroughly tested prior to deployment to production.
--Jeff Moden
Change is inevitable... Change for the better is not.
October 6, 2017 at 2:35 am
ZZartin - Thursday, October 5, 2017 7:51 AMguh.... I just had a senior DBA type person ask, after breaking a file extract in prod.What difference does the order of the fields make?
:crying::crying:
<singing>As someday it may happen that a victim must be found...</singing>
Thomas Rushton
blog: https://thelonedba.wordpress.com
October 6, 2017 at 10:30 am
Jeff Moden - Thursday, October 5, 2017 2:28 PMTo be honest, that's exactly what I do because most data providers are just exactly that... amateurs. For those that have good track records for data consistency, etc, then I'll remove the overhead of doing the full blown hail mary but that's more of a rarity than I care to admit or have happen.
Dun and Bradstreet comes to mind. We'd send out info for matches, and what we got back was rarely formatted the same way.
I would have thought with the line of business they are in, they would have been better.
October 6, 2017 at 12:43 pm
Greg Edwards-268690 - Friday, October 6, 2017 10:30 AMJeff Moden - Thursday, October 5, 2017 2:28 PMTo be honest, that's exactly what I do because most data providers are just exactly that... amateurs. For those that have good track records for data consistency, etc, then I'll remove the overhead of doing the full blown hail mary but that's more of a rarity than I care to admit or have happen.
Dun and Bradstreet comes to mind. We'd send out info for matches, and what we got back was rarely formatted the same way.
I would have thought with the line of business they are in, they would have been better.
When you get paid more for each custom file you build than for just reusing the standard extract, conformity and standardization are not your priority😛
----------------------------------------------------------------------------------
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 9, 2017 at 2:31 am
Greg Edwards-268690 - Friday, October 6, 2017 10:30 AMJeff Moden - Thursday, October 5, 2017 2:28 PMTo be honest, that's exactly what I do because most data providers are just exactly that... amateurs. For those that have good track records for data consistency, etc, then I'll remove the overhead of doing the full blown hail mary but that's more of a rarity than I care to admit or have happen.
Dun and Bradstreet comes to mind. We'd send out info for matches, and what we got back was rarely formatted the same way.
I would have thought with the line of business they are in, they would have been better.
Oh, don't mention D&B. I get flashbacks to the various times I spent working on projects there... And I'm not surprised.
Thomas Rushton
blog: https://thelonedba.wordpress.com
October 10, 2017 at 6:11 am
So came across an article on a new programming language someone's working on. I wonder if it'd be possible to get a "wrapper" for TSQL so we could use it for coding?
http://www.theregister.co.uk/2017/10/09/fetlang_erotic_programming_language/
Imagine the fun of code reviews?
:hehe:
October 10, 2017 at 6:36 am
jasona.work - Tuesday, October 10, 2017 6:11 AMSo came across an article on a new programming language someone's working on. I wonder if it'd be possible to get a "wrapper" for TSQL so we could use it for coding?
http://www.theregister.co.uk/2017/10/09/fetlang_erotic_programming_language/
Imagine the fun of code reviews?
:hehe:
For some reason, that link isn't working. http://www.theregister.co.uk/2017/10/09/fetlang_erotic_programming_language
And yes, it could be quite interesting (I see another quirk of SSC today is that all my text is now a hyperlink... Good!). I dred to think what an "INSERT" statement woudl be. O.o
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 10, 2017 at 8:27 am
This was interesting. CSV Injection: http://georgemauer.net/2017/10/07/csv-injection.html
October 10, 2017 at 8:44 am
Steve Jones - SSC Editor - Tuesday, October 10, 2017 8:27 AMThis was interesting. CSV Injection: http://georgemauer.net/2017/10/07/csv-injection.html
So..... excel is even more terrible than we already knew?
October 10, 2017 at 9:26 am
Perhaps. I think Excel is great in many ways. More, I think the idea of programming as a part of basic applications is a bad idea.
October 10, 2017 at 11:14 am
Steve Jones - SSC Editor - Tuesday, October 10, 2017 8:27 AMThis was interesting. CSV Injection: http://georgemauer.net/2017/10/07/csv-injection.html
Wow! Just ... WOW! Thanks for posting that.
--Jeff Moden
Change is inevitable... Change for the better is not.
October 10, 2017 at 11:45 am
Jeff Moden - Tuesday, October 10, 2017 11:14 AMSteve Jones - SSC Editor - Tuesday, October 10, 2017 8:27 AMThis was interesting. CSV Injection: http://georgemauer.net/2017/10/07/csv-injection.htmlWow! Just ... WOW! Thanks for posting that.
I had a go at this with the calc injection. Excel did warn me, which is good, and I therefore had the option. For it not to happen. I wonder, however, what might happen in different environments. I can imagine Excel 2007 not being as clever.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 10, 2017 at 12:19 pm
Thom A - Tuesday, October 10, 2017 11:45 AMJeff Moden - Tuesday, October 10, 2017 11:14 AMSteve Jones - SSC Editor - Tuesday, October 10, 2017 8:27 AMThis was interesting. CSV Injection: http://georgemauer.net/2017/10/07/csv-injection.htmlWow! Just ... WOW! Thanks for posting that.
I had a go at this with the calc injection. Excel did warn me, which is good, and I therefore had the option. For it not to happen. I wonder, however, what might happen in different environments. I can imagine Excel 2007 not being as clever.
Are people still using Office 2007?
Viewing 15 posts - 60,076 through 60,090 (of 66,738 total)
You must be logged in to reply to this topic. Login to reply