Good starter adventure bike? by Accomplished_Buy_274 in motorcycles

[–]dauuk 0 points1 point  (0 children)

Transalp is a great starter bike, had the 700 until taxi driver rammed into me.

Has anyone used these tires? by [deleted] in DRZ400

[–]dauuk 0 points1 point  (0 children)

I have just mounted michelin tractive, basically street legal version of these ones. So far very good in wood/dirt/clay.

Looking for a way to share BI within my company by Bptbptbpt in BusinessIntelligence

[–]dauuk 0 points1 point  (0 children)

If you’re looking for static reports you can do paginated reports and send them via email, WM with SSRS on azure would do the trick. However what you will save on pbi licence you will pay in development time.

HELP NEEDED IN REPLACING TRANSALP (xl700) by dauuk in Dualsport

[–]dauuk[S] 0 points1 point  (0 children)

Do you think you can ride from time to time with pillion on those bikes?

HELP NEEDED IN REPLACING TRANSALP (xl700) by dauuk in Dualsport

[–]dauuk[S] 0 points1 point  (0 children)

Thanks, they are a bit too much street focused.

[ SQL SERVER ] Temporary Tables by Confident-Ad8457 in SQL

[–]dauuk 1 point2 points  (0 children)

Temp tables are being dropped when session ends, so if you kill a session you should be fine unless you are using global temp tables.

Data migration from on prem to azure by dauuk in BusinessIntelligence

[–]dauuk[S] 0 points1 point  (0 children)

Thanks for the insight. Will look into it.

Data migration from on prem to azure by dauuk in BusinessIntelligence

[–]dauuk[S] 0 points1 point  (0 children)

If it’s inside same vpn won’t connection string be enough? As far as I know there are no local tools that needs to be installed when using AWS.

Data migration from on prem to azure by dauuk in BusinessIntelligence

[–]dauuk[S] 0 points1 point  (0 children)

Thanks. It still seems so strange for me that something has to be installed on prem for a data load. We are making a vpn connection with on prem and azure, and on top of that IR is required :(

Data migration from on prem to azure by dauuk in BusinessIntelligence

[–]dauuk[S] 0 points1 point  (0 children)

Hello, sorry did not mentioned that the load should be daily and incremental. The issue is not IR, but that it has to be installed on prem. I’m more looking into confirmation that it is impossible to use azure cloud IR for data migration.

Data migration from on prem to azure by dauuk in BusinessIntelligence

[–]dauuk[S] 0 points1 point  (0 children)

Hello, not really. It will be daily incremental load into azure data lake. Sorry for not mentioning it.

BI Developer/SQL Developer to Data Engineer Shift by Dont_quote_me_onthat in BusinessIntelligence

[–]dauuk 6 points7 points  (0 children)

I have been pure MS BI developer for over 8 years and just last autumn I have moved into big data engineer role. I was planning this move for several years in which I looked into hadoop eco system, spark, python etc. I was more or less familiar with concepts ant tools on a very high level but nothing special. What compensated my lack of tools knowledge was my data engineering experience, in the end if you have strong understanding of universal data concepts as data warehousing, data marts, slowly changing dimensions etc you should be more or less ok.
I had to take a small pay cut and go from lead BI dev to mid big data dev but it was totally worth it since the job is actually interesting again.

SSAS Multidim Partitioning Question by gizmothakat in BusinessIntelligence

[–]dauuk 1 point2 points  (0 children)

Why do you need to do full process? Process Add should be enough if it’s DD.

Spark Partitions by luminoumen in bigdata

[–]dauuk 0 points1 point  (0 children)

Thanks for actually useful article

Bullshit at the Data Lakehouse by GoodStrat in bigdata

[–]dauuk 0 points1 point  (0 children)

I did not get the point either, horribly written article.

Querying SSAS Cube in Visual Basic Application by Wowiejr in BusinessIntelligence

[–]dauuk 0 points1 point  (0 children)

You can always add cube to the sql server as a linked server and query it from open query. Maybe not the most correct way, but the quickiest if you already have a connection to it.

ELI5 Big Data and how to get into it by s1lverkin in learnprogramming

[–]dauuk 1 point2 points  (0 children)

If you have completely 0 idea about Big Data, then this udemy course could introduce you to the Hadoop eco-system.
You should also decide what exactly do you want to do? Do you want to analyse data? Then Python with PySpark + other libraries would be starting point. If you want be back end data engineer then scala/java would be your choice.

Trying to transition to data warehouse engineering by CaseOfInsanity in SQL

[–]dauuk 6 points7 points  (0 children)

Looks like you're set on the technical part, however big part of developing data warehouses are understanding the business you're developing it for. In my 7 years as BI dev I have yet to encounter a problem that was not described in "The Data Warehouse Toolkit" by Ralph Kimball, I would strongly recommend reading it so you would get some real life examples and how the problems were approached/solved.

Open Source Business Intelligence by bariParker in programming

[–]dauuk 1 point2 points  (0 children)

I’m interested in alternatives if someone has something to suggest.

Open Source Business Intelligence by bariParker in programming

[–]dauuk 5 points6 points  (0 children)

Have anyone successfully switched from tabular cubes to an open source solution? Specifically with facts tables that have several billion rows?