ParallelFun

That's it...in T-SQL a 'select ... where someval...in @tablevar' can be over int or string. But in Oracle the IN will only work over number values, thus we must cast TO_NUMBER. That was fun =). SELECT TO_NUMBER(column_value) FROM XMLTABLE(<csv_string>)

Steps to migrate from SQL Server to Oracle for Shuts Project. 1.       Download and install Oracle Database 11g – Personal Edition – this edition offers the full feature set of Enterprise Edition and is targeted for development/staging. 2.       Download and install JDK 7. 3.       Upgrade the SQL Developer from 2.x to 4.0.0.12.84 4.       Launch SQL Developer and use the Migration workbench to capture an external database. a.       Click tools -> migration -> Create database capture scripts 5.       Copy the capture scripts to the target server. Execute OMWB_OFFLINE_CAPTURE.BAT and pass in parameters for username/password and target db. rem   %1 DBA login id rem   %2 password rem   %3 database name rem   %4 database server name 6.       Copy output of ...

A quick script works on both SharePoint 2010 and 2013. Make sure to update en-AU to the target locale you are after =). Enjoy! [System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SharePoint") $farm = [Microsoft.SharePoint.Administration.SPFarm]::Local $websvcs = $farm.Services | ? -FilterScript {$_.GetType() -eq [Microsoft.SharePoint.Administration.SPWebService]} $webapps = @() foreach ($websvc in $websvcs) { $NewLocale = "en-AU" foreach ($webApp in $websvc.WebApplications) { foreach ($site in $webApp.Sites) { Write-Host "Updating Site -" $site -ForegroundColor "Green"       $Webs = $site.AllWebs ForEach ($Web In $Webs) {    If ($Web.locale -ne $NewLocale)    {       Write-Host $Web.title "- " -NoNewLine; Write-Host "changing from" $Web.locale "to" $NewLocale -ForegroundColor "Green"       $Web.Locale = $NewLocale       $Web.Update()    ...

Installing SPS 2013 isn't a very smooth exercise..as a matter of fact neither was 2010 in the early days. But that said, it isn't too difficult to get by using PowerShell to correct or instantiate missing service applications. I've found that SSRS integration is a major pain in the butt. PowerPivot will install fine, with almost any edition and has an advanced configuration tool that report's accurately what is missing. SSRS is just a shot in the dark..it may not work and the error if you get one will be obscure. There were enough got-ya's that writing this post became a must. This post led me to create this article: http://social.msdn.microsoft.com/Forums/sqlserver/en-US/1b4d69aa-96a5-4787-b44d-ee473b667ce9/reportserver-not-showing-up-in-iis7 The SQL Server 2012 SP1 installation media is broken and only installs RTM http://support.microsoft.com/kb/2783963 . You will need to install the SharePoint Reporting Services add-in for Service Pack 1 from Microsoft and...