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

You Must Upgrade SQL Server to Stay Secure

A whole series of “speculative execution side-channel attacks” were disclosed in the first week of 2018, as detailed in this Microsoft article: https://portal.msrc.microsoft.com/en-US/security-guidance/advisory/ADV180002

Major security events like this highlight the severe risk companies are..

PowerShell (PoSH) and SQL Server automation

Automating SQL Server with PowerShell

If you perform the same task more than once, you're probably asking yourself "how can I automate this?" PowerShell provides the tooling to automate monotonous tasks that require manual effort.

Securing connections to SQL Server with TLS

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

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.

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.

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

Removing Sensitive Data from a Database

The Problem

PowerApps – 500 Record Limit, Delegation and How to Work Around it