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: )

5,840 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,157 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

858 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

8,455 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: )

34,818 reads

Blogs

Replicate permissions to new Login/User with dbatools

By

Continuing to share tips and tricks using dbatools like the Refresh databases that belongs...

SQL Server Sample Databases

By

[MSSQLFUN & Decode ITeS becomes a family of 1500 individuals across the globe. Please...

Using WAITFOR to Test Slow Code–#SQLNewBlogger

By

Another post for me that is simple and hopefully serves as an example for...

Read the latest Blogs

Forums

The Challenges of Working Under Quarantine

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Challenges of Working Under...

Upgrade SQL 2008R2 Cluster to SQL 2017

By AdamJSawyer

Hi, I've been asked to develop an implementation plan for upgrading a SQL 2008R2...

The Basics of Using a Sequence as a Table Default

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Basics of Using a...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers