In my previous blog post (https://blog.coeo.com/the-real-difference-between-the-select-...-into-and-insert-...-select-statements) I explored the difference between the ‘SELECT … INTO’ and ‘INSERT … SELECT’ and referenced the fn_dblog() function as a tool that can be used to retrieve information..
PCI DSS and your data platform
{% video_player "embed_player" overrideable=False, type='scriptV4', hide_playlist=True, viral_sharing=False, embed_button=False, autoplay=False, hidden_controls=False, loop=False, muted=False, full_width=False, width='640', height='480', player_id='6513539541', style='',..
Reserved Capacity for Azure SQL Database
It doesn't seem that long ago when the DTU model was the only way of purchasing Azure SQL Database. In the last year Microsoft has announced some significant changes in the way we can buy it. Earlier in the year I blogged about the introduction of the vCore purchasing model, which provides greater..
Data visualisation in the insurance industry
The insurance industry is a sector built on data and, with the increasing amounts being generated, data mastery and digital technology will become vital parts of the insurance process.
Microsoft UK Partner Pledge
During the Microsoft Inspire 2018 partner conference, held in fabulous Las Vegas, Microsoft UK CEO Cindy Rose talked about the real challenges technology businesses face back home in the UK on digital skills, diversity and inclusion, and responsible and ethical AI. While we're a tiny part of the..
Servers – Pets, Cattle – mince?
Pet servers are those servers you named, nurtured (loved?). Cattle servers are disposable, numbers only. When they are sick they are “…taken out back, shot, and replaced…”. Containers offer a new way to think about the services we’re delivering – processing our cattle-like servers into something we..
Who unscheduled my agent jobs?
Introduction
Due to the large number of different SQL Server instances (and versions) we support, we get the luxury of seeing unusual behaviour more often than most. Something I’ve seen three times now is a curious issue with the SQL Server Agent on SQL 2016 CU5 which rarely crops up following a..
Installing SQL Server 2016 on Windows Server 2012 R2 (the KB2919355 issue)
While performing an in-place SQL Server upgrade for a customer, I came across the KB2919355 issue. This article will show you how to resolve this this problem and point out why this can be misleading.
How removing intermediaries improves the ecommerce supply chain
Online retail can involve very long processes leading to the customer, but what if the supply chain could be shorter, and the process leaner?
This article examines how disintermediation — the process of removing intermediaries from the supply chain — can impact online retail.
RDP broken due to Windows Update - and how to fix it
Published: May 2018
In the past couple of weeks, following the recent Windows update CVE-2018-0886, we have had multiple occurrences of ourselves and our customers having issues connecting to some of their servers via Remote Desktop Protocol (RDP). When trying to RDP to certain servers, we are..
