> Markdown version of [/playlists/sql](https://www.wearedevelopers.com/playlists/sql). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Playlist: SQL 20 videos · 28 moments · 74.5 minutes ## Fault Tolerance and Consistency at Scale: Harnessing the Power of Distributed SQL Databases - **Comparing native SQL clustering to NoSQL distribution layers** (07:55, 2min) — Layering relational SQL queries over baseline NoSQL frameworks creates unavoidable application performance bottlenecks. - **Evaluating criteria for distributed SQL system adoption** (26:41, 1min) — Examining standard SQL completeness and flexible deployment topologies ensures productive modern architecture adoption. - **Evolution from key-value stores to distributed SQL** (00:57, 1min) — Why organizations move away from basic key-value engines to structured distributed relational systems for complex processing. [Learn more](https://www.wearedevelopers.com/videos/1520-fault-tolerance-and-consistency-at-scale-harnessing-the-power-of-distributed-sql-databases) ## Using WebAssembly for in-database Machine Learning - **Testing sentiment inference behavior via SQL select statements** (24:37, 2min) — Verifying the WebAssembly function behavior on text patterns like capitalization and exclamation points directly inside standard SQL queries. [Learn more](https://www.wearedevelopers.com/videos/588-using-webassembly-for-in-database-machine-learning) ## TiDB, One Layer at a Time: How Distributed SQL Became an Agentic AI Backbone - **Processing queries with a stateless SQL layer** (04:43, 1min) — The processing layer routes reads and writes without storing data locally while maintaining syntax compatibility with MySQL. - **Consolidating workloads through a smart database optimizer** (21:17, 2min) — An intelligent sql optimizer automatically routes various query fragments to row, columnar, or vector engines without manual manual intervention. - **Distributed SQL properties for agentic AI applications** (23:20, 2min) — The fundamental features of distributed databases completely align with what agentic AI backbones need regarding consistency and elastic scale. [Learn more](https://www.wearedevelopers.com/videos/100117-tidb-one-layer-at-a-time-how-distributed-sql-became-an-agentic-ai-backbone) ## Enjoying SQL data pipelines with dbt - **Moving away from unstructured SQL strings** (00:03, 2min) — How executing raw commands through scripting prevents pipelines from acting predictably. - **Building transformation models with SQL and Jinja macros** (09:37, 2min) — How compiling modular jinja templates abstracts away repetitive querying workflows. [Learn more](https://www.wearedevelopers.com/videos/823-enjoying-sql-data-pipelines-with-dbt) ## Hacking MSSQL on Cloud. All of them. How I became sysadmin on Azure, AWS, GCP and Alibaba. - **Identifying SQL injection vulnerabilities in internal stored procedures** (00:03, 4min) — Automating security checks reveals common flaws in complex internal queries where user input is unsafely concatenated. - **Validating SQL injection risks with a PowerShell module** (04:11, 3min) — A programmatic demonstration parses statements to pinpoint unsafe dynamic command concatenations and risks stemming from implicit data type convers... [Learn more](https://www.wearedevelopers.com/videos/100339-hacking-mssql-on-cloud-all-of-them-how-i-became-sysadmin-on-azure-aws-gcp-and-alibaba) ## Fault Tolerance and Consistency at Scale: Harnessing the Power of Distributed SQL Databases - **Evolution of distributed SQL database architectures** (00:00, 1min) — The transition from simple key-value systems to scalable databases providing strong consistency and standard SQL capabilities. - **Engineering scale-out architectures specifically for relational queries** (20:11, 1min) — Avoiding typical degradation by constructing full relational processing directly over the core rather than mapping abstractions onto object stores. [Learn more](https://www.wearedevelopers.com/videos/1146-fault-tolerance-and-consistency-at-scale-harnessing-the-power-of-distributed-sql-databases) ## Python-Based Data Streaming Pipelines Within Minutes - **Validating end-to-end functionality using direct SQL insertions** (33:43, 2min) — Confirming immediate remote prediction delivery upon raw query executions against the initialized database container. [Learn more](https://www.wearedevelopers.com/videos/1233-python-based-data-streaming-pipelines-within-minutes) ## Scaling GraphRAG: Efficient Knowledge Retrieval for AI - **Modeling semantic database layers for reliable SQL queries** (18:00, 1min) — Structuring complex relational database schemas into graph models enables accurate SQL translations beyond standard context window restrictions. [Learn more](https://www.wearedevelopers.com/videos/100025-scaling-graphrag-efficient-knowledge-retrieval-for-ai) ## Dangerous Reactivity: Why AI Output Is the New XSS - **Preventing SQL injection originating from natural language queries** (11:46, 2min) — Returning structured data instead of direct queries protects databases from prompt-driven data exfiltration attacks. [Learn more](https://www.wearedevelopers.com/videos/100115-dangerous-reactivity-why-ai-output-is-the-new-xss) ## OpenAI for FinTech: Building a Stock Market Advisor Chatbot - **Core capabilities of SingleStore distributed relational SQL database** (06:10, 3min) — Scale-out clustering and universal storage mechanisms streamline analytics workflows by centralizing transactional and historical processing. [Learn more](https://www.wearedevelopers.com/videos/805-openai-for-fintech-building-a-stock-market-advisor-chatbot) ## GraphQL: Does it replace SQL, REST or Something Else? - **Adapting relational querying principles for modern JSON documents** (06:04, 2min) — How the SQL++ standard ports traditional select statements directly to object-oriented document architectures. [Learn more](https://www.wearedevelopers.com/videos/1054-graphql-does-it-replace-sql-rest-or-something-else) ## Beyond SQL Generation: How to Teach Agents What Your Database Actually Means - **Analyzing valid structural query code lacking domain meaning** (09:37, 2min) — Perfectly executable database queries generated by an agent fall short without explicit situational metric instructions. [Learn more](https://www.wearedevelopers.com/videos/100127-beyond-sql-generation-how-to-teach-agents-what-your-database-actually-means) ## We Gave Every Tenant a Postgres Connection String - **Why data workflows require raw SQL over REST APIs** (01:38, 1min) — Providing direct database access prevents customers from self-hosting by allowing custom joins and aggregations directly in standard tooling. [Learn more](https://www.wearedevelopers.com/videos/1951-we-gave-every-tenant-a-postgres-connection-string) ## Automated MS SQL Server database deployments with dacpacs and Azure DevOps - **Validating and publishing with SQL package executables** (19:28, 4min) — Generating standalone deployment scripts before execution provides safer validation of target database updates against existing states. - **Resolving deployment issues across hundreds of databases** (00:02, 6min) — Automating SQL Server database changes replaces manual scripting across highly distributed custom environments. [Learn more](https://www.wearedevelopers.com/videos/334-automated-ms-sql-server-database-deployments-with-dacpacs-and-azure-devops) ## ChatGPT, ignore the above instructions! Prompt injection attacks and how to avoid them. - **Comparing prompt injection to traditional SQL injection attacks** (13:04, 2min) — The fundamental lack of separation between developer code and user input in language models mirrors the mechanics of SQL injection. [Learn more](https://www.wearedevelopers.com/videos/723-chatgpt-ignore-the-above-instructions-prompt-injection-attacks-and-how-to-avoid-them) ## How We Built a Machine Learning-Based Recommendation System (And Survived to Tell the Tale) - **Evaluating limitations of legacy sql-based recommenders** (05:40, 2min) — Statistical formulas calculated continuously in sql struggle to provide accurate recommendations for newly listed or unpopular items. [Learn more](https://www.wearedevelopers.com/videos/752-how-we-built-a-machine-learning-based-recommendation-system-and-survived-to-tell-the-tale) ## Programming secure C#/.NET Applications: Dos & Don'ts - **Demonstrating and preventing SQL injection in .NET** (17:41, 3min) — Modifying inline SQL statements to use parameterized queries prevents malicious database manipulation by untrusted user input. [Learn more](https://www.wearedevelopers.com/videos/1126-programming-secure-c-net-applications-dos-don-ts) ## Data Science in Retail - **Leveraging BigQuery ML for scalable SQL-based segmentation experiments** (29:06, 2min) — Using enterprise data warehouses empowers analytics teams to train machine learning models directly via standard database queries. [Learn more](https://www.wearedevelopers.com/videos/586-data-science-in-retail) ## Tomb rAIder: AI Search with Kotlin - **Applying hard constraints with SQL filters** (10:54, 2min) — Combining relational filters for exact bounds alongside vector distance queries limits errors and improves overall relevance. [Learn more](https://www.wearedevelopers.com/videos/1989-tomb-raider-ai-search-with-kotlin) ## Fine-Tuning Small Language Models for Agentic AI - **Benchmarking text-to-SQL tasks with custom datasets** (07:08, 3min) — Custom training and evaluation datasets for manufacturing and hospital domains help benchmark agentic performance effectively. [Learn more](https://www.wearedevelopers.com/videos/100352-fine-tuning-small-language-models-for-agentic-ai)