Arnaud Aubert’s blog

Done ! Me and my wife found our son’s future firstname : Liam !

According to the last ultrasound display : this will be a BOY !

Assuming @thetime is the value you want to extract the date from, here is the code to use :

DECLARE @thetime datetime
SELECT @thetime = getdate()
SELECT CONVERT(DATETIME, FLOOR(CONVERT(NUMERIC(18,9), @thetime)))

He (or she ?) was not planned so quickly but we are proud to announce our third child should born on 27st January 2009. Here are the first ultrasound displays.

     
     

Warning, the FormParameter element doesn’t work correctly inside a master page. You should prefer using ControlParameter instead.

https://connect.microsoft.com/VisualStudio/feedback/ViewFeedback.aspx?FeedbackID=118678

You need to update the web.config file placed in your site collection virtual directory (eg. c:\inetpub\wwwroot\wss\VirtualDirectories\80) and edit all of the following settings :

• callstack=”True” in the SafeMode element
• mode=”Off” in customErrors element

If you try to optimize your collaborative processes or disk space used by identifying duplicated files and these files are being indexed by MOSS, then you can use the search database to report these duplicate items :

– Step1 : get all files with short names, md5 signatures, and size
select
md5,
right(accessurl, charindex(‘\’, reverse(accessurl)) - 1) as ShortFileName,
accessurl AS Url,
llVal / 1024 as FileSizeKb
into
#listingFilesMd5Size
from
MSSCrawlURL y inner join MSSDocProps on ( y.DocID = MSSDocProps.DocID )
where
MSSDocProps.pid = 58 – File size
and llVal > 1024 * 10 – 10 Kb minimum in size
and md5 <> 0
and charindex(‘\’, reverse(accessurl)) > 1

– Step 2: Filter duplicated items
select count(*) AS NbDuplicates, md5, ShortFileName, FileSizeKb
into #duplicates
from #listingFilesMd5Size
group by md5, ShortFileName, FileSizeKb
having count(*) > 1
order by count(*) desc

drop table #listingFilesMd5Size

When you get the following error messages and no one of the reasons may apply, try to delete the registry key HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Internet Explorer\ActiveX Compatibility\{65bcbee4-7728-41a0-97be-14e1cae36aae}.

The list is displayed in Standard view. It cannot be displayed in Datasheet view for one or more of the following reasons: A datasheet component compatible with Windows SharePoint Services is not installed, your browser does not support ActiveX controls, or support for ActiveX controls is disabled.

SSAS setup program does not configure SPNs correctly by default. Therefore, Kerberos authentication cannot run and connection from delegated accounts cannot run. The following article describes how to configure the domain account SPNs depending on the instance name. Also, don’t forget to add “SSPI=Kerberos” to the SSAS connection string to use Kerberos instead of NTLM when connecting. This is required to secure connections from MOSS/Sharepoint for example (see: http://blogs.msdn.com/martinkearn/archive/2007/04/27/configuring-kerberos-for-sharepoint-2007-part-2-excel-services-and-sql-analysis-services.aspx). 

http://support.microsoft.com/kb/936628/en-us

I recently encountered many difficulties with Kerberos authentication and delegation especially when dealing with web applications and users belonging to many groups. There were several problems in fact :

1. The size of the Kerberos ticket was larger than the default buffer
2. IIS 5 and IIS 6 do limit the size of the POST variables and therefore also apply a different quota for Kerberos tickets going through HTTP
3. When implementing Kerberos authentication with FQDN, you should check that SPNs are set up correctly

I wrote down a summary of the links that helped me solving these issues. Also, I created a small .REG files that upsize all these limites (Kerberos, IIS 5, IIS 6…).

For IIS 5 : http://support.microsoft.com/kb/310156/fr

For IIS6 : http://support.microsoft.com/kb/920862

For setspn.exe : http://support.microsoft.com/kb/929650

For the ticket size issue :

http://support.microsoft.com/kb/327825

Windows Registry Editor Version 5.00
 [HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\HTTP\Parameters]
“MaxFieldLength”=dword:00008000
“MaxRequestBytes”=dword:00008000
  [HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\w3svc\parameters]
“MaxClientRequestBuffer”=dword:00008000
  [HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Lsa\Kerberos\Parameters]
“MaxTokenSize”=dword:0000ffff
 [HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Tcpip\Parameters]
“MaxUserPort”=dword:0000fffe