Shawn

Microsoft MVP, PowerShell Enthusiast, major contributor to dbatools PowerShell module.
  • Interests: SQL Server, PowerShell, SSIS/Biml, SSRS

SQLServerCentral Article

Getting query text from SSMS into a CSV with PowerShell

You have times where you need to copy/paste something out of SSMS' grid view results pane that has a carriage return in it. Trying to copy/paste that data into Excel can be a headache and cause you to waste precious time reformatting. This just offers a tidbit of PowerShell code to help.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(7)

You rated this post out of 5. Change rating

2018-03-23 (first published: )

6,466 reads

SQLServerCentral Article

SSRS - Report for Stored Procedure with Multiple Values Passed

You created a report that passed three separate values to a stored procedure, simply enough. However, now the user comes back and they want the ability to select multiple values for the report to return data against. Check out this article for a walk-through on how to handle this request.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(10)

You rated this post out of 5. Change rating

2014-12-09

13,794 reads

SQLServerCentral Article

SSRS - Report for Stored Procedure with Parameters

You receive a request from an analyst for a report to be built from a procedure they wrote. It will require parameters based on values currently in the database and ones that allow free-typing. This article will provide a basic walk-through on handling this type of request.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(9)

You rated this post out of 5. Change rating

2014-11-04

60,505 reads

Blogs

The Book of Redgate: Fun with Images

By

We’ve celebrated our birthday many times at Redgate. In the Book of Redgate –...

Why companies use Palantir and how we help implement it in the Czech Republic

By

Discover how Palantir connects enterprise data, supports AI-driven decision-making and helps companies turn insights...

Why companies use Palantir and how we help implement it in the Czech Republic

By

Palantir is an American software platform that brings together business data from different sources...

Read the latest Blogs

Forums

Pay for Performance

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Pay for Performance, which is...

BCA KCP Gresik Kota Baru Hub/Wa. 0817-819-444

By Halo_BCA

WhatsApp:0817819444 Jl. Kalimantan No.76 Kavling, Blok RV 55B, Wonorejo, Yosowilangun, Kec. Manyar, Kabupaten Gresik,...

Alamat Telp BCA KCU TUBAN Hub/Wa. 0817-819-444

By layanan 24jam BCA

WhatsApp:0817819444 Jl. Panglima Sudirman No.35, Baturetno, Kec. Tuban, Kabupaten Tuban, Jawa Timur 62314

Visit the forum

Question of the Day

SQL Server Audit Failures

If I have a SQL Server Server Audit setup, what are my options for configuring the instance in the event it can't write to the audit log?

See possible answers