AI for SQL Server: dbForge Studio + AI Assistant (Full Demo)

AI for SQL Server: dbForge Studio + AI Assistant (Full Demo)


πŸš€ Ready to take your SQL skills to the next level?
In this video, I’m exploring the brand-new AI Assistant in dbForge Studio for SQL Server β€” a powerful AI-powered companion that helps you write, explain, and optimize SQL queries faster than ever! ⚑
🧠 Whether you’re a database developer, data analyst, or SQL Server DBA, this tool can help you:
βœ… Generate SQL queries from natural language prompts πŸ’¬
βœ… Analyze and optimize existing code 🧩
βœ… Get indexing suggestions to boost performance βš™οΈ
βœ… Understand complex SQL with AI-driven explanations πŸ“˜
βœ… Build and manage reports directly inside dbForge Studio πŸ“Š
πŸ’‘ Why it’s awesome:

The new dbForge AI Assistant integrates seamlessly into your workflow β€” it saves time, improves accuracy, and makes SQL easier for both beginners and pros.
dbForge - unified database ecosystem β†’ https://is.gd/ZI7Swb
Get started with dbForge AI Assistant β†’ https://is.gd/APkheI
Download a free trial and start testing the AI-powered dbForge Studio for SQL Server today!
https://is.gd/Zo7CBh

0:00 Intro & why good data tools matter
0:40 What is dbForge Studio for SQL Server
2:00 Connecting to your SQL environment
3:00 How the AI Assistant works
4:30 Writing SQL from natural language
5:30 Explaining and improving queries
7:00 Indexing recommendations
8:30 Building reports inside dbForge Studio
10:00 Giveaway info & how to try dbForge


πŸ›’ 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
Closed Caption:

If you do any work with data
administration, development,
engineering, data science, analysis,
then you know how important it is to
have good quality data tools so that you
can have good quality data. And in this
video, I'm going to share with you my
favorite tool for working with data,
specifically SQL Server. But the company
that makes this tool has an entire suite
and range of tools that work across the
data world. And I'm going to focus on
the tool that I use for working with
Microsoft SQL Server and an upgrade that
this tool recently got that incorporates
artificial intelligence to make it even
more effective. The tool we're going to
take a look at today is called DBForge
Studio for SQL Server. It's by a company
called Devart and they make a number of
different database tools for different
database products to really help me
manage my database environment. And they
were actually a very early sponsor on
the channel a few years back when I was
first starting out. And I've been using
their product ever since because it's
absolutely fantastic. And they've
actually decided to sponsor this video.
So, and there's a special announcement
near the end of the video. So, make sure
you stay tuned for that. But let's take
a look at DBForge Studio for SQL Server
and specifically the new AI assistant
that we can use in order to get our
queries optimized, to get our data
optimized, well to do a lot of very
interesting things. So when I launch
DBForge Studio, you'll notice that I get
a connection string. It's very similar
to other tools that I might have. I'll
go in, I'll choose the server that I
want to connect to. Um, so I'll choose
local host because I do have SQL running
on my local machine. I'll choose Windows
authentication. So we can go and choose
our authentication type. I'll choose the
database that I'd like to connect to or
just the server itself. And then I get
some additional options like I can
choose to make it a production
environment, a development environment
or a sandbox environment. I have
advanced options so I can make sure that
I have encryption and such. So once I
test the connection and make sure it
works, I can then go in. I'm connected
to the to the database. In this case
here, local host, the data server with
all of my databases on here. I can
create another connection in here. Same
same idea, localhost and Windows
authentication. And then what I could do
is change my environment from say a
development environment into a sandbox
environment. So you can see here test
the connection and the icons on the side
change so that I know that I'm in my
sandbox environment and there are a ton
of tools that are available with DBForge
Studio uh things around development lots
of different tools. We're going to focus
on the AI assistant here and uh in this
video, but there's so many more things I
can do around database development,
database design, some really useful
tools for both uh traditional design and
and analytical design, different
database sync tools, different
administrative tools, uh different types
of data pump tools to move data,
different types of data analytic tools.
So, lots of useful features in here and
some DevOps as well. So, this is a a
platform that allows me to really do a
lot with my database environment, not
just being limited to a few things. So,
let's open up a query window. You can
see I have a query window. I can choose
different databases. I'll open up my AI
assistant here and I'll sign into the AI
assistant. And then I can start using
the AI to build my queries. I can use it
to build queries. I can use it to
analyze queries. I'll connect up to a
database here. Let's connect up to my
Adventure Works data warehouse. Now,
data warehouse, of course, is something
that's used to answer business
questions. I can type my business
question into the AI. So, in this case
here, I want to take a look at showing
me customers that have multiple orders,
and I want to look at those orders
sorted by year. So, I could write the
SQL query myself or I can have the AI
generate that query for me. And this is
great because this means I can put in my
business question and use this code. Um,
I could use it as starter code. I could
copy this code. I could actually open it
right into a query window. I could then
make sure I'm on the right database. I
could then execute the code to see the
results. So, I can start debugging. I
can execute the code and it'll actually
generate the results. So you can see
this is a very powerful tool and it can
be used uh to take existing SQL queries
as well and optimize them. So let's say
I have this query here and I want to
work a little bit more here. I want to
then sort the query by the customers
that have purchased the most products
with me. So you can modify the query and
you can build this query up over time.
So I'm going to build this query by
adding a little bit more to it. And what
it'll allow me to do I'll make sure I'm
on the right database here. it'll allow
me to modify and have this query uh
enhanced. So now I'm going to get the
enhanced query. You see obviously it's
very similar to the first query. I'm
just doing a a sort on here, but I'll
open it to a new query window. I'll go
ahead and execute that. And we can see
that I've got my top customers that have
placed the most orders. So you can see
that in here as well. And if I'm just
starting out on my SQL journey, I can
actually ask the AI to explain the query
to me. So it could explain the query
that I just created or if I had existing
SQL code in a query editor, I could
bring it into the AI and ask it to
explain it. This AI is also directly
connected to the help and documentation
for DBForge Studio. So if there's things
that I want to do in the studio, so for
example, if I if I want to go in, I can
ask it a question here. So I'll say, you
know, how can I um modify the database
structure? So maybe I want to know how
to make the database structure um more
effective. So I'm going to modify it so
that the query maybe runs side by side.
So I want to modify this. So make it
more efficient. So if you're in the
world of databases, we know the number
one way to make a query more efficient
is index it. So you can see here, it's
going to make that recommendation to me,
but it's going to go beyond that. It's
going to tell me what table or what uh
where I want to put the indexes. It's
going to tell me what type of indexes
and it's going to even write code for
those indexes which again I can copy
into query windows and execute. That's a
really handy feature. And then if I want
to, I can even go in and ask it
questions like, let's say I want to know
how to use DBForge Studio in order to uh
create uh sidebyside comparisons or
maybe I want to keep a copy without the
index, keep a copy with the index, and
run sideby-side comparisons. I just have
to put that question into the AI. And
when I put that question in the AI, it's
going to give me a suggestion of how I
can run sideby-side comparisons. This is
pretty helpful if you're teaching or
learning because what you can do is say,
here's the query with an index. Here's
the query without an index. Indexes are
a good thing. So, we can go in here and
it's just giving me some information on
how to do that, but not just how to do
it. It's actually writing the code that
would enable me to do that. And there
are a lot of different features that I
can do in in the studio here. So the
studio itself has a lot of different
things we can do. Let me show you one
for fun. But there's a lot that we can
do. So you can see I can do database
things. I can look at um working with
the data itself. I can work with SQL. Uh
there's lots of different ways to to
work in this environment. You saw them
at the very beginning of when I was
demonstrating it. Just all the things
that I can do. The AI is integrated with
that. Let's do something like build a
report. So notice that I have a report
designer built right into DBForge
Studio. Very common to have to generate
reports from data. You can see that I've
got the report wizard here. I'm going to
create a standard report. You can do a
little bit more here, but I'm just going
to go to my local host. Do a simple
query, simple um simple report. I can
choose other hosts if I have them in
there as well. And what I'll do here is
I'll just choose my database. Now, this
is a data warehouse. So, of course, I'm
going to have dimensions that are very
wide. So, I'll go ahead and add just a
bunch of the fields from the dimension
here. So, this might be a report where I
want to do a little customer address and
phone number report. I'll go ahead and
add those columns and finish. And notice
it generates the RDB file for me. So, it
actually generates my report definition
file for me. I'll just close the AI
assistant for a moment for some desk
real estate here. Uh, and that's why we
should always have big giant monitors or
more monitors. And you can see I've got
my file here. I can make my own
modifications to the report definition
file. I'm able to go in and add things
like headers and footers, all the good
things that a report would want to have.
I'm not going to make a crazy fancy
report here. I'm just going to do a
preview of the existing one. And you can
see there's the report there and a
preview of the report. It's couple
thousand pages long. Actually, the AI
assist is fantastic and it's something
that just makes my favorite data IDE
even better. That integrated development
environment, it just makes it better
because now I can use AI to do so many
things around optimization, development,
understanding, learning, teaching. And
Devart, the company that makes this
tool, also makes a whole bunch of other
data tools for Oracle databases,
Postgress, SQL, for MySQL, Maria DB,
connectivity tools. There's just I'll
put a link to their website down below
because they just make so many useful
tools when it comes to the world of
data. And in fact, in this video,
they're sponsoring this video and are
offering a contest. There's a prize to
be won. If you like the video and
comment down below, you'll be entered
into a draw. I'll put the details in the
description of how this is going to
work. But they've kindly offered to have
a prize that they can they can give away
to uh to one lucky winner. So, I'm
looking forward to to doing that draw in
the near future after this video is
published. If this video is 3 years old,
the contest is probably over. I'll put
the details down below. But the real
prize is that you can go to their
website, download a free trial, and
start playing with the tool that works
with the database environment that that
works for you. So, if you're in an
Oracle environment, if you're a MySQL
user, or if you're using a SQL server
like I am, you can check out the tools
and the AI assist. There's a lot of
different things to explore. So, I hope
the video was useful. I hope that you do
explore the tool. Comment down below,
tell me what you think of the tool, and
I guess have a chance to win a prize.
And um and I'll see you in the next

Video Length: 11:14
Uploaded By: Learning and Technology with Frank
Published: 10/20/2025
View Count: 15,202

Related Software Products
dbForge AI Assistant
dbForge AI Assistant

Published By:
Devart

Description:
dbForge AI Assistant: an SQL Chat That Knows Your Schema, Inside dbForge dbForge AI Assistant is the AI chat built into Devart's dbForge database tools for SQL Server, MySQL, MariaDB, Oracle and PostgreSQL. It writes SQL from plain-language requests, explains and fixes queries, and suggests index changes, using your database's schema as context. There's a free Express plan with 200,000 tokens a month, and the Professional plan costs $99.95 a year...


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

Video Length: 08:15
Uploaded By: Learning and Technology with Frank (2/19/2026)
View Count: 1,741

Reinvent Your SQL Coding With dbForge AI Assistant in Seconds
Reinvent Your SQL Coding With dbForge AI Assistant in Seconds

Video Length: 00:57
Uploaded By: Devart (12/16/2025)
View Count: 613

dbForge AI Assistant Overview for SQL Developers
dbForge AI Assistant Overview for SQL Developers

Video Length: 05:33
Uploaded By: Devart (12/15/2025)
View Count: 256

Copyright Β© 2026, Ivertech. All rights reserved.