explore | Grilled Cheese

Want to see exactly what's going on in an Oracle #SQL query calling a view?

Pass it to

DBMS_UTILITY.EXPAND_SQL_TEXT

This merges view queries into the main select, giving you the complete statement

@connormcd.bsky.social made a script to make calling it simple

Work with #SQLite directly in your #IDE. Open SQLite databases, explore tables, edit data and run #SQL queries alongside your application #code. Compare leading IDEs.

RedMimicry is hiring: Software Developer (#Go) - Security Analytics #RemoteWork #Berlin 🇩🇪 #golang #sql #javascript

How to run funnel analysis in SQL #data #dataanalytics #Sql #FunnelAnalysis #WindowFunctions

Your own #tech #news from here in #Australia & #NewZealand

👉 scratchnews.io

☁️ Why So Scalable?
🐌 #SQL Anti-Patterns
🍒 Why Is #Privacy Hard?
🤖 #AIAgents Easily Tricked
🎪 Illusion Of 99.9% #Uptime
🌟 How #Blind People #Code
🥸 #Australia Ban #SmartGlasses?
🪭 #Website #Design & #Foldable Devices

Nuevo artículo sobre el caso límite en C++ a una consulta SQL.
https://conclase.net/blog/item/casolimitesql
#cpp #c++#sql

https://bit.ly/4im5XDQ #PowerShell for SQL Server Administration

Join over 15k learners as they join @mrdenny.com in a journey though #PoSH for #SQL #Server #Administration and how PowerShell can be used to make administration of your SQL environment easier and faster.

#LinkedIn #Learing

Starting in release 23.26.2, you can nest WITH clauses/CTEs inside each other in Oracle #SQL:

WITH cte1 AS (
WITH cte2 AS (
WITH cte3 AS ( ... )
SELECT * FROM cte3
)
SELECT * FROM cte2
)
SELECT * FROM cte1

https://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

Me: Write efficient code.
AI: "Here’s a 7-table JOIN for a simple query!" 🫠
The sheer amount of useless join operations AI generates is impressive... and terrifying for server bill.
Creating a custom High-Performance Coding Skill today. Hope it actually learns! 🤖⚡
#AI #BuildInPublic #Developers #SQL

https://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

Do 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.

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

Unlock the secrets of fuzzy search! This piece dives deep into Levenshtein automata and n-gram similarity to revolutionize how we match terms.

#database #reading-list #sql

【SQL】テーブル作成、テストデータ投入(bulk)、データクエリ、テーブルドロップのメモ

#SQL

https://bit.ly/41o8esi With DCACs assistance ATTOM Data was the second company in the world running #SQL 2016, back in 2015. After this DCAC and ATTOM moved to #Azure to improve performance and consolidate resources.

Contact DCAC to discuss your cloud migration needs https://dcac.com/contact