The Coeo Blog

Following one of my earlier blog posts about Always Encrypted, I thought I'd stick with the security theme for my latest one. With the General Data Protection Regulation (GDPR) on the horizon, encrypting connections is one of the most common discussion points that comes up during customer..

"We are going to see 2 or 3 more of these seismic events in the next 12 Months"  RunAsRadio, episode 546 http://runasradio.com/Shows/Show/546

Ransom Demands

People don't notice great security practice. End-users and Business Managers want new features and better performance, sometimes leaving..

In my previous post Getting Started with SSIS Scale Out I discussed the use cases for SSIS Scale Out and how to install and configure it. In this post I'll look at how to execute packages in Scale Out, depending on your type of workload and security considerations.

Recently I was asked what my favourite SQL Server 2017 new feature was. The answer was easy, SSIS Scale Out. This is a feature that provides a quick and easy solution to a variety of ETL problems. If your ETL processing looks like one of these scenarios, this could be for you.

Hi everyone! I’m Chris and I’ve recently joined Coeo as a Cloud Consultant. I specialise in helping customers looking towards the cloud with all aspects of Azure cloud adoption and usage..

I’m quite a fan of automation when it comes to Azure. Automating the build of your environments in Azure has..

New Servicing Model for SQL Server

Last week, following the confirmation of SQL Server 2017 being generally available on Oct 2nd, Microsoft announced a major change to the way they will be releasing updates in future. They will no longer be producing Service Packs, instead relying on regular..

I recently had a scary moment at a customer when I was testing to see how long it would take to copy a data file between two of their disks using Robocopy and an old and relatively small backup file. If you haven't heard of Robocopy, then you should look into it as a command line (cmd) tool for..

Recently, while working with a customer to help restore their SQL services, I came across an issue I hadn’t seen before and more interestingly, one where little information can be found within the community.

Configuring scheduled database backups has always been an important activity for database professionals. As we transition our SQL Server workloads into Microsoft Azure Infrastructure-as-a-Service (IaaS), we now have a number of options available for backing up databases which at first glance can be..

UNION ALL returning incorrect results?I recently came across an interesting behaviour when executing queries that included a UNION ALL statement, the examples below were created using SQL Server 2016 Service Pack 1.