How to prevent man in the middle SQL injection attacks

As a SQL engineer with an interest in security I’m convinced that security is a concept that should be implemented throughout an organization. Just placing a (properly configured) firewall and forcing password policies doesn’t suffice. In light of that last statement I wondered whether or not it was possible to gain access to a MS …

Continue reading "How to prevent man in the middle SQL injection attacks" »

SQL Server 2017 and Linux : Part 1

Today I will be writing about the new SQL 2017. It has been launched yesterday (Get your copy here) and one of the new and exciting features is you can now run it on a supported linux distribution (redhat, ubuntu, Suse, …) As I have been working exclusively with Windows OS’es for the past 6 years, …

Continue reading "SQL Server 2017 and Linux : Part 1" »

Failover Clustering and Regional Settings

Hi all, This week I was installing a brand new SQL Server 2016 AlwaysOn Availability group on Windows Server 2016 . As Always On Availability groups depend on an underlying Windows Cluster, the first step in the installation was building the cluster, after getting the necessary coffee. Building a cluster means running the validation report …

Continue reading "Failover Clustering and Regional Settings" »