-
Download all Report Server RDL's
Thanks kindly to Vinay: http://bit.ly/1mfZY5n There is no option to download all RDL's at once from Report Server. This handy script will at least collect them ... -
An error occurred within the report server database
Today I experienced an error within SSRS Report Manager when attempting to modify the site schedules. I'd later find that editing any subscription on any ... -
Skydiving from 15,000ft: Wollongong Tandem Jump Experience
Something I have wanted to do for a long, long time now. I don't have a fear of heights. I love the adrenaline rush from anything ... -
Excel 2010 - Set Default Template
You'd think that saving a workbook as a template and have that template load automatically when you start Excel shouldn't be that hard, right? You'll ... -
Find SSRS subscriptions of an email address
I recently had the need to remove an email address from all SSRS subscriptions as a certain person was no longer with the company. Rather than ... -
Conditionally display end date if different to start date
With SQL Server Reporting Services (SSRS) and the power of AD HOC reporting, we'll offer a StartDate and EndDate picker for many, if not all ... -
Hide #DIV/0! From Excel Pivot Table
Conditional formatting #DIV/0! within Excel is easy enough, but that doesn't work in Pivot Tables. Luckily, there's an option within Pivot Table options that allows ... -
Create CSV from file names in Windows folder
I have several hundred files in a windows directory that I need to get into a CSV list for import into a SQL table. This ... -
Find the datatypes of a SQL #temp table
I'm sure you've done it a million times like I have: selected a chunk of data into a #temp table for some quick and dirty ... -
Excel Lookup - Maintain Date Format
Consider the following spreadsheet in Excel: I wish to perform a lookup on these fields to build a dirty INSERT into SQL list, however when ...
