Who are these scripts for? You need to troubleshoot performance problems with SQL Server, and you need to do it now. You don't have time to track down a bunch of DMVs, figure out Extended Events, ...
MySQL and PostgreSQL are two of the most used open source SQL databases, and both fulfill the role of a general-purpose database well. How do you choose which one to use for a project? Let's look at ...
sqlite3 is a dynamic module for GNU Emacs 25+ that provides direct access to the core SQLite3 C API from Emacs Lisp. While this module provides only 14 functions (vs 200+ in the C API), it should ...
The table below shows my favorite go-to R packages for data import, wrangling, visualization and analysis — plus a few miscellaneous tasks tossed in. The package names in the table are clickable if ...