+44 (0)20 3051 3595 | info@coeo.com | Client portal login

The Coeo Blog

A Basic Overview of Locks in SQL Server

We have all heard of locks and can probably even name a few; shared or exclusive locks, for example. We notice them more when something goes wrong and we run into blocking or other performance problems, but what are locks and how do they work in SQL Server?

In this blog, I aim to give a basic..

Cyber Security Monthly News - July 2020

In July's news, Amazon confirms that its cloud computing platform, AWS, was subject to largest distributed denial of service (DDoS) attack in recorded history back in February. The 2.3Tbps attack, which took place on 17th February, surpassed the previous record of 1.35Tbps sustained by GitHub in..

Configure Kerberos for Availability Groups

Today I want to tell you about an issue we ran into while working on one of our customers and, while it’s easy to understand when explained, it might be tricky to get done when you don’t look at the whole picture.

Taking the DP-201 Exam? Here’s what you need to know!

As a follow up to my recent post, we’ll be discussing Microsoft’s DP-201 exam (“Designing an Azure Data Solution”); the second exam and final step required in gaining the Azure Data Engineer Associate certification.

Five Cool Things You Can Do Using Partitioning

It’s been a while since I last wrote about my favourite piece of tech, which is not the latest neither sometimes the greatest, but we’ve been together for over a decade now and I still love it. That is the SQL Server engine.

Taking the DP-200 Exam? Here’s what you need to know!

At Coeo, we are actively encouraged to take exams and broaden our understanding in new areas. Not only do these exams help focus our learning, they help to build a breadth of qualifications throughout the company.

In this post, we’ll be discussing Microsoft’s DP-200 exam; the first of two exams..

Azure Data Factory & XML: Loading unsupported file types

Recently I was working with a client to build an Azure analytics solution, replacing an existing on-premises SQL Server implementation.  The scope of the project was to transform and model data from XML files and present the output through Power BI.

Creating your First Cosmos DB Database

Here we are again, I hope you’re already feeling like an astronaut or Carl Sagan exploring the Cosmos.

In my previous posts, we have seen basic concepts of No-SQL databases and how to start with Azure Cosmos DB, if you haven’t read those posts, I’d recommend you take a minute and check them.

Changes to Microsoft DPS Vouchers

This year, Microsoft has been making a significant investment in new ways to support customers with deploying and using its products and services.

Power BI Tips & Tricks: Concatenating Labels on Bar Charts

Introduction to the problem

We recently worked with a client who wanted to report on the number of sales per region with the ability to drill down to a specific county and town. Out of this came a requirement for a Power BI report with stacked bar charts with concatenated labels.

The data..

Back to top