https://stackoverflow.com/questions/951419/how-many-windows-handles-in-use-is-too-many

SELECT has_perms_by_name(null, null, ‘ALTER TRACE’)
EXECUTE AS LOGIN = ‘testUser’;
–Verify the execution context is now login1.
SELECT SUSER_NAME(), USER_NAME();
SELECT has_perms_by_name(null, null, ‘ALTER TRACE’)

REVERT;
–Display current execution context.
SELECT SUSER_NAME(), USER_NAME();

SELECT name,type_desc,is_disabled
FROM master.sys.server_principals
WHERE IS_SRVROLEMEMBER (‘sysadmin’,name) = 1

https://docs.microsoft.com/en-us/sql/ssdt/previous-releases-of-sql-server-data-tools-ssdt-and-ssdt-bi?view=sql-server-2017

Queryparser, an Open Source Tool for Parsing and Analyzing SQL

Streamific, the Ingestion Service for Hadoop Big Data at Uber Engineering

ALTER function [dbo].[client_ashrae_get_committee_voting](@cst_key av_key)

RETURNS nvarchar(150)
as
begin
Declare @val nvarchar(30)
select top 1 @val = CASE when cmc_voting_flag= 1 THEN ‘Voting’
ELSE ‘Non-voting’
END

FROM mb_committee_x_customer cxc WITH ( NOLOCK )
INNER JOIN mb_committee Committee WITH ( NOLOCK )
ON Committee.cmt_key = cxc.cmc_cmt_key AND Committee.cmt_delete_flag = 0 AND cxc.cmc_delete_flag=0
INNER JOIN co_customer Customer WITH ( NOLOCK )
ON Customer.cst_key = cxc.cmc_cst_key
AND Customer.cst_delete_flag = 0
where cmc_cst_key = @cst_key

return @val
END

select [path], [name],convert(varchar(max), convert(varbinary(max), content)) as content from reportserver.dbo.catalog where content is not null and itemID ='<ID>’

https://community.powerbi.com/t5/Desktop/POWERBI-Desktop-Running-total-per-column/m-p/92057#M38839