Strange Loop is a multi-disciplinary conference that brings together the developers and thinkers building tomorrow’s technology in fields such as emerging languages, alternative databases, concurrency, distributed systems, security, and the web.
About – Strange Loop (thestrangeloop.com)
Strange Loop was created in 2009 by software developer Alex Miller and is now run by a team of St. Louis-based friends and developers under Strange Loop LLC, a for-profit venture.
Some of our guiding principles:
No marketing. Keynotes are never sold to sponsors. The conference mailing lists are never sold or given to sponsors.
Tech, not process. Talks are in general code-heavy, not process-oriented (agile, testing, etc). There are many fine speakers, topics, and conferences in the process area. This is not one of them.
Technology stew. Interesting stuff happens when you get people from different areas in the same room. Strange Loop has a broad range of topics from academia, industry, and a touch of weirdness.
SQL Server: Copying Data From One Table To Another
Insert With Indexes Enabled – Import Abandoned After An Hour
Insert With Indexes Disabled – Import and Index Rebuild Finished After 23 Minutes
Insert With Tab Lock and Indexes Disabled – 21 Minutesyou find details about that: Copying Data From One Table To Another – To Disable Indexes or Not To Disable Indexes, That’s the Question.
Apache Impala vs Presto
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
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:
A python package that gives you easy access to the most valuable datasets of Germany
https://github.com/bundesAPI/deutschland
Auf dem API-Portal des Bundes und hier auf GitHub.com/bundesAPI finden Sie Dokumentationen zu Programmierschnittstellen von Verwaltungsleistungen und Informationsportalen des Bundes. Die Dokumentionen liegen idR. im API-Dokumentationsformat OpenAPI 3 vor und sind insofern sowohl menschen- als auch maschinenlesbar.
Momentan finden sich auf bund.dev bereits Dokumentationen zu mehr als 30 Programmierschnittstellen – wobei die Zahl online verfügbarer und dokumentierbarer Schnittstellen aufgrund des „Gesetzes zur Änderung des E-Government-Gesetzes und zur Einführung des Gesetzes für die Nutzung von Daten des öffentlichen Sektors“ (2. Open-Data-Gesetz) bis 2024 stark anwachsen wird.
https://de.wikipedia.org/wiki/Lilith_Wittmann
SourceGrid
SourceGrid is a free open source grid control. Supports virtual grid, custom cells and editors, advanced formatting options and many others features SourceGrid is a Windows Forms control written entirely in C#, goal is to create a simple but flexible grid to use in all of the cases in which it is necessary to visualize or to change a series of data in a table format. There are a lot of controls of this type available, but often are expensive, difficult to be customize or not compatible with .NET. SourceGrid allows users to have customizable datasource which is not in DataSet format.
Free Controls: https://www.syncfusion.com/products/communitylicense
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