Stan Kulp

SSRS Audit: All reports executed/not-executed during previous 30 days

This article presents a pair of queries and reports that reads the ReportServer.dbo.ExecutionLog table to list all SSRS reports that were executed or not-executed in the past 30 days, how many times they were executed, and who executed them.

4.93 (15)

2020-01-17 (first published: )

6,152 reads

Parse Data from a Field Containing Multiple Values using CROSS APPLY

It is possible for a field in a character-delimited text file to contain a list of further-delimited values instead of the customary single value. This article demonstrates how to load such a file into a staging table, then use a CROSS APPLY query to parse the list of values into a related table.

3.27 (15)

2019-06-07 (first published: )

9,493 reads

Generate QR Code® barcodes in an SSRS report with the QRCoder library

QRCoder is an open source implementation of standards specification ISO/IEC 18004, which defines the requirements for two-dimensional QR Code symbols. It is a more complete implementation of the standard than the open source QRCode4CS library that was used in a previous article.

5 (2)

2019-04-11

981 reads

Generate QR Code® barcodes in an SSRS report with the QRCoder library

QRCoder is an open source implementation of standards specification ISO/IEC 18004, which defines the requirements for two-dimensional QR Code symbols. It is a more complete implementation of the standard than the open source QRCode4CS library that was used in a previous article.

4.67 (9)

2018-10-22

9,651 reads

How to execute an SSIS package from the command line or a batch file

An SSIS package that is executed on an ad hoc basis can be run from Business Intelligence Development Studio easily enough, but a package that is going to be run on a regular schedule is best executed through a batch file using the DTExec.exe command line utility.

4.86 (14)

2018-08-31 (first published: )

39,755 reads

Blogs

SQL on-demand in Azure Synapse Analytics

By

The new SQL on-demand (to be renamed SQL serverless) offering within Azure Synapse Analytics...

My First Hand-built AWS CodePipeline

By

I’ve just completed my first, successful, AWS CodePipeline. I’m sorry to say it took...

Fixing Broken Pip

By

I’ve got Python 3.8 on my machine, and recently I got a note that...

Read the latest Blogs

Forums

Using Begin Tran for a select statement?

By Steve

Hello All I have an overly complex SELECT statement that I am married to...

Exclude square bracket and text from start or end of string

By PSB

Hi, I want to remove square brackets and text from either start of string...

MCSA Certifications - SQL2016

By dax.latchford

Dear all - Firstly apologies if my post isn't specifically for this particular forum...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers