01 · Starting point
Situation
SharePoint 2010, SQL queries, crawling and the existing PKI needed analysis and optimisation so that collaboration and certificate deployment worked together reliably.
Constraints
- Changes within an already established IT environment
- Short, clearly scoped engagement
- Internal system and operating details remain confidential
02 · Responsibility
My scope of responsibility
I set up SharePoint 2010, worked on crawling and SQL topics, reviewed the PKI and configured CRL distribution and web deployment of certificates.
- I optimised SQL queries and analysed crawling problems.
03 · Technical work
Documented scope of work
Key decisions
Work through application, database and certificate topics along their technical dependencies. SharePoint functionality, search and secure deployment cannot be optimised sustainably if SQL and PKI are considered separately.
- I installed and configured SharePoint Server 2010 with web applications and services.
- I reviewed the PKI, configured CRL distribution points and automated certificate deployment.
04 · Technical context
Technology in use
SharePoint 2010
SharePoint 2010 was part of the documented toolset in this Messaging & Collaboration engagement.
SQL Server
SQL Server was part of the documented toolset in this Messaging & Collaboration engagement.
PKI
PKI was part of the documented toolset in this Messaging & Collaboration engagement.
CRL
CRL was part of the documented toolset in this Messaging & Collaboration engagement.
Certificates
Certificates was part of the documented toolset in this Messaging & Collaboration engagement.
05 · Factual basis
Evidence and limits
Collaboration, database access and certificate deployment gained a better-aligned technical foundation.
- Role
- System Engineer
- Period
- January 2011 — April 2011
Lesson from the engagement
Platform problems often lie at the transitions between application, database and trust infrastructure rather than in a single component.
Confidentiality note: Internal architecture and operating data of this engagement are not published.