October 26, 2018 at 7:23 am
ChrisM@Work - Friday, October 26, 2018 7:13 AMLet's not beat about the bush Eirikur..."Try to use the right f..g tool for the job"!
Heh, SSIS and ADF can be the right tools if the developers do NOT have access to a graphical design interface and all the packet and pipeline generation is automated using configurations and metadata.
😎
Manually maintaining the stuff is the real killer.
October 26, 2018 at 7:46 am
Eirikur Eiriksson - Friday, October 26, 2018 7:23 AMHeh, SSIS and ADF can be the right tools if the developers do NOT have access to a graphical design interface and all the packet and pipeline generation is automated using configurations and metadata.
😎
Manually maintaining the stuff is the real killer.
I gave up trouble shooting a problem with one of our SSIS packages awhile ago. It connects to a Samba share and loads a file from there.used to work one day but then, suddenly, when running through the Agent with the package deployed through SSISDB the load fails on every folder apart from one; stating it does not have access to edit the file. If I run the package locally in SSDT, as the SQL Agent Service account, it runs fine. If I change the process so that simply tells me what files are in the folder, but not do anything with said files, doesn't enter the for each loop, as apparently there are no files to iterate on. Removing the "Do this" node within the for each changes the behaviour of what files it can see?! ARGH!
I just run it the package a month through SSDT now; I sometime forget, but I wasted too much time on trying to get it to work.
OH, and don't get me started on the fact that when i run a package in SSDT, it has to load EVERY package in the project, and then tries to run one which requires parameters that haven't been completed...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 26, 2018 at 8:10 am
Eirikur Eiriksson - Friday, October 26, 2018 7:23 AMHeh, SSIS and ADF can be the right tools if the developers do NOT have access to a graphical design interface and all the packet and pipeline generation is automated using configurations and metadata.
😎
Manually maintaining the stuff is the real killer.
I'd argue the main problem is the MS developers don't build the CLI/API side first. That makes it hard, especially for the BI stuff.
At Redgate, we've realized this over the last couple years and new stuff is all API based first, for CLI/REST access. Not quite enough CLI for me, but it's getting better.
October 26, 2018 at 8:48 am
Steve Jones - SSC Editor - Friday, October 26, 2018 8:10 AMI'd argue the main problem is the MS developers don't build the CLI/API side first. That makes it hard, especially for the BI stuff.At Redgate, we've realized this over the last couple years and new stuff is all API based first, for CLI/REST access. Not quite enough CLI for me, but it's getting better.
I'm definitely an advocate of CLI. It's truly amazing what you can do without a human operator.
--Jeff Moden
Change is inevitable... Change for the better is not.
October 26, 2018 at 8:54 am
October 26, 2018 at 11:36 am
Eirikur Eiriksson - Friday, October 26, 2018 8:54 AMAs Alexander Pope said, "To err is human", ergo, remove the human😉
😎
I like that..
But not all of us.
We need to keep the ones that facilitate getting rid of the human.
<hr noshade size=1 width=250 color=#BBC8E5> Regards,Jeffery Williams http://www.linkedin.com/in/jwilliamsoh
October 26, 2018 at 12:54 pm
Eirikur Eiriksson - Friday, October 26, 2018 8:54 AMAs Alexander Pope said, "To err is human", ergo, remove the human😉
😎
Ehrlich said: "To err is human, but to really foul things up requires a computer."
Thomas Rushton
blog: https://thelonedba.wordpress.com
October 26, 2018 at 1:16 pm
ThomasRushton - Friday, October 26, 2018 12:54 PMEirikur Eiriksson - Friday, October 26, 2018 8:54 AMAs Alexander Pope said, "To err is human", ergo, remove the human😉
😎Ehrlich said: "To err is human, but to really foul things up requires a computer."
To err is human... to blame it on someone else is even more human.
+--------------------------------------------------------------------------------------+
Check out my blog at https://pianorayk.wordpress.com/
October 26, 2018 at 1:43 pm
ThomasRushton - Friday, October 26, 2018 12:54 PMEhrlich said: "To err is human, but to really foul things up requires a computer."
So a human is still at fault as a human told the computer what to do.
October 26, 2018 at 7:52 pm
jasona.work - Thursday, October 25, 2018 12:15 PMI may have to go burn down our local news radio station...
During the lead-in to a story they've been talking about all day, they keep playing "It's beginning to look a lot like Christmas"IT'S TOO EARLY!
I don't CARE that the state capitol is getting their XMas tree today!
We haven't even reached Halloween yet!!!
/me goes into a dark corner and curls up sucking my thumb and whimpering
You know, Halloween is the same thing as Christmas.
Here is the mathematical proof:
31OCT = 25DEC
_____________
Code for TallyGenerator
October 27, 2018 at 12:31 pm
Sergiy - Friday, October 26, 2018 7:52 PMjasona.work - Thursday, October 25, 2018 12:15 PMI may have to go burn down our local news radio station...
During the lead-in to a story they've been talking about all day, they keep playing "It's beginning to look a lot like Christmas"IT'S TOO EARLY!
I don't CARE that the state capitol is getting their XMas tree today!
We haven't even reached Halloween yet!!!
/me goes into a dark corner and curls up sucking my thumb and whimperingYou know, Halloween is the same thing as Christmas.
Here is the mathematical proof:
31OCT = 25DEC
😛
--Jeff Moden
Change is inevitable... Change for the better is not.
October 29, 2018 at 5:51 am
I think some people are really over interpreting GDPR: Europe’s privacy laws are now so tough, they are taking names off doorbells in Vienna.
Maybe Steve will soon enforce all of us to use pseudonyms on these forums instead, for want of "compliance". :hehe:
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 29, 2018 at 6:33 am
Sergiy - Friday, October 26, 2018 7:52 PMjasona.work - Thursday, October 25, 2018 12:15 PMI may have to go burn down our local news radio station...
During the lead-in to a story they've been talking about all day, they keep playing "It's beginning to look a lot like Christmas"IT'S TOO EARLY!
I don't CARE that the state capitol is getting their XMas tree today!
We haven't even reached Halloween yet!!!
/me goes into a dark corner and curls up sucking my thumb and whimperingYou know, Halloween is the same thing as Christmas.
Here is the mathematical proof:
31OCT = 25DEC
Nice. I've not seen that before, but it's true.
October 29, 2018 at 9:18 am
Ed Wagner - Monday, October 29, 2018 6:33 AMSergiy - Friday, October 26, 2018 7:52 PMjasona.work - Thursday, October 25, 2018 12:15 PMI may have to go burn down our local news radio station...
During the lead-in to a story they've been talking about all day, they keep playing "It's beginning to look a lot like Christmas"IT'S TOO EARLY!
I don't CARE that the state capitol is getting their XMas tree today!
We haven't even reached Halloween yet!!!
/me goes into a dark corner and curls up sucking my thumb and whimperingYou know, Halloween is the same thing as Christmas.
Here is the mathematical proof:
31OCT = 25DECNice. I've not seen that before, but it's true.
A bit-wise funny isn't it?
😎
October 29, 2018 at 4:32 pm
Thom A - Monday, October 29, 2018 5:51 AMI think some people are really over interpreting GDPR: Europe’s privacy laws are now so tough, they are taking names off doorbells in Vienna.Maybe Steve will soon enforce all of us to use pseudonyms on these forums instead, for want of "compliance". :hehe:
Whether someone's name is on the doorbell ought to be according to that someone's preference (assuming it's their doorbell).
The real problem that we are getting with GDPR is that a lot of people to think they've found a way around it, they just produce a pricvacy policy that begins with sweet-sounding guff and ends with providing people with a three way choice:-
(i) accept that we can do whatever we like whatever we like with whatever of your personally identifiable data we can get hold of.
(ii) don't allow us to store any of your personally identifiable data (which means you can't use our website).
(iii) wade through 1764 densely packed pages of incomprehensible gobbledegook with at least a a dozen pairs of tickboxes on each page without any way of indicating your choices so far to us except by having ticked exactly one out of each of the 25000 tickbox pairs and clicking the accept button, while the website reserves the power to change the gobbledegook and inform you that it has changed, at which point your 25000 answers are discarded and you have to choose again from the original three-way choice with a new variant of teh gobbledegook.
When people can get away with crap like that the pronblem is clearly that GDPR is not sufficiently forceful to give us any privacy or any protection from doing us harm by misusing out personal data.
If you ask where 1764 came from, my answer is: don't blame those websites for choosing that number, you can either blame Douglas Adams - if he'd picked 110 instead of 42 none of those personal information abusers would have thought of squaring it (because 110 is alread big enough) - or blame American revolutionary history: in 1764 the English-dominated British parliment passed the sugar Act and the Currency Act, resulting in the Masachusets cry of "no taxation without representation" and most of the American colonies adopting the non-importation policy (aka trade-war with Britain) before the end of the year.
Tom
Viewing 15 posts - 62,776 through 62,790 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply