Setting up SQL Server Database Mail

Today I am going to write about how to setup SQL Server Database Mail.  This is very handy as the server will be able to email you query results, whether a maintenance job succeeded or failed, status results, etc. Continue reading Setting up SQL Server Database Mail

Add Parameter to SSRS Report

In a previous posting, I showed you how to create a Vendor listing report using SSDT and SSRS.  This was a handy report, but it showed all of the data in the tables and you could not search on specific criteria.  This week I am going to show you how to create a parameterized version of the report so you can search by area code or really any part of the phone number.

Continue reading Add Parameter to SSRS Report