North Texas SQL Servers Users Group

Next Meeting

Thursday,

June

15

NTSSUG 15 JUN 2017

  • In-Person @ 7000 North Highway 161 Irving, Texas, United States (map)
  • 18:00 - 19:30 Central Daylight Time
  • Language: English

RSVP Here: https://www.meetup.com/North-Texas-SQL-Server-User-Group

Managing SSRS Reports
Using PowerShell and SSRS Web Services
 


By Russ Loski 

Summary: When you have to do something more than once, you should script it!  That’s true for SQL Server maintenance tasks.  It’s also important for Business Intelligence projects as well.  Microsoft has provided web services to manage your reporting service and to download reports in various forms.  In this session I demonstrate how to leverage these web services from PowerShell to handle common SSRS administrative tasks:  uploading and copying a report; checking the parameter values, setting the parameter defaults, scheduling a cache refresh.  I addition, I demonstrate how to download a report top PDF using PowerShell.  You will not only come away with a set of PowerShell scripts to manage your SSRS server, you will learn how to work around some of the less intuitive features of PowerShell to use and extend these scripts. 

Presenter: Russ Loski

Bio: Russ is the Director of Finance of the North Texas SQL Server User Group.  He began developing database applications beginning with SQL Server 6.5.  For much of the last 15 years he has worked as a contract database and ETL developer for various companies in Dallas Fort Worth and Bermuda.  His clients has included the Dallas Cowboys, Rave Motion Pictures and Bank of America.  Currently he works for Baylor Scott & White.  Russ blogs occasionally at http://www.sqlmovers.com.  You can follow him on Twitter @sqlmovers.

Meeting starts: 6:00 pm with food and a QA session

Presentation: 6:30 pm to 7:30 pm

Address: 
Microsoft Las Colinas Offices  
7000 North Highway 161 , Building LC-1  
Irving Texas 75039  
Map: https://goo.gl/maps/h9aWDZ6Z3wK2

Afterward socializing: If there is interest, we will gather at NYLO (1001 W Royal Ln, Irving, TX 75039) to casually socialize

Featured Presentation:

Managing SSRS Reports using Powershell

Russel Loski, Senior Developer Loski Data Movers

When you have to do something more than once, you should script it! That’s true for SQL Server maintenance tasks. It’s also important for Business Intelligence projects as well. Microsoft has provided web services to manage your reporting service and to download reports in various forms. In this session I demonstrate how to leverage these web services from PowerShell to handle common SSRS administrative tasks: uploading and copying a report; checking the parameter values, setting the parameter defaults, scheduling a cache refresh. I addition, I demonstrate how to download a report top PDF using PowerShell. You will not only come away with a set of PowerShell scripts to manage your SSRS server, you will learn how to work around some of the less intuitive features of PowerShell to use and extend these scripts.

About Russel:
Manipulating data has been passion for me for almost thirty years. I hate entering the same data twice and have tried many creative ways to move data from application to application. I continue to move data using various tools. I use custom scripts in Visual Basic and C#. I have developed Transact SQL Scripts to move data. My favorite tools are the Microsoft SQL Server ETL tools Data Transformation Services and SQL Server Integration Services. I have moved data as diverse as payroll data to national sports’ league data. I addition I have provided access to SQL Server data from ASP.Net applications, reports and Access front end applications.


Thank You to the 

PLATINUM

SPONSORS 

of our May 2018 

SQL Saturday!











Back to Top
cage-aids
cage-aids
cage-aids
cage-aids