Benefits of Microsoft Office SharePoint Server 2007

Hello Guys,


      Below are the benefits of MOSS 2007

•  Provide a simple, familiar, and consistent user experience.
•  Boost employee productivity by simplifying everyday business activities.
•  Help meet regulatory requirements through comprehensive control over content.
•  Effectively manage and repurpose content to gain increased business value.
•  Simplify organization-wide access to both structured and unstructured information across disparate systems.
•  Connect people with information and expertise.
•  Accelerate shared business processes across organizational boundaries.
•  Share business data without divulging sensitive information.
•  Enable people to make better-informed decisions by presenting business-critical information in one central location.
•  Provide a single, integrated platform to manage intranet, extranet, and Internet applications across the enterprise. 

About Content Query

Hi Everyone,


             Content Query:

                                        We can use a Content Query control to link to pages or other items that are displayed based on a query that you design. For example, if you are presenting articles in an online news site, you could add a Content Query control to your site's Welcome Page layout so that new articles are highlighted on that page. You can build complex queries by using the Content Query field control. For example, you can specify which sites in your site collection to query, which lists to use, and what audience to target. You can also filter queries based on lists or libraries metadata.

We can add a Content Query control to a layout page in two ways:

·      We can add it directly to the layout page and configure it. When you do this, any page that uses the layout page will display the results of the query.

·       We can add it as a Web Part to a Web Part zone. When you do this, authors can modify the query or delete the Content Query control.

Convert MS Excel to SQL Server

Converting Excel database spreadsheets to a MS SQL Server database provides a far more structured, more repeatable approach for business critical processes. Excel spreadsheets provide infinite flexibility, but at the cost of bad data, and the cost of managing a distributed application that is intended for just one or a few users.  SQL Server database supports well-structured data, and repeatable, high quality data and workflow processes, with unlimited number of concurrent End Users. The good news is that PCA can migrate your Excel spreadsheets to MS SQL Server, and make your Excel Application more structured, while preserving the original functional integrity of the original MS Excel spreadsheet.

       Comparison of MS Excel to SQL Server:

		MS Excel	SQL Server
	Workflow	None (Email)	Process-flow defined
	Concurrent Updates	No (Single User)	Yes (Multiple, concurrent Users)
	Security	One password fits all	Role-based privileges
	Version Issues	High (file data stamp)	None
	Audit-ability	Low (date and email comparisons)	High (full audit trail)
	Data Integrity	Low (somewhat constrained)	Highly constrained
	Data Capacity	Limited	Unlimited
	Data Structures	Flat: 2-dimensions	Relational: 3-dimensions