How SQL Server 2008 components impact SharePoint implementations

SQL Server 2008 is made up of the following components:

• SQL Server Database Engine
• SQL Server Analysis Services
• SQL Server Reporting Services
• SQL Server Integration Services

SQL Server Database Engine
The Database Engine is considered the foundation of SQL Server 2008, and it is the core service for storing, processing and securing data in SharePoint implementations.

SharePoint related databases, like the content, admin, and s...

RELATED CONTENT Microsoft SQL Server Tools and Utilities Tweet-SQL: Interacting with Twitter through SQL Server Microsoft SQL Server Tools Guide SQL Server Mailbag: Data restoration and DB property management SQL language crash course (just enough to be dangerous) Setting up SQL Server Service Broker for secure communication Microsoft SQL Server 2008 Resource Governor primer The sqlcmd utility in SQL Server Performance analysis tools for SQL Server Software security tools to improve your skills in a single day Surface Area Configuration and other security tools in SQL Server 2005 Database Management and Administration Database encryption in SQL Server 2008: Improvements you finally need Common oversights with SQL Server security audits Top 5 SQL Server DBA tasks that are a waste of time Password cracking tools for SQL Server Using traces in SQL Server Profiler Meet compliance requirements with improved database security practices Hardening the network and OS for SQL Server security Securing the server and database in SQL Server Troubleshooting Distributed Transaction Coordinator errors in SQL Server Achieving high availability and disaster recovery with SharePoint databases SQL Server Business Intelligence Strategies Report Builder tutorials and resources for SQL Server DBA career paths could lead to business intelligence Q&A: Business intelligence gets a facelift in SQL Server 2008 R2 Project Gemini gets a new name, Madison earns buzz Sharing SSAS cube data in SharePoint with PerformancePoint Server 2007 SQL Server Reporting Services Fast Guide Change data capture in SQL Server 2008 improves BI reporting accuracy SQL Server business intelligence toolbox SQL Server 2005 business intelligence features FAQ: DTS packages in SQL Server

RELATED GLOSSARY TERMS Terms from Whatis.com − the technology online dictionary ACID  (SearchSQLServer.com) data aggregation  (SearchSQLServer.com)

RELATED RESOURCES 2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems Search Bitpipe.com for the latest white papers and business webcasts Whatis.com, the online computer dictionary

earch databases, get installed in the Database Engine component. Furthermore, the Database Engine provides the groundwork for high availability, scalability, security and document management as well as rapid access to SharePoint data.

SQL Server Analysis Services (SSAS)
Analysis Services provides a foundation for business intelligence (BI) applications though online analytical processing (OLAP) and data-mining functionality.

BI is one of the six pillars of SharePoint, and it is attracting a lot of interest from both businesses and end users. This is because organizations are trying to use BI to gain an advantage in today's competitive business climate. SharePoint can publish BI data that is in SSAS, enabling knowledge workers to analyze data from disparate systems, view Key Performance Indicators (KPIs) and improve business performance on a SharePoint site.

SQL Server Integration Services (SSIS)
Integration Services delivers a high performance platform for building data integration and transformation packages for extracting, transforming and loading data between source and destination databases and data platforms.

SharePoint developers and administrators can use SSIS to extract, move and load data between SharePoint databases and SharePoint lists, and in addition, Integration Services can populate BI systems.

SQL Server Reporting Services (SSRS)
Reporting Services provides an enterprise class reporting infrastructure and development platform for creating, managing and distributing reports.

The easy-to-use tools allow developers to generate interactive, graphical and free form reports via relational data in the Database Engine or multi-dimensional data in Analysis Services. Integrating SharePoint with SSRS gives information workers access to reports through SharePoint, and it allows them to analyze mission critical data and make better informed decisions.

Reporting Services offers new deployments modes for tighter integration between Reporting Services and SharePoint. The SharePoint Integrated Mode provides front-end access to a report server and associated operations, which creates tight integration because the report server runs in a SharePoint server farm. Another deployment method is Native Mode with SharePoint Web Parts. Reporting Services reports can be viewed in SharePoint by adding the Report Explorer and Report Viewer web part in SharePoint.

Overall, when installing SQL Server to support the back-end functionality for a SharePoint implementation, it is a best practice to keep the SQL Server installation slim and efficient.

[IMAGE]
[IMAGE] SQL SERVER AND MICROSOFT SHAREPOINT
[IMAGE] Part 1: How SQL Server recovery models impact MOSS
[IMAGE] Part 2: Achieving high availability and disaster recovery
[IMAGE] Part 3: The effects of SQL Server components on MOSS

ABOUT THE AUTHOR:   

[IMAGE]Ross Mistry is a principal consultant at Convergent Computing, bestselling author and SQL Server MVP. He focuses on implementing SQL Server, Active Directory and Exchange solutions for fortune 500 organizations residing in the Silicon Valley. Ross' SQL Server specialties include high availability, security, migrations and virtualization. His recent books include SQL Server 2008 Management and Administration and Windows Server 2008 Unleashed. Ross frequently writes for techtarget.com and speaks at international technology conferences around the world. His blog can be found at networkworld.com and his Twitter handle is @RossMistry.

Rate this Tip To rate tips, you must be a member of SearchSQLServer.com. Register now to start rating these tips. Log in if you are already a member. DISCLAIMER: Our Tips Exchange is a forum for you to share technical advice and expertise with your peers and to learn from other enterprise IT professionals. TechTarget provides the infrastructure to facilitate this sharing of information. However, we cannot guarantee the accuracy or validity of the material submitted. You agree that your use of the Ask The Expert services and your reliance on any questions, answers, information or other materials received through this Web site is at your own risk.