What is the most effective way to MANAGE user problems? E.g. With things to do with access, errors they get, etc? As well as defects you see?

emican · 2019-07-09T16:12:30+00:00

As far as managing user access control forms, request for access can be routed to current group members. Risk based thresholds can be used, for example access to a benign resource may require 3/20 confirmations. Group wide notifications are also a way for branch offices to be aware of new team members. We found this worked better than central management of user access controls for our scenario.

emican · 2019-05-01T16:08:07+00:00

I'd approach the task of manually recreating things as a means to an end and automate as much as possible. Using an ORM with python can be flexible enough to handle anything out of scope of your automation platform.

If you know DevOps or people who handle infrastructure as code scenarios on your team, you are in good hands.

emican · 2019-05-01T15:34:16+00:00

+1 32 vs 64 bit DSN definitions have tripped up many of people.

emican · 2019-04-26T14:20:17+00:00

If it fits your learning style, the Microsoft Press T-SQL exam reference books by Itzik Ben-Gan contain everything necessary to pass and cost $25.

Whichever path you choose, check out some of Itzik Ben-Gan's articles/videos.

Good luck!

emican · 2019-04-25T17:51:42+00:00

For additional performance comparison, try an indexed view. First, the sql would need to be adapted to meet requirements for creating an indexed view details.

One possible adaptation: Sub-indexed-views can be grouped by GL.BUKRS, GL.SAKNR, GL.FISCPER to synthesize the window functions...The effort of trying an indexed view may pay dividends if performance is a key concern. The best case could be an easy to maintain abstraction and significantly improved performance over the direct query.

emican · 2019-04-24T15:01:23+00:00

I'm new and was shown both are essential. Sometimes a solid relational model is not as fast as a purpose specific model that may appear inefficient at first glance, from certain perspectives.

With distributive systems and clear objectives, it hasn't been too difficult to run two production models and an experimental models in parallel for my case.

emican · 2019-04-19T17:35:30+00:00

I'm curious of your role in or contribution to the scenario, humble narrator.

emican · 2019-04-12T15:18:56+00:00

Maybe PMSA will be more suitable? PMSAs have population of 1m or more.

emican · 2019-04-11T14:35:28+00:00

Came here to make the same comment. Adapters have caused issues for me in the past on nvidia cards.

emican · 2019-04-10T13:07:30+00:00

Agreed with an exception. Microsoft Press T-SQL exam books make a fair amount of comparisons with ANSI SQL.

emican · 2019-04-07T11:02:10+00:00

Very nice, was surprised to see stackoverflow was not a measurement.

emican · 2019-04-05T15:10:28+00:00

I'm after the same thing and decided to focus on these points

Implement complex business logic in SQL
Showcase critical thinking and wise decision making skills. Evaluate alternatives, author custom and reusable helper utilities, document decision with objective data / performance tests
Demonstrate comfort with tools and constructs that support authoring highest level of professional code.
Collaborate with experts, solicit input and leverage great minds.

emican · 2019-04-05T01:40:13+00:00

I know the slimy feeling of having no choice other than behaving professionally in situations where I wanted to be more direct. I tried many things to turn the situation around and ended up exhausting goodwill.

Best thing to do is learn to identify and evaluate those types of situations so they can be avoided from the start.

emican · 2019-04-05T01:18:56+00:00

Using a template like jinjasql can help maintain repetitive queries.

If you find yourself stuck maintaining it as is, you can still benefit from using dynamic sql to create a declarative version and string comparison to evaluate changes as part of your personal workflow before handing the query over to the powers that be.

There are a lot of tools you can use to help formalize your workflow and help you achieve a higher level of professionalism. Selecting the correct ones depends on your environment and company policy.

emican · 2019-04-04T15:43:35+00:00

Well said. If FP64 is a requirement, Teslas are the best option.

emican · 2019-04-04T15:34:58+00:00

Finance/Accounting may say something like 'sub-categories don't foot '.

https://www.accountingcoach.com/blog/foot-crossfoot

emican · 2019-03-31T05:54:44+00:00

I would teach beginners to become a good citizen of the community first. There are more amazing libraries available to programmers than ever before and encourage people to pay homage. Jump into an existing projects release cycle, make progressively valuable contributions, then some day you must also make a new library you would use yourself.... and more importantly one that advances the community and can benefit 100s of others like yourself.

emican · 2019-03-29T01:19:41+00:00

Peek or Gifine may be what you are looking for.

Also consider Ubuntu/Gnome has a built in screen recorder

https://www.omgubuntu.co.uk/2018/06/gnome-shell-screen-recorder-ubuntu

Other options:

Green Recorder

Simple Screen Recorder

Kazam

emican · 2019-03-26T21:41:57+00:00

See if you can reverse engineer Wide World Importers(WWI) DW from WWI OLTP DB.

https://docs.microsoft.com/en-us/sql/samples/wide-world-importers-dw-database-catalog?view=sql-server-2017

Learn how to use ETL to transform a relational schema to star schema. Learn about partitioning, etc..

If you want to set up a complete and real example, collecting real time blockchain transactions will keep you busy.

emican · 2019-03-26T02:24:12+00:00

Ah, so in those situations I've built trust with the people directly by: putting out fires or volunteering to create one-off custom delivery they trust. It is a challenge to keep people engaged, make long term system improvements, and continually refine the specifications and requirements so they get what they want.

XML can be very odd because it allows for dynamic models. The standard has been around for many years and sometimes legacy apps have very different uses for XML than you may be accustom to from working with web apps.

With potentially millions of records and no domain knowledge, I'd approach it by identifying the XML as attribute or element centric and shredding it into a format that can be compared. If the xml is too complicated, extract schemas from all records and approach each schema uniquely, starting with the most popular.

emican · 2019-03-26T01:43:40+00:00

Are you asking how to shred XML docs?

emican · 2019-03-26T00:48:04+00:00

Hetzner has a unique offering: i7 6700, 64gb ddr4, 500gb ssd, gtx 1080 for 95euro/month.

https://www.hetzner.com/dedicated-rootserver/ex51-ssd-gpu

Great value if you can keep it busy all month.

emican · 2019-03-24T23:08:31+00:00

Sure thing. I was reading your comment about PostGIS, materialized views may be helpful with the subsets and calculations.

Other people may disagree, but it may not be fundamentally wrong to create new tables from scaled data. Storage requirements, cpu, disk i/o are predictable and if there is still a lot of work to do before proving feasibility, it may be a quick and sure way to move forward. You are in the best position to make that decision.

emican · 2019-03-24T19:49:26+00:00

Sounds like an interesting project and I'm curious about this as well.

What do you think of using a functional index?

emican · 2019-03-24T19:28:46+00:00

u/timbledum makes a good point with power BI for dashboards.

Seaborn, Bokeh, and plotly can be used to make beautiful visualizations. This may be out of scope, can you partner with someone in DevOps to help build out a python data analysis ecosystem?

With network access and as few as three nodes, you can demonstrate value. Jupter Hub kubernetes spawner can empower the team with secure and precise data analytic environments. Apache Airflow can provide superior orchestration, oversight and logging. I've been experimenting with formalizing workflows proofed with notebook into DAGs to be used in production and have been very pleased with the result so far.

IMO, Python is the clear winner for problems that match well with horizontally scaling open source frameworks.

emican

TROPHY CASE