Category: T-SQL

2022-09-05

Download All SSRS Reports using PowerShell

There is a nice easy way to download all SQL Server Reporting Services (SSRS) reports in one go. It can be achieved by using PowerShell and the SOAP API that exists for SSRS. Create a new file in Notepad. Add the script further down to new Notepad file. Update SSRS URI and Report Download Location. […]

Get Substring by text in SQL

In Microsoft SQL, the SUBSTRING allows you extract part of a string using a start index and length. For example: SELECT SUBSTRING(‘hello world’, 2, 3) Results in an output of ‘ell’. However, there is no ability to select the start and end of the sub-string using known letters or words. The SQL example shown below […]