Stan Kulp


SQLServerCentral Article

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 (4)

2020-11-20 (first published: )

4,497 reads

SQLServerCentral Article

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

7,939 reads

SQLServerCentral Article

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

11,095 reads

SQLServerCentral Article

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

20,255 reads

SQLServerCentral Article

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

63,135 reads

Blogs

A Live Conference Experience at Data Minds Connect 2021

By

Last week I was privileged to attend a live conference in Belgium. dataMinds Connect...

Daily Coping 25 Oct 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

A New Form of Address: Mx

By

When I was presenting at the dataMinds Connect conference, I called on someone in...

Read the latest Blogs

Forums

Need advice with backup plan and transaction log file

By dubem1-878067

I am missing something I guess.  Here's our backup Plan Full backup weekly Differential...

cannot generate SSPI context

By premkuttan

We have one user who face this issue while connecting to SQL server ''Cannot...

Database Corruption - LOB

By database diva

Hello, I have recently inherited a SQL 2012 database (no backups available), running in...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

A Simple Error

See possible answers