Latest posts tagged with #SQL on Bluesky
Considero que la función de Tablas Comunes de Expresión en #SQL Server ofrece un enfoque altamente eficiente, especialmente para consultas recursivas, reduciendo significativamente la complejidad del código. No obstante, su lógica sigue siendo un tanto indirecta.
The Sequel: The Database Defender
Can you defend your Microsoft SQL environment to keep it clean and running smoothly?
Game Link: blackcatwhitehatsecurity.com/theGame7.cfm
#CyberSecurity #PowerShell #ColdFusion #AI #Networking #SQL #Cloud #GRC #Gaming #Technology #Python #ZeroTrust
Building Go APIs with Huma, sqlc, and Goose
blainsmith.com/articles/bui...
#GoLang #SQL ##OpenAPI #huma #sqlc #goose #codegen
Get Nth rows – third lowest paid person plus all ties Example SQL query using QUALIFY to do this
Get the Nth row in Oracle #SQL with
OFFSET n-1 FETCH NEXT ROW
To include ties, use
N plus all ties: NTH_VALUE ( ..., n ) OVER ( ORDER BY ... ) = n
N distinct value: DENSE_RANK () OVER ( ORDER BY ... ) = n
QUALIFY in 23.26.0 simplifies the last two; details at blogs.oracle.com/sql/how-to-g...
Space Junk: The Ship
Can you land this piece of space junk safely?
Game Link: blackcatwhitehatsecurity.com/theGame4.cfm
#CyberSecurity #PowerShell #ColdFusion #AI #Networking #SQL #Cloud #GRC #Gaming #Technology #Python #ZeroTrust
The Game: The Container
Possible schematics of the container have been acquired.
Game Link: blackcatwhitehatsecurity.com/theGame.cfm
#CyberSecurity #PowerShell #ColdFusion #AI #Networking #SQL #Cloud #GRC #Gaming #Technology #Python #ZeroTrust
Spatial Data Management with DuckDB: From SQL Basics to Advanced Geospatial Analytics by Qiusheng Wu is the featured book on Leanpub!
Link: leanpub.com/duckdb
#Python #Databases #data #sql #books #science
Programming Joke of the Day: Apr 7, 2026
Check out our app: https://restlesside.com 🚀 #programming #programminghumor #programmingjokes #sql #database
One SQL rewrite, 32x faster: moving NOT EXISTS to query the minority (deleted rows) instead of EXISTS on the majority beats it dramatically. No schema changes needed.
#best-practice #database #pattern #postgresql #reading-list #sql
Congrats to the March Weekly DB Dev Gym winners
1 James Su
2 JeroenR
3 mentzel.iudith
And the winners for Q1:
1 James Su
2 mentzel.iudith
3 Stelios Vlasopoulos
Well done to all who took part
Think you know Oracle #SQL better?
Play at devgym.oracle.com/pls/apex/f?p...
🤓Wrote a short recap of some internal AI demos we ran at @mariadb.bsky.social recently. Mostly #SQL + #Vector search + #RAG patterns.
Repo links are in the post if you want to poke around the code:
👉mariadb.com/resources/blog/we-ran-an...
Get the plan for #SQL in Oracle AI Database with dbms_xplan.display_cursor
But what if you want to get many at once?
@lukaseder.bsky.social demos:
SELECT ...
FROM v$sql s
,TABLE (dbms_xplan.display_cursor ( s.sql_id, s.child_number )) p
WHERE s.sql_text LIKE ...
How are databases tackling the modern challenges of #AI? 🤔
Find out in this Andrew Oram article by exploring vector databases, #SQL with vector support, and more: https://lpi.org/5d6x
#LPI #AI #Vector #Milvus #Qdrant #Weaviate #Vespa #ChromaDB #LanceDB
Fehlermeldung in einem SQL-Client: Die Datentypen text und text sind im equal to-Operator nicht kompatibel. Error shown in a SQL-Client: The data types text and text are incompatible in the equal to operator.
Your DB is screaming for help. Stop trusting user input. 💀
📃 scriptdatainsights.blogspot.com/2026/04/sql-...
🎞️ youtube.com/shorts/oCpmg...
🛒 scriptdatainsights.gumroad.com/l/april-skil...
#CyberSecurity #SoftwareEngineering #SQL #Backend #CodingLife #WebSecurity
Your database is wide open. Here is how to fix it before the hackers do. 💀
📃 scriptdatainsights.blogspot.com/2026/04/sql-...
🎞️ youtube.com/shorts/oCpmg...
🛒 scriptdatainsights.gumroad.com/l/april-skil...
Is "Security by Obscurity" your only plan?
#SQL #CyberSecurity #WebDev #Coding #Infosec
A race car at high speed with a blury background.
https://bit.ly/4f8XUYj SQL Server Performance for Developers
Join the 40k+ people who have learned how to improve #performance of your #SQL #Server #database applications.
#LinkedIn #Learing #IT
GIS AMS Support C2C jobs Juno Beach, FL. Hybrid || Long Term Contract techmirrors.org/job/c2c-reqs...
#c2crequirements #gis #vendorlist #corptocorp #vendorempanelment #sql #h1bvisa @awscloud.bsky.social @purduesociology.bsky.social
Trust: The Trust
She is the one who has Zero Trust. Will she trust again?
Game Link: blackcatwhitehatsecurity.com/theGame12.cfm
#CyberSecurity #PowerShell #ColdFusion #AI #Networking #SQL #Cloud #GRC #Gaming #Technology #Python #ZeroTrust
Chess in Pure SQL
www.dbpro.app/blog/chess-i...
Actually render a chess board. With pieces. That you can move around. In your browser. Using nothing but SELECT, UPDATE, and a bit of creative thinking.
Crazy idea 💡 but super interesting and refreshing in this AI era.
#chess #sql
Scales of Justice: Lady Justice
Lady of Justice, the moral force, fairness, and impartiality of justice.
Game Link: blackcatwhitehatsecurity.com/theGame11.cfm
#CyberSecurity #PowerShell #ColdFusion #AI #Networking #SQL #Cloud #GRC #Gaming #Technology #Python #ZeroTrust
Миграция базы данных в Legacy системах Миграция базы данных в Legacy системах Если ваша система не использует ORM Е...
#postgresql #sql #миграция #данных
Origin | Interest | Match
"[ES] ¿Cuando se hace complejo una consulta SQL?: dando una guía referencial." by Carlos Chicata
#sql #databases #spanish #optimization #lets-talk-about-data
An hourglass sitting on black and brown stones
https://bit.ly/4fenEmc DCAC was able to work with DCI and #performance tune their #SQL #Server application allowing them to improve performance for their customer and saving the company $40k a month.
Contact DCAC to discuss your performance tuning needs. https://dcac.com/contact
Gone Phishing: The Unicorn
The Unicorn is a magical individual that all organizations strive to obtain.
Game Link: blackcatwhitehatsecurity.com/theGame9.cfm
#PotatoSecurity #PowerSmell #ColdFusion #AI #Networking #SQL #Clown #GRC #Gaming #Technology #Python #ZeroTrust
Gone Phishing: The Unicorn
The Unicorn is a magical individual that all organizations strive to obtain.
Game Link: blackcatwhitehatsecurity.com/theGame9.cfm
#CyberSecurity #PowerShell #ColdFusion #AI #Networking #SQL #Cloud #GRC #Gaming #Technology #Python #ZeroTrust
Si el CPU de tu motor #sql o #azuresql esta alto, te cuento en esta guia paso a paso como podes atacarlo triggerdb.com/como-bajar-c...
Heaven: The Angel
Can you help The Angel and defeat The Demon with your Cloud skills?
Game Link: blackcatwhitehatsecurity.com/theGame8.cfm
#CyberSecurity #PowerShell #ColdFusion #AI #Networking #SQL #Cloud #GRC #Gaming #Technology #Python #ZeroTrust
#Development #Launches
Syntaqlite Playground · Parse, format, validate, and tokenize SQLite queries, ilo.im/16by65 by Simon Willison and Lalit Maganti
_____
#Parser #Formatter #Validator #Tokenizer #SQL #SQLite #Databases #Server #WebDev #Backend
Graph traversal queries with SQL/PGQ (23.4) SQL/PGQ added in SQL:2023 ISO standard Create a property graph to define relationship between rows Use GRAPH_TABLE operator to traverse the graph Example CREATE PROPERTY GRAPH statement
Graph traversal queries with SQL/PGQ (23.4) Find everyone friends with Mary example GRAPH_TABLE query
With SQL/PGQ in Oracle AI Database, you can
Create property graphs
Query them with GRAPH_TABLE
This maps tables and rows to vertices and edges in a graph
This enables you to traverse networks of relationships with #SQL
Try it at buff.ly/89FnPaf
