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]

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]

Here are some sql server tips and tricks.To get all the Tables Information in SQL Server SELECT * from SYS.TablesTo get all the views information in SQL Server ... [read more]

http://www.sqlservercentral.com/articles/Stairway+Series/72461/ SQL Server Agent and proxy accounts. Conspicuous by its absence is the Transact-SQL script (T-SQ... [read more]

http://msdn.microsoft.com/en-us/library/ms180767.aspx In planning the partition scheme, you must decide what filegroup or filegroups that you want to put your p... [read more]

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

http://programming4.us/database/2922.aspx (1) SQL Server Event Logs and Windows Event Logs SQL Server error log files are simple text files stored on disk, but ... [read more]

... solutions using custom Master Pages, Publishing Page Layouts • SharePoint Administration experience a plus (e.g. can build development environments using ... [read more]

http://www.databasejournal.com/features/mssql/article.php/3691821/Whats-new-in-SQL-2008-Part-1.htm http://www.databasejournal.com/features/mssql/article.php/369... [read more]

At this point we have Reporting Services 2008 R2 and SharePoint 2010 Foundation installed. The next step is to configure Reporting Services SharePoint integrati... [read more]

http://www.sqlservercentral.com/articles/Administration/72162/ Create a database and table to hold all the data from current ERROR.LOG Truncate table and uploa... [read more]

SharePoint Administration experience a plus (e.g. can build development environments using central administration and stsadm) ? SQL Server DB reporting experien... [read more]

http://blogs.msdn.com/b/sqlserverstorageengine/archive/2007/11/12/types-of-data-compression-in-sql-server-2008.aspx I will provide details on PAGE compression l... [read more]

On the Central Administration home page, click Security and in the General Security section click Configure service accounts. b. On the Service Accounts page, ... [read more]