Making SQL sense

+44 (0)20 3051 3595 info@coeo.com
coeoClose

Making SQL sense

+44 (0)20 3051 3595 info@coeo.com

Careers

We're looking for people who share our commitment to excellence in Microsoft's data platform to join us consultants working on exciting business intelligence, analytics, and SQL Server projects on-premises and in the cloud.

Coeo Blog

The Coeo Blog

How to prevent Robocopy from hiding your files and how to fix it when it does

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

Corruption detected when attaching/restoring master database

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.

Backing up your databases in Microsoft Azure

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

Cyber Security Monthly News – July 2017

July has brought some exciting news to the SQL Server community and, at the same time, Microsoft has released a bunch of security updates for Windows that will help in keeping our environments protected from malware vulnerabilities. See below the latest SQL Server and Windows updates along with..

Watching out for SELECT * with UNION ALL

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.

Azure Data Factory Best Practices: Part 2

Hey there! In the second part of my Azure Data Factory best practices I’ll be talking about controlling the flow of your tasks.

SQL Server 2017 will change how we think about it

The next version of Microsoft’s heavyweight database platform came one step closer to arriving this week when Microsoft released Release Candidate 1 of SQL Server 2017. Microsoft usually provides a couple of release candidates, meaning the final version is likely to appear sometime this autumn.

10 Considerations when designing a data platform

1. New technology This does not mean implement every possible new feature or design methodology, but that enough knowledge is gained so that the most appropriate decisions are taken when building the foundation of a solution. Existing functionality may already be offered as part of a 3rd party..

Free Microsoft Data & AI eBooks

Microsoft has updated its list of free to download eBooks and once again there’s some current and relevant books in the list - as well as some less useful ones and aging whitepapers.

Data in Retail Roundup - July 2017

In the last decade, mobile technology has transformed our lives - and now we are seeing it transform the retail landscape.