SQL Server Services

LewiSys has been working with Microsoft SQL Server since version 6.5 through the current SQL Server 2012.  SQL Server provides businesses with a high performance database platform that’s reliable, scalable, and includes a robust set of reporting and business intelligence tools.  LewiSys can help you with all aspects of SQL Server to be sure you get the most out of your software investment.

SQL Server Administration
  • Installations, upgrades, server migrations
  • User permissions and security roles
  • Backup and disaster recovery plans
  • Email alerts for job status and critical system issues
  • Record locking and blocking
  • Performance Tuning

SQL Server Development

  • Query design and optimization
  • Stored Procedures
  • Triggers
  • Functions
  • Data import and export
  • ETL (Extract, Transform, Load)

SQL Server Reporting Services (SSRS)

  • Report development
  • Dashboards
  • Conversion from Crystal Reports
  • User management and security
  • Report scheduling
  • Report distribution to a variety of formats (Excel, PDF, HTML, XML)
  • Sharepoint Integration
  • SSRS can report on multiple data sources, not just SQL. 
    • A single report can include data from SQL, Access, Excel, ODBC, and flat files.

SQL Server Integration Services (SSIS)
  • Build simple or complex processes for data manipulation and delivery
  • Data cleansing and mining
  • ETL (Extract, Transform, Load)
  • File upload and download to FTP and web sites
  • Email delivery and alerting
  • Import and export data to nearly any format, not just SQL
  • Integrate your CRM and ERP databases

Let's make it happen! Contact us today to set up a complimentary consultation.

Located in Modesto, CA, LewiSys is available for travel and capable of servicing customers throughout the North America using remote meeting technology and remote desktop.  We're never too far away.

 MCSE LewiSys
Modesto, CA

(209) 566-0300

Exact Services
KnowledgeSync SQL Server
Crystal Reports
Data Services
Contact Us