I can review your database schema and queries, including stored procedures.
Depending on your requirements, the review might include:
- Suggestions for performance improvements along the lines that I recommend in my book
- Review of the associated LINQ, Entity Framework or ADO.NET code (optional)
- Suggestions to improve scalability, such as partitioning
- How and where to apply techniques such as pre-caching
- Review of unit tests, or suggestions for some if you don't already have them
- When to use native XML columns
- When to use free text search
- Comments about obvious security issues that might come up (this is not a security review)
- Observations about transactional boundaries, use of command batching and multiple result sets
- Instrumentation, monitoring, logging and error reporting
- Integration of SQL CLR with your application
This will be static analysis only, so it won't take into account the details of your application's
job mix under load.
I can deliver my recommendations either in written form or as an interactive presentation, or both.
If this interests you, please send the following information, so that I can provide a quote:
- A brief description of the database to be reviewed (include the schema and queries too, if possible)
- What you would like to get out of the review
- Your schedule requirements