Well Well Well
#programming #database #sql #Deletequery #Productionbugs
https://programmerhumor.io/database-memes/well-well-well-jf1s
@programmerhumor-io.bsky.social
@programmerhumor-io.bsky.social
@rwale.bsky.socialDESC does not mean “best” only highest to lowest.
ORDER BY Total_Score DESC puts the largest values first; ASC does the reverse. Confirm whether a higher value is desirable before ranking results.
Sorting is easy. Interpreting the order is the real work.
#SQL
@dcac.comhttps://bit.ly/3ZGmifd SQL Server: Security for Developers
Join the 9k+ people who have learned how to better #secure their #databases in #SQL #Server.
#LinkedIn #Learing #IT
@cheerchain.bsky.social
@rajeshdataai.bsky.social
@rpgpgm.bsky.socialTuesday, November 11, 6:30 PM CT, we welcome Simon Hutchinson (@RPGPGM) for 2 presentations:
- Designing your own commands
- Using #SQL triggers to track file changes on #IBMi
Register➡️ ctxiug.blogspot.com/2026/10/nove...
@dcac.comhttps://bit.ly/3P4g5E1 RealtyTrac's DB server needed upgrading and #HA. They used the beta of SQL 2016; making them the 2nd company in the world running SQL 2016, giving them the HA and performance that they needed.
Contact DCAC to discuss your #SQL Server upgrade needs https://dcac.com/contact
@sqldaily.bsky.socialOracle AI Database has added a huge number of #SQL and developer features over the past ~2.5 years
Together these have
Simplified SQL
Added AI capabilities
Improved performance & security
Given more data modelling options
Stay tuned for more in the upcoming Oct patch & beyond
![Oracle AI Database 26ai Launch SQL Features
SQL
SELECT without FROM
UPDATE & DELETE direct joins
GROUP BY alias or position
Table value constructor
Better RETURNING clause
FLOOR, CEIL, & ROUND dates
Interval SUM and AVG
PHONIC_ENCODE
FUZZY_MATCH
Seamless concatenations
FETCH top-N rows per group
FETCH APPROXIMATE
Data model & PL/SQL
IF [NOT] EXISTS
BOOLEAN data type
Schema annotations
Data use case domains
Enum domains
Staging tables
Max table columns 4096
Hybrid AUTOLIST & INTERVAL
Update default on null
Extended CASE in PL/SQL
Automatic SQL transpiler
Multi-model
SQL/PGQ graph queries
VECTOR search SQL
VECTOR indexes
VECTOR distance function
JSON-relational duality views
JSON PRECHECK constraints
JSON_TRANSFORM updates
JSON and XML improvements
JSON <> PL/SQL arrays
JavaScript stored procedures
DBMS_SEARCH across tables
Blockchain & immutable table updates
Ops, security, speed
Query tables after parallel DML
Lock-free reservations
Query rewrite for JOINs in MVs
Concurrent](https://cdn.bsky.app/img/feed_fullsize/plain/did:plc:blmnab373idbogizdn742doc/bafkreifsxvnxx3klnvk3uah5lzccvogl57ioh6bpm7bkdsdr5c6yeerf34@png)
![Oracle AI Database 26ai RUs SQL Features
23.5
TIME_AT_DBTIMEZONE
JSON collection tables
JSON_ID operator
23.6
Sessionless transactions
Hybrid VECTOR index
23.7
TIME_BUCKET
Materialized columns
DBMS_DEVELOPER
JavaScript call PL/SQL
23.8
Dynamic statistics for PL/SQL functions
JSON type modifier
23.9
Non-positional INSERT
GROUP BY ALL
UUID functions
23.26.0
QUALIFY clause
GRAPHQL table function
RESETTABLE PL/SQL
23.26.1
Assertions
DATE/TIMESTAMPDIFF
Calendar functions
PARTITION BY expr
FILTER aggregate & window fns
23.26.2
JOIN TO ONE
Nested WITH clause
DML [NO]WAIT clause
Deep Data Security
Alter table to IMMUTABLE
23.26.3
DATEADD
23.26.4
More to come…
Stay tuned!](https://cdn.bsky.app/img/feed_fullsize/plain/did:plc:blmnab373idbogizdn742doc/bafkreicpzpn5sbslkuhzkwu3cdu3ycyowhggr6wlxysmqm4tlo7cww6qra@png)
@hollandnumerics.bsky.socialAltair SLC 2026 series: Summary post #5
Altair SLC 2026 series: Summary post #5 #AltairSLC #ClinicalResearch #CDISC #ADaM #StatisticalProgramming #Excel #ODBC #SQL #DataEngineering #Migration #SAS #ITStrategy
@alexgor.comHow do databases find a single row among millions in milliseconds? 🗄️
Discover database indexing and how B-Trees make queries lightning fast.
@communityaws.bsky.social"Athena o Redshift: arbol de decision desde SQL Server" by Javi Johan Rodríguez Giraldo
#amazon-athena #amazon-redshift #data-engineering #tutorials #sql-server
@communityaws.bsky.social"Athena or Redshift: a decision tree from SQL Server" by Javi Johan Rodríguez Giraldo
#amazon-athena #amazon-redshift #data-engineering #tutorials #sql-server
@dcac.comDo you run a #SQL Server or #IT user group, and need a free web hosting solution for your group?
We have a solution for you at https://sqlugs.com/ where you can host your site, including usign your own domain name.
Go to the site and simply request a site.
@rajeshdataai.bsky.social
@itchie-tatsumi.bsky.social
@tjb.devim constantly impressed by Opus 5.5 and what can be developed via Claude Cloud
i made a sql learning TUI that was really fun and the user flow is pretty nice!
@dcac.comhttps://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
@dcac.comhttps://bit.ly/3P4g5E1 RealtyTrac's DB server needed upgrading and #HA. They used the beta of SQL 2016; making them the 2nd company in the world running SQL 2016, giving them the HA and performance that they needed.
Contact DCAC to discuss your #SQL Server upgrade needs https://dcac.com/contact
@mikhail-mikushin.bsky.socialWhy Real-time dashboards are overrated #data #dataanalytics #sql #datastaleness #datafreshness
@gp-pulipaka.bsky.social
