The key point I was trying to make to an audience of SQL professionals was that they could not ignore SharePoint, because
- SharePoint is Microsoft’s fastest selling product
- 20,000 new users every day
- 99.9% of SharePoint data is stored in SQL, and it is a lot of data
- Business Intelligence in SQL is increasingly linked to SharePoint
The majority of data in SharePoint is stored within the SQL server, and DBA's will often be expected to manage and backup these databases. Without proper engagement and planning SharePoint databases can be a mess like the example I used.
- Plan the size of content databases
- Agree naming and installation approach
- Agreeing maintenance and backup strategy
Business Intelligence and Data Connectivity is the other key area of consideration of SharePoint for SQL Professionals. SharePoint is the key delivery mechanism for Business Intelligence tools such as Analysis Services and Reporting Services. There are also significant considerations around access and security for delivery data to SharePoint from SQL.
I broke down the Business Intelligence and Data Connectivity options in SharePoint into three areas
SharePoint is a large complicated product, and successful implementation relies on specialists skills working together towards a successful delivery. SQL is one of those skills from both Database Management and the Business Intelligence/Data Connectivity perspectives. My presentation did not aim to tell all the answers, that was not the point, instead it was a call to action to the SQL community.
You can download the presentation from my personal blog