What?

We can help you today to implement these:

Source Control

Source controlling your database or etl application is the first step to beginning your journey to engineering excellence. Source control is a vital enabler for everything that we do. We can help you get your database or etl process into source control so you can start realising the benefits of code reviews immediately.

Continuous Integration

Once you have your database or etl application in source control, Continuous Integration (CI) is typically the next step to bringing solid engineering practices to your legacy application. Without CI, you could check-in any old code that might not even compile, and where will you run your tests when you start writing those?

Unit Testing

Unit testing database code and etl applications are such a vital step to engineering excellence but at the same time so hard to start. We have worked on legacy applications which have no unit tests and the difference between an application with no unit tests and an application with just one unit tests is night and day different - with an excellent, full unit test suite the difference is enormous and a real enabler for faster project delivery.

Integration Testing

Unit testing is significant, but integration testing is where we find customers find most of their bugs, so we are a real advocate for implementing integration tests, and we have had the pleasure of writing integration tests for all sorts of applications from c/c++/go/sql database/c#/sas dataflux/scala/python/java you name it, and we have probably written an integration test for it.

Continuous Deployment

You have your code in source control, you have tests that give you confidence that the system will work the next step is to get the code into production safely which is about rolling out small changes often, testing, monitoring, observing and when you are confident rolling out a little bit more until you can report on the success of the change. Then when the change has been rolled out, you keep monitoring it to make sure it stays working.

ETL pipeline development

Developing high quality, resilient etl pipelines is a challenge for any business, outsource the development to us and let us build your etl pipelines which means that you can focus on how to use the data to improve your business.

Database development

We have a great deal of experience writing scalable SQL Server applications, and whether you have a database to design or a bug in a million line long stored procedure, we can help.

DacFx development

Microsoft provides an API for working with their SSDT projects, the API can be used to help deploy code safely, to help refactor code or any number of things, but the documentation is non-existent. We have studied the internals of the DacFx and can help deliver where searching MSDN for non-existent documentation can’t.

With?

The technologies that we are best placed to help you with are:

  • Microsoft SQL Server
  • Azure DevOps (VSTS)
  • Jenkins
  • TeamCity
  • Octopus Deploy
  • Microsoft Azure
  • SQL Server Development Tools
  • SQL Server Integration Services
  • Apache Spark
  • Databricks
  • Azure Data Factory
  • git
  • Java
  • Powershell
  • c#
  • scala
  • python

How?

We can:

  • Deliver training, either onsite or remotely - tailored to your specific needs, drawing on two decades of experience of dev and ops delivering engineering excellence
  • Provide guidance and recommendations on how to implement your system, mentoring and support if you would like to make sure your team learns how to apply these principles of engineering excellence themselves
  • Deliver a proof-of-concept around your requirements which will allow you to deliver the full project yourselves or prove that we are the ones to help you fulfil your project
  • Deliver a production-ready project, if you have a project that you need to deliver and either don’t have the internal resources or need it done ASAP then contact us, and we can deliver custom software for you, fast and reliably with engineering excellence built in

GO GO GO

Contact ed by email here or by phone here.