Data Engineering Blog

Genuine News about the Data Ecosystem.
Topics: #dataengineering #bigdata #python #opensource #etl

Tools I Use – Part III

Tools I use part III will focus on increasing your productivity in communication, grammar, deep work or study, little notes and in Google Chrome. Some of the tools you might already know but hopefully not all the features as I try to elaborate on the most helpful once. Without further ado, please enjoy the tools below. Instant language Translation Around you Google Translate - play.google.com and itunes.apple.com As this is an obvious one to translate text, many might not know about the app having on-the-fly translation using your camera.

Tools I Use – Microsoft OneNote – Part II

As promised in part I here is the part II of tools I use and in this part, I will entirely focus on one of my most used and favourite tool called Microsoft OneNote. I use it for almost everything, you may ask “Why?!_ What is the big deal, I can use Microsoft Word, Google Keep, a paper block or anything else, why MS OneNote?_” Yes, that is fully true but you are lacking fundamental structure and essential features that you won’t have in these tools.

Tools I Use

As I’m using a lot of tools on a daily basis which makes my life easier, I’d like to share them with you. Also because lately, I recommending them more regularly to friends and co-workers. Hope you find them useful, please leave a comment if you’re using other cool tools or if you disagree with my opinion. Some tools I got inspired by the author Tim Ferriss and his guests in his popular podcasts.

SSAS Cubes – Dynamic generation of partition

There is no easy way to generate partition for SSAS Cubes by default. So you have to do a SSIS-Package (here is a way you can do it dynamic-cube-partitioning-in-ssas-2008) or write a SQL Script which generates XMLA executables. As shown in the Statement, you can dynamically generate month partitions. The trick is, to create a linked server, that you can execute XMLA statements with relational T-SQL, so i created a Linked Server first.

The more you share the more you get..

Quote by Leonard Nimoy. I’ve experienced the truth of this a long time ago during my apprenticeship, without being aware of it. You probably remember those days when you had to prepare for an exam, but due to time constraints, you couldn’t look up everything in the books. So my friend and I compiled summaries of the most important things. Not surprisingly, these summaries quickly became very popular in class, and more people asked us if we could share it with them.

Migrate from Oracle to Microsoft (Views) – Part III

Continued from Migrate from Oracle to Microsoft (Views) – Part II here part III with the main focus on very interesting topic testing 😉. Testing When I implemented all about 20 views from Oracle to SQL Server, I had to test the performance and not least important, the content of the views if their still contain the same. And how do you do that the easiest way? Measure performance For measuring the performance you simply select alls Views with a SELECT COUNT(*) on both databases.