Man sollte bei der Nutzung von #SQL-Datenbanken häufiger mal die Struktur überprüfen. Oder auch "Spare minütliche FullTableScans von Tabellen mit Millionen Datensätzen in Produktion mit einem kleinen Index."
Man sollte bei der Nutzung von #SQL-Datenbanken häufiger mal die Struktur überprüfen. Oder auch "Spare minütliche FullTableScans von Tabellen mit Millionen Datensätzen in Produktion mit einem kleinen Index."
Back on tech matters, lately I've been revisiting the Mahalanobis distance.
I had an intention ten years ago to seek an SQL method for deriving it, but it never became pressing enough, and the process using it - via an external call out - was only once once annually.
Returning to the same process ten years later, I've dug a little deeper and found that the callout had only been doing on each separate "variable" - and was thus equivalent to doing each as a simple "z-score".
#SQL #mathstodon
Today I discovered "lnav"or the Log Navigator cli utility. It is a truly awesome log follower and navigator for the terminal which works beautifully with PostgreSQL log files.
#postgres #postgresql #debugging #sql #plpgsql #lnav #logs #logging #rdbms #system #administration
Getting MySQL Error 1175 when trying to update or delete? That’s Safe Update Mode kicking in. Learn how to disable it safely and run your queries smoothly.
Read the full guide: https://www.izoate.com/blog/how-to-fix-mysql-error-1175-disable-safe-update-mode-mysql/
Can we standardize on a #query language for #observability?
It's probably going to end up with good-old #SQL
I shared my notes from last week's #KubeCon EU talk about the #CNCF 's working group that looks into observability query language standardization.
https://www.linkedin.com/feed/update/urn:li:activity:7315987238012518401/
【Databricks】Iceberg REST catalogを利用してPyIcebergでアクセスしてみた
https://dev.classmethod.jp/articles/databricks-iceberg-rest-catalog-pyiceberg/
Options between 5 and 7 seems like to lack a left bracket or a function!
SQuizL 10-APR-25
3/6 guesses
498 seconds
https://bit.ly/SQuizL-game
#SQuizL #SQL
️ Connect Azure SQL Server Using Managed Identity in ASP.NET
Question, my colleague want's a small database with only a few tables ( #Mariadb / #mysql #sql ) - Data pushed with PowerShell Scripts
He also wants a small Web UI to search in this database with "basic" filtering
I've found #Adminer (https://www.adminer.org/de/) which looks simpler then things like phpMyAdmin
Is this a good choice ? thx
DatabricksでS3に外部テーブルとして作成したDeltaテーブルにローカル環境のPythonからアクセスしてみた
https://dev.classmethod.jp/articles/databricks-s3-delta-python/
Esta es la lista con los capítulos del tutorial de #PostgreSQL y el lenguaje #SQL:
https://www.youtube.com/watch?v=8_HFyjcUt6Q&list=PLtdeXn2f7ZbNOTrW0POHNuoNbgpc-Qo-6.
Suscríbete a mi canal.
#bbdd #SiguemeYTeSigo #Followback
Nota: imagen generada con IA generativa.
Advanced Detection and Prevention of #SQL Injection Attacks Using Machine Learning Techniques for Enhanced Web Security ,#pdf ,#free
https://www.researchgate.net/publication/387123538_Advanced_Detection_and_Prevention_of_SQL_Injection_Attacks_Using_Machine_Learning_Techniques_for_Enhanced_Web_Security
SCCM - Create a device collection based on Exchange Server role | https://techygeekshome.info/sccm-create-a-device-collection-based-on-exchange-server-role/?fsp_sid=17464 | #Exchange #Guide #Microsoft #Query #SCCM #SQL
https://techygeekshome.info/sccm-create-a-device-collection-based-on-exchange-server-role/?fsp_sid=17464
SCCM - Create a device collection based on Exchange Server role | https://techygeekshome.info/sccm-create-a-device-collection-based-on-exchange-server-role/?fsp_sid=17463 | #Exchange #Guide #Microsoft #Query #SCCM #SQL
https://techygeekshome.info/sccm-create-a-device-collection-based-on-exchange-server-role/?fsp_sid=17463
Impressive.
SQuizL 09-APR-25
2/6 guesses
102 seconds
https://bit.ly/SQuizL-game
#SQuizL #SQL
Migrate a System Center Orchestrator database to a different SQL Server | https://techygeekshome.info/how-to-migrate-the-database-to-a-different-sql-server/?fsp_sid=17407 | #Guide #Microsoft #SCORCH #SQL
https://techygeekshome.info/how-to-migrate-the-database-to-a-different-sql-server/?fsp_sid=17407