Services Offered

Microsoft SQL Server
We offer project management, implementation, and tactical training on all of the following technologies.

• Database design and optimization - including but not limited to:

  • Relational tables

  • Stored procedures

  • Views

  • Functions

  • Triggers

  • Advanced functionality (PIVOT/UNPIVOT, MERGE, CTEs, SQL Agent Job automation, etc.)
    

• SQL Server Reporting Services (SSRS) Reporting - including but not limited to:

  • Strategic paginated reporting

  • Targeted analytics

  • Automated report generation / emailing / file store
    

• SQL Server Integration Services (SSIS) Processing - including but not limited to:

  • Customized extracts for export needs - ETL / ELT

  • Data import / integration with existing database

  • Server-level process automation (file movement / transfer, archiving, etc.)