Trending

#SQLTips

Latest posts tagged with #SQLTips on Bluesky

Latest Top
Trending

Posts tagged #SQLTips

Video

SQL Performance Showdown: CTEs vs. Temp Tables. ๐Ÿ’พ One is for clean code, the other is for heavy lifting. Know the difference. ๐Ÿš€

๐ŸŽž youtu.be/oqPR-BcT6_c
๐Ÿ“ƒ scriptdatainsights.blogspot.com/2026/02/sql-...
๐Ÿ›’ scriptdatainsights.gumroad.com/l/february-s...

WITH or #? ๐Ÿ‘‡

#SQLTips #DataScience #Coding

0 0 0 0
Post image

๐Ÿ—‚ How to Map Tables and Views in SQL Server

Learn how to map tables and views effectively in #SQLServer to maintain scalable, reliable data pipelines and reduce maintenance overhead.
๐Ÿ”— Read the guide: is.gd/910C2h
โœ… Free trial of #dbForgeStudio: is.gd/4mgWGt

#SQLTips

0 0 0 0
dbForge Studio for SQL Server: Complete Demo for Developers and DBAs
dbForge Studio for SQL Server: Complete Demo for Developers and DBAs YouTube video by Ing. Morales Rubio

๐Ÿš€ 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

1 0 0 0

HN discussion on SQL anti-patterns highlights pitfalls in query efficiency & maintainability. Key themes cover overuse of DISTINCT, NULL handling, sargability, and coding style. Understanding database behavior is crucial for optimization. #SQLTips 1/6

0 0 1 0

The `DISTINCT` operator sparked debate, often seen as a "code smell." It frequently masks underlying issues like poor query design or a lack of understanding of the schema, rather than solving the root cause of duplicate data. #SQLTips 5/6

0 0 1 0
Preview
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, โ€ฆ

๐Ÿ” 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

3 2 1 0
Preview
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.

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

0 0 0 0
Post image

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

0 0 0 0
Preview
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 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...

0 0 0 0
Post image

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

5 0 0 0
Post image

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

1 0 0 0

Discussion also touches on alternative SQL syntaxes like pipe syntax, which could improve readability and integration with LLMs. #Coding #SQLTips

0 0 1 0
Post image

UPDATE vs ALTER in SQL
๐Ÿ‘‰Explained Visually withโ€” infographic!

๐Ÿ“ค Subscribe:https://youtube.com/@rajesh_data_ai

#SQL #interview #DataScience #DataAnalytics #ArtificialIntelligence #data #MNC #SQLPractice #BusinessAnalyst #databases #sqltips #DataScientists #database #DB #interviewtips

0 0 0 0
Post image Post image Post image Post image

๐Ÿ‘‰SQL String Data Types in 60 Seconds!

๐Ÿง Struggling with CHAR, NCHAR, VARCHAR, and NVARCHAR?

๐Ÿ“ค Subscribe:https://www.youtube.com/@rajesh_data_ai

#SQL #interview #DataScience #DataAnalytics #ArtificialIntelligence #data #MNC #SQLPractice #BusinessAnalyst #databases #sqltips #DataScientists

0 0 0 0
Preview
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...

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

5 0 0 0
Post image

๐Ÿš€ 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

0 1 0 1
Mastering Dates with SQLite3, strftime, and Lazarus
Mastering Dates with SQLite3, strftime, and Lazarus YouTube video by The Silver Pascal Coder

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

1 0 0 0
Post image

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

1 0 0 1
MariaDB JSON_TABLE() function example.

MariaDB JSON_TABLE() function example.

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

5 0 0 0
Post image

๐Ÿง  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

2 0 0 0
Preview
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.

๐Ÿ•ต๏ธโ€โ™€๏ธ๐Ÿ’ป Ever wondered what CXPACKET and CXCONSUMER waits really mean? Read my latest blog post..
#SQLServerPerformance #DatabaseOptimization #CXPACKET #CXCONSUMER #SQLTips
thedbahub.com/unraveling-c...

0 0 0 0
Preview
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.

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

0 0 0 0

Capitalizing keywords in SQL not only enhances readability, making your queries easier to understand, but also reinforces best practices in coding standards. It's a small effort with big returns in maintaining code quality. #DataScience #SQLTips #CodingStandards

0 0 0 0