SSRS – Bit Field (sql type) format

SQL Server Reporting Services

Bit field (sql type) with the format Yes/No:

=IIf(Fields!<MyBitField>.Value=TRUE, “Yes”, “No”)


Categorie:SQL Server

Sharepoint – updated Tools

Common (legacy) Tools used for Paltform maintenance and governance:

Updated Tools (Sharepoint 2013):

ULS Viewer updated:


Lesson Learned

“Just Because You Can Doesn’t Mean You Should”

è la versione americana molto simile a “Se funziona quanto basta, non toccar se no si guasta”

Pappagalli di valore

Un collezionista di pappagalli parlanti e imitatori entra in un negozio specializzato per comperare qualche nuova “scoperta”. Il negoziante soddisfatto di avere quello che fa per il cliente gliene fa vedere tre: uno giallo, uno rosso e uno blu. “Quello giallo costa 30.000 euro” dice il negoziante” perché sa fischiare tutta la parte strumentale della Traviata ! Quello rosso costa 50.000 perché sa cantare tutti ruoli di tutta la parte lirica. Quello blu costa invece 100.00″. Il cliente: “Chissà cosa sa fare quello blu che costa così tanto?!”.

Il negoziante: “Non lo so, è arrivato solo questa mattina. Ma ho sentito che gli altri due lo chiamano Maestro!”.



Categorie:Ludoteca Tag:

Sharepoint – move subsite to a new site collection (and new database)

Sometimes we need to rearrange large size content database into smaller pieces to make each lower than 100 GB (Best Practice)

This is easy enough if we had organize the content in sitecollections, in this case we can move the sitecollection using the powershell command:

Move-SPSite <http://ServerName/Sites/SiteName> -DestinationDatabase <DestinationContentDb>


On the other hand the issue requires more effort if we must extract a subsite and create a dedicated Site Collection/DataBase.

Here are some steps and work to be done to achieve the goal:


STEP-1: Some assesment and planning occurs first:

-Identify  used Content Types

-Identify used Features

-Identify used Workflows

-(Identify Parent Site Template)

-(Identify Parent Site Language)


STEP-2: Create a site collection MySiteColl1 (with a  dedicated DataBase: WSS_Content_MySiteColl1)



-Enable Features

-Enable WorkFlows

-Copy Content Types

This is quite easy using Gary Laponte tool:



Add-PSSnapin microsoft.sharepoint.powershell -ErrorAction SilentlyContinue
# My Content Types
Copy-SPContentType -SourceContentType $MyCtype -SourceWeb $siteSRC -TargetWeb $siteDST
Write-host "$MyCtype Copied"


(Backup the entire SiteCollection so we have a recovery point just in case of Rollback)

Export Site

STSADM (export/import)

Stsadm - o export -url http://source/mysite1 -includeusersecurity -versions 4 -filename \\backup\mysite1-Backup.bak


Powershell  (export/import)

Export-SPWeb http://srv1/mysite1 -includeusersecurity -includeversions All -path \\backup\mysite-Backup.bak

(then rename your Site so  your users are not able to use it anymore)



Import Site

STSADM (export/import)

Stsadm -o import -url http://destination/mysitecoll1/mysite1 -filename \\backup\mysite1-Backup.bak -includeusersecurity


Powershell  (export/import)

Import-SPWeb http://destination/mysitecoll1/mysite1 -path \\backup\mysite1-Backup.bak -includeusersecurity

(then create a new Link to the new Site)




Delete Old Site.

Pay attention: this operation is not simple as it seems to be if the old site is big enough (more than 20GB)

In my opinion, best way to do it is deleting the old site piece by piece (working on libraries)

Another tip is to turn off the Recycle Bin (just for the time we do this specific maintenance).


Categorie:SharePoint Tag:

Citazione di un comandante in proprio

…Anzi non sono nessuno per giudicare. So solamente che ho una antipatia innata per i censori, o probiviri… ma, soppratutto sono i redentori che mi disturbano di più.

Corto Maltese

Categorie:Citazioni, Fumetti Tag:

Sharepoint – Extract Farm Solutions

Powershell script to extract Farm Solutions (.wsp files)

#Add-PSSnapin Microsoft.Sharepoint.Powershell
$Folder = “C:\TEMP\mySolutions\”
Set-Location $Folder
write-host “download FARM Solutions”
$Farm = Get-SPFarm
foreach(SSol in Get-SPSolution) {
write-host “download Solution:” $
$file = $Farm.Solutions.Item($
Get-SPSolution > $Folder’ExtractSolution_out.txt’