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...

I am not sure on that one but the error is saying (based on google translate):

OSError WinError 10013 Access to a socket was not allowed due to the access rights...

Pretty sure putting the logins in the datareader role should handle this.

alternately, you could generate the script it with something like:

SELECT N'GRANT SELECT ON ' + name...

• This reply was modified 5 years, 9 months ago by Mr. Brian Gale. Reason: alternate option
• This reply was modified 5 years, 9 months ago by Mr. Brian Gale. Reason: fixing typo
• This reply was modified 5 years, 9 months ago by Mr. Brian Gale. Reason: added NOTE

As a guess on your data, it isn't returning multiple rows in the first select subquery.

I am guessing that in the table HumanResources.Employee, the BusinessEntityID column is unique.  So p.BusinessEntityID...

My understanding (experts correct me if I am wrong) is that if the conversion is potentially possible, but the conversion is invalid, then you get NULL.  If the conversion is...

If it was me, I would look at encrypting by certificate OR by passphrase.

To see some TSQL on it:

https://docs.microsoft.com/en-us/sql/t-sql/functions/encryptbypassphrase-transact-sql?view=sql-server-ver15

Use those examples but instead of displaying to screen, store it in...

To answer question number 2 about the folders, those are version numbers.  110 is 2012, 140 is 2017, 150 is 2019.

If you installed SSMS 18, it does not come with...

I think you need to change your query a little bit to something more like this:

CREATE FUNCTION [dbo].[LastBuyer1]
(@SC1 varchar(30))
RETURNS VARCHAR(3)
AS
BEGIN
DECLARE @LB VARCHAR(3);
WITH CTE AS
(SELECT TOP 1 Buyer,...

I was following this thread because I was curious about this too.  Thanks Anthony for the answer to it.

It also bring up the question, why would you want to restrict...