#SQLTips
LightNews LightNews
mariadb.bsky.social
Unlocking JSON arrays with MariaDB! Query and manipulate JSON data like a pro using JSON_TABLE(). 🎯 #MariaDB #JSON #SQLTips #Developers
mariadb.com/kb/en/json_t...
MariaDB JSON_TABLE() function example.
November 29, 2024 at 5:32 PM
pawarpooja03.bsky.social
Struggling to connect the dots in SQL?

This visual mindmap is your shortcut to clarity!
Joins, functions, DDL/DML/TCL, window functions, and more- all in one quick reference.

Save it. Study it. Use it.

#SQL #DataAnalytics #DataScience #SQLTips #LearnSQL #Database
July 18, 2025 at 9:54 PM
nswarnob.bsky.social
Which one do you use the least? Drop it in the comments 👇
.
.
.
#SQL #PostgreSQL #WebDevelopment #CodeNewbie #100DaysOfCode #BackendDevelopment #DatabaseDesign #TechTok #DeveloperLife #LearnToCode #SoftwareEngineer #TechContent #DevCommunity #SQLTips #TechTwitter
July 26, 2026 at 6:33 PM
nswarnob.bsky.social
Which one do you use the least? Drop it in the comments 👇
.
.
.
#SQL #PostgreSQL #WebDevelopment #CodeNewbie #100DaysOfCode #BackendDevelopment #DatabaseDesign #TechTok #DeveloperLife #LearnToCode #SoftwareEngineer #TechContent #DevCommunity #SQLTips #TechTwitter
July 26, 2026 at 6:31 PM
woodruff.dev
Unleash your inner SQL wizard with FromSql in EF Core!
Need raw SQL power but love EF Core? FromSql lets you write handcrafted SQL like a boss while keeping all the ORM goodness.

Learn how: woodruff.dev/fromsql-writ...

#EFCore #dotnet #SQLTips #DeveloperTools
FromSql: Writing SQL Like a Boss in EF Core - Chris Woody Woodruff
So, you’ve embraced Entity Framework Core, and life’s been good. No more handcrafting SQL for every little query. But what happens when EF Core’s LINQ magic isn’t entirely cutting it? Maybe you need s...
woodruff.dev
January 27, 2025 at 12:33 PM
lazarorenato.bsky.social
🧠 Exemplo de Window Functions no SQL para Análise de Dados! 📊
SUM(valor) OVER (ORDER BY data_venda)
Vai somar acumulando os valores com base na data

#SQL
#DataAnalytics
#WindowFunctions
#SQLTips
#Bi
September 6, 2024 at 8:04 PM
anukhurana.bsky.social
Programmatically Suspending PeopleSoft Process Scheduler: A Working Solution.

Check out the full blog here. anukhuranacloudpsadmin.wordpress.com/2026/02/24/p...

#PeopleSoft #ProcessScheduler #OracleERP #ERPAdministration #SQLTips #Psadministrator #OCICloudComputing #OnPremises
Programmatically Suspending PeopleSoft Process Scheduler: A Working Solution.
Maintaining PeopleSoft environments whether on-premises or in the cloud often requires suspending the Process Scheduler safely for maintenance, upgrades, or patching. As a PeopleSoft administrator,…
anukhuranacloudpsadmin.wordpress.com
March 26, 2026 at 3:19 PM
martindba.bsky.social
🔍 Seeing NULL from JSON_TABLE in Oracle even when the JSON field you query isn't null? It might be due to very long text values.

Here's how to debug & fix it 👉 martincarstenbach.com/2025/08/07/w... #OracleDB #JSON #SQLTips
Why does my call to json_table return null for a column despite it not being empty?
I recently worked on a fun project involving JSON and Oracle Database 23ai. I had to store rather large JSON documents, individual field lengths exceeding what I usually see. No problem with that, …
martincarstenbach.com
August 8, 2025 at 9:50 AM
dailydatabricks.tips
Stop repeating yourself! 🙅‍♂️ Learn how named window specifications in @databricks can help you write cleaner, more maintainable SQL & PySpark code. 💪

Read More: dailydatabricks.tips/tips/Data%20...

#Databricks #Spark #SQLTips #PySpark
December 3, 2024 at 8:30 PM
xavierdatatech.bsky.social
Python + SQL = the perfect ingestion combo:

Python handles unstructured data, APIs, automation.

SQL offers power for joins, filters, and persistence.

Use this hybrid workflow to feed Spark, BI dashboards, or even LangChain apps.

#PythonForData #SQLTips #XavierDataTech #ModernDataStack #BigData
July 11, 2025 at 6:16 AM
devartsoftware.bsky.social
🚀 dbForge 𝗦𝘁𝘂𝗱𝗶𝗼 𝗳𝗼𝗿 𝗦𝗤𝗟 𝗦𝗲𝗿𝘃𝗲𝗿: 𝗖𝗼𝗺𝗽𝗹𝗲𝘁𝗲 𝗗𝗲𝗺𝗼

MVP Ing. Morales Rubio shares a full walkthrough of #dbForgeStudio for #SQLServer by #Devart
👉 Watch the demo: www.youtube.com/watch?v=24lQ...
✅ Try #dbForge for #SQL: is.gd/L9t293

#SQLTips
dbForge Studio for SQL Server: Complete Demo for Developers and DBAs
YouTube video by Ing. Morales Rubio
www.youtube.com
January 9, 2026 at 9:57 PM
silvercoder70.bsky.social
Dive deeper into working with dates in SQLite3 using the strftime function and learn how to handle date and time data effectively in Lazarus.

#SQLite3 #PascalProgramming #LazarusIDE #DatabaseDevelopment #strftime #FreePascal #SQLTips #DateHandling #ProgrammingTutorial

youtu.be/QR2arjyb6YM
Mastering Dates with SQLite3, strftime, and Lazarus
YouTube video by The Silver Pascal Coder
youtu.be
December 7, 2024 at 11:46 AM
izoate.bsky.social
How To Fix MySQL Error 1175: Disable Safe Update Mode MySQL
Running into MySQL Error 1175 while updating records? 🛠️ Learn how to safely disable Safe Update Mode and fix it in no time! 👉 Visit Now

www.izoate.com/blog/how-to-...

#MySQLError1175 #SafeUpdateMode #DatabaseFix #SQLTips #Izoate
How to fix MySQL error 1175: Disable safe update mode MySQL - Izoate
Stuck with MySQL error 1175? It means you're missing a WHERE clause in your update query. Learn how to fix it by temporarily disabling safe update mode with a simple SQL command.
www.izoate.com
August 7, 2025 at 2:10 PM
realcode.co.uk
Ever watch your database choke on a massive query? SQL SELECT TOP is like Heimlich for databases - instantly clears the blockage. Different syntax per platform (MySQL=LIMIT, Oracle=ROWNUM) but same brilliant result. Database running like a sloth? DM me! #SQLTips
January 4, 2026 at 9:00 AM
realcode.co.uk
Spent my morning deep-diving into database design methodologies. The big revelation? There's no 'perfect' approach - it's all context!

Top-down for clarity, bottom-up for flexibility, hybrid for pragmatism.

What's your DB design philosophy? DM me your database war stories! #SQLTips
August 6, 2025 at 10:00 AM
realcode.co.uk
Just found a goldmine - 20 advanced SQL techniques with actual examples! CTEs, window functions, recursive queries... all the good stuff. Perfect for small biz owners wanting to level up their database game. Who else gets oddly satisfied by a well-optimized query? 🤓 #SQLTips
July 18, 2025 at 3:15 PM
realcode.co.uk
Drowning in too many SQL query tabs in SSMS? Quick productivity hack: Tools > Options > Tabs and Windows > check 'Show pinned tabs in separate row'. No more endless dropdown scrolling! Been using this for years and it's saved me hours of frustration. #SQLTips #DatabaseProductivity
July 18, 2025 at 12:45 PM
realcode.co.uk
Just spent my morning geeking out on SQL Server statistics. 🤓 These little histograms are CRITICAL for query performance! If you've done bulk inserts or major data changes, run UPDATE STATISTICS WITH FULLSCAN. Your slow queries will thank you! #SQLTips #DatabasePerformance
July 2, 2025 at 1:15 PM
realcode.co.uk
SQL Server tip I'm implementing for all clients now: UPDATE STATISTICS daily, don't just rely on AUTO! 💡 Just read a great piece confirming what I've seen for years - outdated stats kill query performance. Small biz owners: this simple task could save you tons of headaches! #SQLTips
June 28, 2025 at 10:40 AM
thedbahub.bsky.social
🕵️‍♀️💻 Ever wondered what CXPACKET and CXCONSUMER waits really mean? Read my latest blog post..
#SQLServerPerformance #DatabaseOptimization #CXPACKET #CXCONSUMER #SQLTips
thedbahub.com/unraveling-c...
Unraveling CXPACKET and CXCONSUMER - The DBA Hub
Discover CXPACKET and CXCONSUMER waits in SQL Server, their impact on performance, and practical solutions to optimize your queries.
thedbahub.com
July 23, 2024 at 1:33 PM
thedbahub.bsky.social
Here I dive into SOS_SCHEDULER_YIELD, a common SQL Server wait type. Learn what causes it, how to identify it, and effective strategies to resolve it for better performance.
#SQLServerPerformance #DatabaseOptimization #SQLTips #SOSSchedulerY
thedbahub.com/understandin...
Understanding and Resolving SOS_SCHEDULER_YIELD - The DBA Hub
Dive into SOS_SCHEDULER_YIELD, a common wait type. Learn causes, how to identify it, and strategies to resolve it for better performance.
thedbahub.com
July 16, 2024 at 2:36 PM
roxsross.bsky.social
🐘 🎲 Genera datos de prueba aleatorios en PostgreSQL fácilmente

https://dzone.com/articles/postgresql-random-test-data

#PostgreSQL #Testing #DataScience #SQLTips
May 2, 2026 at 11:25 PM
purplefrogdata.bsky.social
Struggling to reset ROW_NUMBER() in SQL when a condition is met? 🧠

Jeet shows exactly how to do it using CTEs and smart partitioning.

🐸 Read the Frog Blog by Jeet!
www.purplefrogsystems.com/2025/07/rese...

#SQL #SQLTips
August 7, 2025 at 11:11 AM
juans3.bsky.social
🚀 Optimiza tus consultas #SQL con CTE:

¿Sabías que puedes usar Common Table Expressions (CTE) para simplificar tus subconsultas?

👉 Más claro, más limpio, más rápido, más profesional. ¡Pruébalo hoy! 💡

#SQLTips #DataScience #CTE #Analytics #Data
December 7, 2024 at 6:22 PM
naoyacreates.bsky.social
AIMindUpdate News!
Struggling with database design? 🤯 Follow these simple tips to write cleaner, more efficient code! #DatabaseDesign #SQLTips #SoftwareDevelopment

Click here↓↓↓
aimindupdate.com/2025/07/17/d...
Database Design Tips & Best Practices for Developers | AI News
Avoid database nightmares! Learn essential database design tips to boost performance and maintainability. Get expert advice and optimize your database today.
aimindupdate.com
July 24, 2025 at 6:30 AM