Written by 
Database queries are a pretty surprisingly powerful tool that can solve seemingly intractable problems. It is a fun coding challenge to do things in SQL. I’ve seen people solve sudokus or do advent of code, or you can build a datalog on SQL with a little metaprogramming (maybe even fully internally). It is also possible […]
Microsoft recently launched a public preview of native vector support for the Azure SQL Database. With this update, the database can now store and process vector embeddings directly within it. Earlier, the support native vector support for the Azure SQL Database was in early adopter preview as the company sees the integration of vector search […]
We are trying to use SQL Server trigger for scaling application and trying to authenticate the SQL DB using Azure Service Principle. But no luck. We are keeping connection string in Kubernetes Secret and trying to use this. but no luck. Getting login failed error like ERROR mssql_scaler Found error pinging mssql: mssql: login error: […]
I am using Flink sql client to commit a job by sql： Flink SQL> create table products ( > id int, > name string, > primary key(id) not enforced > ) with ( > ‘connector’=’oracle-cdc’, > ‘hostname’ = ‘myip’, > ‘port’ = ‘1521’, > ‘username’ = ‘****’, > ‘password’ = ‘*****’, > ‘database-name’ = ‘ORCLCDB’, […]
I’m testing out some new apps and ran into an odd one. Data connects perfectly when apps are running on a classic application pool, but it blows out with ‘Cannot load encryption DLL C:\Program Files\SQL Anywhere 17\bin32\dbrsa17.dll: version mismatch’ if it’s on integrated. This app uses Owen and that throws the toys out if classic […]
submitted by /u/mehdifarsi [comments] Source link
[This is a table structure. Based on the child and parent status want to populate result column. ][ These three records is a one config. If any one of the child or parent has status as compliance then result should be populated as Investigate for entire config or else it should be default. Want to […]
Slack Data Engineering recently underwent data workload migration from AWS EMR 5 (Spark 2/Hive 2 processing engine) to EMR 6 (Spark 3 processing engine). In this blog, we will share our migration journey, challenges, and the performance gains we observed in the process. This blog aims to assist Data Engineers, Data Infrastructure Engineers, and Product […]
A cool standard SQL:2003 feature is the aggregate FILTER clause, which is supported natively by at least these RDBMS: ClickHouse CockroachDB DuckDB Firebird H2 HSQLDB PostgreSQL SQLite Trino YugabyteDB The following aggregate function computes the number of rows per group which satifsy the FILTER clause: SELECT COUNT(*) FILTER (WHERE BOOK.TITLE LIKE ‘A%’), COUNT(*) FILTER (WHERE […]
I’ve blogged about generic ways of getting top 1 or top n per category queries before on this blog. An Oracle specific version in that post used the arcane KEEP syntax: SELECT max(actor_id) KEEP (DENSE_RANK FIRST ORDER BY c DESC, actor_id), max(first_name) KEEP (DENSE_RANK FIRST ORDER BY c DESC, actor_id), max(last_name) KEEP (DENSE_RANK FIRST ORDER […]