Compare sql server 2005 and 2008 by SharePoint 2010

20/10/2010 Leave a comment

You can use both Sql server 2005 and sql server 2008 with sharepoint 2010 but what are the advantages or disadvantages .

Absolutely i recommend use SQL Server 2008 r2 for sharepoint 2010 products. Here is the why i choose it

Performance and Avaiblity :SQL Server 2008 R2 Enterprise edition enables several dimensions on which it can scale, enabling even the most demanding SharePoint Server 2010 deployments. For example, rapidly growing Enterprise Content Management (ECM) or Web Content Management (WCM) workloads may often require compute resources beyond those associated with traditional collaboration scenarios. SQL Server 2008 R2 Enterprise can support this scenario through a number of improvements, by enabling greater processor scale, the ability to address more physical memory on 64-bit hardware, and hot-add hardware support.

Business Continuity Management is a combination of high availability and disaster recovery. High availability ensures a certain absolute degree of operational continuity in the event one or more components fail in an isolated location. Availability requirements are defined by Operating and Service Level Agreements. Disaster recovery ensures a certain absolute degree of operational continuity in the event that all systems fail in one or more locations. Disaster recovery requirements are defined by Operating Level Agreements, Recovery Point, and Recovery Time Objectives.

SQL Server 2008 R2 provides a number of native capabilities to enable the design and deployment of a highly available SharePoint Server 2010 deployment including database mirroring, failover clustering, and log shipping.

SQL Server 2005 mainstream support will end fairly soon (read more athttp://support.microsoft.com/gp/lifesupsps)

Security: Transparent Data Encryption (TDE) is a feature added in SQL Server 2008 Enterprise that performs real time I/O encryption and decryption of data and log files without requiring unsupported modification of the underlying table schema or increasing the size of the database—that means no changes to SharePoint to enable TDE SQL server audit.Server Audit, which enables tracking and logging events that occur on the system, for example detecting changes or modifications to database objects/stored procedures, surfacing changes to server configuration settings, or detecting changes to audit configuration settings.

Better Reporting Services:SharePoint Server 2010 and SQL Server 2008 R2 Enterprise provide close business intelligence capabilities integration through SQL Server Reporting Services. Using SQL Server Reporting Services, administrators can configure reporting servers to enable real-time access to information and control who has access to that information. End users can benefit from this integration by publishing SQL Server reports directly to Document Libraries or by optionally embedding reports in pages hosted on one or more sites in a Microsoft SharePoint Server 2010 deployment.

To learn more about Reporting Services in SQL Server 2008 see SQL Server Reporting Services (http://msdn.microsoft.com/en-us/library/ms159106.aspx).

Using FileStream Functionality with 2008:Remote Blob Storage integration with SharePoint Server 2010 in SQL Server 2008 R2 Enterprise enables an administrator to externalize SharePoint binary large object (BLOB) data by hosting it on less expensive, commodity hardware solutions and managing it with SQL Server through the same data management techniques they use today. Remote Blob Storage can be an integral component in the most stringent compliance scenarios by enabling third-party technologies to implement solutions such as expunge on the server(s) hosting the externalized BLOBs
see:https://blog.bugrapostaci.com/2010/10/01/sharepoint-2010-server-with-filestream-rbs-provider/

 

Sharepoint Server 2010 Fuctionality and SQL Server Eddition Comparison

Resources:
http://technet.microsoft.com/en-us/library/cc990273.aspx
http://technet.microsoft.com/en-us/library/cc262749.aspx

Other:

http://sqlcat.com/top10lists/archive/2009/02/24/top-10-performance-and-productivity-reasons-to-use-sql-server-2008-for-your-business-intelligence-solutions.aspx



Filed under Sharepoint Tagged with , , , , ,

which process lock my dll

17/10/2010 Leave a comment

Sometimes you want to know whats happinging at the background or wonder which app or process using specific dll. Or may be like me when try to copy a dll getting error “DLL is used by another process” . So what now ?

Process Explorer is one of great tool for this.

Download:

http://download.sysinternals.com/Files/ProcessExplorer.zip

Filed under C#, Tips & Tricks Tagged with , ,

LangStore for Sharepoint 2010

16/10/2010 Leave a comment

Sharepoint developers knows LangStore for building Multilingual Sharepoint 2007 Sites  by Chris O’Brain. This is very useful tool and i personally thanks Chris for this great tool. But when you want to use this tool with sharepoint 2010 it has some compatiblity issues .
Some of Site columns collide with comming out of the box columns already used by site content type for example “catagory”. I download and change code with schema.xml and element.xml of MultilingualItemType like below:

<FieldRefs>

<FieldRef Name=“LinkTitle“ />

<FieldRef ID=“{E5C8FDA4-BDA7-4419-8A4E-DE102964884B}“
Name=“LangStoreCategory“ Required=“true“ />

<FieldRef ID=“{D36535DC-31D1-4eb2-9C5C-58CE11EDA226}“
Name=“LangStoreDescription“ Required=“false“ />

<FieldRef ID=“{160036D9-C1A0-419a-AFCE-4CF0525E2160}“
Name=“LS_LANG_EN“ Required=“false“ />

<FieldRef ID=“{21C5A600-9BE5-4f2a-ABD8-271206FC988F}“
Name=“LS_LANG_TR“ Required=“false“ />

<FieldRef ID=“{20DA8826-4CAC-41ca-9399-A82C50E9D66F}“
Name=“LS_LANG_EN-US“ Required=“false“ />

<FieldRef ID=“{1DC99CF7-6667-44ee-83AB-0A5D46D0A092}“
Name=“LS_LANG_EN-GB“ Required=“false“ />

<FieldRef ID=“{600081D6-5AA3-4901-AC55-5537C044D383}“
Name=“LS_LANG_FR-FR“ Required=“false“ />

<FieldRef ID=“{E96813DE-E8A8-4640-AF8D-1E4AC4292B3E}“
Name=“LS_LANG_DE“ Required=“false“ />

</FieldRefs>

.

And i also change all project for suitible with Sharepoint 2010 project for VS 2010 IDE.

 

 

Original Langstore :

http://www.sharepointnutsandbolts.com/2008/12/building-multi-lingual-   sharepoint-sites.html

 

Orginal Langstore Download:

http://splanguagestore.codeplex.com/

You can download LangStore2010 from:

http://rapidshare.com/files/425395340/LangStore2010.rar

Filed under Sharepoint, Sharepoint Tools Tagged with , , ,

Sharepoint 2010 Publishing Portal and missing Search Center template

15/10/2010 Leave a comment

Hi everybody, last day one of my friend called me and asked ” i provision a Publishing portal template but i couldn’t found Search Center Templates do you know where are they?” If you encounter with this situation Dont panic they are already there but  in sharepoint 2010 when provisioning Publishing Portal and Enterprise Wiki templates other templates administratively disabled by default .You can activate them  from Site Actions->Site Settings -> (Look and Feel) Page layouts and site templates

Happy tips & tricks

Filed under Sharepoint Tips & Tricks Tagged with , , , ,

Sharepoint Log management with ULS Viewer

10/10/2010 Leave a comment

Hi Everybody ,

Sharepoint logs is one of the important point for developers . When an error occures you may want to examine sharepoint logs in drive:\Program Files\Common Files\Microsoft Shared\Web Server Extentions\[12,14]\Logs.These log files are text based and sometimes its make me creazy for searching related data .Because its hard to find some thing in these texts files. There are some tools for easily manage your logs.

What is ULS Viewer:

ULSViewer allows users to open a ULS log file and display its contents in a user friendly format. Users can then perform advanced functions such as filtering, sorting, highlighting, loading logs, appending logs, etc in order to single out the data that is important to the user. This information can be used to diagnose problems with machines running ULS services, or to monitor machines and the events they create in realtime.

Toggle Correlation Tree and Notification features are most i like.In SharePoint 2010 has come with new error handling feature named  “correlation id”  which is help us to trace a series of event inside SharePoint.

Download: http://code.msdn.microsoft.com/ULSViewer/Release/ProjectReleases.aspx?ReleaseId=3308

ULS Viewer for sharepoint:

 

Filed under Sharepoint Tools Tagged with , ,

← Older posts

Newer posts →