>> Learn all about
Azure Advisor signals and how they can help you get
the best recommendations and stay in
compliance with well-architected framework.
This week on Data Exposed SQL Insider Series.
[MUSIC].
>> Hi, I'm Anna Hoffman and welcome to this episode
of Data Exposed SQL Insider Series.
Today I have joining with us a very special guest, Roberto.
Roberto, thanks so much for joining us today.
Before we get into the topic,
I was wondering if you could share a little bit about what you do.
>> Certainly. Thank you for having me, Anna.
My name is Roberto Cavalcanti.
I'm part of the CAT or customer architecture team.
Today I'll be talking about
my participation on the SQL Insider program.
>> It's super great to have you on the show.
We worked together a lot in the past.
That's exciting to actually finally
get you on the show and get some
of your insights out to the broader community,
so thank you for coming on.
Today we're going to be talking about
Azure Advisor signals and more specifically, what are they.
Because personally I don't know a ton about them and I have
a feeling a lot of our viewers might be new to these as well.
I'd love to just toss it to you and say,
what are Azure Advisor signals?
>> Exactly, so Azure Advisor is a service
that we have in our multiple services in Azure.
In the signals are the actual advice that you get,
which we are building with the product groups.
When I say we, I mean,
the SQL Insiders,
we've been building individual signals
that are going to be exposed to you as a recommendation.
I can talk a bit more when we're looking at the portal,
so folks will be more familiar when they see it there.
>> Yeah, definitely want to see
a demo that would be very exciting.
Before we get into the demo,
another question for you is,
you said that you've been working to create these signals like how
do SQL Insiders and folks like
yourself create Azure Advisor signals?
>> We have internal tools where we will get
the asks from our customers and turn them in practical terms,
text that will show up in
your screen with directions on how to fall,
what to do to fix whatever we found
out that was outside of best practices
or anything that we can make it to
improve the service that we're advising customers about.
It's a set of internal tools that we will
program and make it show up as advice.
>> When we say Azure Advisor,
this is really coming from experts like
yourselves that are working with
customers, seeing these things show up.
That's awesome to see.
If someone's watching this video
or they have an idea for an advisor signal,
is there a way that they can collaborate with you and other
SQL Insiders to get that in the portal for them?
>> Yes. Thank you so much for
bringing that up because I would love to
have folks just adding their requests here on the channel.
Just tell us what you would like to be advised about.
How we can help you improve your experience with Azure?
From your inputs, from anything you put out there,
will read those and try and see if we can transform
them into actual signals or advice back to you.
>> Awesome, no I love that.
Viewers go ahead, leave a comment and let us
know what you want to see in Azure Advisor signals.
Now let's take a deeper look.
What these things look like,
how we can learn more about them, what they are.
>> Let's do it. The first area
that I wanted to share with everybody is the actual documentation.
You see here the Get Started with Azure Advisor.
This document will guide you to understand what they are,
what they do, what's already present.
You can just go over
the entire documentation you see here on the left.
More topics that will give you
a better understanding on how you can contribute with us,
to help us help you have
a better experience with the advice that you get on your portal.
You'll see the final result of these advices.
As you can see here on the right-hand side,
we have cost, security,
reliability, operational excellence, and performance,
under the advisor area of your portal.
Here you can see that on my subscription,
I have a 91 percent score,
and that's based on the number of advices that I'm
getting based on what we already have built in.
For example, under Security,
you'd see all these 28 advices
or signals that we have created already,
and I will use this one as an example.
My SQL servers should have active
Directory Administrator provisioned and I don't.
If I click there,
the advice will be to actually do it.
You'll see here at description,
and we have also remediation steps
that will tell you how to be compliant.
Also what actual service this is being referring to.
When you are thinking about what you'd
like to have us develop for you.
Taking consideration the existing ones in this format.
Where you have the description of
the steps in the affected resources,
and we would love to go and
implement those for you as much as we can.
Going back to the Advisor main menu here,
you see that I have security costs,
all of them separated and in what we
call a well-architected framework.
This knowledge about these advisors or
these advices come from
the best practices that the field has been collecting,
and that's the work of the SQL Insiders on talking to customers,
learning about what they need help with,
to being compliance with all these pillars that you see
there and to have you experience Azure,
the best way possible by fixing whatever is out of compliance.
That's the idea and that's the work we've been doing,
and we'd love to have you contributing to it as well.
>> Awesome, thanks so much for your time.
I learn a lot in this episode,
I'm sure our viewers said too.
You'll definitely want to leave a comment and
let folks like Roberto and
the other SQL Insiders know what you want to see next here.
That's a really exciting way to make an impact.
As folks just get started with this,
do you have any advice for people?
>> Certainly look at
the needs that you have for your own organization.
For example, you already have something similar at 80 percent
of capacity on my usage.
When it's getting to 80 percent,
someone telling me that it's getting to that number.
Look at what is important for your organization, your solutions,
and see how we could create something that would help
you not getting to problems with it.
>> I love that real-world example and how people can get advice.
For our viewers as we wrap,
leave us a comment and let us know what you want to see in
these Azure Advisors Signals
specifically related to databases or really anything.
Also, we'll put some links in
the description for you to go learn more.
Roberto, again, thanks so much for coming on the show.
If you like this episode,
go ahead and give it a like subscribe to our channel
and we hope to see you next time on Data Exposed.
[MUSIC]