|
Dear Bing:
I work in a place where instead of creating conversion programs to convey data from a system with no data integrity to out relational Data Base, they use packages and just some SQLs . . . the plan is now to further improve the constant Bad data issues is to write more SSRS reports and . . . I am in my 50's I have been doing many tasks for many years - where can I go to escape this madness . . . signed - message in a bottle.
|
|
|
|
|
David Scott Longstreth wrote: where can I go to escape this madness
Government? They seem to have no regard for the integrity of data. 
Marc
|
|
|
|
|
Marc Clifton wrote: Government? They seem to have no regard for integrity at all
FTFY
* CALL APOGEE, SAY AARDWOLF
* GCS d--- s-/++ a- C++++ U+++ P- L- E-- W++ N++ o+ K- w+++ O? M-- V? PS+ PE- Y+ PGP t++ 5? X R++ tv-- b+ DI+++ D++ G e++>+++ h--- ++>+++ y+++* Weapons extension: ma- k++ F+2 X
* Never pay more than 20 bucks for a computer game.
* I'm a puny punmaker.
|
|
|
|
|
Quote: Government? They seem to have no regard for integrity at all
FTFY.
|
|
|
|
|
CPallini wrote: Government? They seem to have no integrity at all
FTFY
|
|
|
|
|
Bassam Abdul-Baki wrote: Government? They seem to have no integrity at all
FTFY
* CALL APOGEE, SAY AARDWOLF
* GCS d--- s-/++ a- C++++ U+++ P- L- E-- W++ N++ o+ K- w+++ O? M-- V? PS+ PE- Y+ PGP t++ 5? X R++ tv-- b+ DI+++ D++ G e++>+++ h--- ++>+++ y+++* Weapons extension: ma- k++ F+2 X
* Never pay more than 20 bucks for a computer game.
* I'm a puny punmaker.
|
|
|
|
|
Bassam Abdul-Baki wrote: Government? They seem to have no integrity at all
SSH!
They're listening!
I wanna be a eunuchs developer! Pass me a bread knife!
|
|
|
|
|
Well, for the last five years I've been working on a team that might be similar to yours. We use SSIS to "source" data from all over the enterprise into SQL Server -- from SQL Server, Oracle, Teradata, MySQL, CSV, Excel (ptui), Web Services, whatever. We have one job -- to bring in all the data as exactly as we can. At most we have to detect values that SQL Server can't handle (SQL Server appears to support the narrowest range of date and numeric values  ).
Data integrity and data quality are not our job. Those are dealt with downstream of us and they who are performing that function can't do it unless they see all the data.
I recommend you adopt this separation of concerns before you start down a rabbit hole.
|
|
|
|
|
We're doing something similar. One of the business units have vendor software, but we have access to the database. Since the software only has some user validation, some of the records are considered wrong and they ask us to write reports to validate the data; so they can find the records that are incomplete. The reports can be nasty and take a lot of time, but job security is job security.
|
|
|
|
|
Thank you for the interesting inputs . . . I feel a little better know that there are a variety of similar data changes.
If this is of any interest. I am posting the thread, due to an 'is it just me' - this is not actually and area where I have to deal with.
I support IaM - I am control of the what I pick up for HR ( and students ) that feeds the IM software that modifies AD . . .
As well, I came from a Mainframe background ( over ten years ago ) and there was control over production items which were programs.
As well, when I was a COBOL / SQL contractor I had some conversion jobs, bringing over data after passing thru a program that was a combination of code and SQL. This was always the case.
So now, that I work in an environment, where there are people with different backgrounds, I am not able to explain why you should not use just SQL solutions and do not combine data retrieved with code doing the heavy lifting and then returning the data using SQL in the code.
So that is a glimpse of my background . . . but then again, I was just told today by a server mng. that the MS rep made comments about getting away from Email that I have been making for four yeas, so maybe people just to have to hear these ideas from an outside source.
D.S.L.
|
|
|
|
|
On my desktop, the Community edition, with all the Xamarin stuff - 39GB - in 40 minutes.
Now all I have to do is work out how to get GIT in there...
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
|
|
|
|
|
OriginalGriff wrote: Now all I have to do is work out how to get GIT in there...
Why on Earth would you want to ruin it so fast? 
Anything that is unrelated to elephants is irrelephant
Anonymous
-
The problem with quotes on the internet is that you can never tell if they're genuine
Winston Churchill, 1944
-
I'd just like a chance to prove that money can't make me happy.
Me, all the time
|
|
|
|
|
Hah! 39GB. The install I did last night; 55GB and that didn't select everything for installation.
This space for rent
|
|
|
|
|
Yeah, I didn't install the C++ stuff this time - and of course the first GIT project I open has a small C++ project, so it's now adding that... 
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
|
|
|
|
|
Quote: Yeah, I didn't install the C++ stuff this time
Betrayer!
|
|
|
|
|
I don't seriously use C++ any more - it's easier to do it all in C#, and the performance difference is nowhere near what it was to start with.
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
|
|
|
|
|
So "39GB" = "not bad" nowadays.
I remember decades ago (there goes grampa again with his stories) buying a computer for schoolwork from a small local shop (actually a summer job employer of mine) and insisting I needed a big fat hard drive because Borland C++ was going to use 33MB[*] on its own.
I remember the company owner (my boss at the time) wondering out loud, WTF does a compiler need a whole 33MB for???
[*] Not a typo in my units
|
|
|
|
|
I was thinking of the time it took, really.
I remember installing VB from a huge stack of floppies and it took longer than that...
Most of the 39GB is Xamarin, so it's Android images, their .NET equivalent, and such like.
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
|
|
|
|
|
Hah! young'uns.
I remember using MS FORTRAN on an IMSAI 8080 with 48K RAM from floppies where you had to swap floppies midway through a compilation ( The compiler was on the floppies - as was the FORTRAN source)
An elephant: A mouse built to government specifications. - Lazarus Long
|
|
|
|
|
Tried several time to install AnkhSVN and it installed successfully but doesn't show up in Options? Overall I'm impressed with how quick it went, without Xamarin for me.
Someone's therapist knows all about you!
|
|
|
|
|
And Git is built in, it seems - certainly, connecting to my repo's worked fine.
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
|
|
|
|
|
Yeah I ssw that, guess I'll have to break don and learn git. I've tried a couple of times but after using SVN for so many years it;s like trying to learn to pitch left handed.
Someone's therapist knows all about you!
|
|
|
|
|
I too installed VS2017 yesterday. I remoted into my PC at home and installed it. Checked it later in the day and got "Setup Failed".
There was a View Log link which opened the log in Notepad. The failure was
Package 'CordovaToolset.6.3.1,version=6.3.1.36' failed to install.
Search URL: https:
Impacted workloads
Mobile development with JavaScript (Microsoft.VisualStudio.Workload.WebCrossPlat,version=15.0.26208.0)
Impacted components
Cordova 6.3.1 toolset (Component.CordovaToolset.6.3.1,version=15.0.26208.0)
Log
C:\Users\Kevin\AppData\Local\Temp\dd_setup_20170308084143_431_CordovaToolset.6.3.1.log
Details
Command executed: "c:\windows\syswow64\\windowspowershell\v1.0\powershell.exe" -NoLogo -NoProfile -ExecutionPolicy Unrestricted -InputFormat None -Command "& """C:\ProgramData\Microsoft\VisualStudio\Packages\CordovaToolset.6.3.1,version=6.3.1.36\ToolsetInstall.ps1""" -Version 6.3.1 -InstallationID 07e9da70 -ExtensionFolder """C:\ProgramData\Microsoft\VisualStudio\Packages\CordovaToolset.6.3.1,version=6.3.1.36""" -Operation Install"
Return code: 1
Return code details: Incorrect function.
Only Cordova failed. That's not so bad I guess. It started up OK.
If it's not broken, fix it until it is.
Everything makes sense in someone's mind.
Ya can't fix stupid.
|
|
|
|
|
My wife and I were driving home after a nice non-alcoholic lunch a couple of Sundays ago. There was rain in the air and the brightest rainbow I have ever seen arching across the sky. We came through the village of Stoneleigh and drove across the river bridge. Rather than turn sharp right along the main road, we decided to take the road up the hill in front of us. As I glanced right to make sure it was clear and then started to go up the hill, both my wife and I saw a distinct rainbow against the trees that form the wood on the right hand side of the road. It was projecting vertically down the trunks of the trees with a small but distinct gap between them, and I could see where it hit the ground. I have never seen anything like it before.
|
|
|
|
|
So now you are so rich you don't need to work anymore?
Anything that is unrelated to elephants is irrelephant
Anonymous
-
The problem with quotes on the internet is that you can never tell if they're genuine
Winston Churchill, 1944
-
I'd just like a chance to prove that money can't make me happy.
Me, all the time
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
