North Texas SQL Servers Users Group

Dallas SQL Saturday 2019 Info

     4 Full Day Sessions for Ridiculously Low prices. One of them has already sold out. Tell your boss, "Hey, I can get a $1200 class for only $139!". Seriously, it's that much of a steal! And these speakers are
Internationally Known, Book Authors, and Respected Authorities. Good gracious folks, what's holding you up? Can't miss that Friday meeting?


 

  More than 60 Sessions throughout the day, 10 different sessions to choose from in any particular hour. Absolutely FREE. What's to lose? Register now!

 


 

   The MAY 2019 meeting is sponsored by Red Gate. We will have 1 big raffle prize and many smaller raffle items to give out. We will also announce their upcoming SQL in the City, taking place next week in Austin, TX. Thank you Redgate!


Next Meeting: Thu, Jun 15 2017

NTSSUG 15 JUN 2017

Language: English
Event Type: In-Person
Online Meeting URL: None
RSVP URL: 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

When

iCal
UTC : Thu, Jun 15 2017 23:00 - 00:30
Event Time : Thu, Jun 15 2017 18:00 - 19:30 Central Daylight Time
Your Local Time: Thu, Jun 15 2017 23:00 - 00:30

Where

7000 North Highway 161
Irving, Texas

Direction: None

Featured Presentation

Managing SSRS Reports using Powershell

Speaker: Russel Loski, Senior Developer Loski Data Movers

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.

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.

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