Logo

Microsoft SQL Server

Deploy and manage your on premise and cloud data.

INKEY brings together experienced database professionals who can help tailor a solution to suit your database needs. Want to maximize your company's performance?

Our Competencies:

INSTALLATION AND CONFIGURATION

Experienced in installing and configuring all versions of SQL Server.

MIGRATION

Experienced in migrating to new versions of SQL Server in all types of environment - physical, virtual or cloud.

DESIGN

Data modelling and Database design catered as per your needs in all types of environment - physical, virtual or cloud.

PERFORMANCE TUNING

We take care of all T-SQL coding and Capacity planning.

AUDIT

Conduct SQL server health check to ensure you experience the best performance.

BI AND ANALYTICS

We provide integration service (SSIS), ETL development, and SQL Server analysis and reporting support (SSAS & SSRS)

Case Studies:

1

Linked Server and SSRS report performance

Recently we had to use linked servers to fetch data for some SSRS reports. Our initial approach degraded the performance and the reports were getting loaded very slow which was not at all acceptable. We had to come up with a solution that would use linked servers yet decrease the report loading time.

2

Performance Optimization

One of existing our clients whom we provide support for BI and SQL Server had a stored procedure giving poor performance and we were asked to analyse it for optimization. The limitation was to just re-structure the queries without making any changes to the underlying DB structure.

3

Database Design

For our client, handling and managing the business processes involved a lot of manual work which was tedious, error- prone and time consuming. The client suffered delays in making deliveries to the customers, which were danger for the client's image. The client wanted us to develop an easy to use ERP that would automate their business processes and help eliminate the cons of manual work. Giving the much obvious benefits of SQL Server, we decided to use it in for the back-end.

4

Migrating from SSIS to T-SQL

The client provided us some SSIS packages, which extracted required information from their servers having identical databases. For some servers, it was not possible to use SSIS and the client wanted to have T-SQL Queries developed, which would return the same results as those of the SSIS packages.