How to Use AI for SQL Server with dbForge AI Assistant (Full Demo)

Looking for a way to use AI with SQL Server to generate queries, understand complex code, and improve database performance? In this video, I show how dbForge Studio for SQL Server and the built-in dbForge AI Assistant help data engineers, developers, and DBAs work more effectively with their data. You’ll see how to connect to a database, generate SQL queries from natural language, explain and optimize existing SQL code, detect and fix errors, and improve query performance with AI-driven suggestions. 🔍 What you’ll learn: - Generate SQL queries from natural language - Explain SQL (useful for learning, reviewing, or onboarding) - Optimize SQL and get performance-focused suggestions (including indexing ideas) - Detect and fix SQL errors - Work across hybrid environments (cloud + on-prem) with a unified toolset If you work with SQL Server as a data engineer, analyst, developer, or DBA, this demo shows how AI can support query writing, review, and performance tuning. 🔗 Useful links: dbForge - unified database ecosystem → https://www.devart.com/dbforge/?utm_source=youtube.com&utm_medium=referral&utm_campaign=cc_dbforge2025.3_learning_and_Technology_with_Frank dbForge Studio for SQL Server → https://www.devart.com/dbforge/sql/studio/download.html?utm_source=youtube.com&utm_medium=referral&utm_campaign=cc_dbforge2025.3_learning_and_Technology_with_Frank dbForge AI Assistant → https://www.devart.com/dbforge/ai-assistant/getting-started.html?utm_source=youtube.com&utm_medium=referral&utm_campaign=cc_dbforge2025.3_learning_and_Technology_with_Frank ❓ Do you rely more on visual tooling and automation, or do you prefer writing and tuning SQL manually? Share your experience in the comments. 00:00 Why Data Engineering Is Critical for AI Success 00:17 AI Is Only as Good as Your Data 00:54 The Most Important Skill for AI Projects: Data Engineering 01:15 The Problem with Using Multiple Tools for Data Management 01:38 Unified Data Lifecycle with dbForge 02:32 Introducing dbForge AI Assistant for SQL Server 02:56 Connecting the AI Assistant to an Azure SQL Database 03:26 Generating SQL Queries from Natural Language 04:15 How AI Generates SQL Based on Your Database Schema 04:28 Improving and Reviewing SQL Code with AI 05:06 Explaining Complex SQL Queries with AI 05:44 Optimizing SQL Queries with AI Suggestions 06:33 Improving SQL Performance with Indexing Recommendations 06:46 Detecting and Fixing SQL Errors Automatically 07:16 Using AI to Learn SQL and Improve Query Skills 07:30 Why dbForge Is a Complete Tool for Data Engineering 07:47 Final Thoughts 🏫 Join our community on Skool - we discuss Educational Technology and more! https://www.skool.com/learning-and-technology-5738/about?ref=c81f61a3afdf4c1da084f81a713d979c ✍️ BLOG: https://www.summittechacademy.com 🔉 PODCAST: https://thelearningmindset.buzzsprout.com 🧠 The Learning Mindset: https://learningmindset.ca 🛒 My Amazon Stores: 📦 US Store https://www.amazon.com/shop/learningandtechnologywithfrank 📦 Canada https://www.amazon.ca/shop/learningandtechnologywithfrank * some of the links may support the channel as affiliate links Some of my Favourite Software and Tools for Teaching (some with discounts!) 🧑‍🎓Coursera Learn something new every day https://imp.i384100.net/qzVZrb 🎥TechSmith Create content using powerful tools https://techsmith.z6rjha.net/zxRkv7 🧠 Get AnswerThis - you can try it for FREE https://answerthis.io?fpr=frank65 If you decide to upgrade, use the code FA10 for a discount. #DataEngineering #SQLServer #dbForgeAIAssistant #dbForge #DatabaseTools #dbForgeStudio #DatabaseTools #Devart #DBATools #AIAssistant