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,248 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,105 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

55,063 reads

Blogs

How I implemented database migration on AWS using AWS DMS

By

As a Software Engineer, I would like to replicate a copy of my database...

My personal experience dockerizing a Rust Application: Deploy to AWS ECR using Github Actions

By

I have heard about many interesting things about programming in Rust and I decided...

Terraform Elastic Jobs

By

I did a couple of other posts on Elastic Jobs. But now I want...

Read the latest Blogs

Forums

Unable to add the database back into AG

By LearningDBA

I took the full backup of the DB Backup database MyDB to disk =...

Planes, Trains, and Automobiles

By Ryan Booz

Comments posted to this topic are about the item Planes, Trains, and Automobiles

How do I get a certificate for a SQL Server database?

By Doctor Who 2

I'm working on a new application at home, using SQL Server 2019 Developer Edition....

Visit the forum

Question of the Day

Synapse Analytics History I

Before Synapse Analytics was a service in Azure, what was the name of the analytic data warehouse platform in the Azure cloud?

See possible answers