At Structured Concepts, we specialize in SQL Server development and performance tuning, as well as technical training for users and developers. Because SQL Server is what we do all day, it’s what we do best. It’s our core belief that a consultant should be a hired professional who can help you with a specific technical challenge.
When our job is done, you’ll have a robust solution along with the skills and the confidence to take over.
What we do.
We develop things.
When it comes to T-SQL development, we’re at the top of our game. We’ve been providing our clients with robust ETL processes, future-proof data models and lightning-fast transactional processing for decades.
At first glance, the actual development work can seem like the biggest challenge on your way to a good SQL Server solution, but the some of the most important factors in keeping your solution running smoothly and efficiently are experience, planning and an immaculate attention to detail. Those are the things that are going to save you a lot of grief and money going forward.
As part of a corporate restructuring, we helped a client in Norway separate their existing data warehouse into two distinct entities.
The development cycle was short and the implementation was put in production in less than one day, causing minimal interruption to the client’s on-going business transition.
We make things go fast. Really fast.
Performance is at the heart of everything we do. A few days of targeted performance tuning could very well push the looming cost of a hardware update several years into the future. And what’s more, a well-performing database solution will scale better and work better with your existing infrastructure.
As a subcontractor to an independent swedish management consulting firm, we performed a technical review of an existing business intelligence solution for a large european industrial corporation.
We provided the client with specifics on how to redesign their solution in order to improve both performance and reliability.
Two-day performance review
Book us for a two-day performance review that could save you huge amounts of money on licensing or hardware upgrades and make your application run smooth. Today, as well as next year.
… and we’ll show you how to do it.
Don’t become reliant on consultants to keep your operation running smoothly. In our world, the consultant is a hired expert – a specialist contractor that gets a specific task done. And one that can show you how it’s done going forward.
Ask us about our efficient turn-key training programs, or custom-design a development or performance tuning workshop just for you and your specific needs. Either way, you’ll cement the confidence and know-how in your colleagues to keep your SQL Servers running. Fast, precise and smooth.
Hypergene is a leading swedish BI software and consulting company.
We developed a series of technical training sessions for the consultants at Hypergene. The aim was an improved understanding of advanced features and performance tuning. All in all, the material was compact and targeted, so as to get the most efficient training outcome in a short time.
Create your own instant cloud datawarehouse using nothing but a standard SIE file. SIE is the predominant swedish file standard used by accounting software to import/export data.
Our cloud platform allows you to upload and instantly turn your SIE file into a SQL Server-based datawarehouse.
Forget BI consultants, licensing, project meetings and budget constraints. With our platform-as-a-service, you’ll be running your own datawarehouse in minutes at a low, predictable cost. Security, robustness and performance included.
The datawarehouse service is only available in swedish at this time.
Instant master data management – no installation required.
In many applications, primarily in Business Intelligence, you’ll frequently see the need for user-maintained tables that hold mapping information and “golden record”-type of data, which is necessary for the app to function. While Excel sheets or text files are very user-friendly, they are an utter mess to integrate with your ETL solution.
This is the gap that a Master Data tool fills – a user-friendly graphical user interface that stores data in structured tables in a database, where it’s easy to extract.
With our Master Data software as-a-service, you’ll be up-and-running in minutes. Bring your own database or let us set one up for you.
Try it yourself: masterdata.strd.co
More automation, less headache.
A good ETL process needs good tools and a robust framework. For an example of implementations we’ve worked on, check out our file parser API that will automatically identify, correct and translate most file formats.