Latest posts tagged with #Sql on Bluesky
An image showing a computer screen displaying SQL queries related to device make, model, and architecture. The screen should have an open SQL editor with queries like 'SELECT make, model, arc
SQL Queries for Make, Model and Architectures of Devices | #Guide #SystemCenter #SQL #SQLQuery #Database #DataEngineering #DeviceManagement
Scales of Justice
You are the Lady of Justice and you must keep the Serpent from rising up and corrupting your Python code-base.
Game Link: blackcatwhitehatsecurity.com/theGame11.cfm
#CyberSecurity #PowerShell #ColdFusion #AI #Networking #SQL #Cloud #GRC #Gaming #Technology #Python #ZeroTrust
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
