Looking at your color chart and the way it is ordering it, to me it looks like you are ordering by region (North America, Europe, Pacific) first and by the...

I am not aware of any tools that do this automatically for you, but that doesn't mean there are not any.

Where I work, we don't actively monitor for things like...

I know we use SQL Aliases at my work and they can be a pain.  They are nice once they are set up and working, but what if a developer...

Quick check on your query, and if you look at the 3rd parameter to Substring (the LENGTH portion) you have this:

LEN(output_response_xml) - LEN(LEFT(output_response_xml, 
CHARINDEX ('>Thank you', output_response_xml)))...

To add to Steve's comment, there is more overhead than just the dataype overhead on a row.  On top of the overhead by VARCHAR and NVARCHAR, you also have the...

When I run your query with the date set to 21/05/20, the WEend Raised - Sund is the 24th and the Thursday one is the 21st.  Does this not match...

If you have the Russian language installed in Visual Studio with SSMS version 18.5, it lets you pick that from the settings.  I expect it is similar with SSMS 13. ...

Oh, it didn't come out wrong, I was just admitting that someone on here (ie me) with a lot of posts and been a DBA for nearly 10 years and...

To add to Jeff's reply, best practice is not always how you should set things up either.  Best practice is to use Windows Authentication and not use mixed mode.  I...

Have a look at Database Health Monitor.  It will give you that info and a whole bunch more.  Plus it is free!

That being said, using an automated "build" or "drop"...

To get the "VALUE" of the Property you could use:

ItemValue = q.n1.value('(.)[1]','VARCHAR(4000)')

To get only the case where ItemValue is "Value", you should be able to toss that...

One guess on this - are you closing the connection and committing the transaction in your application code?

When I've seen "stuck transactions" like that, it is often caused by the...

Is this what you are looking for:

https://docs.microsoft.com/en-us/analysis-services/instances/log-operations-in-analysis-services?view=asallproducts-allversions

I am not an expert on Browser Service either, but I am not sure it actually adds much security.  If someone really wants into your system, a port probe isn't...

So just to confirm, the stored procedure is the EXACT same query?

That is, you said the following query works:

EXEC sp_execute_external_script
@language = N'Python',
@script = N'
import pandas as pd
from...