BONITSThink · Do · Achieve
Talk to us
Technologies

SQL Server

Microsoft SQL Server development, performance work and migration — from transactional schema design through to modernising a warehouse onto a cloud data platform.

A SQL Server database feeding reporting, applications and a cloud warehouse, with supporting capabilities listed.
Where SQL Server sits today — and where we move it next.

Programming skill sets

  • Cross-platform support
  • Stored procedures and functions
  • Indexing concepts
  • High-speed, data-driven applications
  • Triggers
  • Views
  • Caching
  • Migration from any kind of database management system

Development platforms

Our SQL Server experience spans the desktop and server editions as well as the compact editions used for mobile and embedded scenarios, including SQL CE 3.0 and SQL CE 3.5.

Beyond the single instance

Much of our current SQL Server work is about what comes next: moving databases to Azure SQL and managed instances, splitting reporting load away from transactional systems, and refactoring stored-procedure logic into tested, version-controlled transformations as part of a wider data platform.

  • SQL Server
  • T-SQL
  • SSIS
  • SSRS
  • Azure SQL
  • Synapse
  • dbt