The Coeo Blog

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..

PowerShell provides an extremely efficient method to globally clean up and drop objects within your SQL Server estate based on some pattern matching in the object names. Some of the reasons you may wish to do this are: -

The SQL Server 2016 Upgrade Advisor is a great graphical user interface for analysing your existing SQL Server database to discover any features or syntax you are using that are not compatible with a 2016 upgrade.

In my new role at Coeo as Head of Digital Transformation, I’ll be helping Coeo to help its customers become digital businesses.

Recently we helped one of our customers with a Microsoft case in regards to a clustered AG deployed in Azure. We would regularly receive reports of the clustered nodes failing to heartbeat, and as such this would terminate the cluster service, and sometimes impact the synchronisation status of the..

The DBA team here at Coeo have spent a fair amount of time over the last few months discussing and debating the Netflix series ‘Making a Murderer’. If you haven't seen it already, I thoroughly recommend it. It’s a documentary based on the conviction of an American man, Steven Avery, for murder and..

In the past, the IT departments bought an organisation’s IT services. In the future, they’ll also need funding from business units so they can afford to deploy the new services they want as well as modernise those they want to keep. Along with their cash though comes the expectation of influence..

Past success is no guarantee of success in the future. Database platforms, like web browsers, might be an established technology but the demands of them are likely to change more in the next two years than in the previous 25.

During my years as a DBA I’ve come across ephemeral port exhaustion just a handful of times. It is rare enough that is not often considered, not widely understood and can cause extreme confusion when it does pop up. Understanding what port exhaustion is and why it can occur can make your job..

No matter how advanced or automated technology gets, organisations – and as we shall see taxi passengers – need to be able to describe their journey before they set off. Otherwise they risk delays communicating where they’re starting from or ending up in the wrong place.