With the General Data Protection Regulation (GDPR) becoming a focus point for many organisations, data owners are investing in ways to better protect their customers' data. Microsoft has invested heavily in a range of new security capabilities in SQL Server 2016 such as Row-Level Security, Dynamic..
Why you should always configure a quorum witness on a failover cluster
Since Window Server 2008, the role of what we used to call the “Quorum Disk” in a Failover Cluster has changed significantly and it’s now referred to as a “witness” because its only job is to help the nodes in the cluster decide who should be running the cluster resources in the event that they..
Changes to the Power BI family
Microsoft regularly delivers new functionality for its Power BI data analytics and visualisation services, but rarely does it change how you pay for it or how you deploy it. In May 2017, it has and some of the changes are significant.
The importance of bringing Python to SQL Server
Microsoft proudly announced this week that SQL Server 2017 will be the first relational database engine to ship with built-in artificial intelligence (AI) capabilities. In the future, database servers running its software won’t just be able to store, query, and analyse data. Instead, they’ll also..
Azure Data Factory Best Practices: Part 1
Recently I have been working on several projects that have made use of Azure Data Factory (ADF) for ETL. During these projects it became very clear to me that I would need to implement and follow certain key principles when developing with ADF. This is the first of a series of posts which will..
GDPR and what it means for you
Data and digital privacy laws don’t change very often but the online world has evolved a lot since the Data Protection Act of 1998. As such, an overhaul of the EU laws have been long overdue and new regulation is arriving in the form of the General Data Protection Regulation (GDPR).
10 Steps to Enterprise Business Intelligence with Power BI
You have worked with Power BI to produce beautiful visualisations of your data. The Power is its simplicity, but you can encounter the following problems:
Managed Service Accounts with SQL Server
Managed Service Accounts (MSA)
In Windows 2008 R2 onwards a new object type was created in Active Directory called msDS-ManagedServiceAccount, which is more commonly referred to as a Managed Service Account (MSA). MSAs allow for a type of Active Directory (AD) account that is automatically managed...
Differentiate to stand out - how the Consortium does it
Watch Coeo's James Boother and the other Consortium leaders talk about the ways differentiation helps both our individual organisations and our customers in this new video:
The speed of time
It often feels like time passes quickly and the pace of innovation is getting faster, but is it?