SharePoint 2010 | @SPJeff

New Version of SSRS add-in released for SharePoint 2010

July 28, 2012 in Uncategorized

Today a new download showed up on my RSS feeds and I wanted to take a minute to compare this new MSI file against the trusty old MSI I’ve used for so long now. As you know, the SharePoint 2010 Prerequisites installer requires “rsSharePoint.msi” to be loaded before you can install SharePoint 2010. Below is the OLD link for SSRS which most people use today for cool stuff like a PowerShell script to download all Prerequisites for offline install. as well as the NEW link. The release of Service Pack 2 for SQL 2008 R2 seems to be triggering lots of new downloads so it might be worthwhile to make sure you’re SharePoint front end binaries match the backend SQL server version. If patching SQL to SP2, then it’s probably a good idea to update the web front end components and look for the “4000” version number.

NEW – SP2	http://www.microsoft.com/en-us/download/details.aspx?id=622	10.50.4000.0	7/27/2012	36.9 MB
OLD – SP1	http://www.microsoft.com/en-us/download/details.aspx?id=28132	10.50.2500.00	11/3/2011	36.9 MB

It might be a good idea to download the most recent add-in for any new server installs. There appear to be updates to most all files, but “sqlserverspatial.dll” grew more than most possibly hinting at better geographic data support.

Old Package – File Version Detail

New Package – File Version Detail

.program filescommon filesmicrosoft sharedweb server extensions14templateadminreportserverreportserverproperties.aspx
.program filescommon filesmicrosoft sharedweb server extensions14templateadminreportserverreportserversitesettings.aspx
.program filescommon filesmicrosoft sharedweb server extensions14templatelayoutsreportserverrsaction.aspx
.program filescommon filesmicrosoft sharedweb server extensions14templatelayoutsreportserverrsintegrationresults.aspx
.program filescommon filesmicrosoft sharedweb server extensions14templatelayoutsreportserverrsviewerpage.aspx
.program filescommon filesmicrosoft sharedweb server extensions14templatelayoutsreportserversitelevelsettings.aspx
.program filescommon filesmicrosoft sharedweb server extensions14templatelayoutsreportserverstyles1025sqlrvdefault.css
.program filescommon filesmicrosoft sharedweb server extensions14templatelayoutsreportserverstyles1026sqlrvdefault.css
.program filescommon filesmicrosoft sharedweb server extensions14templatelayoutsreportserverstyles1027sqlrvdefault.css
.program filescommon filesmicrosoft sharedweb server extensions14templatelayoutsreportserverstyles1028sqlrvdefault.css
.program filescommon filesmicrosoft sharedweb server extensions14templatelayoutsreportserverstyles1029sqlrvdefault.css
.program filescommon filesmicrosoft sharedweb server extensions14templatelayoutsreportserverstyles1030sqlrvdefault.css
.program filescommon filesmicrosoft sharedweb server extensions14templatelayoutsreportserverstyles1031sqlrvdefault.css
.program filescommon filesmicrosoft sharedweb server extensions14templatelayoutsreportserverstyles1032sqlrvdefault.css
.program filescommon filesmicrosoft sharedweb server extensions14templatelayoutsreportserverstyles1033sqlrvdefault.css
.program filescommon filesmicrosoft sharedweb server extensions14templatelayoutsreportserverstyles1035sqlrvdefault.css
.program filescommon filesmicrosoft sharedweb server extensions14templatelayoutsreportserverstyles1036sqlrvdefault.css
.program filescommon filesmicrosoft sharedweb server extensions14templatelayoutsreportserverstyles1037sqlrvdefault.css
.program filescommon filesmicrosoft sharedweb server extensions14templatelayoutsreportserverstyles1038sqlrvdefault.css
.program filescommon filesmicrosoft sharedweb server extensions14templatelayoutsreportserverstyles1040sqlrvdefault.css
.program filescommon filesmicrosoft sharedweb server extensions14templatelayoutsreportserverstyles1041sqlrvdefault.css
.program filescommon filesmicrosoft sharedweb server extensions14templatelayoutsreportserverstyles1042sqlrvdefault.css
.program filescommon filesmicrosoft sharedweb server extensions14templatelayoutsreportserverstyles1043sqlrvdefault.css
.program filescommon filesmicrosoft sharedweb server extensions14templatelayoutsreportserverstyles1044sqlrvdefault.css
.program filescommon filesmicrosoft sharedweb server extensions14templatelayoutsreportserverstyles1045sqlrvdefault.css
.program filescommon filesmicrosoft sharedweb server extensions14templatelayoutsreportserverstyles1046sqlrvdefault.css
.program filescommon filesmicrosoft sharedweb server extensions14templatelayoutsreportserverstyles1048sqlrvdefault.css
.program filescommon filesmicrosoft sharedweb server extensions14templatelayoutsreportserverstyles1049sqlrvdefault.css
.program filescommon filesmicrosoft sharedweb server extensions14templatelayoutsreportserverstyles1050sqlrvdefault.css
.program filescommon filesmicrosoft sharedweb server extensions14templatelayoutsreportserverstyles1051sqlrvdefault.css
.program filescommon filesmicrosoft sharedweb server extensions14templatelayoutsreportserverstyles1053sqlrvdefault.css
.program filescommon filesmicrosoft sharedweb server extensions14templatelayoutsreportserverstyles1054sqlrvdefault.css
.program filescommon filesmicrosoft sharedweb server extensions14templatelayoutsreportserverstyles1055sqlrvdefault.css
.program filescommon filesmicrosoft sharedweb server extensions14templatelayoutsreportserverstyles1058sqlrvdefault.css
.program filescommon filesmicrosoft sharedweb server extensions14templatelayoutsreportserverstyles1060sqlrvdefault.css
.program filescommon filesmicrosoft sharedweb server extensions14templatelayoutsreportserverstyles1061sqlrvdefault.css
.program filescommon filesmicrosoft sharedweb server extensions14templatelayoutsreportserverstyles1062sqlrvdefault.css
.program filescommon filesmicrosoft sharedweb server extensions14templatelayoutsreportserverstyles1063sqlrvdefault.css
.program filescommon filesmicrosoft sharedweb server extensions14templatelayoutsreportserverstyles1087sqlrvdefault.css
.program filescommon filesmicrosoft sharedweb server extensions14templatelayoutsreportserverstyles2052sqlrvdefault.css
.program filescommon filesmicrosoft sharedweb server extensions14templatelayoutsreportserverstyles2070sqlrvdefault.css
.program filescommon filesmicrosoft sharedweb server extensions14templatelayoutsreportserverstyles2074sqlrvdefault.css
.program filescommon filesmicrosoft sharedweb server extensions14templatelayoutsreportserverstyles3082sqlrvdefault.css
.program filesmicrosoft sql server100keyfile1033rssharepoint_keyfile.dll
.windowsgacmicrosoft.reportingservices.sharepoint.ui.serverpages.dll
.windowsgacmicrosoft.reportingservices.sharepoint.ui.webparts.dll
.windowsgacmicrosoft.sqlserver.types.dll
.windowsgacrssharepointsoapproxy.dll
.windowsgac_32microsoft.sqlserver.types.dll
.windowssystem32sqlserverspatial.dll
.windowssyswow64sqlserverspatial.dll

Tags: Reporting Services, SharePoint 2010, SQL Server 2008 R2, SSRS
No Comments »

EmptyList.ps1 – delete all SharePoint list items with PowerShell

March 21, 2012 in Uncategorized

Recently I needed to empty an InfoPath Form Library by deleting all of the items and skipping Recycle Bin. Datasheet view is great for small lists (a few hundred rows) but it doesn’t perform as well on large lists. Also, skipping the Recycle Bin is a unique requirement best handled with server side code. See the below PowerShell script for how to easily “empty” any SharePoint list or library. This works with both SharePoint 2010 and SharePoint 2007 (MOSS 2007). NOTE – Use this script carefully, it is really good at deleting. Smile

[System.reflection.Assembly]::LoadWithPartialName("Microsoft.SharePoint")
 
$site = Get-SPSite "http://sitename/"
$web = $site.rootweb
$list = $web.Lists["Shared Documents"]
$caml=""
#optional filter
#<Where><Eq><FieldRef Name=""ContentType"" /><Value Type=""Text"">Form</Value></Eq></Where>"
 
$query=new-object Microsoft.SharePoint.SPQuery
$query.ViewAttributes = "Scope='Recursive'"
$query.Query=$caml
 
$items=$list.GetItems($query)
Write-Host $items.Count

$items | % { $list.GetItemById($_.Id).Delete() }
 
$web.Dispose()
$site.Dispose()