WingNews logo WingNews GitHub [2]

scomp's comments

scomp | 4 years ago | on: What Is Dbt and Why Are Companies Using It?

I recently applied for a job in a data warehousing team that was using this. The way they were using it replace their transformation stage from legacy tools like SSIS,DataStage and Informatica, It was certainly impressive and looked great to work with. I can see dbt becoming a lot more common moving forwards.

scomp | 4 years ago | on: Flu has disappeared worldwide during the Covid pandemic

I had the worst cold of my life in July last year (could of been the flu, it was a struggle to walk from the lounge room to the bedroom), got tested thinking 100% I had COVID (partner was a COVID nurse, seemed likely I would get it). Got a negative result.

scomp | 4 years ago | on: Facebook approves alcohol, vaping and gambling ads targeting 13-17 year olds

When watching TV during a football (Aussie rules football not soccer) game I see probably 15-20 gambling ads and so would the 0-17 year olds watching. There is also an ad with Matthew McConaughey drinking whiskey, although im not sure if that's during prime time or late hours. Never seen a smoking or vaping ad though.

scomp | 5 years ago | on: ClickHouse as an alternative to Elasticsearch for log storage and analysis

I work for a company that uses it as a mission critical product. It provides the search in our SAAS. I'd say it mysteriously fails 3-4 times a year. But no one wants to invest or encourage anyone to look at it proactively or even re-actively. We've had JVM issues and indexers spiral out of control using 99%CPU only to stop at random hours later. It's definitely a product to learn before it fails.

scomp | 6 years ago | on: SQL queries don't start with SELECT

To be honest I don't think the article highlights very well where this applies. I am a SQL Developer with SQL Server right now and in the past using Teradata I vaguely remember an aliased column could be referenced in the where clause if you didn't use the AS keyword.

scomp | 6 years ago | on: Adblocking: How about Nah?

You may not use the CCTV in stores but I can assure you it is using you.

Source: I set up this tracking for a retailer.

scomp | 6 years ago | on: Salesforce is buying Tableau for $15.7B

big expensive Oracle-ish databases

Don't forget Teradata.

I found the same thing with MicroStrategy. I spent a lot of time reverse engineering what I could from MicroStrategy jars to expose additional functions in their plugin interface (which is so incomplete it shouldn't be advertised). But the reality is its 20+ year old system with front end updates, can only put so many band aids on it.

I think the only thing keeping MicroStategy alive is its cube functionality and the businesses who have invested to much into it.

scomp | 6 years ago | on: Show HN: Turn an Excel file into a web application

I don't know if a BI Developer with a web skillset would solve this problem. I worked as a BI Developer and was solely hired because I had mucked around with the COGNOS and its API's and written a few analytics based web apps. The reality was that the rest of the team didn't want to support anything outside COGNOS/MicroStrategy nor did the project managers foresee web apps as a solution to any problem.

scomp | 7 years ago | on: My Salary Progression in Tech

Was it hard to get into a COBOL role? I am interested in moving that way, was driven to Coldfusion under the excitement of working on challenging code. Naturally the next progression is COBOL.

scomp | 7 years ago | on: My Salary Progression in Tech

Sounds sort of inline with me (Melbourne):

2014/2015 - 23 - $50K - $70K | Fraud Analyst using C#/Python/SQL

2016/2017 - 25 - $90K | Teradata/SQL Developer

2018 - 26 - $70K | SQL Developer and Coldfusion/Java

I switched companies in 2018 to be a little closer to home which resulted in a substantial paycut.

I feel your struggle with savings, buying a house in Melbourne is definitely not easy.

I couldn't care less about salary if I could work remote.

scomp | 7 years ago | on: Data science is different now

I think DS has been abused by some people as an umbrella to not produce qualify code, yet they somehow they put themselves in higher regards in the value chain.

Hit the nail on the head here. I worked in an DevOPs/ETL team across from the data science team, all they did was write SELECT * FROM sales and complain Teradata was slow and when they got the result set they'd use "R" to SUM the column and display it with GGPLOT.

page 1
more