DevSharePoint.com

For Analysis Services instances that you deploy in a SharePoint farm, always use SharePoint Central Administration to change the server accounts for PowerPivot ... [read more]

While I am trying to use sql server authentication mode, i got the following error Unable to use SQL Server because ASP.NET version 2.0 Session State is not ins... [read more]

Dot net walkin both windows and web based application is conducting in bangalore. Please see the details below: Date: Saturday, 22 Oct 2011  Experience: 2-5 ye... [read more]

http://www.sommarskog.se/grantperm.html Owner/Schema Separation Before we look at any of the methods to grant permissions, we need to look at a change in SQL 20... [read more]

http://technet.microsoft.com/en-us/magazine/2007.03.partitioning.aspx When creating a partitioning function, you can choose a LEFT or RIGHT partition function. ... [read more]

http://decipherinfosys.wordpress.com/2007/12/20/forceseek-table-hint-in-sql-server-2008/ Here is the data distribution that was created by this small script: SE... [read more]

Open the SharePoint Central Administration website. Choose Application Management > Manage web applications. Click the New button in the ribbon. This will bring... [read more]

Unknown SQL Exception 262 and Central Administration. So, I have been creating a new SharePoint 2010 Farm using guidance from three distinct sources (all of whi... [read more]

http://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/thread/a308837d-afb9-4e68-9df9-1c550c652a4a/ http://social.msdn.microsoft.com/Forums/en-US/sqlda... [read more]

SharePoint can be configured for all services to run on a single server. A popular SharePoint deployment might consist of a small three-tier server farm with a ... [read more]

http://www.databasejournal.com/features/mssql/article.php/3916166/article.htm ... [read more]

http://www.dotnetmafia.com/blogs/dotnettipoftheday/archive/2010/12/22/use-keyword-query-syntax-instead-of-sql-syntax-for-sharepoint-2010-search-queries.aspx &nb... [read more]

http://www.databasejournal.com/features/mssql/article.php/3904846/article.htm ... [read more]

http://blog.sqlauthority.com/2008/09/01/sql-server-2008-introduction-to-filtered-index-improve-performance-with-filtered-index/ ... [read more]

http://msdn.microsoft.com/en-us/library/dd758814(SQL.100).aspx ... [read more]