News & Events

How Many Databases does it take to get to work?

One Our Microsoft SQL Server consultants at dsp talks to us about one of his favourite subjects … Databases

“While I was sitting on the slightly overcrowded train this morning, I allowed my mind to drift from the hot, slightly pungent carriage to think of my favourite topic; Databases and how important they are. Since the introduction of mainstream database in the late 70’s they have managed to be so successful, they have proliferated everywhere and are becoming more critical by the day.
How important is important I hear you ask? Well if I consider my typical daily commute to London – I wanted to work out how many databases I pass through: So here it goes…
1. I wake up – Alarm – small database = (#1)
2. I check the weather on Sky – Sky has a number of databases that ensure my sky box is getting the correct program (#2), I’m a subscriber (#3), the weather report (#4)
3. I get a text on a meeting – EE has my phone number in their database (#5)
4. Take a shower & get ready – Utilities databases (Water & Power) =(#6 & #7)
5. Get in car to drive to station – Car has SatNav Database (#8) and Traffic report (#9)
6. Get to station and park, pay for parking through phone app (#10)
7. Head to Costa, pick up coffee – Loyalty card (#11)
8. Head to station and pick up tickets – Transport Databases (#12)
9. Pay with debit card – Visa (#13), Bank Account (#14)
10. Check time of next Train – Transport database (#15)
11. Play and read various apps on phone – App store database, BBC news, Linked in(#16, #17, #18)
12. Get off at Waterloo, hit the underground (it’s raining – damn weather report was wrong)
13. Get on tube – TFL Database (#19)
14. Off at Leicester SQ. Run to office, trying to avoid rain unsuccessfully
15. Use swipe card to get into office (#20)
So that’s my journey, and I think I pass through the “system” at least 20 times just to get to work. There are probably more if you start to count train scheduling, CCTV etc…
If I were to look at the databases I use to get into the office, some of my experiences are more important than others and I would hope some of these databases have adequate DR and HA…. The Costa Coffee being absolutely the top of my priority list…
In summary, to me in my day job databases are very important. But then they should be, but to most people, databases are something that you just don’t care or worry about on a day to day basis; and you shouldn’t need to. That’s what makes a successful database.
As a Microsoft DBA at heart I worry about DR, transactions per second etc. But as a commuter every morning, I am a massive consumer of data; – it’s not about the database, it’s about how quickly and painlessly I can get to work…. “Please… no…. I can’t be late to work again!!”
So there you go, hopefully and interesting blog. So 20 databases for me, Is that an average for every person? I honestly don’t know – be cool to find out.”

Get in touch

For more information or to schedule a demo please contact us

Contact us

News

dsp drives up its share of the Database MSP Market with
record contract growth and 2nd acquisition

DSP firmly established itself as one of the UK’s fastest growing proactive Database MSPs during 2016, signing £2.1m of new contracts and making its second acquisition, the Oracle DBA support division of IT Services provider ITSB.

Read more
View All

Event

Applications on Oracle Database Appliance (ODA)

A main goal... how to future proof your applications environment through Oracle while becoming more efficient in terms of costs and productivity.

As well as the option of developing the fundamental steps you need to take to get ...

Read more
View All

Blog

How can you regularly benchmark your database and application infrastructure against real-life? Why would you want to?

In the age of big data, public cloud, private cloud it’s easy to be pushed into constantly thinking about the future... What should you optimise though and how can you be sure it’ll make a difference? Would knowing it could give you a competitive edge be worth considering?

Read more
View All