Data models for business systems
Schemas for orders, stock, users and permissions with Entity Framework, tuned for the queries the business actually runs.
SQL Server development
SQL Server databases behind business-critical .NET systems.
SQL Server is the database under most of our .NET systems: the Aspect and Peregrine Ship commerce platforms, the EM2 event microservices, the HS High Stake portal, a support desk, a no-code ETL product and Auto.co.il’s 100,000-item catalog.
SQL Server at OSKIFrom case studies
Client projectsPublished case studies that used SQL Server
8projects
Where in the stackDatabase, Data
2layers
IndustriesE-commerce and logistics, Automotive media, E-commerce and more
8industries
Most recent projectAmazon Custom orders that reach the print queue without manual handling
2026year
What we build with SQL Server
Where SQL Server earns its place.
The kinds of work we use SQL Server for, based on the projects below rather than a list of everything the technology can do.
Performance and reporting
Indexes, T-SQL and caching for screens and reports that must stay fast as data grows.
Migration and ETL
Moving data out of legacy databases and connecting SQL Server with Oracle, MySQL and files on a schedule.
8 client projects
How SQL Server fit into each project.
Which part of the system it ran, and what it worked with. Every row links to the full case study.
Automating 1688 sourcing for Peregrine Ship's dropshipping platform
DatabaseSQL Server
Together withAngular, .NET 8, AWS EC2, AWS S3, AWS CodeBuild, 1688 Marketplace API
Rebuilding a major Israeli car portal on Umbraco 15 with ~100K migrated nodes
DatabaseMS SQL
Together with.NET 9, Umbraco 15, Lit (TypeScript), Vanilla JavaScript, Lucene, Umbraco hybrid cache
Amazon Custom orders that reach the print queue without manual handling
DatabaseSQL Server
Together with.NET 8, Angular, AWS EC2, AWS S3, AWS SQS, Amazon Selling Partner API (SP-API)
Customer tickets, team tasks and form building in one support system
DatabaseSQL Server
Together with.NET Core, Vue.js, Vuetify, Vuex, Axios, FullCalendar
A no-code ETL platform business users run without engineers
DatabaseSQL Server
Together with.NET 7, C#, Entity Framework, Vue.js, JavaScript, Oracle
EM2: matching thousands of event attendees across 8 .NET microservices
DatabaseSQL Server
Together withReact 18, TypeScript, Ant Design, ASP.NET Core, MediatR (CQRS), Entity Framework Core
Back-office tools for a school platform teaching Danish, Norwegian and Swedish
DatabaseSQL Server
Together with.NET, Umbraco, React
A .NET business portal for a German division, its dealers and staff
DataSQL Server, T-SQL
Together with.NET Framework 4.8, ASP.NET Core 3.1, .NET 5.0, HotChocolate (GraphQL), Entity Framework, Hangfire
SQL Server case studies
Results from these projects.
Each one with the client’s problem, our approach and what changed.
Integrations2024–2025
Peregrine Ship · Hong Kong
Automating 1688 sourcing for Peregrine Ship's dropshipping platform
A sourcing step that buys from 1688 suppliers for each order, tracks the shipment and bills clients only when each stage is complete.
~35%faster fulfillment, reported by the client
50%less manual admin work, reported by the client
Web platforms2025
Auto.co.il · Israel
Rebuilding a major Israeli car portal on Umbraco 15 with ~100K migrated nodes
The third generation of a leading Israeli car site: ~100K records moved from a legacy CRM into Umbraco, fast catalog search and an editor-friendly back office.
~100Kcontent nodes migrated
Umbraco 15on .NET 9
Integrations2026
Aspect · Ukraine
Amazon Custom orders that reach the print queue without manual handling
A platform that pulls orders from 7 Amazon marketplaces, turns personalized orders into print jobs and shows the real margin on every product.
7Amazon marketplaces in one place
15 minorder and stock sync
Web platforms2025–2026
Tech, finance and healthcare
Customer tickets, team tasks and form building in one support system
A support system that pairs a customer request portal with internal kanban, calendar scheduling and a form builder, all updated in real time.
80%faster form creation
50%support efficiency
Web platforms2025
Data integration
A no-code ETL platform business users run without engineers
A web-based ETL product where users build data pipelines without code, schedule recurring transfers and watch every stage in real time.
80%success rate
<1sreal-time monitoring
Web platforms2025
Events and conferences
EM2: matching thousands of event attendees across 8 .NET microservices
A cloud-native platform for multi-day, multi-venue events: 8 .NET microservices on Azure handle registration, scheduling, attendee matching and Zoom.
8microservices
1000sattendees and sessions
Web platforms2024
EdTech
Back-office tools for a school platform teaching Danish, Norwegian and Swedish
Custom Umbraco plugins for a platform that teaches Danish, Norwegian and Swedish in schools: reporting, a translation-aware editor and moderated comments.
3Nordic languages
Umbracoback-office plugins
HS High Stake GmbH
Web platformsSince 2021
HS High Stake GmbH · Germany
A .NET business portal for a German division, its dealers and staff
OSKI developers joined HS High Stake to build modules for a large business portal that links a German division, its dealers and its employees.
7developers over the project
18+ monthsof continuous work at review time
Related services
SQL Server is a tool. These are the jobs it does.
We do not sell hours of a technology. We take on a result, and choose the stack with you. These are the services where SQL Server usually comes in.
.NET development & modernizationNew .NET applications and migrations from .NET Framework to .NET 8–10, without stopping the business.Custom software developmentERP, CRM, portals, SaaS products and back-office tools built for your processes.Maintenance, support & project rescueTaking over existing systems: stabilization, bug fixing, security updates and ongoing support.
Technologies
Other technologies we have shipped with.
Each one backed by at least one published client project.
Backend
SQL Server FAQ
SQL Server questions we hear.
Anything missing? Send us your question and an engineer will answer, usually within one business day.
Contact usCan you speed up a slow SQL Server database?+
Usually. We profile the slowest queries, fix indexes and query patterns, and add caching where it is safe. Most gains come from a handful of queries.
Do you migrate data from other databases?+
Yes. We moved about 100,000 records from a legacy CRM into Auto.co.il’s new platform and built ETL that moves data between SQL Server, Oracle and MySQL.
Azure SQL or SQL Server on a VM?+
Managed Azure SQL or Amazon RDS for most systems; it removes patching and backups from your list. A VM makes sense only for special licensing or features.
Start a project
Tell us what you are building with SQL Server. We come back with a plan and a price.
A spec, a Figma file or three paragraphs is enough to start.
- First reply · from an engineer, not a sales rep
- 30-min call · with Roman, our CTO, to clarify scope
- After the call · a written proposal with plan, team and price
Roman Oleksuk, CTOPrefer to talk? Pick a slot in Roman's calendar