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.

3.86 (7)

You rated this post out of 5. Change rating

2018-03-23 (first published: )

6,335 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.

4.3 (10)

You rated this post out of 5. Change rating

2014-12-09

13,524 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.

4.67 (9)

You rated this post out of 5. Change rating

2014-11-04

59,569 reads

Blogs

Measuring What Matters: Operationalizing Data Trust for CDOs

By

Trust is the currency of the data economy. Without it, even the most advanced...

A Small LLM Fail

By

Another test with Copilot in SSMS (v22 P3) that didn’t go so well. This...

SQL Server Versions: Out With the Old, In With the Supported

By

If your production SQL Servers are still running 2016 (or older) you’re basically banking...

Read the latest Blogs

Forums

Create an HTML Report on the Status of SQL Server Agent Jobs

By Nisarg Upadhyay

Comments posted to this topic are about the item Create an HTML Report on...

ETL Framework In Production

By Rahulmsb5

Hello, I am leveraging Python within SQL Server Integration Services (SSIS) packages, primarily through...

SQL Server Ghosts

By Steve Jones - SSC Editor

Comments posted to this topic are about the item SQL Server Ghosts

Visit the forum

Question of the Day

SQL Server Ghosts

For Halloween, what are ghost records?

See possible answers