>> Learn how you can learn about all the lessons
learned from the Trenches on Azure SQL Database and
Azure SQL Managed Instance from the experts
on this special blog series this week on Data Exposed.
[MUSIC]
>> Hi, I'm Anna Hoffman and welcome to
this episode of Data Exposed.
Today we have a special episode
planned for you as we're going to be talking about
the Azure Database Support blog and
some other really exciting things
and lessons learned along the way.
To talk about this with me,
I bring on Jose.
Jose, thanks so much for joining us today.
Can you tell us a little bit about what you do?
>> Thank you so much, Anna. Thank you so much to be here.
My name is Jose Manuel Jurado.
I am working as escalation engineer from
customer service support for
technologies about SQL Managed instance.
I have been working for Microsoft by now,
11 years and I
support also multiple things about SQL Server world,
let's say SQL hybrids,
SQL VMs, etc
>> Awesome. You have your hands on
all the different SQL flavors and I think you're the guy to
talk to you when it comes to talking about this amazing set
of blog posts that are hosted on the tech community page.
Today we're going to be talking about the lessons learned from
the Trenches blog series that I believe was
started by you sometime ago.
We'll learn more about it.
I wanted to start by actually asking you,
how long have you been putting
together this series and what really is the series?
>> Well, you can see it's around
six years right now from 2016.
We wrote a lot of articles in this blog.
At the beginning, we boost
this post in MSDN
and after these content was migrated to the community.
Also we have other articles
about MySQL and Postgres
but mainly is about SQL DB Managed Instance.
>> Okay, got you. When it comes to thinking
about the topics like this topic you're showing or other topics,
obviously these topics are getting a lot of views.
I can see. But how do you go about
choosing which topics to post about?
>> Well, as you can see here we have many topics.
I think that, in summary,
any topic that we can
increase the customer experience using SQL DB Managed Instance.
We know that working
with our customer, working with the community,
we have different roles, different skills.
For this reason we have articles about configuration,
monitoring and performance,
connectivity, work around,
step and tricks that we
found working daily with our customers and community.
>> Got it. I think this is
really interesting example or
series because you-all are actually working with customers,
seeing these issues come up
time and time again and then say, "Hey,
let's democratize this knowledge and get it out to folks so that
they can learn and grow on their
own without necessarily needing our help."
I think it's really awesome what you-all are doing.
Now, I believe it's not just you
writing these blogs or I could be mistaken.
Who else are writing these blogs?
What types of authors are writing these?
>> Well, first of all,
we have the honor to have
this opportunity to provide
this article because we're working with the customers.
For us it's an honor to work with them. Who are?
Well, I think that
almost all the engineers that we have in Support right
now working as support engineers
with Azure SQL DB Managed Instance.
We have other engineers or people from Microsoft that they
want to elaborate or collaborate with
us in other articles but mainly it's this.
It's very important to mention this because we thought
this contribution was not possible to have right now.
One thing that we found that is
a good resource to find information about,
as I mentioned before, workarounds, etc.
As you can see here, for example,
many things about how to connect with Azure Data Factory,
issues that we have about subscription failover groups, etc.
We have many starting in US and India and Europe and in England
>> Awesome. That's awesome to see that
everyone's contributing and sharing that knowledge.
I know there's a lot of topics that
go on and I know there's a lot of things that
get covered but why are you actually
going through the effort
of writing these blogs and publishing them?
>> Yes. Is a very good question, Anna,
because when we started six years ago working at the beginning,
because we started more or less on the beginning with Azure,
we thought that it's very important
to share our experience that we are every day with customers.
For the reason you could see one of the topic that we have right
now to automate the Azure SQL DB index and
statistics or other topics that we have about how to troubleshoot.
On VM, this is the experience that we
are working in the cases because we have
the great privilege to air
more details about the daily by day or
day-by-day about this product.
Also, as you can see here for example,
how we are able to fix
a problematic index spool operator that we have.
Or for developers, for example,
we know that our developer are very important for us,
how to capture when they run a TSQL command statement timeout etc.
On VM is sharp on
this experience and also try to be
another resource where customers are moving to Azure,
what other issues that they could find,
useful information about experience from
another customer because on VM is based on customer support.
We could summarize that we
want to increase the customer experience.
I think that is very important that if you are having
some problems or you need
to sort other things or you need more information,
beside public information that we have,
beside that expose that we have beside multiple things is also you
have this blog in order to find more information about it.
>> Got it. Now, makes a lot of sense.
One question that I'll put you on the spot in it's like,
I know there's so many blogs out here because I read them
every month and I talk about them in our news updates series.
If you're a customer and you have
some problem or issue
and you're thinking maybe there'll be a solution here,
how do you recommend folks navigate that?
Should they go search the web and
include like Azure DB support in their query.
How can they find
these workarounds if they're looking for a specific one?
>> It's a very good question.
Even we are working on it because right now we have a lot
of articles that we need to find information.
In this case, basically,
you strive to search the main concept,
the main problem that you have,
let's say errors that you have, several other things.
For example when you type timeout
and you click in the "Search" button,
you can see all the articles that we have.
Basically right now, for example,
we have to learn about what is the comparison,
for example, when we have
remote query timeout against applications command timeout.
Because, for example,
this topic it's about
that we have many questions from customers say, "No,
it's running from SQL Server
connecting to Azure SQL database I got and timeout.
Why is the reason?
Basically searching the data through the search.
We are right now in the process in order
to add more search engine.
Much broadly in two or three months we are going to change
something in terms of try to explain,
for example, here topics about categories,
to make more easy to our customers to
find the right articles for them.
>> Awesome. I love that tip of how to search.
I didn't even know you could search like that.
Also it's cool to get the insight
that you-all are thinking about it as
well and so stay tuned maybe there'll be
some easier ways to navigate through.
Jose, I just really want to thank you for coming on the show.
Personally, I learned a lot about the backstory,
the value, why you-all are doing what you're doing,
and I just want to encourage all our viewers to check the link in
the description or do
a quick search for Azure Database Support blog.
You-all are always posting great stuff pretty regularly as well.
Before we close, I just wanted to check
and see if there were any final tips,
tricks or comments that you might have for our viewers, Jose.
>> No. Thank you so much for giving us
the opportunity to share
some several minutes with you and with the community.
I hope that this blog that
we spent a lot of time working on these will be
useful for the customer experience
working on Azure SQL Database Managed Instance.
>> Thanks so much. Yeah, I think you can already
tell by the views that it's very
helpful to our customers and I hope
maybe this helps quite a few new people to the blog.
If you're watching this video,
go ahead give it a like, leave us a comment,
and let us know what you think of
the Azure Database Support blog series and
all the lessons learned from the Trenches.
We hope to see you next time on Data Exposed.
[MUSIC]