Internals Viewer for SQL Server Managment Studio 2017
Kategorie: Alles andere
Intersystems IRIS \ Docker \ Openflights Dataset
Some links about the topic from title
https://github.com/andreas5588/openflights_dataset
https://community.intersystems.com/post/tips-and-tricks-brand-new-load-data-command
https://hub.docker.com/r/andreasschneiderixdbde/openflights-iris-zeppelin
https://hub.docker.com/r/andreasschneiderixdbde/openflights-iris
https://openexchange.intersystems.com/package/openflights_dataset
https://www.kaggle.com/datasets/sherrytp/airline-delay-analysis/code
The Million Song Dataset Challenge aims at being the best possible offline evaluation of a music recommendation system
https://www.kaggle.com/c/msdchallenge/overview
Do you want to query complex data structures in an iterative way? Do you have access to hierarchical data structures that need to be queried? This course will teach you the tools required to solve these questions. You will learn how to write recursive queries and query hierarchical data structures. To do this, you will use Common Table Expressions (CTE) and the recursion principle on a wide variety of datasets. You will, for example, dig into a flight plan dataset and learn how to find the best and cheapest connection between two airports. After completing this course, you will understand the principle of recursion, and be able to identify and create hierarchical data models.
https://www.datacamp.com/courses/hierarchical-and-recursive-queries-in-sql-server
This article aims at showing good practices on how to retrieve data with SQL using practical examples on the data above. The following topics are covered:
- operations on columns
- most common joins
- aggregations and window functions
- tips to handle complex queries
https://www.mit.edu/~amidi/teaching/data-science-tools/tutorial/queries-with-sql/
Have you ever wondered about the differences between a subquery and a common table expression (CTE) in SQL? The concepts seem very similar, but knowing the difference – and when to use each one – will help you write efficient and readable queries.
MDX Studio
MDX Studio is a tool that was developed by Mosha Pasumansky, a former Analysis Services developer.
https://www.sqlbi.com/tools/mdx-studio/
This tool is invaluable when writing a MDX query: you have a code formatting feature, an embedded system to analyze query performance and many other features for writing MDX queries.
Unfortunately, the source code is not publicly available and the project is currently no longer being updated by Mosha. Other contributors made an effort to keep the tool compatible with newer versions of Analysis Services and client connection libraries.
Hummingbird Exceed
Hummingbird Exceed: http://x11.gweb.info/win/
Martin Fowler – Software Design
Kent Beck is an American software engineer and the creator of extreme programming, an original signer of the Agile Manifesto, and the author of the Extreme Programming book series, and a proponent of Test-Driven Development
https://www.hanselman.com/blog/the-weekly-source-code-33-microsoft-open-source-inside-google-chrome
Developer and Power Users Tool List for Windows
ROBOCOPY
robocopy <source> <target> /MIR /sec /XD "<exclude folder>" /MT /NP /DCOPY:T /COPY:DT /COPY:copyflag[s] :: what to COPY for files (default is /COPY:DAT). (copyflags : D=Data, A=Attributes, T=Timestamps). (S=Security=NTFS ACLs, O=Owner info, U=aUditing info). /DCOPY:T :: COPY Directory Timestamps.
Ultimate Developer and Power Users Tool List for Windows
The History of Development of Norton Commander
Norton Commander for DOS is the original line of Orthodox file managers that exists in five major versions: 1.0, 2.0, 3.0, 4.0 and 5.0. Only the last one has an additional sub-version (nc 5.5). All versions are still used (mostly by DOS enthusiasts) and are often posted on the abandonware sites. […] It was probably one of the most popular file manager of the DOS era, which along with Xtree remains one of the few programs which managed to transcend their DOS roots and Norton Commander descendants (OFM managers) now exist on all popular OSes. The first version of NC (1.0) was designed and written by John Socha in 1984-1989. We provide a short biographical notes about him later in this chapter.
http://www.softpanorama.org/OFM/Paradigm/Ch03/norton_commander.shtml#Timeline
Hi-Eddi – Mein erstes Malprogramm ;-)

Hi-Eddi ist ein sehr bekanntes Zeichen- und Mal-Programm für den hochauflösenden Grafikmodus, das in den Computerzeitschriften 64’er und Happy Computer Mitte der 1980er-Jahre zum Abtippen als Listing des Monats erschien. Im Gegensatz zu den meisten damals käuflichen Programmen, die im Multicolor-Modus arbeiten (mehrere Farben, aber nur halbe Auflösung), ist Hi-Eddi konsequent als Zeichenprogramm mit maximaler Auflösung von 320×200 Punkten konzipiert. Die Farbfähigkeiten sind nur ein „Nebenprodukt“ und deshalb nicht so ausgeprägt.
https://www.c64-wiki.de/wiki/Hi-Eddi
SOFTICE 3.25 FOR WINNT/2000 NUMEGA
SoftICE is a kernel mode debugger for DOS and Windows up to Windows XP. Crucially, it is designed to run underneath Windows such that the operating system is unaware of its presence. Unlike an application debugger, SoftICE is capable of suspending all operations in Windows when instructed. For driver debugging this is critical due to how hardware is accessed and the kernel of the operating system functions.
Details über Numega SoftIce: https://en.wikipedia.org/wiki/SoftICE