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

jdbc:jtds:sqlserver://localhost:1433/Blog;instance=SQLEXPRESS;user=sa;password=pwd

Enable TCP/IP

if still Not able to connect from remote, need to open the port from the windows firewall settings.

UPDATE msdb.dbo.sysschedules SET msdb.dbo.sysschedules.owner_sid=job.owner_sid
FROM msdb.dbo.sysjobs job (NOLOCK)
inner join msdb.dbo.sysjobschedules jobsch (NOLOCK)on job.job_id = jobsch.job_id
INNER JOIN msdb.dbo.sysschedules sch (NOLOCK)on sch.schedule_id = jobsch.schedule_id