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.