Category Archives for "Business"

Jul 03

Who Loves SQL Server? Linux loves SQL Server 2017

By Charles | Architecture

You read that correctly SQL Server 2017 is coming to LINUX.


Good question. Linux has been around for decades and is a very stable and solid platform but it has usually been offered ‘free’. I started using Linux before I had used SQL Server so my excitement is at record levels right now. In fact I can actually remember a client asking if it was possible to run SQL Server on Linux back in 2008! If you are after a Continue reading

May 29

Why Do I Want You to Sort Your Backups?

By Charles | Business

There are so many companies that are not doing their database backups correctly but they need to be sorted asap. I can’t do them all on my own so I need your help to sort them. So lets look at how to sort your backups.

How many backups do I need to be doing?

For something which is so important to a business, well vital really, it is a surprise to see backups failing or entire backup processes just not fit for purpose. With the massive cyber attack happening last weekend NOW is your last chance to sort them before something really serious happens.

Server backups

There should be a central solution for your database backups. Having one place to look and check your entire business backups have completed successfully is a high priority. It is of course not always possible to have just one piece of software looking after everything so you need one dashboard pulling in multiple data sets which can give you that single pain of glass to help you sleep at night.

There should be three copies of your data at any point in time. If you do not have 3 copies you DO NOT have ANY data. You should therefore have your live copy of your data. A backed up copy on site and an off site copy of your data. This is really the bare minimum your business needs to recover from a disaster. I would prefer two off site copies at separate locations. Only one would need to be accessible for a disaster but all it takes is an accident to burn a place down and a system to fail for your business to go up in smoke.

Hot and Cold

We talk about hot and cold systems. A hot system is one you can use straight away in a disaster situation. A cold system is one that needs some time to be brought into a usable condition. So you may have a server setup for the application but it requires a fresh restore from your most up to date backup to bring it online with minimal data loss.

When did you last test a DB restore?

Test restores should be performed on all DBs regularly, once a week should be sufficient although this should be happening fairly regularly anyway if you are refreshing dev/test from production servers for testing.

Why test restores? You are checking that the backup file you are creating is readable otherwise what’s the point of even having a backup? I can assure you there is no worse feeling than thinking you have backups and can restore in any situation to find out that when that situation occurs your backups count for nothing.

If you are not regularly testing restores from production systems you have NO backups. That sense of security counts for nothing without being tested. If you want to sleep well sort your backups.

Run DB Integrity checks

Whilst not a backup process at all you should still be doing this.

Run DBCC integrity checks on live databases. 2 types of checks full at the weekend as you have more time and physical only during the week for a quicker check. You do not want to be in the position where you must restore the DB due to internal file corruption (it happens and its a &*%$£ to recover from).

You also do not want to be in that position and realize that your backups failed and you are unable to restore from your backup solution. I am talking from experience, we managed to recover the data but it took several days of a complete systems outage to accomplish.

Full, Differential and Log backups

Before you can sort your backups you need to know your backups. There are three types of backup in SQL Server.

A full backup writes everything to disk. It is an exact copy of your data in a new file which can be restored somewhere else. It also starts off the backup chain.

A differential backup is a backup of all the changes that have happened since the last FULL backup. You can take multiple differential backups in a chain but you will only ever have to restore the most recent differential after the previous full backup. So if you take a Full on Sunday and differential backups every night Monday to Saturday. If you need to restore back to Friday evening you would just restore the Sunday backup and the Friday evening differential no need to restore all of the diff backups from Monday to Thursday too.

Log backups for point in time restores can only be taken if the DB is in FULL RECOVERY MODEL. These backups allow you to backup each transaction that happens on a DB. In order to restore to a point in time you must have a DB in FULL recovery model and be taking log backups. If you do not take Log backups the log will be constantly growing until the next log backup is completed or the drive runs out of space.

Please sort your backups

Right now task a member of your team or your company to design a backup schedule/solution. If you do not have anyone with experience or you prefer to get someone in give us a call. We will go through the whole design of a backup strategy based on your business requirements. We take into account disaster recovery and business continuity in order to keep your business safe. So take the time right now to sort your backups.

May 23

When did you last patch your systems?

By Charles | Architecture

sAs of the very recent and no doubt still stinging cyber attack I thought I would hit this question head on with some rather frank honesty. When did you last patch your systems?

Patch your systems

I have mentioned patching before and this time I’m not pulling any punches. Everyone and I mean everyone should know security patches are something to install each month as part of continuous improvement. Microsoft release patches on roughly the second Tuesday of every month. They should in my opinion be deployed to test systems on that day or within 7 days. What happens to the test system if the patches screw it up? Well, you restore from backups. You do have backups right?

IT service providers

These patches once installed then lead to some testing of those servers to make sure that any software on them still functions. If it stops working you roll back the patches and work out which one is causing the issue. Then you try again without the patch causing the issue to start with to confirm it is a problem. Then you either do not install the offending patch if you believe it is not needed or you make it work with it installed. The one thing you never do with patching is NEVER patch anything.

When do good IT service providers patch systems?

As soon as patches are released the information about them is available to hackers. That can literally read through the latest vulnerabilities being patched and create exploits for them. This is a dangerous time to be sitting on unpatched systems. Google give Microsoft a 90 day lead to fix any issue they find. Then they announce it to the world no matter if people feel it is right or wrong even if Microsoft have not got a patch for it yet. Any decent IT service provider would have tested these patches for their clients and rolled them out through their change management processes.

Any company with an internal department worth their salaries should have been doing the same each month. Cyber security is not a joke. The losses in respect to data theft, reputation and financial losses can be staggering even over short periods of time. The company you work for could be out of business in a matter of weeks or a few months after a devastating attack.

If you think a single piece of equipment like a firewall or anti virus are going to stop an attack you are living in the dream world. Security has to be a broad strategy and in depth. Multiple defences on multiple lines just like a standard battlefield.

Personally I would expect every system to be patched within 2 weeks of patches being rolled out to your test systems. That should be a complete patching of all systems within 2 to 3 weeks of release. Rolling patches straight to production systems is risky hence the time to test them first. Not rolling them out at all should be a P45 generating event.

Wake up call

This weekend past will have been a serious wake up call to many companies and organisations around the world. If anything is to be learned, the need for regular patching schedules should be at the top of your list. I foresee tens thousands of man hours of overtime being spent as unprepared departments scramble to patch every neglected system on the net. Both in terms of biological health and in IT, prevention is better than cure. You will most likely find it a lot cheaper too.

So when is the best time to patch your systems the answer is before a major cyber attack and not during/after it. So spend the next few days creating a patching schedule and patch your systems!

May 09

How businesses can benefit from managed IT services

By Charles | Business

Every business uses IT for their day to day tasks. Most businesses even use the same pieces of software. Let’s look at the traditional IT use for a small to medium sized business and see how businesses can benefit from managed IT services.

What do they use?

Most businesses are running Microsoft Windows on their PCs and until recently your accounting software was probably one version or another of Sage. If you are using spreadsheets and creating documents your choice was most likely Microsoft Excel and Microsoft Word. My point is 80% of businesses are using the same software in the exact same way. Then they all hire the exact same type of person to manage and look after their IT.

This leads to a massive over spend for each individual company. Not just on the hardware but also on those hired to look after everything. What is worse is that each of these companies sees IT as an expense! As IT is not a direct way for these companies to make money (they don’t charge per hour for their IT experts like managed IT services companies would) every pound spent appears to have a return of zero.

The logical thing to do is make sure that the least amount is spent on IT as possible. Spending most of the budget on maintenance leaves very little left for actual hardware and software. The very systems your business depends on are procured for the lowest possible price resulting in the lowest possible quality. There is nothing wrong with getting the best possible value for the best price but is there a better way to do it?

managed IT services

There is indeed a way to get more from your investment by shifting where the money is spent.

What skills do they need?

Every business needs a minimum depth and breadth of IT skills and I can tell you now you will not find an expert on virtual networks, security, database administration, Email, SCSM, SCOM, Active Directory and application performance management in a single person.

IT roles do have overlap in areas but you cannot hire an expert in everything that is why we call them experts. The role of IT in business is too big and software packages are now too complex for a single person to know everything about everything. You need a team or you need to return to the use of paper and pen. Most businesses will need accounting, email and office applications and probably a CRM system of some type. Add to that the skills to manage the applications and systems they run on and your have an every increasing list of added costs looking like zero return.

What is an MSP?

An MSP is a Managed Services Provider. Essentially you outsource a function of your business to an external company that will perform that function as a service. This is a very cost effective option for businesses that want to focus on growing their customer base whilst not having to worry about functions that either do not interest them or are not part of their core business. Most frequently this is done with Payroll, Marketing, Accounts and IT but other services can also be outsourced. Legal for example might be something you decide is best done via a third party as you may not have enough work to justify paying lawyers full time. But where do I benefit from Managed IT services? Just a little bit further to go. First let’s see how MSPs do things better.

How do MSPs do it better?

Focus. MSPs specialise in a set of skills or a business function. It is what they do day in and day out and better yet it’s what makes them money. A business function that may have been a cost for your business (as you do not directly bring money in from it) will be their source of income. By outsourcing it you get to vastly reduce what would be a cost to your business and still manage to get the work completed to a high standard.

MSP’s need to cater to the broad set of skills needed but each person can be 100% invested in their field of expertise. Having a team of 10 people with 100% depth on each personal skill set is infinitely better than an individual who knows 5% to 7% of 15 or more different specialist topics. By having access to all those skills you can save a fortune on professionals that may only need needed a few hours a week.

Larger teams have built in redundancy. For the exact same reason that you spread your email workload over multiple servers. MSPs can spread the workload of a skill set over multiple people. What happens in your business when your email expert is on his holiday or on a training course or is off ill?

IT experts are paid more at companies where IT is the direct source of revenue. As they are responsible for the revenue that the business generates, the business can afford to pay them top rates. Whilst paying the most for a role is not a guarantee they will be the best, being able to pay higher amounts should on average improve their chances of finding better people.

How do they compete?

Prestige. If you work for one of the big tech companies, there is a reputational advantage. Everyone will know that you must be good enough just to get through the interview stages. After that if you say you worked for Google or Facebook it is as good as saying you worked for IBM in the 80’s. Doors will just fly open with new opportunities.

Unless your organisation has a mission that does some good for the world like save the Rhinos or protect the rainforest it might be difficult to compete for tech roles. Millennials are not all about money though, for them it is as much about the cause as the money.

Whilst most MSPs are not tech giants some staff will feel more at home with other tech professionals. They feel they can learn more, faster, by working for a Microsoft Partner. They may also feel safer working for a company that does not see tech as a cost. A Microsoft Partner also has some benefit for employees. They have a better standing in the IT industry as well as direct links to one of the biggest IT companies in the world. Being able to leverage the skills of an MSP is a clear benefit from Managed IT services. By partnering with an MSP you have access to some of the best IT professionals in the industry.


How can my business benefit from Managed IT Services

We know what an MSP is and how they compete but how can my business benefit from Managed IT services?

If your IT person is away on holiday, on sick leave or on a training course and your email server goes down do you still call him/her? Do you have someone that can fill the temporary skill gap? Do you just chance it and hope that everything stays up and running? By using an MSP with a team of experts, you know that even if one person is on holiday or on a training course or is on sick leave there will always be someone else to cover your needs.

Savings from having to train staff on the latest tech is another bonus. Do you pay 2k for a Microsoft training course plus lose out on the skills of the person being trained? Do you lose out on 4 to 5 weeks of an individual’s skills when they are on holiday? That can be the equivalent of 6+ weeks that you are seeing no return on their skills per year.

Last but certainly not least a benefit from managed IT security services are the SLAs which are agreed. They usually come with or allow for some sort of financial penalty. Should the MSP not hit a certain service level. Whilst not hitting the level is obviously not good for either party. You do know that your businesses are financially aligned on service uptime. If they mess up you can get a part refund which seems to be offered by most Cloud Service Providers. This can be a nice incentive and certainly a benefit from Managed IT services.


As 80% of businesses need the same skill sets to manage their IT you can outsource the management of your IT for a fraction of the cost. You should be able to improve the service level by leveraging the better skills available from your MSP. Getting the exact same skills but for a fraction of the cost allows you to free up some of the savings from the budget. This can be used to improve the quality of the hardware and software you run your business on.

Reallocating your budget to go into the software and hardware will give you a better return on the investment. By shifting where the money goes you can increase the quality of your purchases. Using fresher and higher quality ingredients will always improve a low quality recipe. Using high quality ingredients and a high quality recipe will give you a result in orders of magnitude greater. It is quite common for businesses to be spending 70% to 80% of their IT budgets just on the maintenance. By outsourcing the maintenance, you can change that figure around so you are spending 20% to 30% on the maintenance and 70% on the projects. By investing in better software with more required features this will help you grow faster and achieve more.

There are many ways to benefit from Managed IT services from reducing costs to improving service levels. The most important points are

  • Spend less on maintenance to benefit from Managed IT services
  • Focus your budget on higher quality software, offering better functionality
  • No work hours lost from holiday, training, sick leave
  • Saving on annual training costs
  • Team of wide and in depth skills always available
  • No need to worry about staff leaving after receiving training
  • Potential refunds in case of service level targets being missed.

Hire Managed IT Expert Today!

Apr 14

SQL MCSE is Dead Long Live SQL MCSE

By Charles | Business

Microsoft SQL certification exams seem to be going around in circles.

microsoft certification professional


In the beginning

Alright not quite the beginning but in 2008 you had the choice of Developer, Administrator or BI. 3 certifications paths which most people liked. Then they changed it so that for
the first certification level, the new MCSA, you needed to do an exam in each of the disciplines. One in T-SQL development, one in DB administration and a BI style exam focused on SSIS. I personally did not like the new certifications and nor did many others. Why would a brain surgeon need to do an exam in podiatry when it is not his/her focus?

Note: You may not have noticed the MCSE: Data Platform and MCSE: Business Intelligence certifications were withdrawn on March 31st 2017. If you already have them marked as active before Sept 2016 on your transcript you get to keep them. If you did/do the exams after, then I believe they will not count.

New SQL 2016 Exams

Back to the new SQL 2016 exams. You can once again go down one of three paths Developer, Administrator or BI which I think shows what each SQL role does. However, this time once you have completed the MCSA you can do one more exam to attain the MCSE. Instead of it being called MCSE: Data Platform or MCSE: Business Intelligence all three tracks end up in the same place MCSE: Data Management and Analytics.

With the 2008 exams after completing each track you would have an MCITP: with either Developer, DB Administration or Business Intelligence showing your chosen path and skill set. So why do I think there is a problem?

It is possible to attain the MCSE: Data Management and Analytics with no business intelligence/analytics skills whatsoever. No SSRS, No SSIS and certainly not a single mention of SSAS.

So how is this new MCSE going to affect potential clients or potential employers?

To MCSE or not to MCSE

Well if I was employing someone with an MCSE (which is now the highest level of SQL certification available) with the word analytics in it I would expect them to have actual hands on experience of the BI stack. I am not sure if the Data Platform MCSE will make a comeback in some new form. I hope it does but for me, right now, the MCSE is dead.

There is just no additional value in doing a single extra exam for the MCSE without showing what you have focused your skills on. There is no added value in going that extra mile at all to have a watered-down certification which does not accurately reflect your skills. Even worse it might appear to employers that you have skills that you do not. In fact, Microsoft could have saved some space on the logo by just calling it MCSE: SQL

Where does that leave employers?

The MCSA is now focused on the three career paths for certification. This is great news for everyone. If I wanted a BI developer I would search for someone with a MCSA: SQL 2016 BI Development certification. For a DBA I would look to hire someone with a MCSA: SQL 2016 Database Administration certification. If I wanted to hire a SQL developer I would look for someone with a MCSA: SQL 2016 Database Development.

This bit is not so great. By grouping all three of these paths into a single MCSE there is now no distinction between these careers. Any distinction is now determined from the MCSA level which makes taking your certification to the advanced level will not show your career focus.

Every employer now needs to look at the lower level MCSA certification to see if they are suitable for the role. By looking at the MCSE they will no longer be able to tell what advanced skills that person has. They may have some advanced SQL skills but that is as far as you can tell.

Projects as diverse as setting up a new clustered or Always On environment, building a Kimball Data Warehouse, implementing ETL processes in SSIS and writing reports could theoretically all come under the same MCSE certification but you have no way of knowing if they have the skills for one or more of those projects.

Microsoft have made the MCSE certification in my opinion completely redundant which I imagine will hurt them with the loss of certification fees. Why do three exams when the skills people are looking for stop at the second exam?

Problem with finding the right skills

There is in the job market a problem with finding people with the right skills to fill a vacancy. I am not sure if the problem is with the clients being unsure of what each role entails, what skills each job title is for, if they are requesting the wrong person or if the agency has not interpreted the requirements correctly but it leads to the same issue. Speaking from direct experience I have recently turned down another project. The problem is that there is some confusion between what a client is looking for and what they need.

I do not always talk myself out of roles with potential clients however if I do not have the skill set needed for what they are looking for then I will not put my reputation on the line by accepting a role and trying to blag it. A good reputation takes years to create and seconds to destroy.

The client may think they need a SQL Developer, BI developer or DBA for their role but what they in fact need is someone else entirely. By grouping every person that works with SQL under the same MCSE certification title Microsoft have now made this hiring process even harder. So how would I fix it?

The solution

To sort this out I believe that the MCSE certifications need to correspond with the three MCSA certifications by name. There should be one MCSE for each certification path. The skills tested in the advanced MCSE certification need to be focused on that skill set.

If anything should be changed to say Data Management and Analytics it should have been the Silver/Gold Partnership competencies (Data Platform and Data Analytics). By reducing the competencies from two to one it streamlines the partnership program. It allows individuals to continue to specialise in their chosen field. It also makes sure that MS partners cover the full SQL stack of skills available in a single partnership/agency. SQL Server is shipped with multiple different products so it makes sense to make sure anyone selling or providing SQL services has the full set of skills to support it.

Simply put – One SQL Silver/Gold Partnership, 3 SQL MCSE paths, 3 MCSA paths. The partnership requirements should require at least one of each MCSE for Silver and two of each for Gold.

One final thought and reason to do this is the tab to find the MS competencies for SQL is called Data Mgmt and Analytics. Perhaps it was all just a copy and paste error anyway!

Apr 03

Data Driven Decision Making

By Charles | Business

Most business decisions being made are data driven. If you see huge demand for one SKU being sold you buy more in to replace it and meet that demand. If you notice that 30% of those orders also included the exact same product you could use that to justify a special offer to try and double those additional sales to 60% increasing your ATV (Average Transaction Value).

Data Driven Decision Making

What is Data Driven Decision Making?

Simply put it is using your available data to justify your next business move. Do it right and those decisions can lead to bigger profit margins but do it wrong and your team can lose all faith in their decisions and lose a load of money.

GIGO – Garbage In Garbage Out

In order to have high quality decisions being made you need to have high quality data to start with. If your data is at best average then your decisions will be average. You need a decent sized amount of data to dig through to find patterns. The more data you have the greater the probability of a good decision being made. However it is not just about the amount of data its also about the quality of the data.

DQS – Data Quality Services

DQS is a service which comes with SQL Server. It allows you to cleanse, match and profile data. It allows you to cleanse data in your Integration Services packages and also integrates with Master Data Services allowing you to perform de-duplication on source data.

For Data Driven Decision Making to work well you must remember that the quality of the data will determine the quality of the decision. The data must be clean, relevant and fresh. If your data is old or stale it will have a detrimental effect on your decision making. For example do not use January 2015 data to predict January 2017 use January 2016 instead.

For more information on DQS check out my post here.

To discuss data quality issues either call us or use our contact us page located here.

Mar 18

Who uses sql database support?

By Charles | Business

sql database support

It seems like a silly question, obviously organisations that use SQL databases but what organisations and what size are they?

SQL Server users

Since SQL Server has had an express edition (formerly Desktop Edition) available for customers to use for free its use has grown massively. More and more software has used it as the back end to store application data and settings. This has lead to the mass adoption of SQL server in businesses and organisations around the world. Once the organisation has outgrown the server there is an easy upgrade path through standard edition then enterprise edition.

What size business?

As Managed SQL Server has several different editions it caters for all size businesses so it will not come as a surprise that all businesses are likely to need SQL database support. Small businesses may just have SQL Server running one express edition instance possibly used for Backup Exec or an industry specific piece of software.

Medium sized businesses are more likely to have multiple databases possibly consisting of internally written software which needs more support. As databases change the older they get this can show up as performance issues. If processes are not setup to re-index and update statistics regularly performance can degrade over time. It is likely a part time DBA (Database Administrator) will be looking out for the database server. A developer or infrastructure engineer may also be tasked with this responsibility.

Large businesses particularly those grown by acquisition can end up with server sprawl. Dozens and even hundreds of SQL instances spread all over the place leading to massive licensing costs. Generally large enterprises have a team of DBA’s to monitor and maintain the databases.

Not my job

Occasionally you find or hear the phrase not my job or not my role in a department. First of all this is exceptionally poor to hear but it usually comes around as no one wants to get blamed for breaking anything. With training this can be removed as an excuse. The other alternative is to hire someone to fill that missing skill set or outsource the role completely.

Why outsource?

I’m not going to lie DBA’s are expensive. A simple job search can show average salaries in London of £70k even outside London average salaries are around the £50k mark.

What if we get a junior DBA? This is a possibility but I would highly recommend not hiring a skill set that you have little or no experience with internally. How would you know if they were any good or not? Think about it for a few minutes would you want to leave one of the most important roles which looks after every single piece of business critical data your business has to someone who is new to the role?

Outsourcing to an experienced Microsoft Partner is your best way to go. You can even get an out of hours service giving your business 24/7 access to DBA’s in emergencies. This is the most cost effective way to get the skills your business needs without the worry of finding someone with the right but unfamiliar skill set.

SQL Database support

For a quote to cover sql database support get in touch and we can discuss your requirements.

Mar 13

Who needs SQL Server consulting?

By Charles | Business

As everyone seems to blame the database for slow performance the answer could be everyone.

Why You Need SQL Server Consulting?

It would be almost impossible to find a business that does not have a database sat somewhere in their organisation. A database might be part of an application like a CRM system or it could be a custom made application to track holiday requests but there is always a database at the back.

Databases are Organic

They are more like babies in that they grow and change over time. A database might start off small and efficient but over time how the database is used can change. Even if its used for its entire life as expected the amount of data it now holds can affect how it performs.

Who is To Blame?

If I had a pound for every time I had heard “the database is slow”, well I would be writing this post from a beach. A very nice beach without pebbles that’s for sure. I do not know why it is always the database being blamed for being slow. I do know however that they need to be maintained and monitored over time because the amount of data that gets inserted and stored is usually forever and is always going up. The number of users on a system also tends to always go up over time as businesses tend to grow.

Is SQL Server consulting right for me?

  • Are users complaining about slow performance?
  • Have you heard the phrase “Is the database running slow”?
  • Has anyone performed a health check on your database server?
  • Is your application freezing for an unknown reason?

The above are just a few ideas which can point to a yes answer. If you have never had a SQL health check or if you are not sure if indexes are being organised and rebuilt then its worth at least a quick chat to find out if there are any issues lurking in the near future which can cause performance issues.

If you know for a fact there are database performance issues then you should absolutely get a SQL consultant. Our consultants can troubleshoot and tune SQL for better performance so get in contact for a resolution.

Mar 08

Why do I need Managed IT Services?

By Charles | Business

Tale as old as time. OK perhaps not as old as time but certainly one of the oldest IT questions.

Do I need Managed IT Services?

In my opinion it is not a question of do I need them but a question of when. Sooner or later your business will reach the size where IT issues are costing you time and lost revenue. For a smaller growing business this can really kill your momentum. If your growth starts to slow competitors can swoop in and steal your market share.

managed IT services bristol

When do I need Managed IT Services?

Have you just found out how important IT is to your business from an outage or simply trying to get an IT issue sorted, then it is that time?

Do you have enough work for a full time IT engineer? If not then it is time to consider Managed IT services as a cost effective approach.

If you do not think you can find the full range of IT skills in a single person (lets be clear about this) it is very unlikely. A persons skill set is never as broad as those recruitment ads want them to be. Then it’s time to look at a full service solution.

The Solution

By using a managed IT service provider you get a very wide and very in depth skill set which your business can use for a very cost effective IT department.

When you think about your business can you think of a single part of it that does not use IT in at least one way? Accounts are all online and these days have to filed electronically. CRM systems are all stored in databases which run on IT hardware. Even your smartphones are more like computers than phones and need to be secured and enable access to your internal systems.

Unless you are big enough to warrant an entire IT department of at least three plus a manager. Then a managed service is the right cost effective solution for your business.

Jun 20

DBaaS – what is it?

By Charles | Business

DBaaS is an interesting term which started to gain popularity in late 2011 and early 2012 and has continued to reach new heights every year since but what is it?


You may have heard of several similar terms like IaaS, PaaS, SaaS which stand for Infrastructure as a Service, Platform as a Service and Software as a Service. DBaas is of this ilk, standing for Database as a Service. Instead of using your own infrastructure you pay a monthly service fee based on the number of databases you have hosted, their size and any advanced features you might need. No licensing fees to worry about as it has all of the benefits of a cloud based service.

DBaaS digital samuari

The licensing costs of Enterprise SQL server can be substantial at approx. £6k per CORE and if you need those features for a fairly small database it can feel very expensive. DBaaS can help by reducing this cost to a monthly cost on a shared server where you are only paying for part of the total environment. This is a much more performance focused basis allowing you to pay only for what you are actually using rather than the entire cost of hardware and software as well as the resource to look after this environment.

Have you heard of DBaaS before? Is it an approach that you would consider either now or in the future?

1 2 3