The standard SharePoint 2013 top navigation menu just wasn't blowing my hair back. There are some decent examples of how to style the top menu but nothing close to what I was looking to do. I wanted a Mega Menu type layout without heaps of flair which was simple to implement and easy for others …
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 »
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 »
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 »
If you are diving deep into SSIS you're probably familiar with the fancy string manip needed to get your file names and folder paths to line up with various date structures and formats. Here's a few I've used recently that might come in handy. Feel free to offer improvments and supplements. Month Date Short Year …
I needed a way to programmatically get all of the workflows from all site collections and webs. PowerShell looks to be the best answer. This script returns all items in all sites, webs and lists with workflow attached from the application level. It then outputs a file with a pipe separated list of everything.
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, …