In today’s data-rich landscape, private equity firms, financiers and insurers who already collect vast quantities of information can use it to gain a competitive advantage.
How Coeo sped up lead processing with PowerApps
The Coeo team decided to transform the way we process marketing leads from industry events by turning a paper-based process into a PowerApp. Big Data LDN 2019 was the perfect place to test our new system.
Laying the groundwork for data-driven retail
The Coeo team have worked with organisations from across the retail sector and we've seen that increasing numbers of companies are looking to learn more from their customer data.
Optimising retail IT spending
It's no secret that the past few years have been challenging for UK retailers. According to Deloitte, 2018 saw a 36% increase in net store closures compared to 2017 - 7,500 in total. With pressure increasing and costs rising, we expect budget holders in areas like IT will start to see a squeeze on..
The Need to Continually Improve
At Coeo personal development is huge part of our ethos. Since I joined the company a little over 3 years ago now I have studied for, and passed 7 MCP exams, and these haven’t just been in SQL Server. We’re constantly encouraged to explore other areas that complement the work we do. In the last 3..
Stretch Database - SQL Bits XV Q&A
When I was at SQL Bits this week someone was asking me about SQL Server 2016’s new stretch database features. The attendee in question was asking about backing up and restoring the production database for development purposes. In their case the development team like to work with up-to-date..
Restoring 1000's of SQL Server Databases Using PowerShell
Recently I have been working with a client who has a production SQL Server instance that has ~2.5k databases on it. They are in the process of moving to a new SQL Server cluster and are reviewing their other non-production environments too.
Choosing the right tool for the job
I was working with a client recently when an architect expressed disdain for a particular part of the SQL Server stack. In this particular case the architect had then chosen to roll-their-own solution which they felt was better. My intention is not to comment on their particular solution but it did..
SQL Server Data Files in Azure – Part 1 – Creating a database
One of the interesting new features of SQL Server 2014 was being able to place SQL Server database files directly in Azure blob containers. The purpose of this post is to walk you through setting up a database with its data and log files in Azure. In a later post I plan to test the performance of a..
The curious case of the slowly starting cluster
I came across an interesting case today that I thought it was worth doing a quick blog post about. I was working with a customer who was migrating onto their newly built SQL Server 2014 clustered instance. Part of the pre-migration testing was to fail the SQL Server service between the two nodes to..