New Microsoft SharePoint 2007 SDK

In the most recent MSDN flash are the following updates to take note of – some new SharePoint SDK releases:

Download the SharePoint Server 2007 SDK (Aug 08 1.4 Refresh)

The August 2008 update of the SharePoint Server 2007 SDK contains documentation for new and improved features in the Infrastructure Update for Microsoft Office Servers and new conceptual, procedural, and reference information. You can also view the August update online.

Download the Windows SharePoint Services 3.0 SDK (Aug 08 1.4 Refresh)

See the latest additions to the Windows SharePoint Services SDK. Find conceptual overviews, programming tasks, and references for Windows SharePoint Services. View the Windows SharePoint Services 3.0 SDK online.

Supporto ufficiale Microsoft SQL Server 2008 in Sharepoint SP1

Dopo il recente rilascio RTM di Microsoft SQL Server 2008, pochi giorni fa ne è stata resa nota la definitiva compatibilità e supportabilità con Sharepoint.
Attenzione… necessita di uno Sharepoint SP1
Windows SharePoint Service 3.0
http://technet.microsoft.com/en-us/library/cc288751.aspx
Office SharePoint Server 2007
http://technet.microsoft.com/en-us/library/cc262485.aspx

Office SharePoint Server 2007 supports SQL Server 2008. However, you must install Windows SharePoint Services 3.0 SP1 or later and Office SharePoint Server 2007 SP1 or later before you install SQL Server 2008.

Alte info e vantaggi:
1. Improved Manageability
Manageability and governance is important for SharePoint as well as the SQL Server database engine. Now administrators can also benefit from the new management features introduced in SQL Server 2008 – from Policy-based administration to back-up compression. For details, please refer to http://technet.microsoft.com/en-us/library/cc645579(SQL.100).aspx.
2. High Availability
Availability in SQL Server 2008 has been improved through enhancements in data mirroring. For details, please refer to http://technet.microsoft.com/en-us/library/cc645581(SQL.100).aspx.
3. Enhanced Data Security
The SQL Server 2008 database engine introduced new encryption functions that enhance security. SharePoint administrators can take advantage of these new encryption features by simply turning on transparent data encryption (TDE). No additional changes need to be made on the SharePoint side. For details, please refer to http://technet.microsoft.com/en-us/library/cc645578(SQL.100).aspx.
Tratto da:
Microsoft SharePoint Team Blog:
http://blogs.msdn.com/sharepoint/

Supporto di Moss 2007 e Wss 3.0 in Hyper-V (Richiesto SP1 di Sharepoint)

E’ stato finalmente rilasciato il documento che conferma la supportabilità di Moss 2007 e Wss 3.0 in Hyper-V.
Using SharePoint Products and Technologies in a Hyper-V virtual environment:
http://technet.microsoft.com/en-us/library/cc816955.aspx

Note importanti:
- Windows Server 2008 requires Windows SharePoint Services 3.0 Service Pack 1 and Office SharePoint Server 2007 Service Pack 1.
- We recommend that you install Office SharePoint Server 2007, 64-bit edition on a virtual machine that is running a 64-bit edition of Windows Server 2008.

Microsoft Office SharePoint Server 2007 – Best Practices Resource Center for SharePoint Server 2007

What is the best way to do something in SharePoint ?
Recently, the SharePoint Team Blog announced the SharePoint Best Practices Series (http://blogs.msdn.com/sharepoint/archive/2008/08/29/announcing-the-sharepoint-best-practices-series.aspx).
The series includes a “Best Practices Resource Center for SharePoint Server 2007″ site, which includes all guidelines about implementing Search, Publishing Portals, My Sites, Team Collaboration, SP Development, and more!
http://technet.microsoft.com/en-us/office/sharepointserver/bb736746.aspx

Software per la pulizia del registro di Microsoft Windows

Il programma che vi segnalo, riguarda la pulizia del registro di Microsoft Windows.
Da questo sito http://www.ccleaner.com/ potete scaricare un programma, che migliora le prestazioni del vostro PC, migliorando il registro di Microsoft Windows, sistemando i riferimenti delle dll, che non sono più valide, effettua una pulizie del proprio hard disk di quei file temporanei ed inutili.
Un ottimo programma, che in questi mesi, si sta facendo notare per la sua qualità e semplicità
Per maggiori informazioni e download visitate il sito indicato.

Download HTML Portable Editor

Per coloro che preferiscono i software portatili, ossia i programmi che non richiedono installazione e che si possono utilizzare nella propria chiavetta USB o Hard Disk esterno, segnalo questo programma per la creazione di pagine web.
Da questo sito http://www.eskiso.net/hpe.htm potete scaricare HTML portable editor, un software gratuito, che non richiede installazione.
Per il download e per maggiori informazioni, visitate il sito indicato.

Error in the Site Data Web Service. (Value does not fall within the expected range.)

Di seguito possibili cause per l’errore: “Error in the Site Data Web Service. (Value does not fall within the expected range.)”

1) You use the Stsadm.exe command-line tool to migrate users. When the Windows SharePoint Services 3.0 Web sites are crawled and are indexed, the following error message is logged in the crawl log: Error in the Site Data Web Service. (Value does not fall within the expected range.)
 
It is noted, however, that a few site collections, after a new full clean crawl, that the above error persists
 
The following stsadm commands should be used to finalize the solution against any remaining site collections that still display the Error in the Site Data Web Service error:
 
1. stsadm -o export -url <URL to be exported> -filename <export file name> -versions 2
 
2. Delete the site collection. Then, run a import using the following command:

3. stsadm -o import -url <URL to be Imported> -filename <import file name> -updateversions 2 -nofilecompression
 
Note: do not use the command switch -includeusersecurity. Some customers, rightfully so, will use this by default when doing a export/import. However, in this instance, when issuing the -includeusersecurity switch, you are effectively bringing the short user SIDs back over into the site collection. When doing so, after issuing a full crawl, you will note that the error will still appear in the
crawl logs.

B) KB937832 is installed without KB934525

C) Error message when you edit an .aspx Web page in SharePoint Server 2007: “Value does not fall within the expected range”:
http://support.microsoft.com/kb/953445/

D) Installare la SP1 di MOSS 2007 “potrebbe” risolvere il problema come capita con molte SP

E:\Workarea>”C:\Program Files\Common Files\Microsoft Shared\web server extension
s\12\BIN\STSADM” -o import -url http://serversharepoint/ -filename e:\workarea\nomefile.estensione -updateversions 2 -nofilecompression

Installare MOSS utilizzando i DBA created database

Durante il setup di MOSS vengono creati applicativamente una serie di database su SQL Server, tanto che tra i requisiti dei service accounts c’è l’attribuzione dei permissions roles DB Creator e Security Administrator su SQL Server.
In diverse realtà aziendale le policies impediscono l’attribuzione di tali permissions ad utenti “fuori controllo”. E i DBA dell’azienda spesso pongono il veto al deployment standard di SharePoint.
In questi contesti è però possibile creare i database in forma controllata. La procedura è tra quelle supportate ufficialmente e recentemente è stato pubblicato un articolo su Technet dove approfondire la cosa.

Differenze tra RDL ed RDLC

RDL files are created by the SQL Server 2005 version of Report Designer. RDLC files are created by the Visual Studio 2005 version of Report Designer.
RDL and RDLC formats have the same XML schema. However, in RDLC files, some values (such as query text) are allowed to be empty, which means that they are not immediately ready to be published to a Report Server. The missing values can be entered by opening the RDLC file using the SQL Server 2005 version of Report Designer. (You have to rename .rdlc to .rdl first.)
RDL files are fully compatible with the ReportViewer control runtime. However, RDL files do not contain some information that the design-time of the ReportViewer control depends on for automatically generating data-binding code. By manually binding data, RDL files can be used in the ReportViewer control.
Note that the ReportViewer control does not contain any logic for connecting to databases or executing queries. By separating out such logic, the ReportViewer has been made compatible with all data sources, including non-database data sources. However this means that when an RDL file is used by the ReportViewer control, the SQL related information in the RDL file is simply ignored by the control. It is the host application’s responsibility to connect to databases, execute queries and supply data to the ReportViewer control in the form of ADO.NET DataTables.

Migrazione dei DTS di MS SQL Server 2000 in SIS di MS SQL Server 2005

Se l’esigenza è quella semplicemente di eseguire i vecchi package DTS basta che, durante la fase di installazione di MS SQL Server 2005, venga scelta l’opzione di installazione del runtime dei DTS 2000. Questo basta per eseguire “as is” i packages sviluppati su MS SQL Server 2000. Se invece si desidera anche editarli/modificarli o addirittura migrarli alla versione 2005, bisogna installare il componente che si trova nel Feature Pack for Microsoft SQL Server 2005 e che viene chiamato Componenti di Microsoft SQL Server 2005 per la compatibilità con le versioni precedenti.
Il pacchetto per la compatibilità con le versioni precedenti di SQL Server include le versioni più recenti di Data Transformation Services 2000 Runtime (DTS), SQL DMO (Distributed Management Objects), DSO (Decision Support Objects) e dell’interfaccia di periferica virtuale SQL (SQLVDI). Questi componenti sono stati aggiornati per garantire la compatibilità con SQL Server 2005 e includono tutte le correzioni disponibili in SQL Server 2000 SP4.

Pacchetto per X86 (SQLServer2005_BC.msi) – 11222 KB
Pacchetto per X64 (SQLServer2005_BC_x64.msi) – 18516 KB

Direi che abbiamo tutte le scelte a disposizione