SQLAuthority News – Presenting at South East Asia SharePoint Conference – Oct 26, 27, 2010 – Singapore

Every SharePoint site runs on SQL Server and most of the SharePoint sites face issues with performance due to suboptimal configuration of underlying SQL Server. Recently, I presented a session on SharePoint and SQL Server Performance at Singapore on Oct 26-27, 2010. It was South East Asia SharePoint Conference, and…
Read More

SQL SERVER – Fix: Error: MS Jet OLEDB 4.0 cannot be used for distributed queries because the provider is used to run in apartment mode.

I recently got email from blog reader with following error. MS Jet OLEDB 4.0 cannot be used for distributed queries because the provider is used to run in apartment mode. The fix of the same is very easy. Fix/Workaround/Resolution: sp_configure 'show advanced options', 1; GO RECONFIGURE; GO sp_configure 'Ad Hoc…
Read More