>> Are you a user of SQL Server data tools or SSDT?
In this episode, we'll learn all about
what's new and what's upcoming,
including some exciting announcements of
things that just work like co-pilot,
this week on Data Exposed.
[MUSIC].
>> Hi, I'm Anna Hoffman and welcome
to this episode of Data Exposed.
We have an exciting episode because we're going
to be bringing back on Subhojit,
so welcome back Subhojit.
Subhojit has joined us before to talk about
SQL Server Data Tools and other services like SSAS, SSRS.
But today we're going to focus on SSDT and what's new.
Subhojit can you tell us what's been going
on in the SSDT space recently.
>> Sure. But even before I go into what's new in SSDT,
I want to thank all our viewers for
the great response that we have got for SSAS and SSRS.
The readings of both the extensions have shot like anything.
SSAS is moving from 2.13-3.29 and
SSRS is moving from 2.8-3.93. Thank you so much.
We are constantly hearing you and monitoring
your feedback and keeping on making the improvements.
Coming back to SSDT,
we all know SSDT is used to build,
debug, maintained, and refactor database.
It is mainly targeting database developers.
For people who are new to SSDT,
SSDT comes as a workload with Visual Studio.
We don't have a standalone installer of SSDT for VS 2022.
The current version of SSDT is 17.6.
Make sure that you download
the latest version to get all the features.
When you download Visual Studio through the installer,
you have the small Data Storage and Processing tab.
Once you check it,
you have SSDT in your IDE.
Coming to the new things that we have,
I know some of them are little old.
We have released support for SQL Server 2022 with 17.5.
But I just wanted to reiterate
because that has been a great enhancement,
something that the community has been asking us for a long time.
With this, you can explore the features like code navigation,
IntelliSense, debugging,
and declarative editing in the T-SQL editor.
Although it's something which we have done it previously,
I just wanted to reiterate that this is there and
please take full advantage of SQL Server 2022.
>> Awesome.
>> Some new enhancements which
all our users would be really interested
about is that we have introduced ledger in SSDT.
Ledger we already know was introduced in ADS and SSMS.
It's a feature to establish trust
around the integrity of the database system.
These are special tables
which brings the power
of blockchain to make auditing much more simpler.
We already know that ledger is,
I don't want to bore you with the details,
but we just wanted to share that
we have introduced ledger in SSDT.
When you open SSDT,
if you have created the ledger in some other system,
you can navigate your ledger tables in
the SSOX and check
all the ledger tables and its functionalities there.
Not just that, we have included both the types of ledger table,
updateable and append-only in SSDT.
You can create a SQL project ledger tables from SSOX.
From the navigation,
you can create table and also you can go to
the Solution Explorer and add an item from there.
You can add a table under
the tables and views
options and you can create all the tables from there.
Also you can publish a ledger table into a ledger database.
We are providing ledger as
a functionality holistic in SSDT with 17.6.
>> Awesome. Subhojit that's really exciting to hear.
I know people have been really
excited about ledger bringing blockchain
to Azure SQL database and
SQL Server and now if they're using SSDT,
they can do all of those things ledger as well.
It's great to see that.
I'm sure there have been some other improvements.
Can you tell us a little bit more about them?
>> Sure Anna. There have been some other improvements.
One, we have moved from SDS to MDS
so that it gives some enhanced security features.
We have ensured that
the build and published database projects with
unit test projects using build tools are there.
We are provided support for that.
We have worked on performance as well.
We have moved to the latest version of
MSBuild API for faster build support.
There had been a lot of complaints on
Visual Studio crashes because of SSDT.
We have worked on it and we are
also continuously working on
it to hear feedback from our customers,
especially for 17.5 and 17.6 which are
our focus applications and whatever problems you are facing,
trust me, we're looking into it.
Just a fun fact which I wanted to
add that we all know about co-pilot and
how Microsoft have ensured that
we help every user to achieve more.
You can go ahead and use the co-pilot in 17.6.
Maybe just write what you want,
you can populate the data in the table,
you can do a lot of things.
Just write the statement
and the co-pilot would generate the code as you can see here.
Now it is up to you if you want to accept the solution or not.
There would be dedicated videos for it coming up very soon.
But this is something that you would really like to try
out and experiment and give us feedback on how we can improve.
>> Wait Subhojit. Just so I understand this new update,
in this screenshot that you have,
you wrote out a comment,
create a table for course and co-pilot
suggested that gray text all of the ways to create a table.
>> Exactly. We just write the command and the co-pilot gives
the entire code whether we want to accept
it or not accept it is up to you.
If we accept it, then we press a tab and it becomes the code.
So back and we agreed help for somebody who's new.
>> Do I need to upgrade to
a certain version to get this or it's just going to work?
>> Is going to work with the latest release.
>> Awesome, cool.
That's really exciting. All these improvements are great.
I think customers are going to be really excited about it.
Can you share any sneak peek at what's coming next?
>> Some of the things which are there in the pipeline and it has
been an ask from the developer community for a long time,
is support for Azure Synapse Serverless SQL Pools.
We want to give that support very soon,
it's in testing phase and I hope
to release it as soon as possible.
We're also working on support for VS on ARM64,
support for SSDT on ARM64,
VS you'll be able install SSDT on ARM64 architecture machine.
Also Azure Active Directory authentication as a user uses in SSMS.
We're going to give that feature in
the same way in SSDT very soon.
>> Awesome, cool. A lot of great stuff
happening in this space and upcoming in this space.
Subhojit, thanks so much for joining us on Data Exposed.
If I could ask, do you have
any final tips or tricks
or advice or things you want to share with our viewers.
>> Just that we have a very robust feedback system,
we are listening to you, we are checking it.
If you have any problems with SSDT,
please write to us,
we will revert back to you.
>> Awesome. Well, thanks so much Subhojit.
If you like this episode, go ahead,
give it a like a check the description.
We'll put some links to learn more and some related
videos and we hope to see you next time on Data Exposed.
[MUSIC]