Author: Daniel Holt

Machine learning algorithms help to identify hidden insights in data without needing explicit, complicated programmes. Machine learning uses algorithms which learn from previous data to help produce reliable and repeatable decisions. It’s important to know the iterative aspect of machine learning, as…

Azure Analysis Services is a fully managed platform as a service (PaaS) that provides enterprise-grade data models in the cloud. Advanced mashups and modeling features are used to combine data from multiple data sources, define metrics and secure your data…

With Microsoft releasing SQL Server on Linux and a lot of SQL Server DBAs coming from a predominantly Windows background, this post is going to arm the DBA with the fundamental knowledge of the Linux file system. If you come…

This blog post will cover SQL Server on-premise or IaaS and Azure SQL DB and how to classify data in both. Let’s start by explaining what data discovery and classification is and why is it important. Data discovery is not…

Following on from my previous post where we installed SQL Server with the default configuration this article goes into more detail regarding the configuration options available on Linux to customize your SQL Server environment. Installing SQL Server Agent Changing Default…

With the release of Microsoft SQL Server 2017 (SQL Server 2017) comes the ability to run SQL Server on the Linux Operating Systems. With Linux being the platform of choice for millions of application developers this is a smart move by…

Daniel Holt, Database Administrator at Pythian, discusses transparent data encryption for SQL Server in an availability group.

Daniel Holt, Database Administrator at Pythian, provides readers with commonly used SQL Server date functions.

Daniel Holt, Database Administrator at Pythian, provides a step-by-step guide to installing SQL Server 2016, and highlights some of the new installation features.

Daniel Holt, Database Administrator at Pythian, provides some examples of databases to work on, for new and future DBAs/Developers.