admin

SQL Query to Get Reporting Services Report Permissions SSRS 2012

Sometimes you need a way to quickly get a list of users that have permissions to all of your SQL Server Reporting Services reports. This is especially true if you have fine grained permissions or use Active Directory roles that are constantly changing. The idea is simple; query the ReportServer database and find who has …

SQL Query to Get Reporting Services Report Permissions SSRS 2012 Read More »

SharePoint 2010 Display Form Sections Based on URL Querystring Parameters

So how can you display sections of your form based on where the item is in the approval process? Easy, some basic XHTML, a querystring parameter and javascript. The idea was have an Edit Item List Form that would show or hide sections based on when the item was in the approval process. I started …

SharePoint 2010 Display Form Sections Based on URL Querystring Parameters Read More »

SSIS Script Task to Upload a File to a Website using C#, HTTP Post with HttpWebRequest

Need a way to upload a generated file to a website using SSIS? The code below uses HttpWebRequest to make page requests, HttpWebResponse to get server responses and CookieContainer to hold the session data. The website required a session cookie along with login credentials. To complicate things even more the cookie was created on one …

SSIS Script Task to Upload a File to a Website using C#, HTTP Post with HttpWebRequest Read More »

Refresh Development from a Production SharePoint 2010 Farm Using Content Database Restore

In the real world it's nice to have a refresh cycle for your development farm. Usually it needs to happen after a large development project or some business process improvement. The problem is how to update your development site so that it mirrors your current production farm. One answer is to use the publishing infrastructure, …

Refresh Development from a Production SharePoint 2010 Farm Using Content Database Restore Read More »