Is sharepoint installed on a separate server to the SQL server as well (I should expect so). You need to ensure that it's installed on your Sharepoint host as well.

Permissions are cumulative. So someone accesses SQL server via Windows Authentication, and they have their own login, but also they belong to two Active Directory groups that has access to...

I did just remember one concern with VSCode; if you ask it to store the password for your SQL Server login it keeps in it in plain Text on Ubuntu....

This topic is 8 years old...

I've certainly enjoyed having a play around with SSoL at home. I actually use it as my test bed more often than the instance on my laptop, as I've almost...

Use a CASE statement. For example:
CASE WHEN Value BETWEEN 0 AND 10 THEN 1 ELSE 0 END

Then use a GROUP BY on your Server Name...

Dynamic SQl is not really the way to go with this, I would say. How much control do you have over the way the parameters are passed (I.e. in delimited...

Lag works something like this:

SELECT m.monthIndex as CurrentMonthIndex,
       LAG(m.monthIndex) OVER (ORDER BY m.monthIndex) AS PreviousMonthIndex
FROM months m;
You can read about it in full...

Personally I think you'd be better off using a LEFT JOIN rather than right. It just reads that much better:
SELECT *
FROM months m
    ...