Apache Impala vs Presto: What are the differences?
What is Apache Impala? Real-time Query for Hadoop. Impala is a modern, open source, MPP SQL query engine for Apache Hadoop. Impala is shipped by Cloudera, MapR, and Amazon. With Impala, you can query data, whether stored in HDFS or Apache HBase – including SELECT, JOIN, and aggregate functions – in real time.
What is Presto? Distributed SQL Query Engine for Big Data. Presto is an open source distributed SQL query engine for running interactive analytic queries against data sources of all sizes ranging from gigabytes to petabytes.
Apache Impala and Presto belong to „Big Data Tools“ category of the tech stack.
stackshare.io
https://stackshare.io/stackups/impala-vs-presto
Kategorie: Dev
Some links about the good old (and dead?) SSAS Multidimensional Cube
Why doesn’t SSAS cache the entire cube?
Also, if you cube is much larger than the memory available to SSAS, then you would expect to see continual IO, and it is likely to be quite well optimised. However, when you have a 64 bit server with a cube that is larger than 3GB but is comfortably less than the server memory, you might be surprised to see the volume of continual IO.
http://richardlees.blogspot.com/2011/12/why-doesnt-ssas-cache-entire-cube.html
Best Practices for Performance Tuning in SSAS Cubes, you are in right place. Define cascading attribute relationships, for example, day > Month > Quarter > year and define user hierarchies of related attributes (called natural hierarchies) within each dimension as Appropriate for your data
Best Practices for Performance Tuning in SSAS Cubes, you are in right place. Define cascading attribute relationships, for example, day > Month > Quarter > year and define user hierarchies of related attributes (called natural hierarchies) within each dimension as Appropriate for your data
Remove redundant relationships between attributes to assist the query execution engine in generating the appropriate query plan. Attributes need to have either a direct or an indirect relationship to key attributes, not both.
https://mindmajix.com/msbi/best-practices-for-performance-tuning-in-ssas-cube
https://kejserbi.wordpress.com/
https://hub.packtpub.com/query-performance-tuning-microsoft-analysis-services-part-1/
https://github.com/RichieBzzzt/SSASActivityMonitor
https://github.com/ssasdiag/SSASDiag
https://christianb7.wordpress.com/2012/11/11/analysis-services-2012-configuration-settings/
Ez SQL: Query editor for Microsoft SQL Server
https://github.com/GUrbiola/Ez_SQL
Krypton customized version of the .NET Winforms DataGridView (C#) that allows multi-grouping and multi-sorting. Featuring a TreeGrid mode, conditional formatting and additional custom columns. https://github.com/Cocotteseb/Krypton-OutlookGrid
How to check in which language/technology a exe is created?
TrID is an utility designed to identify file types from their binary signatures. While there are similar utilities with hard coded logic, TrID has no fixed rules. Instead, it’s extensible and can be trained to recognize new formats in a fast and automatic way.
https://mark0.net/soft-trid-e.html
Where did we go wrong?
… or Abstraction over Abstraction over…
… or did we need somethinf like Electron?
… or:
node.js and the Heaviest Objects In The Universe :-)
WinForms?! YES -> Because it bloody works :-)
Netter BLOG warum es auch noch im Jahr 2022 noch gute Gründe gibt WinForms zu verwenden! Lesenswert:
Aardvark’d: 12 Weeks with Geeks
Aardvark’d: 12 Weeks with Geeks is a 2005 documentary film about the development of Fog Creek Copilot, a remote assistance software tool. Conceptualization of the film began when Fog Creek Software CEO Joel Spolsky announced on his blog that he was seeking a filmmaker to document the development of the product, then called Project Aardvark.[1][2]
https://en.wikipedia.org/wiki/Aardvark%27d:_12_Weeks_with_Geeks
Hardcore Software by Steven Sinofsky
Hardcore Software is a non-fiction, first-person account of the rise and fall of the PC revolution serialized through this platform, one section at a time, once or twice a week.
https://hardcoresoftware.learningbyshipping.com/archive
Through this first person account of Steven Sinofsky’s time at Microsoft, he aim to convey to you an insider’s story of growing influence and corporate obstacles, the evolution of technology that changed the world, and most of all the people that made it happen.
Check out companion videos and demonstrations of legacy products on the YouTube Channel.
What is it like to work with Microsoft’s Dave Cutler?
Dave is one of the most inspiring people I worked with (not closely, to be clear). Not only did he lead the team that built a new OS from scratch that was still compatible with DOS-based Windows, with many features on day one that took years to arrive in competitor’s products, he personally designed and coded the portable, multithreading, multiprocessor, secure NT kernel. He was brilliant.
https://www.quora.com/What-is-it-like-to-work-with-Microsofts-Dave-Cutler
Ex-Microsoft programmer Dave Plummer: I wrote Task Manager
The Microsoft developer who wrote Task Manager, along with other utilities and games, has popped up to „write this stuff down before I forget it all“.
A post on Reddit goes into detail about the tool, familiar to every Windows expert, which if you are lucky lets you terminate errant applications or processes, as well as providing some handy stats on how your PC is or is not performing.
Dave Plummer, or davepl, „started in MS-DOS in 1993 and spent a little more than a decade at Microsoft, leaving after Server 2003“, he told the University of Regina. He talked about the challenges of „coding for a billion machines“, saying: „It’s like you’re building one bull to be released into an infinite number of china shops.“
https://www.theregister.com/2020/05/26/task_manager_confession/